I currently have the following query written:


DELETE * FROM TABLE1


When runs, it tells me the number of rows to be deleted and I have to click "Yes" for it to run. Is there a way to run the query and not have the prompt so it will run without human input?

Yes, use

CurrentDb.Execute "Delete * From Table1", dbFailOnError