Using Hyperlinks to open external files

[darren]

My database consists of 80 sites, each site has related information in one
single pdf such as maps, photographs, reports, drawings, etc. As these files
are quite large I do not want to store these in my table as OLE object, but
rather store these files externally to the database and set up hyperlinks
that will automatically open up the folder containing the information. I am
transfering this database from ny hard drive to a CD that will contain one
database file and 80 folders each containing a site pdf file. I am wondering
how to set hyperlink file path in my table to open the folders. The
hyperlinks work fine on my hard drive, however when I burn the CD the
hyperlinks to not work.

Darren

 

[Arvin Meyer [MVP]]

You don't even need a hyperlink. In fact it's better not to use them because
they, themselves, are OLE objects. Instead use the hyperlink property of a
command button (or even a text box). Here's some same code:

Private Sub cmdHyperlink_Click()
Dim strPath As String
If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Me.cmdHyperlink.HyperlinkAddress = strPath
End If
End Sub