Avatar of Richard Korts
Richard Korts
Flag for United States of America asked on

MS Access "Auto Exec"

I know there is a way to run a macro (or query) automatically when an Access database is opened.

I know there is a way to open an Access DB with an Auto Exec Macro and NOT execute the macro; I can't remember how?

How can I edit the Auto Exec Marco to change what it does?

Thanks
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
SOLUTION
Gottler

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Bembi

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Dale Fye

to bypass the macro or automatic opening of the "Display Form" (the form that is automatically opened at startup, which is set in the Access Options -> Current database), hold down the shift key as the database opens.
Richard Korts

ASKER
If there is an AutoExec Marco, is iit called "AutoExec" or something like that?

Thanks
Bembi

If it is an AutoExec Macro (and not auto statup form) then there is should be one, yes...
Another article for you.:
http://support.microsoft.com/kb/826765
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"I know there is a way to run a macro (or query) automatically when an Access database is opened."

It's a macro you create to do whatever - with a very specific name:
AutoExec

AutoExec macro
"I know there is a way to open an Access DB with an Auto Exec Macro and NOT execute the macro; I can't remember how?"

When you open the database, hold down the Shift key - until the db is completely opened. This will bypass the AutoExec macro (and/or any start up Form - as mentioned by fyed).  You will now able to edit the AutoExec macro.

Note that ... if this is not your db. it's possible that the Shift Key bypass has been removed, which then requires additional steps to get into the db.

mx