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.
ggodwinAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Open the DB, then Tools/Startup.   Look at "Display Form/Page".

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
There's nothing all encompassing that tells you that.

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.
0
 
Dale FyeCommented:
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).
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
ggodwinAuthor Commented:
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?
0
 
Dale FyeCommented:
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.Access OptionsThen, in the Access Options window, Access Options - Display Form (startup)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.
0
 
ggodwinAuthor Commented:
I am running Access 2003
0
 
Dale FyeCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.