connecting to pdf files

[sunhealth]

Hi all,
I am trying to connect from an access form to an external pdf file so
that it will open in adobe reader.
Any help would be appreciated.
Thanks

 

[Dirk Goldgar]

Hi all,
I am trying to connect from an access form to an external pdf file so
that it will open in adobe reader.
Any help would be appreciated.
Thanks

You can probably call the Application.FollowHyperlink method to open it:

Application.FollowHyperlink "C:\My Documents\MyFile.pdf"

Or you could call the Windows ShellExecute API, using the code to be
found here:

http://www.mvps.org/access/api/api0018.htm

 

[sunhealth]

Thanks Dirk
the application object works like a dream.