Linking to file system objects - advises ?

  • Thread starter Thread starter AlexT
  • Start date Start date
A

AlexT

Folks

I have to implement links to external documents, i.e. links to files
existing in the file system (such as office documents or PDF files).

I'm pretty sure this a very common need and have browsed a little bit
(actually more than that) on the net to find sample code / advises /
best practices in this field. Much to my amazement I have not found
much relevant material.

Any pointers would be much welcome (A2k3 / Mdb / Vba)

Thanks & regards

--alexT
 
Alex:

Not sure where you want the links to be displayed, but in a table / query
and form you can use a hyperlink field type to create a link to a file;
hyperlinks are not active in Access reports. If you want to set the
hyperlink by code (i.e. via a recordset) you can do so using this syntax:

standard hyperlink field values: #c:\some dir\somefile.doc#
aliased hyperlink field value: AliasFileName#c:\some dir\somefile.doc#

HTH
 
Thanks

Must say that I'm a bit suprised not to find more material on this
topic...

Regards

--alexT
 
Back
Top