Solved

Access VBA pauses at a line that used to have a breakpoint

Posted on 2012-04-03
9
561 Views
Last Modified: 2012-04-04
Access VBA pauses at a line that used to have a breakpoint.  The line turns yellow, but there's no red indicating a breakpoint.  When I click the "run" arrow, it continues.

I've cleared all breakpoints.  I also made a copy, and that does it, too.  How do I make it stop stopping?
0
Comment
Question by:Barry Sweezey
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37801959
1. back up

2. After clearing all breakpoints, try a compact and repair.

3. It that still doesn't work, try decompiling and recompiling the database.  I usually do this via a batch file on my desktop (do it once or twice a week for the app I'm working on at the time).

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Users\xxx.yyy\Documents\Work\Access\myDb.accdb" /decompile

The stuff in the first set of quotes is the full path and filename where your version of Access resides (probably not Office12 from your post).  The second is the full path and filename of your database file.

Then do another compact/repair operation and then recompile.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 250 total points
ID: 37801960
Try cutting the offending line and pasting it back to the same place.

I've seen breakpoints refuse to clear occasionally - not sure what causes it, but deleting/reentering the line seems to do the trick for me.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 37801983
VBA is notorious for phantom breakpoints.  Copy the line to notepade, delete it.  Do a compile.  Close and then compact and repair the DB, then re-open and paste the line back in.  Then compile and save.

 That usually gets rid of it.

Jim.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 57
ID: 37801989
BTW, sometimes just adding a line or two, then doing a clear all breakpoints will take care of it to.

Jim.
0
 
LVL 75
ID: 37802334
Believe it or not ...  Reboot your system ... done. Gone.

mx
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37802390
A little extreme, don't you think, Joe?
0
 
LVL 57
ID: 37802699
<<A little extreme, don't you think, Joe?>>

  Maybe, but from where I sit, Windows needs a reboot as soon as it gets started....

 Actually I'll take that back...Windows 7 is a lot more stable then past versions were and it seems pretty solid even without reboots.

 Interesting though that a reboot would take care of it.  Never knew that.

Jim.
0
 
LVL 75
ID: 37802708
"A little extreme, don't you think, Joe?"

Nooooo ... because that's what it takes.

mx
0
 

Author Closing Comment

by:Barry Sweezey
ID: 37807568
I deleted the line, compiled, reinserted the line, and compiled again.  It runs without stopping now.  Thanks!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

806 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