• Confirm Action Queries (Access 97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Confirm Action Queries (Access 97)

    Author
    Topic
    WSlmo23111
    AskWoody Lounger
    June 17, 2004 at 11:33 am #406307

    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.

    Reply | Quote
    Viewing 2 reply threads
    Author
    Replies
    • WSpatt
      AskWoody Lounger
      June 17, 2004 at 11:38 am #841577

      Use the DoCmd Setwarnings command

      Reply | Quote
    • WSpatt
      AskWoody Lounger
      June 17, 2004 at 11:38 am #841579

      Use the DoCmd Setwarnings command

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      June 17, 2004 at 11:40 am #841583

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

      CurrentDb.Execute “QueryName”

      This DAO method does not prompt for confirmation.

      Reply | Quote
    Viewing 2 reply threads
    Reply To: Confirm Action Queries (Access 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.