Hiding a Macro's Dialogue Boxes

[MilinPCH]

Hello,

I have created a macro that executes an append query and then a delete query. It is executed when the end user presses a button on a form. The macro works perfectly, except I don't want to confuse or labor the user with having to answer all of those "are you sure you want to do this" dialogue boxes and click "Yes" - is there a way in VBA I can code it to answer Yes to all dialogue boxes and make them invisible as the macro runs?

Thanks,
Milin

 

[RickBerem]

you should use

docmd.setwarnings false

it's what I used to make almost the same thing as you

I wish it helps!

RickBerem

 

[jwhearn]

Try the SetWarnings Method:

DoCmd.SetWarnings False
Code...Code...Code
DoCmd.SetWarnings True

You may also want to use this in conjunction with the Echo Method, such as:

DoCmd.Echo False
DoCmd.SetWarnings False
Code...Code...Code
DoCmd.SetWarnings True
DoCmd.Echo True

Hope this helps,
JW.

 

[nick999]

Alternatively, the setwarnings method can be accessed through the macro builder window and incorporated there

Nick