Solved

View Code running at startup

Posted on 2014-01-03
7
439 Views
Last Modified: 2014-01-06
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.
0
Comment
Question by:ggodwin
  • 3
  • 2
  • 2
7 Comments
 
LVL 57
ID: 39754692
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
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39754746
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
 

Author Comment

by:ggodwin
ID: 39754871
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39754906
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
 

Author Comment

by:ggodwin
ID: 39758458
I am running Access 2003
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39758991
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 75 total points
ID: 39759133
Open the DB, then Tools/Startup.   Look at "Display Form/Page".

Jim.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now