VB break point does not work?

[Henry]

I put the break point in the VB event code, then open form with Access 2003.
The code does not stop at break point. I add in MsgBox before the break point
and run again. Again, I got the MsgBox comes up, but the program does not
stop. Any sugestion is really appreciated.

Thanks,
Henry

 

[George Nicholson]

Try:

Tools>Startup> then check "Use Access Special Keys" (which includes Pause
Execution)

HTH,

This is somewhat anecdotal. I don't find this to be 100% consistent, as I
can *usually* set a breakpoint and have it work even if this setting is
unchecked. However, if I find that breakpoints aren't working, changing this
setting seems to fix it.

HTH,

 

[Henry]

Thanks a lot!! It works now. Now I know why it only happens after I set up
program "auto start".

Henry

 

[John W. Vinson]

I put the break point in the VB event code, then open form with Access 2003.
The code does not stop at break point. I add in MsgBox before the break point
and run again. Again, I got the MsgBox comes up, but the program does not
stop. Any sugestion is really appreciated.

Thanks,
Henry

I've seen this happen when the database is getting corrupted. Try Compact and
Repair; if that doesn't help, see the instructions for decompiling the
database at
http://www.granite.ab.ca/access/corruptmdbs.htm

Decompile the database; compact it; open the VBA editor and recompile; then
compact once again.

John W. Vinson [MVP]

 

[Henry]

Thanks. I have another real bad database. I will try the database decompiling
to see if it fixes thing.

Henry Nguyen