Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Confirm Action Queries (Access 97)

    I have a cmd button in a database that set to run 4 action queries. Some of the persons using this database only have a runtime version of Access, and I cannot get to the Options Box on the Tools menu to turn off the "Confirm Action Queries". Is there some sort of code that I can add to stop the confirmation messages.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Confirm Action Queries (Access 97)

    Use the DoCmd Setwarnings command

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Confirm Action Queries (Access 97)

    One possibility is to insert <code>DoCmd.SetWarnings False</code> before, and <code>DoCmd.SetWarnings True</code> after the instructions that execute the action queries. Another possibility is to use

    CurrentDb.Execute "QueryName"

    This DAO method does not prompt for confirmation.

Posting Permissions

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