followhyperlink problem

majsparky

Registered User.
Local time
Today, 13:59
Joined
Nov 8, 2003
Messages
21
Hello Everyone;

I have a Form with a List Box that displays hyperlinks to the internet and intranet. Behind the "After Update" event, I use "Application.FollowHyperlink strXXX" to go to the internet.

Private Sub Combo46_AfterUpdate()
Dim strhyperlink As String

strhyperlink = Me!List46
Application.FollowHyperlink strhyperlink, , True, True
End Sub

This works fine for intranet addresses, such as:
https://rep.ittind.com

However, it gives me an 'runtime error 7971 ... can't follow hyperlink... Please verify destination' when I try to go to
a www address such as:
http://www.bellgossett.com/

Note: If I click on the field in the table itself it goes to the www site.

Can anyone tell me where I am messing up in the coding for the FollowHyperlink routine??

Thank you in advance for any help on this one.
 
Found Problem

Just to inform everyone, I found the problem in that I had the table with the internet addresses formatted as a hyperlink. I change it over to text and the "Followhyperlink" routine now works like a champ.
 

Users who are viewing this thread

Back
Top Bottom