Hyperlink to Scanned Documents

[Guest]

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?

 

[Graham Mandeno]

Hi Jim

Have you tried using the FollowHyperlink method?

Application.FollowHyperlink "\\Law\DataXfers\Jim\ScannedFiles\" _
& [AddSubFormFile!DAFileNumber] & ".tif'"

 

[Guest]

That looks like it will work, but meanwhile I have worked out another solution.
Private Sub Form_Load()

If Form_AddSubFormFile.ScannedFile = -1 Then
Command19.Visible = True
Command19.HyperlinkAddress = "\\Law\DataXfers\Jim\ScannedFiles\"
& [DAFileNumber] & ".TIF"
Else
Command19.Visible = False
End If
End Sub

This loads the command button and, if the field has been flagged, makes the
button visible.

Thanks for your support.

Jim

Hi Jim

Have you tried using the FollowHyperlink method?

Application.FollowHyperlink "\\Law\DataXfers\Jim\ScannedFiles\" _
& [AddSubFormFile!DAFileNumber] & ".tif'"
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

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
without success. What am I doing wrong?