Hyperlink on Form

[simplymidori]

Hello,

I have a list of hyperlinks in a continious subform. The link has this code

Private Sub Link_Click()

Application.FollowHyperlink Me.Link

End Sub


Link: Format("view#ftp://XXX:[email protected]/spot/" & [Link] & ".wmv")

I have view# as my display text as and when I click on the link I get a
runtime error 490 cannot open the specified file. But, when I click END it
goes to the link.

Am I missing something?

Thanks

 

[Jeanette Cunningham]

simplymidori,
If the textbox called Link has the full path and file name, using
Application.FollowHyperlink Me.Link should open the file.
Here's an example:
I have a file on my computer called MyTestFile.txt
It is in the C drive.
The code
Application.FollowHyperlink "C:\MyTestFile.txt" will open the file

Jeanette Cunningham

 

[Jeanette Cunningham]

See it this info helps
http://www.allenbrowne.com/func-GoHyperlink.html

Jeanette Cunningham

simplymidori,
If the textbox called Link has the full path and file name, using
Application.FollowHyperlink Me.Link should open the file.
Here's an example:
I have a file on my computer called MyTestFile.txt
It is in the C drive.
The code
Application.FollowHyperlink "C:\MyTestFile.txt" will open the file

Jeanette Cunningham

Hello,

I have a list of hyperlinks in a continious subform. The link has this
code

Private Sub Link_Click()

Application.FollowHyperlink Me.Link

End Sub


Link: Format("view#ftp://XXX:[email protected]/spot/" & [Link] &
".wmv")

I have view# as my display text as and when I click on the link I get a
runtime error 490 cannot open the specified file. But, when I click END
it
goes to the link.

Am I missing something?

Thanks