F8 key won't step thru code

[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

 

[Jack Leach]

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)

 

[Dirk Goldgar]

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!

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

 

[BAC]

Outstanding!

Thanks

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)

 

[BAC]

That's what the F9 key I mentioned does => couldn't remember the term "Break
Point"..

Dirk Goldgar got it, tho

Thanks anyway

BAC

 

[akash.add]

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.