Access drop-down menu

[demo383]

Is there anyway that, instead of having all of my queries listed in the main menu, i could create some kind of drop-down menu to organize my queries better. I have about 30 queries and it is a real hassle to have to look through all of them when i'm looking for one.

Thank you for your help in advance.

 

[fneily]

First, post Access questions in one of the six Access forums. You'll get more responses.
I posted this sometime ago, you can use it to place your queries on the menu:
Creating a Custom Menu Bar
A) Create a Menu bar first
a. Click View, slide to Toolbars and click on Customize
b. Click the New button
c. In theToolbar Name box, type in a name (such as the database name) for your Menu bar
d. Move the blank new menu bar out of the way of the customize window.
e. In the Customize box, click the Properties button
f. In the Type box select Menu Bar
g. Click the Close button

B) Add some built in menus to your customize bar
a. In the customize dialog box, click the Commands tab
b. Select Built-in Menus in the Categories list
c. In the Commands list, click the File menu entry and drag it to your bar
d. Drag the Edit menu from the Commands list to your bar
e. Drag View, Records, Window and Help to your bar

C) Add your own version of the Tools Menu
a. In the Categories list, click New Menu
b. In the Commands list click New Menu and drag it to your bar
c. Right click the New menu , select the existing text in the Name box and type &Tools and then press enter
d. At the top of the Access window click the Tools menu.
e. Hold down the CTRL key and click the Spelling command. Drag it down to the Tools menu on your bar and drop it in the blank dropdown menu.
f. Repeat to bring the Autocorrect and Options submenus down to your bar.
g. With the right mouse, click the Options command on your menu and then click Begin A Group.

D) Add Another menu to your bar
a. In the Categories list, click New Menu
b. In the Commands list, click New Menu and drag the text to your bar
c. Right click the New Menu on your bar and in the Name box call it something pertaining to the database
E) Add custom menu commands to open forms in your application
a. In the Customize dialog box, click the Commands tab
b. Select All Forms from the categories list
c. In the Commands list, drag a form name to your new menu on your menu bar and drop it off. If you want to change the name to something more user friendly, right click it and type the name in the Name box
d. Let’s say the form finds a record of some type. You want to put an Icon on the menu bar. Steal the binoculars from the Find command by doing the following: Right click the Find button and then click Copy Button Image. Then click your menu and right click and click Paste Button Image.
e. Repeat above steps for the forms you want to use.
F) Tell your Form to use the created Menu bar
a. Drag the new menu bar to the top and dock it.
b. In the Customize dialog box, click the Toolbars tab and click on the check next to your new menu bar to hide it. You only want it to show when your form is opened.
c. Close the Customize window.\
d. Go to the Design view of your form and open the forms Property Sheet.
e. Click the Other tab of the sheet
f. Set the MenuBar Property to your menu bar.
g. Click the form view and check to see if it worked.

 

[demo383]

that worked great thanks for the help