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!

--
Jim McDermott

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
*




Jim wrote:
> 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!
>

Thanks!
--
Jim McDermott


"strive4peace" wrote:

> 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
> *
>
>
>
>
> Jim wrote:
> > 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!
> >
>

you're welcome, Jim happy to help

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
*




Jim wrote:
> Thanks!