Results 1 to 11 of 11
  1. #1
    Join Date
    May 2007
    Posts
    7

    Unanswered: Problems with switchboard buttons

    Hi eveyone
    can some one please assist me here I have created three forms in Access and i now want to create a switchboard with menu buttons as some of the people using and inputing data into the database are not 100% computer savi.

    I have created a custom switchboard using access 2007 and the forms have been created using the same. However when i create a button then select open form it goes to the box which should list all forms previously created forms, but it's blank. These are stored in "My Documents" by default but Access 2007 doesn't seem to register these forums.

    can someone tell me where I'm going wrong
    Last edited by Towbar; 04-27-08 at 17:39.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I can only offer you an alternative; I've always made my own switchboard. I still call it a "menu" though.

    Just could just make your own form with command buttons for your three forms and any other commands you want. Then use the On Click event procedure on each button to write a VBA command to open your form.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2007
    Posts
    7
    Hi StarTrekker

    many thanks for the reply. I understand what VBA is but thats about as much as i do understand. I also understand the concept of "On Click Event" as I've already seen this this and had a play with it, however I am unable to understand the the path/language. If that makes sense. what I need is some basic VBA tips and tutorials. I've tried google, but what comes up seems a little advanced for me
    Last edited by Towbar; 04-27-08 at 17:40.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Access has a lovely wizard that will build simple event like form opens for you!
    If you can't get that to work let us know and the code will be provided
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Making your own menu is a great place to start to learn coding.

    Once you set your On Click to [Event Procedure], use the build button to write your code: Docmd.OpenForm "FormName".

    Give it a go
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    May 2007
    Posts
    7
    Right guys

    been playing with access 2007 any form i create using the wizard shows up when i go to select open form in button Wizard, but forms I've created using blank documents don't seem to show. Is it something to do with the way I'm saving the documents.

    Also when i go to events procedure and add the command open form and enter the name of my form, it tells me the form is miss-spelt or not available I begining to think this is a user error

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Post the offending code please

    And you mention documents; can you elaborate on this?
    The code StarTrekker provided above is used to open forms only. For example DoCmd.OpenReport is another similar command.
    George
    Home | Blog

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds like an Access installation issue to me tbh. I'd be trying to re-install Access. I can't imagine why the wizards would hide forms you created on your own. Saving is saving. A form is a form. Whether it is created with a wizard or not should be irrelevant. Mind you it is Access 2007, so it might be an option I have never encountered yet... especially since I never use wizards.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    May 2007
    Posts
    7
    Cheers StarTrekker that was my next option as i installed 2007 over 2003

    I have tried to upload a word document which show what i'm doing but it won't have it

  10. #10
    Join Date
    May 2007
    Posts
    7
    Update time

    removed 2007 deleted Microsoft Office folder from C:/Progams then ran registry mechanic to remove any dross left behind by the uninstall and reinstalled 2007. The problem still remains the same so for the time being i am reverting back to MS Office 2003. I have since read a few posts on other forums about 2007 some of which are not very complimentary I therefore wish I'd done my homework before using 2007.

    Still least it was only the trial version (an i'm not sure if this has any thing to do with it either) Many Thanks for all your replies will begin again with 2003 and will post back with feedback thanks to all

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yup. I know of no developers that think that Access 2007 is better than 2003. It seems like a rather significant downgrade from from 2003, from the developer's point of view.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •