Bonnie Snider
BSNIDER at utah.gov
Wed Jul 23 16:19:49 CDT 2003
How did you guess that? :-) I told them I wanted my people to access my database from the web and how did I go about that and they came down and looked at it and told me that it was not possible for them to access it from the web, especially across a wide area network because of record locking and this and that, (of course, I have obviously had a few problems that way or I wouldn't be talking to you guys), and if I would have my boss sign a paper authorizing them to write a program for me they would be happy to come down and discuss my needs with me. That just made me made so I got on the internet and started looking up stuff and found out how to do a data access page which didn't work at first, but I was still aggravated, so I kept looking and I found out how to make it work and then I found out about pivot tables and how to put my reports out there so other people could look at them, and now everybody is happy except when it's data entry time. But we'll fix that, as well. I hope. Thanks for all your help. We'll get there. :-) >>> cfoust at infostatsystems.com 7/23/2003 3:10:52 PM >>> Don't listen to them. They're probably IT people or VB programmers who don't understand how powerful Access is. Charlotte Foust -----Original Message----- From: Bonnie Snider [mailto:BSNIDER at utah.gov] Sent: Wednesday, July 23, 2003 1: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 _______________________________________________ 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