<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] Continue Incrementing</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=625441623-23072003><FONT face=Arial color=#0000ff size=2>But...
if you actually learn how to USE frameworks, WithEvents and Classes, then you
have become a pretty good programmer yourself and probably don't have much need
for John any more.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Hale,
Jim<BR><B>Sent:</B> Wednesday, July 23, 2003 2:30 PM<BR><B>To:</B> 'Access
Developers discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD]
Continue Incrementing<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>