Wondershare PDFelement is a simple PDF editor and creator for desktops and mobile phones. Set Application.Printer = Application.Pricing: 79.99/year and free for Reading PDF 'Reset the (original) default printer and release PDF Creator 'Wait until PDF creator is finished then release the objects 'Wait until the print job has entered the print queue MsgBox 'Can't initialize PDFCreator.', vbCritical + _ cStart('/NoProcessingAtStartup') = False Then Set pdfjob = New PDFCreator.clsPDFCreator Set Application.Printer = Application.Printers(lPrinterPDF) Set Application.Printer = Application.Printers(lPrinters) 'Resolve index number of printers to allow changing and preserving

'/// Change the report and output file name here! /// ' Designed for early bind, set reference to PDFCreator 'Author : Ken Puls ('Macro Purpose: Print to PDF file using PDFCreator

You may also want to update the directory to save the file into (sPDFPath), as it will currently save the file into the database's directory. You will need to set a reference to PDFCreator, and change the name of the report. NOTE: Before you 'go it alone' with trying to adapt this routine, you may want to read this article, which shares some of the idiosyncrasies discovered in the development of the PDFCreator code samples. This routine was tested successfully using PDFCreator 0.9.1, GPLGhostscript.exe download package, on Windows XP Pro (SP2), using Microsoft Access 2003.

If you are not familiar with the difference between Early and Late Binding, please read our article on Early vs Late binding.

It should also be noted that this code example uses an Early Bind. Please note that this code will NOT work with Adobe Acrobat. Unlike Adobe Acrobat and CutePDF, which both require pro versions to create PDF's via code, PDFCreator is completely free! Download PDF Creator from Sourceforge here. This code examples is built for PDFCreator, an open source PDF writer utility. This article contains code examples to print a Microsoft Access report to a PDF file.

Pdfcreator download for xp free