Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Don't ask for okay to run append query 1
- Thread starter jnix
- Start date
-
1
- #2
tlbroadbent
MIS
If the query is run from code or a macro you can use the Setwarnings Method or Action to turn off warning messages.
VBA Code:
DoCmd.SetWarnings False
<execute action query>
DoCmd.SetWarnings True
Macro:
Select the Action SetWarnings and choose No in the Warning On box below.
You can also unset the database option to Confirm Action queries. Open Toole | Options and click on the Edit/Find tab. I'm using Access 2000 and the option location may differ in other versions. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
VBA Code:
DoCmd.SetWarnings False
<execute action query>
DoCmd.SetWarnings True
Macro:
Select the Action SetWarnings and choose No in the Warning On box below.
You can also unset the database option to Confirm Action queries. Open Toole | Options and click on the Edit/Find tab. I'm using Access 2000 and the option location may differ in other versions. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
- Question
