carrying out the SetWarnings action in the macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emil - 12 Feb 2006 19:45 GMT

I run a macro with a chain of queries for to update many tables. At every
turn of update appears a message of concerning warning the deletion existing
tables. I have deselected the option “Confirm Document deletions” but the
message appears afterwards. How I escape from message? Thank of support.

Reply to this Message

Douglas J. Steele - 12 Feb 2006 20:32 GMT

SetWarnings No before you start running, the queries, SetWarning Yes after
you're done.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> I run a macro with a chain of queries for to update many tables. At every
> turn of update appears a message of concerning warning the deletion
> existing
> tables. I have deselected the option "Confirm Document deletions" but the
> message appears afterwards. How I escape from message? Thank of support.

Reply to this Message

emil - 14 Feb 2006 17:53 GMT

"Emil" wrote: thank you very much for your support. I took into consideration
what you wrote to me amd it was a very useful answer for my qestion.

> SetWarnings No before you start running, the queries, SetWarning Yes after
> you're done.
[quoted text clipped - 4 lines]
> > tables. I have deselected the option "Confirm Document deletions" but the
> > message appears afterwards. How I escape from message? Thank of support.

Reply to this Message

emil - 14 Feb 2006 18:21 GMT

> "Emil" wrote: thank you very much for your support. I took into consideration
> what you wrote to me and it was a very useful answer for my qestion.
[quoted text clipped - 7 lines]
> > > tables. I have deselected the option "Confirm Document deletions" but the
> > > message appears afterwards. How I escape from message? Thank of support.

Reply to this Message

John Melbourne - 26 Feb 2006 00:18 GMT

Thanks Douglas

I found that one helpful too.

Signature

enruoblem

Reply to this Message