Code for Break on Unhandled Errors

Neil · Nov 1, 2007

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

Neil

tina · Nov 1, 2007

see the SetOption Method topic in VBA Help.

hth

Stuart McCall · Nov 1, 2007

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

Neil

Application.SetOption "Error Trapping", 2

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

Neil · Nov 1, 2007

Well, I feel pretty dumb. Forgot about that. Thanks!

Neil · Nov 1, 2007

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

tina · Nov 2, 2007

you're welcome

Neil said:
Well, I feel pretty dumb. Forgot about that. Thanks!