Using Hyperlink.Follow

[AccessTest]

Hi Guys,

I am trying to use the Hyperlink function.
The problem is that it does not open any graphic software view when I am pressing the button – I would appreciate any help.

Here is the code that I attach to the button:

Private Sub Cmd_To_Plans_Click()
On Error GoTo sof:
If Not IsNull(Me.link) Then Me.link.Hyperlink.Follow
sof: DoCmd.Beep
End Sub

Where link is the field.

Thanks in advance.

 

[boblarson]

Your syntax is in error, use:

FollowHyperlink "http://" & Me.link

 

[AccessTest]

Well i am trying to associate to the filed graphic software view...
and i dont have "http://"...
any thoughts?

Thanks

 

[boblarson]

that would be "file:///" instead then.

 

[AccessTest]

Ok, and if the file is the field name how should i implement it?

Thanks a lot for your help!

 

[AccessTest]

that would be "file:///" instead then.

what i am trying to do is to actually have the ability to see the hyperlink
that within the field - the syntax that you gave me is working - but it is only open the software and not opening the picture associate with...any ideas?

Thanks a lot!

 

[AccessTest]

This is the code that i put:

Private Sub Cmd_To_Plans_Click()
FollowHyperlink "Files://" & Me.Link
End Sub

This is an error that i got :-(
files://C:\Documents%20and%20Settings\All%20Users\Documents\My%20Pictures\Sample%20Pictures\Sunset.jpg/

Any thuoughts?
Appriciate

 

[boblarson]

Well, for one you are missing a forward slash (when using the files designator you need 3 forward slashes, not 2:

it is files:///
and not files://

 

[AccessTest]

Well, for one you are missing a forward slash (when using the files designator you need 3 forward slashes, not 2:

it is files:///
and not files://

Thats works perfect - cheers mate!

 

[boblarson]

Glad to hear!