Opening a custom menu by default

[jackeric]

(Access 2007)
I have a database with 13 tables thus 13 forms. I've created a custom menu to access my forms.

What I'd like to achieve (without VBA if possible, I know nothing about it) is when opening my database, I want that custom menu to open automatically by default.

Is this possible ?

 

[MSAccessRookie]

I assume that you meant to say that you have created a customized SwitchBoard Form to use as the front door to your database.

We do not use Access 2007 here yet, but in Access 2003, there is an option under the TOOLS menu called STARTUP, and one of the items you can define there is the first form to load. You can modify it to be your switchboard instead of any other form that is already there.

I will also assume that Access 2007 has a similar option availableas well.

 

[georgedwilkinson]

Without VBA in Access 2007:
Click on the circular main menu in the upper left corner (looks like a butterfly), select "Access Options" at the bottom right of the menu, select "Current Database" in the left hand pane, and put the name of the form you want to display on startup in the "Display Form:" DDL.

 

[MSAccessRookie]

I knew there would be an Access 2007 expert lurking around here somewhere! Thanks, George

 

[jackeric]

Without VBA in Access 2007:
Click on the circular main menu in the upper left corner (looks like a butterfly), select "Access Options" at the bottom right of the menu, select "Current Database" in the left hand pane, and put the name of the form you want to display on startup in the "Display Form:" DDL.

That's it ! Many Thanks

 

[georgedwilkinson]

NP, always glad to help.