ggodwin
asked on
View Code running at startup
I would like to know how I can see the order of the code that runs upon opening my access database?
Basically, I know that code is running but I dont know how to view and edit this order.
Basically, I know that code is running but I dont know how to view and edit this order.
First, check whether you have a macro with a name AutoExec
Then check in your databases options to see if there is a StartUp form defined in the Current Database options. If there is, then check whether that form has code in either the Open, Load, or Timer events as all of those events will fire when the form loads (Timer Event will only fire if the TimerInterval property of the form is set to something other than zero).
Then check in your databases options to see if there is a StartUp form defined in the Current Database options. If there is, then check whether that form has code in either the Open, Load, or Timer events as all of those events will fire when the form loads (Timer Event will only fire if the TimerInterval property of the form is set to something other than zero).
ASKER
I do not have the AutoExec macro.
I did not find Startup in the options button.
In the tools menu I found "Startup". and I did find the Display Form/Pages area. But, here I have several forms listed.
Am I in the right area?
I did not find Startup in the options button.
In the tools menu I found "Startup". and I did find the Display Form/Pages area. But, here I have several forms listed.
Am I in the right area?
what version of Access are you running?
In 2007, you click the windows icon in the upper left corner, then the Access Options button at the bottom of that popup.Then, in the Access Options window, select the Current Database button (upper left) and look for the name of the "display form". If there is a form listed there, it will be opened automatically when you open your application.
In 2007, you click the windows icon in the upper left corner, then the Access Options button at the bottom of that popup.Then, in the Access Options window, select the Current Database button (upper left) and look for the name of the "display form". If there is a form listed there, it will be opened automatically when you open your application.
ASKER
I am running Access 2003
I haven't used 2003 in a while and have it on another computer at home. I don't remember precisely how to get to the options in 2003. Maybe someone else can chime in.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Access starts with the Autoexec macro if it exists, and then the start form.
Beyond that, once VBA procedures start executing, you can look at the stack in the VBA editor.
Jim.