Jim Lawrence
accessd at shaw.ca
Fri Sep 10 10:51:12 CDT 2010
Hi John: There are always better techniques on how to solve a particular problem. It just depends on how much you are being paid and how fast your client wants results... Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, September 10, 2010 4:33 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Automating web page entry (was: Scroll button) Yes, but I need the program to do stuff in access. While I can appreciate using scripting languages, there is something to be said for using the language built in to Access. The user enters sets of data records, basically all services supplied to a specific child by a specific therapist during a week. After entering the last record for that child, the user clicks a button on the web page and the web page returns a "status" for all of the records entered, which I then have the user capture and insert back into a control on the form and more code runs in the form to parse that information and writes back into all of the records entered for that child. It is a sucky system (yes, stupidity irritates me, particularly when I have to program around it). For the purposes of the discussion here though, we have a perfectly good language called VBA to use to write our applications. To do this little piece in VBA, then call out to AutoIt to do this little piece, then run more VBA then call autoit, then run VBA... C'mon. VBA can automate IE, I know that because I have done that. How about we discuss VBA automation of IE and how a single solution in the language behind Access might solve the problem? John W. Colby www.ColbyConsulting.com On 9/10/2010 7:00 AM, Stuart McLachlan wrote: > I did exactly the same with an application by a paint manufacturer for mixing paints a few > years ago using AutoIt. Same result. > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com