Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unanswered: close macro dialog box

    We have loads of macros that are now run from a scheduler written in vba. If one of the macros fails a dialog box comes up that stops everything. Is it possible to error trap this or to close the dialog box from code??

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251

    Re: close macro dialog box

    VBA code:
    DoCmd.SetWarnings False

    or

    macro:
    SetWarnings



    but be really really carefull!


    jiri

  3. #3
    Join Date
    Dec 2002
    Posts
    3
    That stops messages like " about to update 23 rows" but has no effect on the dialog box that comes up when a macro falls over.

  4. #4
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    Maybe convert macro to VBA or program it in VBA? THen use on error goto errhandler

  5. #5
    Join Date
    Dec 2002
    Posts
    3
    There are hundreds of macros which I have inherited. Converting them all to vba is not a practical reality in the near future - anyway they work most of the time. I just wondered if it was possible to close the dialog using code - I assume not. I have posted this on the off chance that I am wrong! The problem is that the vba error handler can only trap the vba errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •