Debugging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made some small changes in a program this morning and now when I run it the
forms seem to blink...as if it's running some sort of program in the
background (and, in fact, in the lower-right corner it says
'Calculating...'). I tried to retrace my steps and have gone over my code
and can't seem to find where the problem is. I suspect its a loop or requery
operation that's out of place, but can't locate a problem. I've tried to
stop the program (Ctrl+C; Ctrl+S; Ctrl+X; Pause key on keyboard) in hopes
that it would open up to the code area that's giving me the problem but, no
dice. Can someone please tell me how they would approach identifying the
cause of a problem like this? Is there a debug tool that I should be using
here?
 
I made some small changes in a program this morning and now when I run it the
forms seem to blink...as if it's running some sort of program in the
background (and, in fact, in the lower-right corner it says
'Calculating...'). I tried to retrace my steps and have gone over my code
and can't seem to find where the problem is. I suspect its a loop or requery
operation that's out of place, but can't locate a problem. I've tried to
stop the program (Ctrl+C; Ctrl+S; Ctrl+X; Pause key on keyboard) in hopes
that it would open up to the code area that's giving me the problem but, no
dice. Can someone please tell me how they would approach identifying the
cause of a problem like this? Is there a debug tool that I should be using
here?
Click to expand...

I think you have to use Ctrl-Break or Ctrl-Shift-Break to halt the
code execution.
 
Open your VBA Editor. Find an executeable line of code where you want to
start tracing. Press F9 (BreakPoint). Start your code running. It will
stop on the selected line. You can use F8 to step through the code a line at
a time. Also look at the Debug item on the tool bar for other options.
 
Back
Top