[AccessD] Lost Warnings...

Interesting.  So if Access crashes, the docmd.setwarnings sticks in the
actual options, not just as a temporary flag eh?  I always knew to be
careful with SetWarnings, but I didn't realize it would stick from session
to session.

That makes sense though, because I did crash something when I had the
warnings off from code.....hmmm

Drew

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Wednesday, February 19, 2003 12:12 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Lost Warnings...


Drew:

Here's a possibility:

I've had the problem when I've used DoCmd.SetWarnings False.  If the code
gets interrupted before it falls through to DoCmd.SetWarnings True, or if
for some reason the 'True' doesn't get executed, the False condition
persists.  A bad gotcha for me because sometimes I want to abandon all the
changes to a form or report or query so I'll close it and say no to
updating.  If warnings are set to false it saves my form or report or query
without asking.

Which is why I switched from DoCmd.RunSQL to db.Execute which doesn't give
any warnings.

Rocky


----- Original Message -----
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, February 18, 2003 8:54 PM
Subject: RE: [AccessD] Lost Warnings...


> Now I'm wondering how that setting got changed.....That is wierd.  Oh
well,
> thanks again.  (I ran a delete query today, that I knew was right, but I
was
> caught off guard that it didn't prompt before actually deleting......)
>
> Drew
>
> -----Original Message-----
> From: dave sharpe [mailto:davesharpe2 at cox.net]
> Sent: Tuesday, February 18, 2003 10:09 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Lost Warnings...
>
>
> Drew
> I'm glad that I was able to help.
> Dave
> ----- Original Message -----
> From: "Drew Wutka" <DWUTKA at marlow.com>
> To: <accessd at databaseadvisors.com>
> Sent: Tuesday, February 18, 2003 8:30 PM
> Subject: RE: [AccessD] Lost Warnings...
>
>
> > Perfecto!!! Thankyou very much.  That was starting to nag me! <VBG>
> >
> > Drew
> >
> > -----Original Message-----
> > From: dave sharpe [mailto:davesharpe2 at cox.net]
> > Sent: Tuesday, February 18, 2003 5:20 PM
> > To: AccessD at databaseadvisors.com
> > Subject: Fw: [AccessD] Lost Warnings...
> >
> >
> > Drew
> >
> > Have you looked at Tools->Options->Edit\find "confirm"section
> > ( the above is Acc2k may be different in other versions )
> >
> > Dave
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew Wutka" <DWUTKA at marlow.com>
> > To: <AccessD at databaseadvisors.com>
> > Sent: Tuesday, February 18, 2003 5:29 PM
> > Subject: [AccessD] Lost Warnings...
> >
> >
> > > I have noticed for the past few days, when I run Action querries, I am
> not
> > > getting a 'warning' anymore.  I have tried setting SetWarnings to
true,
> > but
> > > it doesn't make an affect.  This happens in current AND new databases.
> > >
> > > Anyone seen something like this, or know a fix?
> > >
> > > Drew
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com