Suppressing delete warning

M

Mike

On my form I have a button, which runs code to delete records from a
temporary table:

DoCmd.RunSQL "DELETE myTMPtable.* FROM myTMPtable"

Is it possible to programmatically suppress the delete warning?

Thank you in advance for any tips!
 
O

Ofer

Use the setwarnings command to false

Docmd.SetWarnings False
DoCmd.RunSQL "DELETE myTMPtable.* FROM myTMPtable"
Docmd.SetWarnings True
 
Top