RE: Breakpoints in VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry

just in case you are not aware and in support of Daniel's answer, press F8 to
single step your code. Also, you can type the word Stop in between lines of
code but it does the same as a breakpoint.
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Daniel Pineault" wrote:

David,

You would need to supply us with your code to review.

Also, in 8+yrs of coding this has never occured. It is most likely that you
have a conditional statement that is not evaluating as you expected ...

One approach I use when i have such problems is to set a break point at the
very first line in my routine and then run the code line by line until I
identify the source of my problem. While doing this evaluate your variable
and ensure that they are giving the results you expected and coded for. this
can be teadeous, but you will no doubt identify the underlying source of your
problem.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"David" wrote:

Hello,
one application of mine doesn't respect breakpoints and runs always till the
end of code. How can I force code to stop at breakpoints ?
Thanks for your help.
David
.

Quantcast