How to Snub "You are about to ..... " dialog boxes in MS Access

[raabbasi]

While processing a series of database tasks - like inserting, deleting and updating a number of records at one time, MS Access presents a dialog box for each of such operations asking to confirm, every time.
How to snub these dialog boxes to appear.

 

[HarleyQuinn]

Hi,

DoCmd.SetWarnings False

should do it.

Once you finish doing what you need you can turn them on again using

DoCmd.SetWarnings True

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[RoyVidar]

[tt]docmd.setwarnings false
' perform thingies
docmd.setwarnings true[/tt]

Or execute the queries through the .execute method of either the DAO database object or the ADO connection object.

Roy-Vidar

 

[raabbasi]

Many thanks to HarleyQuinn and Roy-Vidar.
The alternate solution of using .Execute method of the Connection object is a great idea.