Re: Print Access Report as PDF with Acrobat 6

From: SA (~fake.address_at_nspm.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 06:06:01 -0400

Tony:

You are correct that PDFWriter is not in Acrobat 6 and that there are no
registry entries to control the Adobe PDF printer. You can do a couple of
things:

1.) Reinstall just the PDFWriter printer from Acrobat 5, it does co-exist
well with Acrobat 6 (don't install any of the other parts of Acro 5)
2.) Check out our PDF and Mail Library that does support Acrobat 6
3.) Look at a few alternate print drivers such as PDF-XChange, Win2PDF etc.
that are more light weight PDF creators and operate more like PDFWriter. 

-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Tony_VBACoder" <anonymous@discussions.microsoft.com> wrote in message 
news:c94201c48a06$661dc380$a601280a@phx.gbl...
> Since upgrading from Acrobat 5 to Acrobat 6, my code that
> I used to use to print an Access 2000 Report as a PDF
> using the "PDFWriter" printer, which now with Version 6 of
> Acrobat does not exist, no longer works.  With Acrobat
> Version 5, my sample code is (minus any functions that
> browse for folders and read/write to the Windows Registry):
>
> 1) Ask the user where they would like to store the reports:
> sFolderName = BrowseFolder("Select a Folder to Export the
> PDF Report to:", sCurrentDBPath)
>
> 2) Build the PDF File Path:
> sFileAttachment = sFolderName & "\" & sPDFFileName & ".pdf"
>
> 3) Read the current default printer and save the value -
> we will need this later when we reset the Default Printer
> sMyDefPrinter = dhReadRegistry
> (HKEY_CURRENT_USER, "Software\Microsoft\Windows
> NT\CurrentVersion\Windows", "Device")
>
> 4) Change the default printer to the PDF Writer:
> dhWriteRegistry
> (HKEY_CURRENT_USER, "Software\Microsoft\Windows
> NT\CurrentVersion\Windows", "Device", "Acrobat PDFWriter")
>
> 5) Set the value for PDFFileName in the registry Prints
> the Report without the dialog box from appearing:
> dhWriteRegistry(HKEY_CURRENT_USER, "Software\Adobe\Acrobat
> PDFWriter", "PDFFileName", sFileAttachment)
>
> 6) Open the Report so it will print it:
> DoCmd.OpenReport sReportName, acViewNormal
>
> 7) Change the Printer from PDF Writer back to the default
> printer:
> dhWriteRegistry
> HKEY_CURRENT_USER, "Software\Microsoft\Windows
> NT\CurrentVersion\Windows", "Device", sMyDefPrinter
>
>
> Now, with Acrobat Version 6, the "PDFWriter" printer has
> gone away, along with the Windows Registry entries, and
> now it appears that I must first print my Access Report as
> a PostScript format (*.ps) and then use the Distiller
> printer to convert (print) it to a PDF.
>
> If anyone has any sample code that shows me how to do
> this, it would be much appreciated as I am in a time
> crunch to convert what used to work under 5.0 to 6.0.
>
> Thanks.

Relevant Pages

  • Re: Printing to the Acrobat PDFWriter
    ... PDFWriter came with Acrobat 5.0. ... I use it all the time to create PDF files ... I also had Distiller that came with Acrobat 5. ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: Access Rpt to PDF
    ... If you have PDFWriter, which ships with Acrobat 5 or older, you could use ... If you have Acrobat 6, you could still use the same code but use some third ... party software to create the PDF, such as Win2PDF from Dane Prairie, which I ... > Need help to programmically send Access generated report to a PDF File. ...
    (microsoft.public.vb.general.discussion)
  • Print Access Report as PDF with Acrobat 6
    ... Since upgrading from Acrobat 5 to Acrobat 6, ... I used to use to print an Access 2000 Report as a PDF ... NT\CurrentVersion\Windows", "Device", "Acrobat PDFWriter") ...
    (microsoft.public.access.reports)
  • Re: creating a pdf from access report
    ... > Does not Acrobat 7 install a printer driver that you would print to when you ... It's called Adobe PDF. ... In Acrobat 5, you've got the Acrobat Distiller printer and optionally PDFWriter as well. ...
    (microsoft.public.office.developer.vba)
  • RE: Converting Word Hyperlinks into Acrobat
    ... came to the result that Acrobat has a problem. ... PDF, error messages popped up telling that bookmarks were missing). ... If you replace your hyperlinks by ordinary cross-references (as created via ... About the Adobe Acrobat settings in Word: ...
    (microsoft.public.word.docmanagement)