[AccessD] Continue Incrementing

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Wed Jul 23 12:16:30 CDT 2003


Bonnie,

One way start learning about code, you can convert your macros to code to
see what the code looks like to do the same thing as your macro.

>From the Access 97 help:

Convert global macros to Visual Basic

1	In the Database window, click the Macros tab.
2	Click the name of the macro you want to convert.
3	On the File menu, click Save As/Export.
4	In the Save As dialog box, click Save As Visual Basic Module.

Not sure how to do this in A2k or AXP but I'm pretty sure it can be done.

HTH

Rusty

-----Original Message-----
From: Bonnie Snider [mailto:BSNIDER at utah.gov]
Sent: Wednesday, July 23, 2003 11:34 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Continue Incrementing


I know compared to you guys I'm a real novice.  I've done a lot of
databases and had to update a lot of fields, but I've always done it
with update queries and macros. (I'm terrified of  code and I don't
understand what it means at all).  But any time I've had to update a
field based on an entry to a field in a record, I've always had to save
the record before it would update.  So in the properties of the field I
would tell it to run a macro after update.  The macro has a save record
command and an open query command.  The query is an update query.   I
know it's probably slower than code, but it works for me. 

>>> gustav at cactus.dk 7/23/2003 7:49:12 AM >>>
Hi Virginia

Well, if your form somehow is bound to table "DocumentList" and you
use

  intMax = DMax(..., "DocumentList", ..)

and this doesn't work, something else that prevents DocumentList from
being updated must be going on.

/gustav


> I tried your suggestion and it didn't make any difference.

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

Bonnie Snider, LAN Administrator
DWS North Admin
Phone:   526-9253
Cell:        430-1219
FAX:       526-9744
EMAIL:   bsnider at utah.gov
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list