Can MS access VBA run step into, like Excel VBA F8 button

[johnseito]

I am pretty new to access, so I don't know much of it's use and functions.

But I am wondering does MS access VBA has the step into function that allow
me to run the code step by step to see what it is doing and what value is storing in
the variable so is easier to trouble shoot and manipulate the codes like Excel VBA has
with the F8 button?

Thanks

 

[pbaldy]

Yes; JasonM has a FAQ here:

http://www.baldyweb.com/Debugging.htm

 

[johnseito]

Ok, thanks. Interestingly both Jason and you have the same baldy, does it stand for something.

Also I went into my code editor by pressing alt F11 and I press F8 to step into the code and it doesn't do it.

In excel VBA, normally I just alt F11 to get into VBE and then I just press F8 to step into the code.

I looked Jason web page and while he did mention F8, I couldn't use it to step into the code line by line. Any ideas? Thanks.

 

[Pat Hartman]

Did you set a break to stop the code initially? Just click in the left margin on the line where you want to stop. Once the code stops, you can use F8 to step through it.

 

[johnseito]

Ok, thanks. The code I have is kind of weird, it doesn't run until I open or refresh the form.

so I just close the form, set a break point and then open the form again, it runs to the break point and then I just press F8.

Is a private sub form_current.

 

[pbaldy]

Ok, thanks. Interestingly both Jason and you have the same baldy.

Jason closed his site but let me host his FAQ's on mine.