M
mscertified
What triggers the Delete Warning message box and how do I get rid of it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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]
M
mscertified
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.
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.
J
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]