you tried the macro action SetWarnings with the WarningsOn argument set to
No, and it didn't work for you? i tested it in an A2000 format db running in
A2003, and it suppressed the warning messages as expected. did you get an
error message of some kind? what version of Access are you using?
hth
> Dear user
>
[quoted text clipped - 15 lines]
>
> Kind regards and thanks in advance
John Melbourne - 27 Feb 2006 07:05 GMT
I'm using Access 2003 and I probably didnt use the SetWarnings action
properly when I tried it first. Since then I did what you said and it
worked. I also included another SetWarnings action at the end of the macro
to reset WarningsOn to yes again.
Thank you for your help

Signature
enruoblem
> you tried the macro action SetWarnings with the WarningsOn argument set to
> No, and it didn't work for you? i tested it in an A2000 format db running in
[quoted text clipped - 24 lines]
> >
> > Kind regards and thanks in advance
tina - 27 Feb 2006 17:53 GMT
you're welcome :)
> I'm using Access 2003 and I probably didnt use the SetWarnings action
> properly when I tried it first. Since then I did what you said and it
[quoted text clipped - 31 lines]
> > >
> > > Kind regards and thanks in advance