Change printer to print report

[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

 

[Brad]

I forgot to mention I'm using Access 2000

Thanks again,

Brad

 

[Brad]

I e-mailed PDF995 and got this answer. Original code is from their site.

http://www.freeware995.com/misc/vbacode.txt

Answer:

' Note: The application.printer object is not valid in Access 2000
' and earlier. In that case, set the printer in the report to pdf995
' and comment out the references herein to the application.printer

http://www.freeware995.com/misc/vbacode1.txt

Thank you,

Scott
Software995 Support

 

[Jack Leach]

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)