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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"TAMitch" wrote in message
...
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