Code for Break on Unhandled Errors

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Neil

    #1

    Code for Break on Unhandled Errors

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

    Neil


  • tina

    #2
    Re: Code for Break on Unhandled Errors

    see the SetOption Method topic in VBA Help.

    hth


    "Neil" <nospam@nospam. netwrote in message
    news:AK9Wi.1309 0$4V6.3308@news svr14.news.prod igy.net...
    Does anyone have any code for setting the VBA option to "Break on
    Unhandled
    Errors" (Access 2000). Thanks!
    >
    Neil
    >
    >

    Comment

    • Stuart McCall

      #3
      Re: Code for Break on Unhandled Errors

      "Neil" <nospam@nospam. netwrote in message
      news:AK9Wi.1309 0$4V6.3308@news svr14.news.prod igy.net...
      Does anyone have any code for setting the VBA option to "Break on
      Unhandled Errors" (Access 2000). Thanks!
      >
      Neil
      Application.Set Option "Error Trapping", 2

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



      Comment

      • Neil

        #4
        Re: Code for Break on Unhandled Errors

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

        "tina" <nospam@address .comwrote in message
        news:U1bWi.3099 89$ax1.88823@bg tnsc05-news.ops.worldn et.att.net...
        see the SetOption Method topic in VBA Help.
        >
        hth
        >
        >
        "Neil" <nospam@nospam. netwrote in message
        news:AK9Wi.1309 0$4V6.3308@news svr14.news.prod igy.net...
        >Does anyone have any code for setting the VBA option to "Break on
        Unhandled
        >Errors" (Access 2000). Thanks!
        >>
        >Neil
        >>
        >>
        >
        >

        Comment

        • Neil

          #5
          Re: Code for Break on Unhandled Errors

          Thanks, Stuart!

          "Stuart McCall" <smccall@myunre albox.comwrote in message
          news:fgbj0g$du$ 1$8302bc10@news .demon.co.uk...
          "Neil" <nospam@nospam. netwrote in message
          news:AK9Wi.1309 0$4V6.3308@news svr14.news.prod igy.net...
          >Does anyone have any code for setting the VBA option to "Break on
          >Unhandled Errors" (Access 2000). Thanks!
          >>
          >Neil
          >
          Application.Set Option "Error Trapping", 2
          >
          0 = Break on all errors
          1 = Break in class module
          2 = Break on unhandled errors
          >
          >
          >

          Comment

          • tina

            #6
            Re: Code for Break on Unhandled Errors

            you're welcome :)


            "Neil" <nospam@nospam. netwrote in message
            news:UddWi.3323 $%Y6.972@nlpi06 1.nbdc.sbc.com. ..
            Well, I feel pretty dumb. Forgot about that. Thanks!
            >
            "tina" <nospam@address .comwrote in message
            news:U1bWi.3099 89$ax1.88823@bg tnsc05-news.ops.worldn et.att.net...
            see the SetOption Method topic in VBA Help.

            hth


            "Neil" <nospam@nospam. netwrote in message
            news:AK9Wi.1309 0$4V6.3308@news svr14.news.prod igy.net...
            Does anyone have any code for setting the VBA option to "Break on
            Unhandled
            Errors" (Access 2000). Thanks!
            >
            Neil
            >
            >
            >
            >

            Comment

            Working...