Access Turn Off Pop-Ups

Posted on 2009-04-28
Last Modified: 2013-11-27
In running a Macro in Access, please offer how I may turn off all the pop-ups that appear during Macro execution.

I have gone to the "Security" tab, but cannot find any choice to turn these off.


Question by:tahirih
    LVL 10

    Assisted Solution

    Use Setwarnings = false at the beginning of the macro
    Make sure you include Setwarnings = true at the end!!
    LVL 56

    Accepted Solution

    I believe you mean the confirmation dialogs that you get when action queries are executed. With the database open, go to tools, options, and then client on the Edit/Find tab. uncheck all the boxes in the confirm group.
    LVL 6

    Assisted Solution

    Add the   DoCmd.SetWarnings=False  command before you fireoff the macro.

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    message box formulas 3 17
    phpMyAdmin simple sql statement 3 16
    exporting issues in Access 2 0
    Custom auto number 6 0
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now