<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Continue Incrementing</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>LOL. And just about the time you reach a level where you begin to understand what John is talking about regarding frameworks, sinking events, classes, DEEP, etc., he goes off and starts learning .net and his emails start reading like greek again.<sigh> <g></FONT></P>
<P><FONT SIZE=2>Jim Hale </FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: jcolby@colbyconsulting.com [<A HREF="mailto:jcolby@colbyconsulting.com">mailto:jcolby@colbyconsulting.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 11:51 AM</FONT>
<BR><FONT SIZE=2>To: Access Developers discussion and problem solving</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Continue Incrementing</FONT>
</P>
<BR>
<P><FONT SIZE=2>Bonnie,</FONT>
</P>
<P><FONT SIZE=2>Go for it. Code is easy, it just has to be taken one step at a time. Doing</FONT>
<BR><FONT SIZE=2>that will make you TRULY dangerous. ;-)</FONT>
</P>
<P><FONT SIZE=2>John W. Colby</FONT>
<BR><FONT SIZE=2>www.colbyconsulting.com</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: accessd-bounces@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:accessd-bounces@databaseadvisors.com">mailto:accessd-bounces@databaseadvisors.com</A>]On Behalf Of Bonnie Snider</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 12:34 PM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [AccessD] Continue Incrementing</FONT>
</P>
<BR>
<P><FONT SIZE=2>I know compared to you guys I'm a real novice. I've done a lot of</FONT>
<BR><FONT SIZE=2>databases and had to update a lot of fields, but I've always done it</FONT>
<BR><FONT SIZE=2>with update queries and macros. (I'm terrified of code and I don't</FONT>
<BR><FONT SIZE=2>understand what it means at all). But any time I've had to update a</FONT>
<BR><FONT SIZE=2>field based on an entry to a field in a record, I've always had to save</FONT>
<BR><FONT SIZE=2>the record before it would update. So in the properties of the field I</FONT>
<BR><FONT SIZE=2>would tell it to run a macro after update. The macro has a save record</FONT>
<BR><FONT SIZE=2>command and an open query command. The query is an update query. I</FONT>
<BR><FONT SIZE=2>know it's probably slower than code, but it works for me.</FONT>
</P>
<P><FONT SIZE=2>>>> gustav@cactus.dk 7/23/2003 7:49:12 AM >>></FONT>
<BR><FONT SIZE=2>Hi Virginia</FONT>
</P>
<P><FONT SIZE=2>Well, if your form somehow is bound to table "DocumentList" and you</FONT>
<BR><FONT SIZE=2>use</FONT>
</P>
<P><FONT SIZE=2> intMax = DMax(..., "DocumentList", ..)</FONT>
</P>
<P><FONT SIZE=2>and this doesn't work, something else that prevents DocumentList from</FONT>
<BR><FONT SIZE=2>being updated must be going on.</FONT>
</P>
<P><FONT SIZE=2>/gustav</FONT>
</P>
<BR>
<P><FONT SIZE=2>> I tried your suggestion and it didn't make any difference.</FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
<P><FONT SIZE=2>Bonnie Snider, LAN Administrator</FONT>
<BR><FONT SIZE=2>DWS North Admin</FONT>
<BR><FONT SIZE=2>Phone: 526-9253</FONT>
<BR><FONT SIZE=2>Cell: 430-1219</FONT>
<BR><FONT SIZE=2>FAX: 526-9744</FONT>
<BR><FONT SIZE=2>EMAIL: bsnider@utah.gov</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>