automating queries question

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a series of queries that I execute via code. When
I run them interactively, they warn me about deleting,
updating, etc., and ask for confirmation. When I run
them via code, the same thing happens. Can I get them to
run withOUT this confirmation? If so, how?

Thanks in advance,

Tom
 
Before the query lines in the code type:

DoCmd.SetWarnings False

After the query lines (after they have run) type:

DoCmd.SetWarnings True

That should do it, hope that helps...
 
Back
Top