Problems with breakpoints

[NeilK]

Hi,

I have a problem with my VBA code that I can't figure out. Well, actually the code seems to work, but when I add a breakpoint the code does not stop. The breakpoint doesn't seem to get recognized at all.

I have written text to the Immediate Window to make sure that my functions with breakpoints are being run, and the code does get run. There may be a very simple solution (an ignore breakpoints option?), but I can't find anything in the help. Also, breakpoints in this database use to work fine, then one day they just stopped.

Any ideas? Thanks!

 

[KenHigg]

Check your ref's?

???
ken

 

[WayneRyan]

Neil,

Hard to tell without seeing it, but there are two things you can do:

1) Do a Compact/Repair (why not ...)

2) Instead of a breakpoint, insert a line with STOP! That'll stop it. Maybe
your code is not even running (wrong event?)

Wayne

 

[KenHigg]

Will it let you put a breakpoint on non-valid 'Breakpoint' line?

???
kh

 

[NeilK]

Breakpoints not working

1) I am certain my code is executing, as I am printing strings to the immediate window after the breakpoint
2) The STOP command didn't work
3) The compact/repair didn't fix the problem either

Any more ideas? This has had me stumped for a while.

 

[WayneRyan]

Neil,

If STOP didn't "Stop" then, your code is not executing! Maybe you have
the wrong event.

Wayne

 

[ghudson]

You can place Stop statements anywhere in procedures to suspend execution. Using the Stop statement is similar to setting a breakpoint in the code.

Listen to what Wayne suggests. You could throw in a couple of message boxes just to test at what point the code is not working [or not working at all]. Add a message box to the beginning of the events in question just to determine which events are being triggered.

 

[rata]

Special Access Keys setting

I had the same problem till 10 minutes ago.

From Microsoft KB Arcticle.

This behavior is by design and occurs when the Advanced Startup option, Use Special Access Keys, is disabled.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;296848

 

[NeilK]

Fixed

Thank you very much! This worked! The article suggested using the STOP keyword, which did not work for me, but checking the 'Use Special Access Keys' option did.