Can I create a MENU from wich I could access my forms and reports?

[MarkoKobal]

Can I create a MENU from wich I could access my forms and reports?

 

[LDG1234]

you can create a switchboard which essentially is a form which you design and opens automatically when the Db is opened.

Create a form in design view and add a command button ensuring that the wizard button is selected.

You can create buttons from here which open forms and run reports.

When you are happy with your form, go to the Tools, and then Startup and select the name of your form from the drop down box marked 'Display form' on the top right hand side.

Hope this helps Lloyd Gozzett
Process Developer

 

[Guest_imported]

Yesterday I downloaded a file called Code 11.zip which is
VBA Code Sample #11 The Access 97 Menu Manager Add-in
Created 6-13-99
Helen Feddema (hfeddema@ulster.net)

it does exactly what you are looking for.

Unfortunately I can't remember the site I downloaded it from. This bit is in the documentation

For full details on the design of this add-in, see my article in the April 1999 issue of Smart Access. Smart Access is published by Pinnacle,

http://www.pinpub.com.

Have only started to play with it, but in the long run think it would be even better than a switchboard (which i am currently using). Perhaps someone else can tell you what site it came from.

 

[MarkoKobal]

Thank guys, swichboard is a good idea.

For Helen: could you send me this file Code 11.zip ?
Would be very grateful!

 

[MHadden]

Sorry to butt in, but that wasn't Helen, it was someone pointing you to her website. Her website may be found at

http://www.helenfeddema.com/

After you get to her site click on "Code Samples" then go to code11.zip
Hope this helps & good luck,
Michael

 

[mirirom]

hiya, i recently completed an MSCE prep course for Access 2000 (1300 Mastering Access w/VB) where the instructor explicitly stated that switchboards are much too bulky and slugish for practical use (the addins, unused portions of the utility, et al). your best bet would be to create your own form (unbound to any tables) with command buttons that perform the operations that you want.

you can do this by going into the properties of your newly created buttons and adding in the commands under the Events Tab. if you know a little VB you're all set, otherwise you can peice the commands together w/a macro - the syntax is pretty much straight forward. honestly, the size difference between a form and a switchboard can be tremendous. this comes into play particularly for front-end management on a network; clients should see virtually no lags or delays.