SetWarnings alternative that "Okays" error messages

[m.wanstall]

I have some macros that are running quite a few exports of queries and
also some maketable queries. I'm wanting for them to run WITHOUT me
watching over them and clicking "Yes" to making a new table and the
like. It is also likely that I will get an error message such as "n
Records were not written due to conversion errors...". I am prepared
to drop these records and I really don't care about them as I know
that the data I am importing and querying is unreliable in several
fields.

Is there a way to turn off these error messages and just export the
whole thing without any user input? I'm really wanting to run these
when I don't have to babysit the computer.

Any help is much appreciated.

 

[Steve Schapel]

m.wanstall

Since you used the term "SetWarnings" in the subject of your post, I
would assume you are aware of the existence of the SetWarnings macro
action? All you need to do is put a SetWarnings/No action in your
macro, ahead of the first OpenQuery action, and that should take care of it.

 

[shank]

I have Access 2007. I cannot access SetWarnings like I used to in older
versions. In the trust center, I have ENABLE all macros checked.

How do I get SetWarnings options in Access 2007?

thanks!

 

[shank]

Never mind! I just found the Show/Hide button.

Yuk! Just one more button to deal with. Did the designers of Access 2007 get
paid per the buttons they installed this go around? I thought the old
interface was pretty good. Whichever mode I was in, I had the appropriate
menu in place. Now I've got to click 2-3 times to get what I want.