Append Query without asking YES/ NO

[twlew]

I created a button in Form. When click it, it will run the Append Query. Everything works fine, but I don't like those two messages box come up to ask me whether I want to Append xx records to "yy" table. How to HIDE the message boxes ?

 

[mrf1xa]

It's not clear from you post whether you are running your query using code from the button or via a macro. However, you should check out the SetWarnings command. If using a macro these are available as steps in the macro, if using code use:

DoCmd.SetWarning False

Your code

DoCmd.SetWarnings True

Code is better- if the macro stalls halfway through it will cancel all warnings until the app is closed and reopened.

HTH Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[Maquis]

twlew, you can turn off these messages through the tools menu. In Access 97 you can get to it through tools --> Options ---> Edit/Find tab. In the upper right corner is a section called "confirm". Uncheck the "Action Queries" box and you won't see these confirm run boxes any more. Maq
<insert witty signature here>

 

[mrf1xa]

I have a feeling this is a system setting though, so if you turn off the warnings here you will kill them for ALL access apps you run on this machine. Using SetWarnings bypasses them only for the specific action you are choosing. Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....