Get rid of Action Queries confirmation in VBA 1

[atiaran]

Hi

Whenever I used an Update/Delete Query I have to click on the message appearing "You are about to run an update query that ..." or "You are about to delete ...". to confirm it and tick it back after. Could anybody know how to set that automatically in VBA so that I wouldnt untick that in the Options Edit/Find tab. Coz if I untick them then during my desing if I accidentally delete something it would not warn me that I am deleting.

Cheers for answering

Atia

 

[WildHare]

Very simple.

Before you call any action query:

DoCmd.Setwarnings FALSE

After you're done with all the action:

DoCmd.SetWarnings TRUE

That's all she wrote...

J



If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[atiaran]

Hi WildHare

It works wonderfully.

Thanks a lot, u r a star !!!