Stop macro when Access error occurs

Discussion in 'Microsoft Access Macros' started by John Hipskind, Sep 28, 2003.

  1. How do I stop a macro when an Access error occurs as the
    macro is executing?
    Thanks.
    John
     
    John Hipskind, Sep 28, 2003
    #1
    1. Advertisements

  2. John,

    Only one possibility here, I'm afraid. Figure out what's causing the
    error, and change the macro or the database so it doesn't happen
    again.

    Other than that, using a VBA procedure instead of a macro may give
    more flexibility in managing the error.

    - Steve Schapel, Microsoft Access MVP


    On Sun, 28 Sep 2003 09:18:05 -0700, "John Hipskind"
    <> wrote:

    >How do I stop a macro when an Access error occurs as the
    >macro is executing?
    >Thanks.
    >John
     
    Steve Schapel, Sep 28, 2003
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Mary

    Macro to notify when action occurs?

    Mary, Jul 31, 2003, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    554
  2. Macro Builder

    How do you invoke an Excel macro from an Access macro?

    Macro Builder, Sep 29, 2003, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    6,686
    Ken Snell
    Sep 30, 2003
  3. Guest

    Stop macro upon Access error message

    Guest, Jan 2, 2004, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    1,388
    Steve Schapel
    Jan 2, 2004
  4. Wayne
    Replies:
    0
    Views:
    418
    Wayne
    Mar 16, 2004
  5. Guest
    Replies:
    1
    Views:
    621
  6. Guest

    Macro conditions stop macro

    Guest, Aug 31, 2006, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    421
    Steve Schapel
    Aug 31, 2006
  7. Marco

    Stop macro on error

    Marco, Jun 26, 2008, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    593
    Marco
    Jun 27, 2008
  8. DBM
    Replies:
    1
    Views:
    555
    Steve Schapel
    Nov 11, 2009
Loading...