Code for Break on Unhandled Errors

N

Neil

Does anyone have any code for setting the VBA option to "Break on Unhandled
Errors" (Access 2000). Thanks!

Neil
 
S

Stuart McCall

Neil said:
Does anyone have any code for setting the VBA option to "Break on
Unhandled Errors" (Access 2000). Thanks!

Neil
Click to expand...

Application.SetOption "Error Trapping", 2

0 = Break on all errors
1 = Break in class module
2 = Break on unhandled errors
 
N

Neil

Thanks, Stuart!

Stuart McCall said:
Application.SetOption "Error Trapping", 2

0 = Break on all errors
1 = Break in class module
2 = Break on unhandled errors
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting VBA Options Via Code 5
Error Trapping 6
Stop doesn't work in MSAccess VBA event procedure 1
Worksheet Exists? 1
Code breaks despite error handler 6
How to programmatically set Error Trapping in VBE 4
VBA SETTINGS - WHAT THEY DO WITH DIFFERENT ERRORS? 2
Run Time error 3079 7

Top