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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a series of Action Queries 1
Running DELETE queries from code with no Confirmation prompt 6
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Run time error 3146 2
How to Build an SQL Query on the Fly for Data Export to Excel 3
schedule task macro failes to complete due to persistent prompting 2
DoCmd.RunSQL "HELP What to syntax to delete 1st three records of text file import"??? 6
Stop macro after selecting 'no' 0

Back
Top