Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access 2007 - macro to run when the file is opened

Posted on 2014-07-25
5
Medium Priority
?
1,441 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 58

Accepted Solution

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

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

Jim.
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1336 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 40

Assisted Solution

by:PatHartman
PatHartman earned 664 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 40

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

578 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