Autoexc

[tom1252]

I have created a auto exc macro but the form i want to open when you open the database doesnt unless u click on the macro. What have i done wrong?

 

[Mr. B]

What commands do you have in your macro?

If all you need to happen when you open the database is to open a form, just use the option from the Start Up options and specify the form that is to open.

 

[tom1252]

How can you use the startup option.

OpenForm frmSplashScreen, Form, , , , Normal
Maximize

 

[Mr. B]

You have not indicated which version of Access you are using, but if you are using Access 2003 or less, then go to Tools/Startup. Select the form you want to have load when your applicaiton starts from the "Display Form/Page" combo box.

If you are using 2997, click on the big round button and then click on the Access Options button located at the lower right of the form. Then click on the Current Database option on the right. Locate the "Display Form combo box and select the form you want to load when your applicaiton starts up.

 

[tom1252]

How do you get it to open max screen

 

[Mr. B]

Place the following VBA statement in the On Open event of your form:

DoCmd.Maximize