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

  • Thread starter Thread starter BlueWolvering
  • Start date Start date
B

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
 
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.
 
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.
 
Back
Top