Is it possible to run a Delete Query from VBA with out it prompting the user to delete the data in the table you are deleting from!?

Thanks.

Simply turn the warnings off before the query code and then turn them back on after:

DoCmd.SetWarnings False
Query Code
DoCmd.SetWarnings True

You can also run a dbengine(0)(0).execute("DELETE blabla FROM blabla WHERE etc") etc etc.

This will just delete the record(s) in the recordset in your sql statement above. It does not prompt the user.