Linking Files

[reece]

MS Access2k: I have a column in a table that is "hyperlink column" and the
actual file name is in each record in that column. When I run a report, it
lists the filename on the report, when I export the report in HTML and pull
up the HTML file, the links are all "http://myfilename.pdf" Why does it put
the "http://" in front of it? I looked back at the original table, and the
filenames are highlighted blue and underlined in the table, but when I click
on one it tries to bring up a webpage because for some reason Access is
putting the http:// in the table as well. The files are in the same directory
as the database, so I don't want the "http://" to be anywhere in the table OR
the HTML exported report.

Please suggest!

 

[schasteen]

What are you storing in the table? Are you putting the file path? It should
look like:

DisplayValue#C:\mydiretory\myfilename.pdf

 

[reece]

Since the PDF file is in the same directory as the database, so I am just
typing in the filename, i.e. "12DEC2007-WTG001.PDF"

 

[schasteen]

You need to store the path also. You can also format the hyperlink so that
you can display just the file name or any other text instead of the entire
file path. Type the display first followed by # then the file like

DisplayValue#C:\mydiretory\myfilename.pdf