Consulting

Results 1 to 4 of 4

Thread: Can a "warning" message be disabled?

  1. #1

    Can a "warning" message be disabled?

    I have a program I am writing for a club I belong to. One of the routines needs to run a delete query to empty a table and then a set of vba code to add the records back based on a set of criteria. It is working really great. However,

    Every time the delete query is run, I get the message "You are about to delete ***x records...." I would prefer that the user did not have to click on "Yes" to continue. Is there anyway to eliminate or disable the message?
    ttfn

    Kicker

  2. #2
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    currentdb.execute "queryname"

  3. #3
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    You can turn off System Messages with
    DoCmd.SetWarnings False
    and back on again with
    DoCmd.SetWarnings True

  4. #4
    that is why I love this forum. Thanks guys I appreciate your quick response.
    ttfn

    Kicker

Posting Permissions

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