Solved

Disable the Confirm question for action queries in VBA

Posted on 2004-10-12
3
1,233 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

776 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