View Single Post
  #5 (permalink)  
Old November 30th, 2005, 05:03 PM
echovue echovue is offline
Friend of Wrox
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

I think you might be able to do it by setting up the following...

Add the Microsoft Brower ActiveX Control to your form.
Set the address to the URL of the first record.
On the Download_Complete event of the browser, check the InnerHTML property of the browser.
You will then need a way to tell if the page downloaded or not - Perhaps you could check to see if the first few lines match the HTML for a Page Not Found error.
When that is figured out, just load the next address.

I have some similar code that I used to strip a bunch of information from an online database for one of my customers - If you need a hand, I would happy to post some of it when I get home tonight. Just let me know