• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

Microsoft Access 2003

I have an unusual problem -- when a client opens their application and migrates to a different menu -- it opens to a VBA window and breaks on a line but is not erroring out. I can step on from the line and the rest of the code runs fine. Once this happens, the client can navigate to all menus with no problem.

I have cleared all break-points and compacted and repaired the application and it persists.
0
Eileen Murphy
Asked:
Eileen Murphy
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I've seen this happen occasionally.
Almost always cleared by rebooting the system.

mx
0
 
Anthony BerenguelCommented:
mx, do you know what causes this behavior?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I've had this happen a couple of times, and I vaguely remember it being from stop/breakpoints that were once there, but removed by the developer, but for some reason Access believes they are still there.  I was able to resolve this by deleting the lines in the area.

How it worked or why it happens in the first place?  No idea.

btw, 'Microsoft Access 2003' as a subject line doesn't work real well, as it doesn't describe your question.  'VBA breaks without a stop or breakpoint' would be better.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
jimhorn -- you're absolutely right. Thanks for the reminder.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"mx, do you know what causes this behavior?"

Well ... sort of.  Something literally gets 'stuck'.  Maybe a previous break point or error line.
It maybe happens to me 1x/year if that.
0
 
Rey Obrero (Capricorn1)Commented:
try decompiling your db, then compile, compact and repair

see this link

http://www.granite.ab.ca/access/decompile.htm
0
 
Luke ChungPresidentCommented:
It could be the Error Trapping setting on that machine. Error Trapping is set at the machine level, not the application, so you need to make sure you set it properly when your application starts. Are you raising errors in your classes?

Anyway, this is discussed in my paper Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6) which was also published on MSDN:
http://www.fmsinc.com/tpapers/vbacode/Debug.asp#BasicErrorHandling

It's part of our Microsoft Access Developer Help Center: http://www.fmsinc.com/MicrosoftAccess/developer/index.html

Hope this helps.
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Tried all of the above and wound up creating a new application, yanking everything in and got rid of it that way... I do believe that all of the above could and should have fixed it.

Those nasty little Microsoft gremlins can be a pain in the a@@.

Thanks again Experts!

Best, Eileen
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Tried all of the above and wound up creating a new application,"
Did you try rebooting your system as I suggested?
I've never seen that not work ?

Also, it appears that you did not really use any of the solutions posted ...?

mx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now