Eliminate Append\Delete Query warning 1

[burgerman]

I am trying to eliminate the warning box that appears when an action query is selected. I want to do this programmatically instead of under the toolsptions selection. I tried using the docmd.setwarnings=false but to no avail any suggestions?

 

[Russie]

Click:

Tools

Options

Edit/Find Tab (3rd from left)

In the top right of the panel that you now see you can check/uncheck regarding on your requirements.

 

[KenReay]

Hi

DoCmd.SetWarnings False / True (for off /on )

should do it, what actualyy happened when you tried it?

Alternatively you could use the execute method of the database object

So its is
DoCmd.SetWarnings False
DoCmd.RUNSQL "DELETE ....."
DoCmd.SetWarnings True

or

Dim db As DAO.Database
Set Db = CurrentDb()
Db.execute "DELETE ....." Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[grnzbra]

Put in a break point and step through the code to see what's going on because the SetWarnings command should do the trick.