No Prompt When Deleting Records 1

[alexbel]

Hi,

I use the following code to delete records from a table:

DoCmd.RunSQL "Delete * from tblTable"

Everytime this code runs, it prompts me if I am sure I want to delete all the records. How can I remove this prompt?

Thank you

 

[RoyVidar]

[tt]docmd.setwarning false
DoCmd.RunSQL "Delete * from tblTable"
docmd.setwarning true[/tt]

- or try:
[tt]currentdb.execute "Delete * from tblTable"[/tt]

Roy-Vidar

 

[RoyVidar]

...should have been an "s" at the end of setwarnings, too

Roy-Vidar

 

[alexbel]

Thank you Roy.

That did it!