get rid of confirmation boxes

C

Chris

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.
 
D

DebbieG

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.
 
Top