How do I... On opening file from hard disk, open a form

[BlueWolvering]

Hello,
Microsoft Access 2003.

I would like my Main Menu form to open when a user opens my database. So
far I am in no way networked or web based, I'll probably get there but right
now I have a file (Inventoryv4.mdb) that resides on the user's hard drive.
when she opens this file, I would like my main menu form to open, instead of
her having to go through the little task pane and dbl clk on frm_MAINMENU.

How might one do this?

***Note: I need the task pane with all the tables queries, forms etc to
still be there, just in the background, preferably minimized, and the main
menu open in the foreground.

Thanks

 

[KARL DEWEY]

Create a macro named Autoexec and have action Open - Form - frm_MAINMENU.
It will open the form automatticaly unless you hold down the shift key on
opening the database.

 

[DavidBoyle via AccessMonster.com]

It's more common nowadays to set your startup form as a database startup
option rather than using an autoexec macro. Under Tools/Statup you'll see a
field to display a form/page at startup.

Macros are not generally the best way to do anything in versions of access
since 97 and are included for backward compatibility with earlier versions.

 

[DavidBoyle via AccessMonster.com]

The hold shift key down works whichever way you go.