Solved

Access 2007 - macro to run when the file is opened

Posted on 2014-07-25
5
1,392 Views
Last Modified: 2014-07-25
My OS is win 7 prof 64 bit and I use Access 2007.  I am trying to create a Macro which will run (it will open the main Form) when I open the Access file.  What should be the name of the Macro, and is there any special extensions to the name.  Thank u.
0
Comment
Question by:jegajothy
  • 2
  • 2
5 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 334 total points
ID: 40219787
Just name it AutoExec

 as long as the shift key is not held down, it will run.

Jim.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 334 total points
ID: 40219791
By the way, don't miss the startup form in Options either; you don't have to use a macro.

Jim.
0
 
LVL 36

Assisted Solution

by:PatHartman
PatHartman earned 166 total points
ID: 40219799
When a database is opened, Access looks for a macro named specifically - AutoExec.  If the macro exists, Access runs it.

You also have the option of specifying a start up form to use rather than a macro.  The form can serve the function of the AutoExec by running whatever code/queries/macros you need to run at startup.  If you specify a "Display Form" on the Current Database tab of the Access Options dialog, you do not need to create an AutoExec macro.  Although Access allows both to be specified, you don't need both.  Just settle on one (my preference is code in a form) so you won't get confused later and end up splitting start up functions so some run in one place and others in another.
0
 

Author Closing Comment

by:jegajothy
ID: 40220431
thank u everyone for your suggestions, AutoExec was what i was looking for, as it gives me more options of running other maintenance issues before the main Form displays.  Thanks u everyone.
0
 
LVL 36

Expert Comment

by:PatHartman
ID: 40220457
Actually, it doesn't.  But as long as you don't define both an AutoExec and a start up form, you'll be fine.  Just open the start up form as the last step of the macro.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question