Change printer to print report

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Thanks for taking the time to read my question.

I have a report that I would like to print out in PDF format. I have PDF995
on my pc. When the report opens, a pop up form opens too with a print button
on it. My end goal is to print the report to pdf, then e-mail it all in one
click.

My problem is I don't know how to change the printer to PDF995 temporarily.

I found this but it gets stuck on DIM tmpPrinter As Printer
http://bytes.com/topic/access/answers/633214-how-print-ms-access-2000-report-pdf995-printer-vba-code

I also found this, but I don't think the downloadable example helps me.
http://www.mvps.org/access/reports/rpt0009.htm

Can anyone point me in another direction, or tell me how I can use what I've
found?

Thanks,

Brad
 
1) Google "lebans reporttopdf"
2) download and import the modules
3) place the two dll files in your app root directory
4) run this function:

ReportToPDF "reportname", , "C:\thisfile.pdf"

Done. No extra software, works on any computer, is completely contained
within access (as long as the two dlls are in it's root folder). Comes with
a myraid of utility functions such as merging, etc.

hth


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Back
Top