JosephEricDavis
asked on
Access 2007 VBA - dynamic hyperlinks
I've got a report that is supposed to show a listing of files. This listing of files is contained within a table in my database and I have the data coming down to the report correctly. I have a file name and path to the file on the computer or network where the file is located. I would like to display only the name of the file and then when someone clicks on the file name it open the file for them. I'm inside the onclick event of a textbox in the detail portion of the report that is showing the file name. The textbox is set to appear as a hyperlink. In code, when this textbox is clicked, how do I access the location field of the same record from the database. Again, the location field is already part of the report. The data is present, I'm just now sure how to access the right location (or path) for a given filename that has been clicked on.
Thanks.
Thanks.
ASKER
The field in the current record that I'm trying to access is called Location.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may need to tweak the link string a bit, e.g. if your location field contains
c:\myfolder\subfolder
and the FileName field contains
mysheet.xls
You'll need to do this
strLink = Me.Location & "\" & Me.FileName
OM Gang
c:\myfolder\subfolder
and the FileName field contains
mysheet.xls
You'll need to do this
strLink = Me.Location & "\" & Me.FileName
OM Gang
OM Gang