asked on

Create pdf using DoCmd.OutputTo acOutputReport - acFormatPDF but with ability to pass filter to report

I am creating a PDF from access 2007 using DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, strPath, , , , acExportQualityPrint

I am using microsofts office 2007 pdf generator and works fine.

However I have a report set up to print an order and would like to pass the order number to the report in code so prints the order selected.

I can preview the report with docmd.OpenReport and pass a filter or openarg to the report and control from there but not sure how to do this when creating a pdf.

ASKER CERTIFIED SOLUTION

puppydogbuddy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

puppydogbuddy,

"I have heard that MS Access 2007 natively supports pdf."
Yeah, I heard that too. (then I heard that MS and Adobe could not reach an agreement on "something")

When I installed 2007 at work (sp1), you had to download the PDF creation tool "add-in".
http://www.microsoft.com/downloads/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

So it might not be what you would call "native support".
(But who knows, it may very well be included in a future Service Pack)

;-)

Jeff

puppydogbuddy

Hi Jeff,
I consider the add-in natively supported because it comes with Access 2007, it is a microsoft product, and it works seamlessly with existing Access functions.

pDog

SOLUTION

Eric Sherman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

puppydogbuddy,

"I consider the add-in natively supported because..."

Good point!
;-)

Jeff

donhannam

ASKER

Thanks guys. Passing the global variable to the filter is what I was looking for - I use the add in pdf program.