Solved

Disable the Confirm question for action queries in VBA

Posted on 2004-10-12
3
1,209 Views
Last Modified: 2008-01-09
I am currently using Access 2000 and want to know if there is a way to disable to disable the confirm question you get when you execute and action query using the Docmd.RunSQl statement in VBA code instead of disabling it from the tools/ option menu.
0
Comment
Question by:gemost
3 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 250 total points
ID: 12289968
Turn the options off and on with SetWarnings:

DoCmd.SetWarnings False
DoCmd.RunSQL .......
DoCmd.SetWarnings True
0
 
LVL 8

Expert Comment

by:arcross
ID: 12290058
as well, if you use Currentdb.execute "yuor SQL" no messages will appear

0
 
LVL 3

Author Comment

by:gemost
ID: 12290127
Thanks for the help shanesuebsahakarn  the code work perfectly.

gemost :)
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 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

11 Experts available now in Live!

Get 1:1 Help Now