Debug/Step mode in macro/VBA

  • Thread starter Thread starter Jim
  • Start date Start date
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!
 
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 :)
*
 
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...
 
Back
Top