What triggers the Delete Warning message box?

[Guest]

What triggers the Delete Warning message box and how do I get rid of it?

 

[John Vinson]

What triggers the Delete Warning message box

Running a Delete query, or some other action which will delete records
from a table in your database. What are *you* doing right before you
see the message?

and how do I get rid of it?

Are you certain that you want Access to permanently, irrevocably, and
silently delete data from your database without any warning?

John W. Vinson[MVP]

 

[Guest]

I am providing my own customized warning and want to suppress a second
warning. I am doing nothing other than allowing the user to press the Delete
key and processing other deletes (of related records) myself via EXECUTE.

 

[John Vinson]

I am providing my own customized warning and want to suppress a second
warning. I am doing nothing other than allowing the user to press the Delete
key and processing other deletes (of related records) myself via EXECUTE.

The Querydef Execute method (qd.Execute "MyDeleteQuery" for example)
will not issue any prompts; or you can use

DoCmd.SetWarnings False

prior to running the delete. Be sure to

DoCmd.SetWarnings True

afterward or you'll turn off ALL warning messages for the rest of the
Access session!

John W. Vinson[MVP]