Problem with linking in MS Acces

[mboy]

Hi' Guys

I have a problem linking to a file from forms. I have build a form to search for entrys in the database. In a textbox the path to the link is displayed so i thougt that just clicking the link now would execute the viewer and display the file but no it's apparently not that easy because the link don't work ????

I have inserted this frequenze in Queries (Link: "c:\documents\" & [DocumentId] & ".TIF") wich is displaying the actual path of the actual imagefile.

I have tryed in Forms under properies of the textbox to set "is hyperlink" to yes wich don't help either ?????

How will i make my path/link work Guys ?????

Reg. Mboy

 

[mdmilner]

Do you have the text box formatted as a hyperlink?

 

[bat17]

I dont know why your hyperlink is not working but you could try using the FollowHyperlink command in the onclick event of the control.
Application.FollowHyperlink Me.MyControl

where MyControl is the name of your control.

HTH

Peter

 

[mboy]

Hi' Peter

Thank's for your answer.... But i have to get a littel more help i gues

I don't quite understand the part about my.control where am i suppose to put that part ??

Im sure you already know this but as you can se the link comes from merging other info so it's not constant so i can't predefine the link if it's what the my.control functions for ?

Mboy

 

[mboy]

Hi' mdmilner

How will i check that ?? I tryed formatting the textbox as hyperlink, but don't know how to format text as hyperlink ??

Mboy

Do you have the text box formatted as a hyperlink?

 

[bat17]

It goes in the code module behind the form. In design view click on you control and then in the property sheet select the "Click Event". Hit the build button (...) and select "Code Builder". This will take you to the form module and insert the first and last lines of the code for you, then just add the line I gave you, changing the names as required. you should end up with something like

Private Sub MyControl_Click()
Application.FollowHyperlink Me.MyControl
End Sub


HTH

Peter