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

[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]

You need to create a custom menu with "Reports", "Record Management", etc.
Then under each of these you need to create menu items where each does a
specific task such as open a specific report. For each menu item to open a
specific report, you would set the action property to execute a function
such as"

Function OpenReportXYX
Docmd.OpenReport, "ReportXYZ"
End Function

This function would be placed in a standard module.

Look in the Help file to find out the details to do all of the above.

If you need help, I could implement all this in your database for you for a
modest fee.

Steve
(e-mail address removed)

 

[John... Visio MVP]

If you need help, I could implement all this in your database for you for
a modest fee.

Steve
(e-mail address removed)

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

 

[Gina Whipp]

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

 

[TOP]

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?

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.