Solved

View Code running at startup

Posted on 2014-01-03
7
440 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

776 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