Solved

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

Posted on 2012-04-03
9
567 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 48

Expert Comment

by:Dale Fye
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 58

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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 58
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 48

Expert Comment

by:Dale Fye
ID: 37802390
A little extreme, don't you think, Joe?
0
 
LVL 58
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

627 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