Link to home
Start Free TrialLog in
Avatar of force3inc
force3inc

asked on

MS Access 2010: Breakpoints not hit when debugging

For some reason, all of a sudden, when I am debugging code in a module, the execution no longer stops on my breakpoints, it just runs to the end.

I've compacted/repaired, with no results. I don't get any compile errors - execution just blows by any breaks....

Any suggestions would be greatly appreciated.
Avatar of mona4980
mona4980

The only reason I know that could happen is because the code is not running where your breaks are. For instance if you have code like:

If txtTest <> '' then
   do something here with a break
end if

if txtTest is null and not '' then it will not go to that break.
You have any code you want to show?
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Have you tried rebooting your system (seriously) ?

mx
Also, try inserting a MsgBox in a couple of places where you want to Break ... and see if those get triggered ?

mx
Avatar of force3inc

ASKER

I have tested another db and it works properly, using the same function - so it appears to be a problem with the particular db - and no, I have not re-booted my system. If all else fails, I will create a new db and import the objects. But, I'd really like to find out why this is happening.

I tested a simple process by inserting a break point and the function returned the expected result, it just failed to break on any breakpoint....
1) Try the message box suggestion

2) Reboot ... VBA *does* get stuck sometimes ... I've seen this before.

mx
Is the "stuck" situation general (i.e. applies to all db's), or can it be just for a particular db?
What are your error trapping options set to in your VBE?
Try: Break on  All Errors
ASKER CERTIFIED SOLUTION
Avatar of force3inc
force3inc

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"Is the "stuck" situation general (i.e. applies to all db's), or can it be just for a particular db?"
Sorry ... missed this before.
I guess either way.

mx
Thanks for all suggestions....
This the quickest way to fix the issue and move on.