PC Review


Reply
Thread Tools Rate Thread

Code for Break on Unhandled Errors

 
 
Neil
Guest
Posts: n/a
 
      1st Nov 2007
Does anyone have any code for setting the VBA option to "Break on Unhandled
Errors" (Access 2000). Thanks!

Neil


 
Reply With Quote
 
 
 
 
tina
Guest
Posts: n/a
 
      1st Nov 2007
see the SetOption Method topic in VBA Help.

hth


"Neil" <(E-Mail Removed)> wrote in message
news:AK9Wi.13090$(E-Mail Removed)...
> Does anyone have any code for setting the VBA option to "Break on

Unhandled
> Errors" (Access 2000). Thanks!
>
> Neil
>
>



 
Reply With Quote
 
Stuart McCall
Guest
Posts: n/a
 
      1st Nov 2007
"Neil" <(E-Mail Removed)> wrote in message
news:AK9Wi.13090$(E-Mail Removed)...
> 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



 
Reply With Quote
 
Neil
Guest
Posts: n/a
 
      1st Nov 2007
Well, I feel pretty dumb. Forgot about that. Thanks!

"tina" <(E-Mail Removed)> wrote in message
news:U1bWi.309989$(E-Mail Removed)...
> see the SetOption Method topic in VBA Help.
>
> hth
>
>
> "Neil" <(E-Mail Removed)> wrote in message
> news:AK9Wi.13090$(E-Mail Removed)...
>> Does anyone have any code for setting the VBA option to "Break on

> Unhandled
>> Errors" (Access 2000). Thanks!
>>
>> Neil
>>
>>

>
>



 
Reply With Quote
 
Neil
Guest
Posts: n/a
 
      1st Nov 2007
Thanks, Stuart!

"Stuart McCall" <(E-Mail Removed)> wrote in message
news:fgbj0g$du$1$(E-Mail Removed)...
> "Neil" <(E-Mail Removed)> wrote in message
> news:AK9Wi.13090$(E-Mail Removed)...
>> 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
>
>
>



 
Reply With Quote
 
tina
Guest
Posts: n/a
 
      2nd Nov 2007
you're welcome


"Neil" <(E-Mail Removed)> wrote in message
news:UddWi.3323$%(E-Mail Removed)...
> Well, I feel pretty dumb. Forgot about that. Thanks!
>
> "tina" <(E-Mail Removed)> wrote in message
> news:U1bWi.309989$(E-Mail Removed)...
> > see the SetOption Method topic in VBA Help.
> >
> > hth
> >
> >
> > "Neil" <(E-Mail Removed)> wrote in message
> > news:AK9Wi.13090$(E-Mail Removed)...
> >> Does anyone have any code for setting the VBA option to "Break on

> > Unhandled
> >> Errors" (Access 2000). Thanks!
> >>
> >> Neil
> >>
> >>

> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set to Break on Unhandled Errors via VBA louishong@lycos.com Microsoft Excel Programming 0 23rd Jun 2009 06:26 PM
Code for Break on Unhandled Errors Neil Microsoft Access VBA Modules 5 2nd Nov 2007 02:07 AM
How auto EnableEvents again on code-break and errors? Michel Microsoft Excel Programming 2 4th May 2004 02:21 AM
add page break code in csv file to force break when loading. tim Microsoft Excel Misc 3 1st Apr 2004 01:49 AM
Re: Remind me to set Error Trapping to Break on Unhandled Errors Chip Pearson Microsoft Excel Programming 1 5th Nov 2003 06:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:14 PM.