Help to stop error msg's when running action querys

[kgreen]

I am calling an action query, that moves records from one table to another, from a buttons OnClick event.

The query works fine but Access being Access throws up the standard error message.

I know that there is a way the the messages can be turned off while the query runs but I have forgotten how its done.

I am using the following:

DoComd.OpenQuery "QueryName"

Any help or suggestions

Kenny. [sig][/sig]

 

[kgreen]

Hi Gang,

I forgot to mention I am using the DoCmd.SetWarnings True and false.

The thing I am looking for I think is something like

db.execute "Queryname"

But there is some other stuff that goes before it that stops the warning messages.

Thanks again,

Kenny




[sig][/sig]

 

[kpereira]

If you are using code to run the query you can use:

docmd.setwarnings (True)

This will turn off Access warnings while the query runs if it is placed before the query is run.

K. Pereira
[sig][/sig]

 

[petermeachem]

actually setwarnings false before and setwarnings true after [sig][/sig]