Hyperlink string doesnt open file

[tagteam]

I have a table has two fields: CompanyLocation , FileName



I have a form that uses and unbound field to create a file path string

="file:///s:/My Folders/" & [CompanyLocation] & "/" & [FileName]

In the form it looks like file:///s:/My Folders/My Company One/This Is My File.doc

I then set this to hyperlink in the form but when i click on it nothing happens.

When i copy the link it gives me and paste it into Windows Explorer it works fine.

Thanks for any help

[ItsMe]

Try

s:/My Folders/My Company One/This Is My File.doc

[tagteam]

That does the same thing. Both work if you copy the result of the link and paste it in Windows Explorer but neither of them will open the link from within the Access form.

[ItsMe]

In a dbl click or click event place

ControlName.HyperlinkAddress = "s:/My Folders/My Company One/This Is My File.doc"

Just make sure you get the name of the control that is associated with the event before .HyperlinkAddress

[tagteam]

All of the hyperlinks are generated from the database so I can't enter it direct.

What I was able to do is create a continuous form which displays all the hyperlinks associated with that record and then put a button next to each item with the code Application.FollowHyperlink Me.FileURL (FileURL is the name of the unbound field that holds the file path)
However, this doesnt seem to work if I put it in that fields on click event.

[ItsMe]

You have a couple options. I don't like displaying hyperlinks (the actual path). So, I would hide that control and place something else there. Maybe a button or even a text box. You may have a text box that represents what the hyperlink is for/to. Like a file name or file description that the User is familiar with.

What you can do is....
In the click event, assign a string variable the hyperlink value. The hyperlink is the textbox so you just make your string = textbox. Then assign the string variable to the control with the click event.

Dim strLink As String
strLink = Me.ControlWithPath.Value
Me.ControlName.HyperlinkAddress = strLink

THis will work in a continuous form because the act of the user clicking a control will set focus on that record.

[tagteam]

cool, works great ,thanks

[ItsMe]

Glad to hear!