Prevent prompts when running Delete Query

  • Thread starter Thread starter Bruceh
  • Start date Start date
B

Bruceh

I'd like to run a query via
docmd.RunSQL("Delete * from tableX")
and would like to suppress all the prompts.

Can this be done?

TIA
 
Use this instead:

CurrentDb.Execute "Delete * from tableX", dbFailOnError

HTH,
Nikos
 
Back
Top