Breakpoints Window

[Bill]

In Access 2003, where do I find the Breakpoints
Window where I can set a condition upon which
the breakpoint becomes active?

Thanks,
Bill

 

[Jeanette Cunningham]

It's also called the code window or the immediate window.
Ctl + G will open it for you.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Bill]

The immediate window is where I would go to
view the output of "Debug.Print". Unless I'm
missing something here, I don't get that I can
enter a condition that will turn on a breakpoint
like the HELP describes.

What I want to do is single-step through code
when a certain name is reached in a cloned
recordset.

Bill

 

[Jeanette Cunningham]

In the immediate window, choose the line where you want the code to stop so
you can single step.
Click in the very far left of that line, and the line will be highlighted
(often red).
That is called Setting a breakpoint.

Now run the code by opening the form and using the buttons etc.
When access gets to the line with the breakpoint, the immediate window will
open.
Press F8 to move to the next line of code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[BruceM via AccessMonster.com]

Just to clarify a little, select the line of code in the main VBA window, not
hte immediate window.

In the immediate window, choose the line where you want the code to stop so
you can single step.
Click in the very far left of that line, and the line will be highlighted
(often red).
That is called Setting a breakpoint.

Now run the code by opening the form and using the buttons etc.
When access gets to the line with the breakpoint, the immediate window will
open.
Press F8 to move to the next line of code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

The immediate window is where I would go to
view the output of "Debug.Print". Unless I'm

[quoted text clipped - 19 lines]

 

[Bill]

Somehow, I'm not making myself clear. I know how to
set breakpoints and single-step code in Debug. What
I haven't been able to find is how to have a breakpoint
disabled until a certain record is reached.

Bill

Just to clarify a little, select the line of code in the main VBA window,
not
hte immediate window.

In the immediate window, choose the line where you want the code to stop
so
you can single step.
Click in the very far left of that line, and the line will be highlighted
(often red).
That is called Setting a breakpoint.

Now run the code by opening the form and using the buttons etc.
When access gets to the line with the breakpoint, the immediate window
will
open.
Press F8 to move to the next line of code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

The immediate window is where I would go to
view the output of "Debug.Print". Unless I'm

[quoted text clipped - 19 lines]

Thanks,
Bill

 

[Stuart McCall]

In Access 2003, where do I find the Breakpoints
Window where I can set a condition upon which
the breakpoint becomes active?

Thanks,
Bill

In the VBE, Debug -> Add Watch

 

[Bill]

Thank you. Obviously, the online HELP text I
found did not pertain to VBA 2003. Funny that
VBA HELP issued from within VBA edit did not
reveal "add watch" when conditional break in debug
was searched, oh well.

Thanks again,
Bill