How do I create a user menu for them to select reports, etc. from

  • Thread starter Thread starter Cathy b.
  • Start date Start date
C

Cathy b.

Years ago I'm pretty sure I created a small application that presented the
user a series of menus that they used to access various reports. Eg., the
first menu a user would see was "Reports", "Record Management", etc., and
then when the user selected "Reports" for example a list of available
reports appeared and they selected the one they wanted from the menu. I'm
not seeing an easy way to do this in my version of Access (2003). Am I
daydreaming or is there a way to do this?
 
Steve said:
If you need help, I could implement all this in your database for you for
a modest fee.

Steve
(e-mail address removed)
Click to expand...


These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified professionals who gladly help for FREE.
Stevie is not one of them. He is not highly qualified, professional or
willing to help for free. If he was any good, his past customers would be
drowning him in repeat business, but it appears, for them, once was more
than enough.


John... Visio MVP
 
Cathy,

What you want sounds doable using combo boxes and a list box, that is if I
am understanding you correctly. I do not recall ever seeing a template for
this but it can be done. You can either 'create the list' or use the
MSysObjects table to get your list of reports. Using the table is probably
the best way to go as once you add the report to the database it would
automatically be added to your list thereby eliminating the need to maintain
a reports table.

Whichever way you decide to go, doing it yourself or hiring someone PLEASE
check their references. Steve is well know for trolling these newsgroups
for business. The people in these newsgroups VOLUNTEER their time to give
you FREE help. Good luck on whatever you decide to do!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Cathy b. said:
Years ago I'm pretty sure I created a small application that presented the
user a series of menus that they used to access various reports. Eg., the
first menu a user would see was "Reports", "Record Management", etc., and
then when the user selected "Reports" for example a list of available
reports appeared and they selected the one they wanted from the menu. I'm
not seeing an easy way to do this in my version of Access (2003). Am I
daydreaming or is there a way to do this?
Click to expand...

It sounds like you're talking about a Switchboard.

Go to Tools > Database Utilities > Switchboard Manager. That provides a
pretty easy way to create menus of reports, forms, etc...

I gather it's not as powerful or aesthetically pleasing as using a blank
form and creating your own menu buttons, but it's what I'm using right now
to create a usable navigation menu while I learn more about the bells and
whistles I can implement later.
 
Back
Top