Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Access VBA stops at hidden/cleared breakpoint

Posted on 2009-02-24
8
Medium Priority
?
1,411 Views
Last Modified: 2013-11-27
I placed a breakpoint on a line in VBA for my Access database (in the On Load for the form that loads on startup).  I subsequently cleared the breakpoint.  However, Access still halts on the VBA as if the breakpoint was still there.  Any suggestions?

Thanks!
0
Comment
Question by:Chris
  • 4
  • 2
  • 2
8 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 23723837
In the VBE, have you tried Debug menu --> Clear All Breakpoints?  If the problem still persists please post the procedure and indicate where it is halting.

OM Gang
0
 
LVL 58
ID: 23723894
I've seen this numerious times and it's a pain in the butt to get rid of.  I've generally find it's a result of having a break point active, then modifying the number of lines in the procedure.
I've never found a good way to clean it up either.
Usually what I do is try adding/deleting a line, then click on the offending line and toggle the break point on and off a few times.
If that doesn't do it, then I import everything into a fresh DB.
JimD.
0
 
LVL 28

Accepted Solution

by:
omgang earned 2000 total points
ID: 23723933
Based upon what JimD posted above I found this link
http://objectmix.com/ado-dao-rdo-rds/353825-re-access-xp-why-does-debugger-break-when-i-have-no-breakpoi.html

Give that a try.

OM Gang
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Closing Comment

by:Chris
ID: 31550656
Commenting out the line did the trick!  Thanks!
0
 
LVL 28

Expert Comment

by:omgang
ID: 23724822
Orcadian, JDettman identified what the problem was.  I found the link I provided based upon his comment.  My opinion that JDettman should have received some of the points on this.

Thanks,
OM Gang
0
 

Author Comment

by:Chris
ID: 23724855
OM Gang - That is very admirable of you.  I agree. Can I adjust the points, or do we need a moderator?
0
 
LVL 28

Expert Comment

by:omgang
ID: 23724948
You should see a Request Attention link at the bottom right of your original post.  Click that link and ask to have a moderator change the award and the points distribution as you see fit.

Thanks,
OM Gang
0
 
LVL 58
ID: 23725317
Appreciate that, but don't bother.  I really just confirmed that the problem existed.  As I said, I didn't have a good method for cleaning it up.  Importing to a fresh DB container is overkill.
JimD.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
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…
Suggested Courses

577 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