docmd.setwarnings

[cmz21]

Hello,
I am running an Access query using vba. I would like to turn off the alert for running an append query. I thought the code to use was -

DoCmd.SetWarnings = False

But when I try to run it, I get a compile error saying 'Argument not optional'.

Is this the wrong code to use?

Thanks for any help.

 

[Crowley16]

it's not a setting, it's a function which takes in an argument...

i.e. remove the "="

--------------------
Procrastinate Now!

 

[cmz21]

Thank You....I just figured that out as well.