Append Querys

[ddrew]

I have a button that runs an Append Query. I used the code from the wizzard, but I want to suppress the message that you are appending. can someone tell me how to that please, thanks

 

[rainman89]

put this in the button click before and after you run the query

before- docmd.setwarnings = false
after - docmd.setwarnings = true

 

[ddrew]

Its giving me a message Compile erroe: Argument not optional

 

[editolis]

rainman is correct..

before- docmd.setwarnings = false
after - docmd.setwarnings = true

But you do not put the before - and after -

use only this:

docmd.setwarnings = false
docmd.setwarnings = true

 

[ddrew]

Yes I appreciate that! but its giving me a message Compile error: Argument not optional, and then it highlights the setwarnings line

 

[JANR]

docmd.setwarnings = false
docmd.setwarnings = true

Change to:

docmd.setwarnings False
docmd.setwarnings True

aka remove the equalsign

JR

 

[ddrew]

Yup just sussed it, thanks

 

[editolis]

Sorry my fault.

Use this:

docmd.setwarnings false
docmd.setwarnings true

 

[rainman89]

Change to:
aka remove the equalsign

JR

That would do it..