Best Way to Debug Startup Code?

[paul.schrum]

Access 2003, DAO

I need to debug code which is called on startup. Of course, the code
executes before I have a chance to set a break via the VBA IDE/editor.

What is the recommended way around this? Is there a hard-coded break
I can insert which will raise the IDE yet not cause an error
condition?

TIA.

- Paul Schrum

 

[Bob Quintal]

@j39g2000yqn.googlegroups.co
m:

Access 2003, DAO

I need to debug code which is called on startup. Of course, the
code executes before I have a chance to set a break via the VBA
IDE/editor.

What is the recommended way around this? Is there a hard-coded
break I can insert which will raise the IDE yet not cause an error
condition?

TIA.

- Paul Schrum

Stop

Syntax

Stop

Remarks

You can place Stop statements anywhere in procedures to suspend
execution. Using the Stop statement is similar to setting a
breakpoint in the code.

The Stop statement suspends execution, but unlike End, it doesn't
close any files or clear variables, unless it is in a compiled
executable (.exe) file.

 

[paul.schrum]

Bob,

Thanks for the help. Stop does exactly what I need.

- Paul