<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>RE: [AccessD] Lost Warnings...</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">You betcha! <VBG></FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">Charlotte Foust</FONT>
</P>
<UL>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd-admin@databaseadvisors.com [</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B> <FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma">John W. Colby</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Wednesday, February 19, 2003 11:33 AM</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">RE: [AccessD] Lost Warnings...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">There's the voice of experience talking! ;-)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: accessd-admin@databaseadvisors.com [</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com]On"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:accessd-admin@databaseadvisors.com]On</FONT></U></A><FONT SIZE=2 FACE="Arial"> Behalf Of Charlotte Foust</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Wednesday, February 19, 2003 2:22 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [AccessD] Lost Warnings...</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Charlotte Foust</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: Brett Barabash [</FONT><A HREF="mailto:BBarabash@tappeconstruction.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:BBarabash@tappeconstruction.com</FONT></U></A><FONT SIZE=2 FACE="Arial">] </FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: 19. veljaca 2003 11:20</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: 'accessd@databaseadvisors.com'</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [AccessD] Lost Warnings...</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">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!</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Ever have code blow up with Echo set to False? Scariest damn thing I've ever seen!</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: Gustav Brock [</FONT><A HREF="mailto:gustav@cactus.dk"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:gustav@cactus.dk</FONT></U></A><FONT SIZE=2 FACE="Arial">]</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Wednesday, February 19, 2003 3:35 AM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: Drew Wutka</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: Re: [AccessD] Lost Warnings...</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Hi Drew</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">> Interesting. So if Access crashes, the docmd.setwarnings sticks in </FONT>
<BR><FONT SIZE=2 FACE="Arial">> the actual options, not just as a temporary flag eh? I always knew to </FONT>
<BR><FONT SIZE=2 FACE="Arial">> be careful with SetWarnings, but I didn't realize it would stick from </FONT>
<BR><FONT SIZE=2 FACE="Arial">> session to session.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">From time to time you need it. But, in those cases, also add a line that resets it to True in your error handler.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">/gustav</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com </FONT><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A><FONT SIZE=2 FACE="Arial"> _______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com </FONT><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A><FONT SIZE=2 FACE="Arial"> _______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com </FONT><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. </FONT>
<BR><FONT SIZE=2 FACE="Arial">Try it free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
</UL>
</BODY>
</HTML>