PDA

View Full Version : Form Modifies Report and Print to PDF



FrymanSMU
05-29-2009, 10:34 AM
Ok so I'm starting to play around more with reports in access. I have added code that opens a comments form after the report closes, is there a way I can pass these comments back to the report and print to PDF?

I have been googling for awhile but have not found anything on report syntax. If anyone has a good reference for that I would appreciate it.

Thanks,
Rich

FrymanSMU
05-29-2009, 12:56 PM
Ok I was able to pass the variables through OpenArgs but I still am not sure how to automate the PDF part of the report. I need to save the report for audit purpose, anyone have an idea here?

OBP
05-30-2009, 05:50 AM
Fryman, I think only Access 2007 has direct pdf output. You may be able to use "Print to PDF" using a PDF printer, I think there was a KB article on it.
The other option for Audit purposes is to use the Access Snapshot format.
It is Non-Editable and viewed using the Access Snapshot Viewer.

mdmackillop
06-07-2009, 03:31 AM
I've used this with PDF995 (http://www.freeware995.com/misc/vbacode.txt)