SetWarnings alternative that "Okays" error messages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

m.wanstall - 18 Jul 2007 02:33 GMT

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.

Reply to this Message

Steve Schapel - 18 Jul 2007 03:26 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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
[quoted text clipped - 10 lines]
>
> Any help is much appreciated.

Reply to this Message

shank - 27 Jul 2007 19:27 GMT

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!

> m.wanstall
>
[quoted text clipped - 4 lines]
>
> --

Reply to this Message

shank - 27 Jul 2007 19:43 GMT

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.

>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.
[quoted text clipped - 9 lines]
>> 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.

Reply to this Message