?
Solved

MS Access 2010: Breakpoints not hit when debugging

Posted on 2011-04-28
11
Medium Priority
?
1,036 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:force3inc
11 Comments
 
LVL 1

Expert Comment

by:mona4980
ID: 35487710
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?
0
 
LVL 75
ID: 35487727
Have you tried rebooting your system (seriously) ?

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

mx
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:force3inc
ID: 35488215
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....
0
 
LVL 75
ID: 35488222
1) Try the message box suggestion

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

mx
0
 

Author Comment

by:force3inc
ID: 35488229
Is the "stuck" situation general (i.e. applies to all db's), or can it be just for a particular db?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35513366
What are your error trapping options set to in your VBE?
Try: Break on  All Errors
0
 

Accepted Solution

by:
force3inc earned 0 total points
ID: 35516823
I just imported all objects into a new database, and that worked. I was looking for a reason I was having the problem in the first place, oh well....
0
 
LVL 75
ID: 35516838
"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
0
 

Author Comment

by:force3inc
ID: 35516847
Thanks for all suggestions....
0
 

Author Closing Comment

by:force3inc
ID: 35714895
This the quickest way to fix the issue and move on.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question