Automatically Click "Ok" 1

[Ebes1099]

I have a button that clears out my database and performs Delete Queries on a handful of tables. When I click the button I have a prompt asking if the user is sure they want to clear all the tables. Then if they click yes it runs through all the delete queries. But with each Delete Query it asks if you want to delete the records from the table. This is somewhat annoying and I was wondering if there's any way I can bypass those by putting in some code to automatically click through them?

 

[kray4660]

I did not write this code, but I believe it will suppress the warnings.
DoCmd.SetWarnings False

Of course you will want to put in
DoCmd.SetWarnings True
when your code is finished.

 

[Ebes1099]

Thanks, that seemed to work.