Results 1 to 4 of 4
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    set warnings false

    How can I set warnings to false in the macro editor?

  2. #2
    DougsGraphics is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Location
    New Mexico
    Posts
    11
    Found this:
    Use a macro to turn the messages off and back on

    1. In the drop-down list at the top of the Macro Builder, select the SetWarnings action.


      • If you do not see the SetWarnings action listed, on the Design tab, in the Show/Hide group, make sure Show All Actions is selected.

    2. Under the SetWarnings action, click the arrow next to Warnings On and select No.
    3. Enter the necessary macro actions to perform the tasks that you want done with confirmation messages turned off.

    4. Below the last task action, select the SetWarnings action, then click the arrow next to the Warnings On and select Yes.
    5. Close the Macro Builder, save the macro, and then save the form.


  3. #3
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151
    Thank you - exactly what I was looking for

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What action were you performing that needed the Warnings turned off? I think of that like unscrewing your "Low Oil" bulb.

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

Similar Threads

  1. set warnings autoexec
    By bchi99 in forum Queries
    Replies: 6
    Last Post: 11-14-2014, 02:20 PM
  2. Replies: 8
    Last Post: 10-06-2014, 03:02 PM
  3. SELECT "False" if any records are false?
    By Azurewrath in forum Queries
    Replies: 6
    Last Post: 12-21-2011, 03:36 PM
  4. Errors but not warnings ?
    By asearle in forum Access
    Replies: 3
    Last Post: 08-10-2011, 01:26 AM
  5. Set Warnings Off
    By NMJones in forum Access
    Replies: 2
    Last Post: 04-12-2010, 03:06 PM

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