If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > VBA Code breakpoints

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-03-08, 10:45
stuschmied stuschmied is offline
Registered User
 
Join Date: May 2008
Location: Raleigh, NC
Posts: 151
VBA Code breakpoints

Hi All,

I was debugging some code and had a breakpoint inserted. I fixed the problem and removed the breakpoint but the app continues to 'break' at that point, brings up the VB editor and makes me hit F5! I've removed all of the breakpoints, I've compiled it multiple times and saved the code and I've compacted and repair the db and it still 'breaks'!

Any ideas?

Thanx, Stu

PS: Access 2003 SP3
__________________
--If its free, take it for what its worth!
Reply With Quote
  #2 (permalink)  
Old 11-03-08, 10:48
garethdart garethdart is offline
Registered User
 
Join Date: Sep 2002
Location: South Wales
Posts: 580
I've encountered this too - I would try and put the bp in again in the same place, remove it then debug / compile / save and try again. Give it a go...?
__________________
Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull
Reply With Quote
  #3 (permalink)  
Old 11-03-08, 10:52
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
I've had this too although the "remove all breakpoints" option has always sorted it (maybe with a compact and repair too). You explicitly selected the "remove all breakpoints" option right?
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #4 (permalink)  
Old 11-03-08, 10:54
stuschmied stuschmied is offline
Registered User
 
Join Date: May 2008
Location: Raleigh, NC
Posts: 151
Yes

I use the pull down and select 'remove all breakpoints' and I've compacted and repaired. I'm going to try to import into a fresh app and see what happens.
__________________
--If its free, take it for what its worth!
Reply With Quote
  #5 (permalink)  
Old 11-03-08, 10:56
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
I think it 99% probable that this is not the case but ya never know - you don't have a STOP command in there do you? Grasping...straws...I know.
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #6 (permalink)  
Old 11-03-08, 10:58
stuschmied stuschmied is offline
Registered User
 
Join Date: May 2008
Location: Raleigh, NC
Posts: 151
Negative

No stop command. I have had this before and it always cleared itself somehow. I can't remember if I did something I'm forgetting, I think I did. I'll let you know how the import into the new app goes.
__________________
--If its free, take it for what its worth!
Reply With Quote
  #7 (permalink)  
Old 11-03-08, 11:27
stuschmied stuschmied is offline
Registered User
 
Join Date: May 2008
Location: Raleigh, NC
Posts: 151
Finally!

After numerous attempts of getting everything into a new app (way too many forms and queries!) I've finally been able to get it not to 'break'. I did double check all refs and compacted and repaired, so I'm hoping it flushed out whatever it was. Just wish I knew what it was as to avoid it in the future. Thanks for the assists everyone!
__________________
--If its free, take it for what its worth!
Reply With Quote
  #8 (permalink)  
Old 11-03-08, 22:21
StarTrekker StarTrekker is offline
L33t Helpa Munky
 
Join Date: Nov 2007
Location: Adelaide, South Australia
Posts: 4,049
I've encountered this too. I have also always corrected it by setting a breakpoint and then using the Clear All Breakpoints command.
__________________
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!


"Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
"...teach a man to code and he'll be frustrated for life! " -- georgev
Reply With Quote
  #9 (permalink)  
Old 02-04-12, 11:31
wenckdm wenckdm is offline
Registered User
 
Join Date: Feb 2012
Posts: 1
vba brbreak point always triggered at start of access application

I set a break point in an access module. It triggered. I cleared it by using "clear all break points". Closed application (Compact and Repair) set on close.
Re-opened the application and break point triggered.
I selected the module and selected all the code and set them as comments.
I then ran the application and of course an error occurred. I stopped the application, saved it, closed it and then opened it again. I then un-commented the module. It ran without triggering the break point.

Still wondering why the break point triggered even when not sent.

If anyone knows why or a better way to make this type of error go away, please let me know.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On