Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Disable the Confirm question for action queries in VBA

Posted on 2004-10-12
3
Medium Priority
?
1,293 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 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 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