Michael Mattys
michael at mattysconsulting.com
Fri Apr 22 08:06:23 CDT 2011
Hi John, I've just finished a similar project for downloading all pdf and xls from a site and the iron is still hot. I know its volunteer - just send the relevant access info to my address and I'll get your pics for you. Michael R Mattys Business Process Developers www.mattysconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, April 22, 2011 8:45 AM To: Access Developers discussion and problem solving Subject: [AccessD] How do I Grab the picture from the web page I am using the Microsoft web control to navigate to web pages and parse out information for my inmate checkout program. Part of the information is a picture that I have to click on to view. I am a visual kinda guy so it would be really nice if I could get the picture and store it locally so that I could see the picture of the guy without having to go click on that link every time as I scroll through the records. The first question is, can I click buttons in the web page using this web control? The following is what I assume to be button code: <table width="100%" cellspacing="2" cellpadding="5"> <tr align="center"> <td colspan="6" align="center"> <a href="pagelistoffendersearchresults.do?method=list&page=1&searchOffenderId=1 119894" class="actionbutton">Back To Search Results</a> </td> </tr> </table><br> The second question is, how can I extract the picture. The following is what I assume to be the picture control. <table border="0" cellpadding="0" cellspacing="0" class="innerdisplaytable"> <tr> <td bgcolor="#FFFACD" colspan="2"><img class="spacertop" src="images/spacertbl.gif" width="1" height="2" alt=""/></td> </tr> <tr> <td bgcolor="#999999" colspan="2"><img class="spacerbottom" src="images/spacertbl.gif" width="1" height="1" alt=""/></td> </tr> <tr> <td> <table class="picturediv"> <tr> <td> <table class="picturetable"> <td> <a href="#" class="photolink" id="dopobscurelink" onClick="javascript:unobscure('dopobscurelink','dopPicture','viewpicture.do? method=view&showDate=N&pictureType=I&offenderID=1119894','viewdetailbutton') ;return false;"><img align="center" id="dopPicture" src="images/silhouette.gif" /></a> </td> </table> </td> </tr> </table> </td> <td> Sorry for all of the extra "stuff" but not being a web kinda guy I don't really know what is necessary and what is fluff. I manage to grab the "tables" collection and iterate through the tables looking inside each for specific stuff to pull data out into my application. What I don't know is whether I can add another of these web page controls and feed it just a specific part of the whole to get the picture, or whether I can click a button, or how to g about getting this picture. Can anyone help me with this? -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com