Delete Query Msgs

[rem2088]

I know I've disabled these before with a menu setting on my PC, but I can't remember how I did it. I have a delete query that runs when you open the database and I moved the DB to another computer and now they are getting the "You are going to delete, blah, blah, blah" msg. I know I didn't use the DoCmd.... thingy or it wouldn't be doing this on their PC.

Any help would be greatly appriciated.

Thanks.

-Ben

 

[pbaldy]

If you don't want the warnings on any PC, you can add the DoCmd.SetWarnings False/True to the code that runs the query.

The setting you probably changed on your own PC was in Tools/Options on the Edit/Find tab.

 

[daveUK]

Use:

Docmd.SetWarnings False

Delete Query goes here

Docmd.SetWarnings True

This will disable the warning messages.

 

[Pat Hartman]

Don't forget to turn warnings back on immediately after you run the query that generates the warnings you want to surpress. It is extremely dangerous to leave the db in this state since you will not be warned to save changes if you modify some object and then close it without first saving. Access will simply discard the changes and close the object. This can cause you to lose hours of work.

 

[rem2088]

Ok, that will work I guess.... .Probably a better way of doing this to begin with.

-Ben