Results 1 to 4 of 4
  1. #1
    deekadelic is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    23

    SetWarnings = No, but Action Query Warnings Persist

    I have written a sequence of action queries that a coworker needs to execute on a daily basis, and I'm trying to make it so that she doesn't have to approve every action query every time she runs the sequence. I created a macro, with the SetWarnings action, and set WarningsOn to "No". Then I saved the macro as AutoExec, and closed the database. When I reopened it and tried to run the action queries, the warning messages still popped up. Not sure why, or what I'm doing wrong.

    I know in the past all I had to do was go to the Access Advanced Options and click a box that basically said "Turn off warnings for action queries." Life was good then.

    Can anybody help?



    Thank you

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I don't use macros... In VBA, I would use "CurrentdB.Execute blah, blah. "

    And I don't have A2016, but in A2010 you can go to
    FILE / OPTIONS / Client Settings

    Under the section "Editing", look for "Confirm". Uncheck Action queries..

  3. #3
    deekadelic is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    23
    That was it right there, the fix I needed: checking off that "Confirm" box in the Client Settings. I just couldn't find it.

    Thank you!

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You're welcome

Please reply to this thread with any new information or opinions.

Similar Threads

  1. setwarnings not working
    By Dgrazynski in forum Macros
    Replies: 7
    Last Post: 09-16-2015, 07:12 PM
  2. Replies: 12
    Last Post: 11-07-2014, 01:45 PM
  3. Disabling query warnings
    By Tom123 in forum Queries
    Replies: 8
    Last Post: 02-10-2014, 03:35 PM
  4. SetWarnings turned off
    By Paul H in forum Programming
    Replies: 3
    Last Post: 03-28-2013, 07:47 AM
  5. Macro - how to turn off warnings for action queries
    By msmithtlh in forum Programming
    Replies: 3
    Last Post: 03-22-2013, 11:00 AM

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
  •  
Other Forums: Microsoft Office Forums