[AccessD] Get data From Web

Mark,

I've seen it done in VB using a web browser control and I even had a demo but I can't find it :-(  That demo was showing how to feed a value to a named control but I'm sure the reverse is true.

I most likely found it on the web though and given that it was a while ago I probably found it on codehound.com

Another option might be to grab the HTML source code as a text stream and search for the control name tag then get its value.  If the site subscribes to the XHTML doctrine you could probably use the XML DOM to find the tag (or node).

HTH,

Jim DeMarco
Director Application Development
Hudson Health Plan
Tarrytown NY


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Friday, February 18, 2005 10:42 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Get data From Web


Hello All,

Thanks for the feedback...but is there a way to extract data from a web page 
using access?  Example: For example...the page always has a text box 
labelled 'COLOR'...can I use access to open that page and tell me what value 
is in the COLOR text box?

Thanks,

Mark



>From: "Darren DICK" <d.dick at uws.edu.au>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Get data From Web
>Date: Fri, 18 Feb 2005 09:51:52 +1100
>
>Hi Max
>And anyone else
>I can knock up a demo in Access 2003 if anyone wants one
>
>Lemme know off line
>
>See ya
>
>Darren
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max
>Sent: Friday, 18 February 2005 5:18 AM
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Get data From Web
>
>Hmm,
>Very interesting.  Do you (or anybody else) have examples of the HTML 
>object
>library being used?
>Thanks
>Max Sherman
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
>Sent: 17 February 2005 16:30
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Get data From Web
>
>Hi Mark:
>
>You can do almost anything with Access if you have the Microsoft HTML 
>object
>Library referenced. It inserts a full browser class in Access.
>
>HTH
>Jim
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Thursday, February 17, 2005 6:56 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Get data From Web
>
>Hello All,
>
>Not sure where this is going...but I've been asked if this is possible with
>Access...
>
>"Can you use Access to open a web page...and take/get/copy(whatever you 
>want
>
>to call it) the data out of a certain field?"  For example...the page 
>always
>
>has a text box labelled 'COLOR'...can I use access to open that page and
>tell me what value is in the COLOR text box?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>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
>
>--
>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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************