My question is... Is there a way to place a link to a .pdf file into Access where if you click it from a database it will pull up the file? I don't think there is but it's worth the time to ask. Thanks.
Placing a link in Access
Collapse
X
-
Nevermind... I answered my own question via trial and error. Apparantly you can. It's not pretty but it works... lol -
-
Within the tables you can insert a hyperlink column and from there just edit the hyperlinks to the file you want to pull up. I copied and pasted the names of the files into the hyperlink column and that was it. Pretty simple but if you have quite a few links to update, it may take a while. I actually decided to bypass the entire ordeal and did it in Excel.Comment
-
There are several ways to do it, depending on how much time you want to spend, and how elegant you want it.
You can make a button which opens a filebrowser and then simply browse to the file(s), select them, and have the code store the info in the hyperlink field. You can also make code/form that mimics a file-browser but with more customised properties and abilities depending on your needs.Comment
Comment