rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Wed Jul 23 16:50:45 CDT 2003
It would be a good way for you to start learning VBA (visual basic for applications) in Access, and yes, a lot of the code is very similar to VB. Just fyi, we have several Access front ends to jet and MS SQL server backends here and they work very well. There are some instances where VB is a better solution for a particular application, but I honestly have not heard anyone who has used both VB and Access, come up with a strong argument why VB is better than Access as a database front end. Usually it's someone who has not used Access and realizes supervisors/managers can use it to do reporting so it can't be a very powerful program if non-technical people can figure it out. To me, that's what makes Access so great, it can be used for simple databases that most anyone can setup with the built-in wizards. Then when the simple database gets more complex, instead of re-writing the application in something else, Access can scale to the occasion. Hang in there, Access is a powerful tool. If you haven't found out already, if you think it can be done in Access, but you're not sure how, just ask this list. Rusty -----Original Message----- From: Bonnie Snider [mailto:BSNIDER at utah.gov] Sent: Wednesday, July 23, 2003 4:06 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Continue Incrementing 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com