[AccessD] internet screen manipulation

Thu Jun 17 11:23:25 CDT 2010

I would like to do this stuff from inside of Access if it is possible.  Ages ago I used VBA IE 
automation to open a web site and see the objects in the web page.  I have not done that since, and 
the world has changed immensely since then.

John W. Colby
www.ColbyConsulting.com

jeffrey.demulling at usbank.com wrote:
> Jon,
> 
> Take a look at the products offered by OpenSpan.  I am not sure what the 
> pricing is though.
> 
> Jeffrey F. Demulling
> Process Automation Support Group Manager
> Corporate Trust Services
> U.S. Bank
> EP-MN-WS2N
> 60 Livingston Avenue
> St. Paul, MN 55107-2292
> jeffrey.demulling at usbank.com
> 651-495-3925 direct
> 651-495-8103 fax
> 7157680478 at txt.att.net pager
> 
> 
> 
> 
> From:
> jwcolby <jwcolby at colbyconsulting.com>
> To:
> Access Developers discussion and problem solving 
> <accessd at databaseadvisors.com>, VBA <dba-vb at databaseadvisors.com>
> Date:
> 06/16/2010 11:11 AM
> Subject:
> [AccessD] internet screen manipulation
> Sent by:
> accessd-bounces at databaseadvisors.com
> 
> 
> 
> I have a client that has to do data entry into an internet screen.  I am 
> researching whether a 
> program can manipulate an internet form, poke values into specific 
> controls, click buttons etc.
> 
> I have looked at the source for one specific screen and it appears to be 
> all java.  For example, top 
> of the screen
> 
> <html>
>                  <head>
>                                  <title>Professional Claim</title>
>                                  <link href='/ePROM/CSS/styles.css' 
> rel='stylesheet' type='text/css'>
> <script src='/ePROM/ScriptLibrary/utils.js'></script>
> <script src='/ePROM/ScriptLibrary/soap.js'></script>
> <script src='/ePROM/ScriptLibrary/gui.js'></script>
> <script src='/ePROM/ScriptLibrary/xsd.js'></script>
> <script src='/ePROM/ScriptLibrary/xbind.js'></script>
> 
> <script src='/ePROM/ScriptLibrary/validation.js'></script>
> <script src='/ePROM/ScriptLibrary/calendar.js'></script>
> <script src='/ePROM/ScriptLibrary/techSupport.js'></script>
> 
> <script language=javascript>
>                  var g_fFieldsChanged = 0;
>                  var hrs = 0;                                    // DF 
> 5462
>                  var mins = 90;          // DF 5462
>                  var secs = 0;                                   // DF 
> 5462
> </script>
> 
> <SCRIPT FOR=window EVENT=onload>
>                  // Heir Menus
>                  if (typeof(HM_f_StartIt) != "undefined")
>                                  HM_f_StartIt();
> 
>                  // Call any user defined "onload" routines.
>                  var inx;
> 
> ###################################################################################
> 
> So...
> 
> do developers poke data into screens, and read values back from screens, 
> click buttons, select menu 
> items etc?
> 
> I did this kind of thing back in the late 90s but so much has changed.  I 
> am just beginning to 
> investigate whether this is possible and where to go to learn how.
> 
> Any help appreciated
> 