Automating a Delete Query

[Dragenesis]

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?

 

[boblarson]

Yes, use

CurrentDb.Execute "Delete * From Table1", dbFailOnError