Hide confirmation dialog 1

[schwankieog]

I am running a sql delete query using docmd.runsql() when the query runs it works corectly but i get the "you are about to delete x records" Is there any way to hide this? it isnt neccessary but this is a very small part of a larger code and i would like to be able to make it so the user can start it then walk away. thanks

 

[oharab]

replace the docmd.runsql with currentdb.execute

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[SgtJarrow]

place DoCmd.SetWarnings False before your DoCmd.RunSQl to turn off system warnings.... Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[schwankieog]

thanks for the help guys, i forgot the curentdb.execute.