If you will be adding just one link per record, add a hyperlink field to the
table on which the form is based. On the form, add a text box that is bound
to that field. I will call the table field PDF_Link, and the text box
txtPDF_Link. In a command button's Click event, something like this:
Me.txtPDF_Link.SetFocus
DoCmd.RunCommand acCmdInsertHyperlink
If you will be adding a variable number of links you should use a related
Links table. The procedure is the same.
Note that if you use mapped drive letters for a linked pdf file in a network
location, either everybody needs to use the same drive letters or the
database can only be used at a computer that uses the same drive letters.
In general it would be best to add the link by drilling down through My
Network Places. To simplify the process if the pdf files are in a single
location, you can create a shortcut to that location (using the full network
path rather than the drive letter). Place the shortcut in the same folder
as the database. When users click to add the hyperlink, that is the default
starting folder to which they will be taken, and the shortcut will be
waiting for them.
