F8 key won't step thru code

  • Thread starter Thread starter BAC
  • Start date Start date
B

BAC

I'm trying to debug a new sub in VBA but the F8 key won't step through the
code. I start out with an input box to get a date, but when I hit the OK key
the program simply termonates.

I"ve tried to put a STOP statement immediately following the inputBox, and
set a sto (F9) on the statement immediately following the InputBox, but
neither stops execution. I do not now idf anything beyond the Input box is
executing.
I have set the option to Break on all errors, and have tried Break in Class
Module but there seems to be no difference.
I have commented out all my On Error statements and the error handler as well.

I'm at a loss!

Any help wold sure be appreciated

TIA
 
Have you tried an actual breakpoint in the code?? On the grey strip on the
left hand side of the vbe window, click. If you're on an executable code
line (not a dim statement) you should see a red and dot and the line will
highlight red. This automatically breaks the code and pulls the window up
for you to F8 through it.
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
BAC said:
I'm trying to debug a new sub in VBA but the F8 key won't step through the
code. I start out with an input box to get a date, but when I hit the OK
key
the program simply termonates.

I"ve tried to put a STOP statement immediately following the inputBox, and
set a sto (F9) on the statement immediately following the InputBox, but
neither stops execution. I do not now idf anything beyond the Input box is
executing.
I have set the option to Break on all errors, and have tried Break in
Class
Module but there seems to be no difference.
I have commented out all my On Error statements and the error handler as
well.

I'm at a loss!
Click to expand...


Check your startup options (Tools -> Startup). If the option "Use Access
Special Keys" is not checked, breakpoints and debugging keys won't work.
 
Outstanding!

Thanks

Dirk Goldgar said:
Check your startup options (Tools -> Startup). If the option "Use Access
Special Keys" is not checked, breakpoints and debugging keys won't work.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
That's what the F9 key I mentioned does => couldn't remember the term "Break
Point"..

Dirk Goldgar got it, tho

Thanks anyway

BAC
 
Dear Dirk Goldgar,

I am facing the same situation. However, I am using Windows 7. Can you please tell me where exactly I will get to check "Use Access Special Keys".

Please help me.
 
Back
Top