Bonnie Snider
BSNIDER at utah.gov
Wed Jul 23 16:06:10 CDT 2003
I suppose that would be a good way to start learning visual basic? Everyone here tells me I shouldn't be using access for the front end of my databases anyway. >>> rusty.hammond at cpiqpc.com 7/23/2003 11:16:30 AM >>> 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 _______________________________________________ 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