Re: Saving PDF files in Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gal Zilberman (gal.zilberman_at_tns-teleseker.com)
Date: 02/13/05


Date: Sun, 13 Feb 2005 12:39:51 +0200

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
"JGarza" <JGarza@discussions.microsoft.com> wrote in message
news:0074038E-EC4E-4A09-B59B-CBB9231F9230@microsoft.com...
>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!
> --
> Jerry



Relevant Pages

  • Re: how to print pdf with python on a inkjet printer.
    ... to create pdf reports for printing. ... I am not using py--qt or wx python. ... Printing is more complicated, because you actually need something that can ...
    (comp.lang.python)
  • Re: OT: Netiquette and Programatically Emailling Attachments
    ... Stephen Lebans has a free solution to creating PDF reports. ... A2000ReportToPDF is an Access 2000 database containing a function to convert Reports ...
    (comp.databases.ms-access)
  • Open a "Generated" PDF
    ... I have an in-built tool to generate PDF Reports. ... "Viewing" the PDF doesnot hang and show the PDF file successfully. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: New Book on Pioneer
    ... Pat Flannery wrote: ... LOL. ... I'll still refer to the PDF version from time to time but I think ...
    (sci.space.history)
  • Re: Ascot - single track with two platform faces
    ... (PDF): <http://www.nationalrail.co.uk/passenger_services/ ... The document to which you refer appears to be non-existent. ... the document is very much in existence - however Google Groups' ...
    (uk.railway)