Results 1 to 3 of 3
  1. #1
    ssissons is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    May 2014
    Posts
    44

    Turn off Action Query confirmations


    In Access 2007, is there a way to turn off the Action Query confirmations, at the DATABASE level? I know about clearing the Access Options - Advanced - Editing - Confirm - Action Queries box, and it works for my local Access installation. However, the users are using a networked Access 2007 install, and we can't change that option and have it stay. Plus, that turns it off for all databases, and I am not able to make that company-wide decision. We could have them go in and change/confirm the option when they get in the database, but the users don't know/care about that option, and shouldn't. I tried the AutoExec macro, to turn the warnings off, but that didn't work, even on my local copy of the DB. What have I missed?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Not for all db, each individual must turn off the warnings.

    docmd.setwarnings FALSE
    It DOES work.

  3. #3
    ssissons is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    May 2014
    Posts
    44
    I put docmd.setwarnings false in the Form_Load of the Main Menu of the DB. Did NOT work - the confirmations still show. Where should I enter that statement? Does it need to go in each form/query?

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

Similar Threads

  1. how to turn my expression in query to vba
    By sspreyer in forum Programming
    Replies: 7
    Last Post: 01-15-2014, 04:10 PM
  2. How to turn off prompt when running append query from code
    By GraeagleBill in forum Programming
    Replies: 5
    Last Post: 07-22-2013, 03:35 PM
  3. Macro - how to turn off warnings for action queries
    By msmithtlh in forum Programming
    Replies: 3
    Last Post: 03-22-2013, 11:00 AM
  4. Turn off busy icon when performing Query
    By robrich22 in forum Access
    Replies: 1
    Last Post: 03-07-2013, 09:19 PM
  5. Replies: 4
    Last Post: 10-17-2012, 07:27 AM

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