convert access report to pdf file?

[sangleweb]

I there a way that I can convert Access report to PDF file? I am currently using Access 2003 with Adobe Acrobat 6 and like to save the report programatically (VBA) to pdf file. Thanks.

 

[steve-oc]

Hi

This is what I do...

If you set the default printer to in the report properties:

File/ Page Set Up/ Page tab - 'Use Specific Printer' = Acrobat Distiller

then choose properties for the printer and then the Adobe PDF Properties tab then untick 'Prompt for file name' and also 'View in Acrobat'. I think I have seen examples here of how to do this programactically and the reset the default printer back to what every it was.

This means when you docmd.openreport (acNormal) the report will be saved as a pdf in the default file location (Desktop say). Once the file is saved then I use the File System Object to rename the report move it to the correct file location.

So the process is: 1. send the report to the default printer, 2. .pdf file is saved on desktop, 4. check the file saving is finished, 5. use fso to rename and move report.

Hope that helps
Steve

 

[meenctg]

No coding, really simple way follow these http://learn24bd.com/convert-access-report-to-pdf-without-programming/

 

[pr2-eugin]

No coding, really simple way follow these http://learn24bd.com/convert-access-report-to-pdf-without-programming/

Any reason you revived a SOLVED 6 year old thread?

 

[Frothingslosh]

Better late than never?

Although to be fair, if this thread popped up near the top of a search (somehow), maybe him 'solving' it will help someone else down the line?