Nov 13 2006, 04:33 PM
I did this a year ago and now can't remember how I did it! I have a table with 2 fields in each record, a job number and job description. I want to add another field to the record which is a link to a spreadsheet. I only want the spreadsheet to open up if I click on that field. Please help. Thanks in advance.
Nov 14 2006, 10:52 AM
In table design add the field required and make the datatype = Hyperlink
Open the table and place your cursor in the hyperlink field
Use hyperlink button on Toolbar to link to File
Hope this helps
Nov 14 2006, 11:00 AM
This attachment may help as well
Nov 15 2006, 08:02 AM
I would suggest you rather use a text datatype field instead of a hyperlink. Within that you can store the full string paths to the external files. Since users should never see the table or query level and only do what they are supposed to through an interface (forms) you can use the on click event of a control on a form bound to this table field to open up the file. To achieve that you can use the FollowHyperlink or Shell method e.g.:
Where YourControl is the control bound to the text datatype table field holding the full string path to the file.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here