Stopping code on fail

[DubCap01]

Hi all,

Seems I have messed up the VBA options settings, so now if a piece of code fails, it just stops. I'd like to return to the errant piece of code that caused the fail, so it gets highlighted and I can fix it. Is anyone able to tell me what to set in VBA options please?



Thanks in advance, and I promise to stop playing around in there again

Pete

[Rawb]

Comment out the code beginning with "On Error GoTo".

[John_G]

I promise to stop playing around in there again

Please don't keep that promise!!

Error trapping and handling is an important part of VBA programming, as it allows you to take actions you want to have happen when an error occurs, rather than just letting Access stop with its own error message. There are times when you fully expect "errors" to occur as part of normal operations, and you want to able to deal with them.

That said, when trying to debug an application, you can turn off all error handling. In the VBA code window, select Tools - Options from the menu.
Click the General tab, then under Error Trapping, select the "Break on All Errors" option. This will deactivate all your On Error Go To... statements, so you don't have to make any changes to your code.

[DubCap01]

Hi John and Rawb

There are no entries of On Error goto.... in my code. But, having said that I know from the past that the code should stop/break on the fail error, but mine just zooms to a halt with no indication of the break error. I am desperately trying to reinstigate the break on any error, to save hours of frustrating code searching! MOre help needed!

chees
Pete

[orange]

Have you tried compact and repair? It could be some corruption...
Did you see John's post?

[John_G]

If your code is just stopping with no error message, and not giving you the option of debugging, that suggests that the problem is not a trappable run-time error. Instead, it may be a programming mistake which causes your code to run "normally" (i.e. without error messages) but not "correctly" (i.e. it isn't doing what you want it to), and those kinds of errors can be very hard to track down.

What are the symptoms of code failure that you are getting? You are not getting error messages, so what happens, or does not happen, to indicate code failure?