J
JMurray51
I have an established database in Access 2002 to which I want to add the
ability to view scanned documents. I think a dynamic hyperlink would work
well. I will store the scanned documents on my server and name them with the
file number used by the database. My problem is in creating the dynamic link.
A static link, \\Law\DataXfers\Jim\ScannedFiles\9999955.tif works well. The
DAFileNumber, 9999955, is the only variable. It is displayed in the same form
as the hyperlink button. I've tried variations on
'\\Law\DataXfers\Jim\ScannedFiles\' & ([AddSubFormFile!DAFileNumber]) &
'.tif' without success. What am I doing wrong?
ability to view scanned documents. I think a dynamic hyperlink would work
well. I will store the scanned documents on my server and name them with the
file number used by the database. My problem is in creating the dynamic link.
A static link, \\Law\DataXfers\Jim\ScannedFiles\9999955.tif works well. The
DAFileNumber, 9999955, is the only variable. It is displayed in the same form
as the hyperlink button. I've tried variations on
'\\Law\DataXfers\Jim\ScannedFiles\' & ([AddSubFormFile!DAFileNumber]) &
'.tif' without success. What am I doing wrong?