Delete Query

[Zippyfrog]

Quick question:

How can I automatically bypass the messages "You are about to run a delete query that will modify data in your table."? I don't want an end user to see that message, I just want the delete query to run. Is there a way to get rid of that message without supressing all the messages in the entire database?

 

[ByteMyzer]

The following Visual Basic syntax will execute action queries without the warning prompt:

CurrentDb.Execute "[i]<sql statement here>[/i]"

For example:

CurrentDb.Execute "DELETE * FROM MyTable;"

 

[DocNice]

I believe this will work as well:

DoCmd.SetWarnings False

DoCmd.RunSQL "SQL Statement Here;"

DoCmd.SetWarnings True