I am storing image name, directory and path within my database for pdf files
that need to be viewed.  What is the code that I need to do this?

thanks!
kat

Watch out for line wraps, everything after Shell on 1 line.

Public Sub OpenPdf()
   Shell """C:\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe""" & "c:\temp\Portfolio2.pdf", vbMaximizedFocus
End Sub

Do you want to view the image -- in Access or in a separate program -- or
open the PDF file?  If you want to view the image in Access, you can use an
unbound image control and set its Picture property to the path.  If you want
to open either the image or the pdf itself in a separate program (such as an
image editor or Acrobat Reader), you can do it easily if the file extension
is registered with the operating system to open with that particular
application.  You can use either the ShellExecute API (code to be found
here: http://www.mvps.org/access/api/api0018.htm ) or you can probably use
the Application.FollowHyperink method with the path to the file
(Application.FollowHyperlink "C:\FilePath\Filename.ext").

--
Dirk Goldgar
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)

Thank you both!  Both solutions worked.  I greatly appreciate your
assistance.

kat