Menu help

[EjS]

I'm new to Access...would like to create a menu that opens when the database is opened. From here you would have choices (open form, run querie, etc) if a button is pressed. I know how to do the macros behind the buttons but can't figure out the menu part. Any help is appreciated!

 

[[nateobot]]

EjS:

What you want to create is a "Form". Open the database window and select the Forms tab.
Click the new button.
Select the Option of Design View.

Now you will create buttons.

In the toolbar you will see one that has a hammer and wrench crossing each other. Click on that and the "toolbox" will appear.

Hover your mouse over the different pictures till you find one that is called "Command Button" (looks like a grey rectangle). Click on that and draw a button on your form.

To get it to do stuff you need to assign a macro or code. Right click on the button and select properties from the menu. Scroll down all the options you see there and find one called "On Click".

Click on there and you will see a drop down box. Click on that and find your macro.

If you need more help respond and we will try our best to help.

 

[EjS]

Thanks! Actually when I placed the button on the form the wizard popped up and I assigned the command right away. One more question-how do I make it open when access opens?

 

[SaraMegan]

Go to Tools -> Start-up, and under "Display Form" select your menu form.

--Sara