Suppressing generic MS Access message box on Append query

[daleshei]

I have a button which runs an Append query when clicked but it shows a generic message box. I don't want my users to see the message box. I can disable this by going through Tools then Options then Edit and unticking confirm action query tick box but it only works on my machine and my database is on a network. Is it possible to disable the message box or any other message in VBA?

I have no idea how to write the code in VBA.

Thank you.

D

 

[bubba100]

Docmd.SetWarnings False use true to turn the warning back on.

 

[lars7]

I can't find the thread bud TheAceMan1 posted a permanent way to do it:

Tools ---> Options ---> Edit/Find ---> Confirm ---> unselect Action Queries

 

[OhioSteve]

If your vba skills are weak, then use a macro to suppress the warnings. You could make a macro with three actions:

ACTION/ARGUMENTS
SetWarnings(No)
OpenQuery([query name],Datasheet,Edit)
SetWarnings(Yes)

 

[daleshei]

Thanx