a forms list

[_Bigred]

Hello,

(Access 2000)

I have several forms in my database, and would like to create some type of
list that allows the user to select a various form (or even reports) and
click on it and have it open that particular form or report. (I am trying
to eliminate the need to a ton of buttons that would open each seperate form
or report.

e.g - desired --> user would scroll through a list click on "Grievances By
Date Range" and it would open that form or report.

Any help would be greatly appreciated,
_Bigred

 

[_Bigred]

that would be outstanding. tell me more.

thanks,
_Bigred

 

[PC Datasheet]

From Access2000 Help file---

Create a custom menu bar for the current Access database or Access project
1.. On the View menu, point to Toolbars, and then click Customize.


2.. On the Toolbars tab, click New.


3.. In the Toolbar Name box, type the name you want, and then click OK.


4.. On the Toolbars tab, click Properties.


5.. In the Type list, click Menu Bar.


6.. Set any other properties you want, and then click Close.
The new menu bar is now placed to the right of the Customize dialog box.

7.. To complete the menu bar, do the following:
a.. Add custom menus. For more information, click .


b.. Add a built-in menu. For more information, click .
Notes

a.. Microsoft Access supports menu bar macros for applications created with a
prior version of Microsoft Access. For more information, click .


b.. You can attach the custom menu bar to a form or report. For more
information, click . Or, you can designate the bar as the global menu bar. For
more information, click .
For more info, go to the Help file and search on Custom Menu.

Steve
PC Datasheet

 

[Albert D. Kallal]

For reports, I often use a listbox.

I usually use a listbox with two columns. The first column is the actual
report, and the 2nd column is the description text that the user sees (much
more user friendly).

You then just type in the report name, and the report descriptions into this
table.

You can even build the listbox with the wizard.

Then, have the user highlight the report in the listbox, and then put the
following code behind a button.


strWhere = code here to build conditions.

docmd.OpenReport me.mycombolist,,,strWhere

I do actually launch a large portion of my reports from a custom menu bar.
However, most of the menu bar simply launches a nice report form with a
listbox.

Here is some screen shots of what those prompt forms look like, you can see
how a listbox used in many of the examples:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html

 

[_Bigred]

couple questions

1. do i create the menu on a form?
2. if i create a form with a listbox on it, should i enter the
forms/reports I want (to use on the menu) as stored values or does it
require that I create a "table" that has the form/report names in it?
3. with the code you are saying to put behind the button, where exactly am I
entering that value?

Sorry I normally use basic forms, reports, and macros and this stuff (coding
and such) is a little new to me.

Thanks,
_Bigred