Hyperlink an IP Address - Access 97

Posted on 2004-11-29
Medium Priority
Last Modified: 2006-11-17
I have an IP Address field on my form.  I would like a command button that will open a brower with http to the IP Address...

For example,  <---- would be the line in my web browser.

Any idea's?
Question by:perplexed71
  • 3
  • 2
LVL 34

Expert Comment

ID: 12695863
something like this (will open in a new window)

private sub cmdMyButtonName_click()
        application.followHyperlink " ", , true
End Sub
LVL 34

Expert Comment

ID: 12695982
ohh.. a field

private sub cmdMyButtonName_click()
        application.followHyperlink Me.MyHyperLinkField, , true
End Sub

Author Comment

ID: 12695987
I get this error,

Run-time Error '-2146697211 (800c005)':
Methond 'FollowHyperlink' of object'_Application' Failed
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 34

Expert Comment

ID: 12696022
works fine here (Access 2003 though)

But i use 97 at work and im 99.9999999% sure Application.hyperlink is there

Accepted Solution

NGPSoft1 earned 2000 total points
ID: 12696658
I tried it with Access 97, got the same results as you. Interestingly, it appears to work fine if you pass it a FQDN, as opposed to an IP address.

Try this:

Public Sub testit()
Dim i As Integer
Dim progstr As String
Dim url As String
url = ""
progstr = "C:\Program Files\Internet Explorer\iexplore.exe"
i = Shell(progstr & " " & url)
Debug.Print i
End Sub

Hope that helps.

Author Comment

ID: 12696881
Here's what I have:

Private Sub HTTP_Click()
Application.FollowHyperlink Me.IPAddress, , True
End Sub

The error is now:

Run-time Error '432'
File name or class name not found during Automation operation.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question