Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL DELETE statement and Confirm Dialog 2

Status
Not open for further replies.

liamcorkhill

Programmer
Jul 3, 2001
18
GB
Hi all.

I wish to empty a table. I have used the command:

DoCmd.RunSQL ("DELETE * FROM tbl_datecheck")

which prompts Access to come up with the dialog "You are trying to delete (x) rows .... Do you wish to do this?".

I dont want this message to appear. Any suggestions?

Regards

Liam Corkhill
 
Liam,

Go to Tools | Options | Edit/Find and de-select the "Action Queries" option.
 

Use DoCmd.SetWarnings (False) before executing the query to inhibit warning messages.

DoCmd.SetWarnings (True) after to allow messages again. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
 
Excellent :)
I thought it would be fairly straight forward!!
Thanks all

Regards

Liam Corkhill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top