Debug/Step mode in macro/VBA

J

Jim

I'm trying to make a minor code addition to an undocumented Access 2000 app
under v2003.

A menu selection executes a RunCode calling a function
RunBeginUpdatePricing(). I've looked in all obvious modules for this
function and came up with nothing...

First question, is there a way to turn ON tracing/stepping (in the macro)
so I can see where this code is executing from? Will this automatically open
the VBA editor?

Second, is there keyboard shortcut that will EXIT or SKIP the remaining part
of a procedure or function and continue on to the next proc/func? If I knew
where the code was going, I would just comment out the line that calls the
function. But I want to be able to "mark my trail" yet skip over the
functions whose purpose I've already determined.

Thanks!
 
S

strive4peace

Hi Jim,

if you want to execute one line at a time, you can set a Breakpoint in
the code, which is temporary -- or you can put this statement in your code

Stop
(just remember to take it out when you are done debugging <smile>)

once the code stops, press the F8 key repeatedly to execute one line at
a time

~~~

Error Handling and Debugging Tips and Techniques for Microsoft Access,
VBA, and Visual Basic
by Luke Chung
http://www.fmsinc.com/tpapers/vbacode/Debug.asp

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 
J

Jim

Thanks!
--
Jim McDermott


strive4peace said:
Hi Jim,

if you want to execute one line at a time, you can set a Breakpoint in
the code, which is temporary -- or you can put this statement in your code

Stop
(just remember to take it out when you are done debugging <smile>)

once the code stops, press the F8 key repeatedly to execute one line at
a time

~~~

Error Handling and Debugging Tips and Techniques for Microsoft Access,
VBA, and Visual Basic
by Luke Chung
http://www.fmsinc.com/tpapers/vbacode/Debug.asp

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

From FoxPro/VFP to Access 9
step through query records in vba 10
Using a VBA Variable function from Access table data in Access que 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Stop Macro in VBA 3
Convert "OutputTo" to vba code 1
VBA function runs in debug mode but not in macro. 3

Top