surpress confirmations

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

I have a command button which runs a few make table and append table
queries. Is there a way to surpress all confirmation dialogs through VBA?

Thanks in advance,

-rick
 
Try the following, Rick ...

DoCmd.SetWarnings False
' your queries run here
DoCmd.SetWarnings True


hth,
 
Thnk you very much......works great

-rick

Cheryl Fischer said:
Try the following, Rick ...

DoCmd.SetWarnings False
' your queries run here
DoCmd.SetWarnings True


hth,
Click to expand...
 
Back
Top