Organising External Flies

  • Thread starter Thread starter TAMitch
  • Start date Start date
T

TAMitch

Hi,
I have a large number of related PDF documents that are currently
hyperlinked as a means of access and searching. I would like to develop a
access database that can organise these file, but more importantly open them
from an access control.
Therefore I need a way of opening pdf documents from within the database.
Thanks
 
FollowHyperlink will open them in the program registered with Windows for
handling PDF files.

Example:
strFile = "C:\MyFolder\MyFile.PDF"
strFile = strFile & "#file:///" & Replace(strFile, "\", "/") & "#"
DoCmd.FollowHyperlink strFile

If your file names could contains strange characters such as #, see:
http://allenbrowne.com/func-GoHyperlink.html
 
Back
Top