Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2012
    Posts
    108
    Thanks
    0
    Thanked 4 Times in 4 Posts

    MS Access turning MSG Box off

    Running a macro that opens a number of queries but I want to turn the msg box off while they are running and turn them back on when finished. This way the queries can run continuously without interruption

    Thanks

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    In either VBA or in a macro you can turn the warnings on and off. See SetWarnings for the details. One caution, be sure to turn them back on after all of the queries have been run.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Not sure if macros allow error handling these days, but if you're using VBA make sure you turn warnings back on within an error handler, otherwise they'll be left off if an error occurs in the code!

Tags for this Thread

Posting Permissions

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