get rid of confirmation boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to run an Append query without having to confirm every time
you update. In other words I don't want to have to click "yes" every time I
update my database.
 
DoCmd.SetWarnings False 'turn system messages off
... your append query code
DoCmd.SetWarnings True 'turn system messages on

HTH,
Debbie


| Is there a way to run an Append query without having to confirm every time
| you update. In other words I don't want to have to click "yes" every time
I
| update my database.
 
Back
Top