[AccessD] Lost Warnings...

You betcha!  <VBG>

Charlotte Foust

>  -----Original Message-----
> From: 	accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]  On Behalf Of John W.
> Colby
> Sent:	Wednesday, February 19, 2003 11:33 AM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Lost Warnings...
> 
> There's the voice of experience talking!  ;-)
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte
> Foust
> Sent: Wednesday, February 19, 2003 2:22 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Lost Warnings...
> 
> 
> Don't put Echo = True in the exit block alone.  Put it in the error
> handler as well, especially if anything is going to pop up a
> messagebox.  Otherwise, you'll never see the messagebox and the
> routine won't fall through to the Exit block.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] 
> Sent: 19. veljaca 2003 11:20
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] Lost Warnings...
> 
> 
> One of the most valuable lessons that I learned the hard way is to
> ALWAYS put the DoCmd.SetWarnings True, DoCmd.Echo True and
> DoCmd.Hourglass False in the Exit block, if my routine alters those
> settings.  That way, if it crashes, the error handler will cleanup
> after itself!
> 
> Ever have code blow up with Echo set to False?  Scariest damn thing
> I've ever seen!
> 
> 
> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Wednesday, February 19, 2003 3:35 AM
> To: Drew Wutka
> Subject: Re: [AccessD] Lost Warnings...
> 
> 
> Hi Drew
> 
> > 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.
> 
> From time to time you need it. But, in those cases, also add a line
> that resets it to True in your error handler.
> 
> /gustav
> 
> _______________________________________________
> 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
> 
> 
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.  
> Try it free!  http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030219/8e9577ea/attachment-0002.html>