Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 29th, 2005, 05:36 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default URL Checker for a Microsoft Access 2003 Database

Hello again.

I’m looking for some help or information on a URL Checker for a Microsoft Access 2003 Data base.

If anyone can send me information on how I would create this or where I might be able to find the information please do.

Thanks

Corey


Reply With Quote
  #2 (permalink)  
Old November 29th, 2005, 09:49 PM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

What exactly do you mean by a url checker?

Kevin

dartcoach
Reply With Quote
  #3 (permalink)  
Old November 30th, 2005, 11:51 AM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

I would like to be able to verify a list of web links are working

Reply With Quote
  #4 (permalink)  
Old November 30th, 2005, 04:14 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

In order for something like this to work, Microsoft Internet Explorer (or Netscape) has to communicate back to Access of the result of the load. There is nothing I know of that does this.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #5 (permalink)  
Old November 30th, 2005, 05:03 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

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

HTH

Mike


Mike
EchoVue.com
Reply With Quote
  #6 (permalink)  
Old November 30th, 2005, 06:05 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

Mike,

Why an I not able to find teh Microsoft Brower ActiveX Control?

Reply With Quote
  #7 (permalink)  
Old November 30th, 2005, 06:33 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Sorry, my bad - It is the 'Microsoft Web Browser' that you want. If you still can't find it, it should be under the aditional controls option on the toolbox.

Mike
EchoVue.com
Reply With Quote
  #8 (permalink)  
Old November 30th, 2005, 07:00 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

Hi again Mike,

I was able to find the Microsoft Web Browser, and added it to my form.

Could you help me understand what you meant by”
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.

Thanks for the clarification.

Corey


Reply With Quote
  #9 (permalink)  
Old November 30th, 2005, 09:23 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Alright - here you go, this will need a little tweaking but should get you the basic idea...

I have a form with a text box - txtAddress
                    a browser - ocxBrowser
                     a button - cmdGo

What it does it to take the source code of the page and saves it in a file C:\source.txt. I am thinking you could either just check the innerHTML property for whatever the code looks like on a page not found, or check out the contents of the file.

Code:
Option Compare Database
Option Explicit

    Dim objIE As SHDocVw.InternetExplorer
    Dim strURL As String
    Dim strFileName As String

Private Sub cmdGo_Click()
    strURL = txtAddress
    Set objIE = Me.ocxBrowser.Object
    objIE.Navigate strURL
End Sub


Private Sub Form_Load()
    strURL = "http://echovue.com/"
    Set objIE = Me.ocxBrowser.Object
    objIE.Navigate strURL
End Sub

Private Sub ocxBrowser_DownloadComplete()
    On Error Resume Next
    strFileName = "C:\Source.txt"
    Set objIE = Me.ocxBrowser.Object
    Open strFileName For Output As #1
    Print #1, objIE.Document.body.innerHTML
    Close #1
    txtAddress = objIE.LocationURL
    Beep
End Sub

Mike
EchoVue.com
Reply With Quote
  #10 (permalink)  
Old December 8th, 2005, 12:29 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

Hi again Mike –

Sorry I wasn’t able to get back to you sooner, I got pulled into another project.

I tried added the Web Browser within access and I’m not sure if it’s working or how I can check to see if it is working. It just makes a black box.
This is the first time I ever user this function so I apologize for sounding so ignorant.

Any chance you can help me test this –

Corey


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
URL Checker caster001 PHP How-To 1 November 27th, 2006 11:10 AM
Run Microsoft Access 2003 with runtime C_O Access 2 February 17th, 2006 01:36 PM
Problem Connecting to Microsoft Access Database eric_lim_1 Classic ASP Databases 1 September 17th, 2005 03:12 AM
Microsoft Access can't open the database because. vinodkalpaka Classic ASP Components 2 August 4th, 2004 06:27 PM
Microsoft Access can't open the database because. vinodkalpaka Classic ASP Databases 2 July 24th, 2004 04:37 PM



All times are GMT -4. The time now is 12:33 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.