Access y2k debug does not work

  • Thread starter Thread starter inskeep
  • Start date Start date
I

inskeep

I'm working over an Y2K access database. It has quite a bit of VBA code.
I'm trying to test code by setting a 'break'. It doesn't break. It should.
What am I doing wrong?

binskeep
 
inskeep said:
I'm working over an Y2K access database. It has quite a bit of VBA code.
I'm trying to test code by setting a 'break'. It doesn't break. It should.
What am I doing wrong?
Click to expand...

It should? How do you know? Maybe the problem *is* that that very
portion of code doesn't get executed.

You are talking about a break point, right, set with F9? How is the
procedure where this break point sits called?
 
Good question: I can put the break point (make the line red with the red
dot) on the first executable statement in a 'Click' event and it goes right
through (it doesn't stop).
 
inskeep said:
Good question: I can put the break point (make the line red with the red
dot) on the first executable statement in a 'Click' event and it goes right
through (it doesn't stop).
Click to expand...

Well I never...! If you insert a line with MsgBox "Hello", does the
message show up?
 
I put a 'msgbox' at the beginning of the module and a breakpoint at the next
line. The msgbox pops up and when I click on OK, it just keeps on cruising
(not stopping at the break point). Baffling huh!
 
Frumble!

What happens if you press Ctrl-Break when the msgbox is in view, and
click/choose/whatever OK then? Do you get trace view?

Any unusual setting in Tools:Startup? (I cannot find suspect settings
though)

What access version are you using? 97?
 
Bas Cost Budde said:
Frumble!

What happens if you press Ctrl-Break when the msgbox is in view, and
click/choose/whatever OK then? Do you get trace view?

Any unusual setting in Tools:Startup? (I cannot find suspect settings
though)
Click to expand...

Tools -> Startup -> Use Access Special Keys.

I think if that box is unchecked, breakpoints don't work.
 
Your a Genius!

The 'Ctrl-Break' did not work from the msgbox.

I went to Tools|Startup and noticed that the 'Advanced - Use Access Special
Keys' was not checked. I checked it - Got out - Got in - set break after
msgbox - ran the pgm and was able to 'Ctrl-Break' at the msgbox. Not only
that! I ran it again without the 'Ctrl-Break' at the msgbox and it broke at
the 'break point'!

I put the final nail in the coffin by unchecking the 'Use Access Special
Keys' - got out - got in - set break point and it didn't work again.

Thanks again for believing that I wasn't crazy. I thought I was going
there...
 
Dirk said:
Tools -> Startup -> Use Access Special Keys.

I think if that box is unchecked, breakpoints don't work.
Click to expand...

Dead end. With me they do (or at least the one I just tried :-) )

A breakpoint is not some Special Key. Ctrl-Break will not work, nor will
F11, Ctrl-G.
The Help label suggests something about breaking execution? that holds
for ctrl-brk only.
 
inskeep said:
Your a Genius!

The 'Ctrl-Break' did not work from the msgbox.

I went to Tools|Startup and noticed that the 'Advanced - Use Access Special
Keys' was not checked. I checked it - Got out - Got in - set break after
msgbox - ran the pgm and was able to 'Ctrl-Break' at the msgbox. Not only
that! I ran it again without the 'Ctrl-Break' at the msgbox and it broke at
the 'break point'!
Click to expand...
So, when I tested, I didn't close Access where I should have. As the
name 'startup' implies. Well, happy you have your sanity back, and as
for me, either it is getting too late, or I didn't drink enough ;-)

Cheers.
 
Back
Top