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"