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

Microsoft Access 2010 breakpoint and "stop" command not stopping code

I have a microsoft access 2010 application running in 2003 mode. There is an issue with code that runs a report called from a form. The code in the report activate event and other events will not stop when breakpoints and "stop" commands are set.
0
pabrann
Asked:
pabrann
3 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
...can you post the code?

Also take a look at your error trapping options in VBA.
"Break on all unhandled errors" is the default

Also can you clarify what you mean by:
microsoft access 2010 application running in 2003 mode
?
0
 
PatHartmanCommented:
Make sure you are opening the report in print preview or normal mode.  The code doesn't run in report view.
0
 
pabrannPresidentAuthor Commented:
I think I may have a hint as to the issue: when I issue the following:  DoCmd.OpenReport stDocName, acViewNormal

The breakpoints and "stop" code is bypassed. If I change the "acViewNormal" to "acViewPreview" they appear to work.
In my opinion this should not be the case but it appears so.
0
 
Nick67Commented:
:)
In my opinion this should not be the case but it appears so.
Opinions don't count in architecting of a program of which you aren't the author.
https://support.office.com/en-ca/article/Order-of-events-for-database-objects-e76fbbfe-6180-4a52-8787-ce86553682f9#bm5
Open --> Activate --> Close --> Deactivate

Now, Activate is when something becomes the active item in the Access UI.
deactivate is when something stops being the active item in the Access UI.
Printing does NOT show you the object hence when printing you have effectively
Open --> Close

In general, when printing, Access behaves like the run-time version--it may only break for you on errors or required input.
It's nothing new, in that regard.
It can make it tough to test some parts of your functionality without wasting paper, though!
0
 
pabrannPresidentAuthor Commented:
Perfect, thank you all very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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