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

"sunhealth" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)
> 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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks Dirk
the application object works like a dream.