Code for Break on Unhandled Errors

Code for Break on Unhandled Errors

am 01.11.2007 02:13:04 von DM McGowan II

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

Neil

Re: Code for Break on Unhandled Errors

am 01.11.2007 03:41:56 von tina

see the SetOption Method topic in VBA Help.

hth


"Neil" wrote in message
news:AK9Wi.13090$4V6.3308@newssvr14.news.prodigy.net...
> Does anyone have any code for setting the VBA option to "Break on
Unhandled
> Errors" (Access 2000). Thanks!
>
> Neil
>
>

Re: Code for Break on Unhandled Errors

am 01.11.2007 05:00:02 von Stuart McCall

"Neil" wrote in message
news:AK9Wi.13090$4V6.3308@newssvr14.news.prodigy.net...
> 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

Re: Code for Break on Unhandled Errors

am 01.11.2007 06:10:44 von DM McGowan II

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

"tina" wrote in message
news:U1bWi.309989$ax1.88823@bgtnsc05-news.ops.worldnet.att.n et...
> see the SetOption Method topic in VBA Help.
>
> hth
>
>
> "Neil" wrote in message
> news:AK9Wi.13090$4V6.3308@newssvr14.news.prodigy.net...
>> Does anyone have any code for setting the VBA option to "Break on
> Unhandled
>> Errors" (Access 2000). Thanks!
>>
>> Neil
>>
>>
>
>

Re: Code for Break on Unhandled Errors

am 01.11.2007 06:11:15 von DM McGowan II

Thanks, Stuart!

"Stuart McCall" wrote in message
news:fgbj0g$du$1$8302bc10@news.demon.co.uk...
> "Neil" wrote in message
> news:AK9Wi.13090$4V6.3308@newssvr14.news.prodigy.net...
>> 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
>
>
>

Re: Code for Break on Unhandled Errors

am 02.11.2007 03:07:59 von tina

you're welcome :)


"Neil" wrote in message
news:UddWi.3323$%Y6.972@nlpi061.nbdc.sbc.com...
> Well, I feel pretty dumb. Forgot about that. Thanks!
>
> "tina" wrote in message
> news:U1bWi.309989$ax1.88823@bgtnsc05-news.ops.worldnet.att.n et...
> > see the SetOption Method topic in VBA Help.
> >
> > hth
> >
> >
> > "Neil" wrote in message
> > news:AK9Wi.13090$4V6.3308@newssvr14.news.prodigy.net...
> >> Does anyone have any code for setting the VBA option to "Break on
> > Unhandled
> >> Errors" (Access 2000). Thanks!
> >>
> >> Neil
> >>
> >>
> >
> >
>
>