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.
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.
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
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
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.
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