Found the answer in Q323202:
http://support.microsoft.com/default.aspx?scid=kb;en-us;323202&Product=acc
Apparently, Access stores a hyperlink field as
whatyousee#
http://Address#SubAddress
Therefor, with some text functions like LEFT and INSTR
you can set/program the hyperlink address.
Or you could change
http://
to
mailto:
for example.
I did it with this function:
Private Sub Factuurnummer_AfterUpdate()
If Len(Me![Factuurnummer]) = 0 Then Exit Sub
Me![Factuurnummer] = Left(Me![Factuurnummer], InStr(1,
Me![Factuurnummer], "#") - 1) & "#" _
& "\\Server\Data\Bh\Scans\Aankoop\" & Left(Me![Factuurnummer], InStr(1,
Me![Factuurnummer], "#") - 1) & ".pdf#"
End Sub
It seems to me that a hyperlink in Access is differently built compared to
Word or Excel.
Maybe some more work to do for Microsoft for better integration of the
Office parts?
