disable message prompts

[kgcrowther]

I run so many append and delete queries on this one database that I wrote a module to run a couple of them in a row. The problem is that there are two message prompts for each query.
(You are about to run an append query that will alter the table.)
(You are about the append _ pieces of data)
etc. etc. etc.

Can I disable these message prompts in the code that I have written? How do I tell it not to show those prompts?

Any one know? Any information is great.

Kenneth

 

[charityg]

before the code that runs the queries

DoCmd.SetWarnings False

then use

DoCmd.SetWarnings True after the code that runs the queries to set it back

HTH
Charity

 

[kgcrowther]

Again, that's right on target. Thank you so much!

Kenneth

 

[ChrisGow]

thanks

jsut wanted to say thanks for answering this question. it saved me from posting this question again. all I had to do was search.