Need to avoid the access messages

[sabavno]

Hi

I run my sql to append the records into my temporary table and while sql runs I receive Access messages "You are about to append 1 row..." and so on till all the records are appended.

I don't really want user see that messages and having have to click "OK" all the time. Can I avoid that?

 

[gol4]

docmd.setwarnings = false off

query statement here

docmd.setwarnings = true back on

 

[sabavno]

Just ran it, gave me an error...."Argument is not optional", pointing to setwarnings argument

Why is that?

 

[sabavno]

Figured it out myself


No need in '=' sign

Simply DoCmd.SetWarnings True would do the thing

Thanks a lot for the trick!