Saving PDF files in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure if this is possible, but if it is I would sure like to know. Is
there some way to save a pdf file in access, almost like saving an OLE
object? We have a lot of PDF reports that come from other companies, and they
have specs and other information that we would like to have in one
centralized area and be able to pull that information or report back up,
without having to do a lot of searching. I tried researching the adobe
active-x control but dont understand it really. Kinda like the Calender
Control, didn't get that either. =:o)

Thanks!
 
Why not refer to the PDF's location instead?

Just create a PDF folder, give a unique name to the files, create a text
field with the full path to the file and then you just need to call acrobat
with that file name.

Dim stAppName As String
Dim stFileName As String

stAppName = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"
stFileName = "C:\PDF\123.pdf"
Call Shell(stAppName & " " & stFileName, 1)

Gal
 
Or, if you don't want to be bothered figuring out where acrord32.exe is
located, you can use

Dim stFileName As String

stFileName = "C:\PDF\123.pdf"
Application.FollowHyperlink stFileName

or the ShellExecute API (see http://www.mvps.org/access/api/api0018.htm at
"The Access Web" for details)
 
Thanks! I will try this and see how it goes. You are right, I don't need to
save it in access and load the memory with unneeded files. I can just have
links to them.
 
Back
Top