Print Access Report as PDF 1

[Celeste025]

Is it possible to create a .pdf file from an Access report? After I spent weeks creating the perfect printing reports, my boss asked me to e-mail them to the sales managers. When I export into Word, it doesn't keep the same formatting and Im spending quite a bit of time fixing the formatting so it's "perfect". It would be great if I could create .pdf files from the Access reports, but before I ask for the software, I want to make sure it will work.

Thanks!

 

[JohnLowell]

A cheaper and easier alternative would be to use The Micro$oft Snaphot format.
You can get this free from Micro$oft. After you run the Snapshot installation, Snapshot becomes a choice for the Outputto method.

This is the code I use to output to snapshot:

docmd.outputto acoutputreport, "rptReportName", "Snapshot Format", "C:\Test\OutputReport.snp"

 

[Celeste025]

I have the export to snapshot option available but I'm not sure if everyone that Id want to send the report to would be able to view it in a rarer format and some of the sales agents I deal with can barely turn a computer on, let alone figure out how to open a file that isnt in a standard format.

 

[SgtJarrow]

If you have access to the Adobe Writer...which is part of the full version of Adobe Acrobat, not with the acrobat read you download off the internet....you can check out faq703-2533. Here I have written a method for doing this within NT, 2000, and XP...it doesn't seem to work for 9x platforms. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: mstrmage@tampabay.rr.com

 

[jpapillero]

anybody tried output an access report to acrobat 6.0. i tried with acrobat 5.0 but my code won't work with acrobat 6.0.

please help ...

 

[KenReay]

Hi

There are numerous PDF drivers available some cheaper that Adobe Distiller, I have tried win2pdf from Dane Prairie, among others. Your sales reps would need only the reader softare (free from adobe)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[nickperez22]

You also may want to try edocPrinter PDF pro, it just creates a printer driver that turns any report into a PDF file plus it's cheap.

check it out at download.com or

http://www.regsoft.net

 

[rozuki]

There are freeware pdfwriter programs available....do a google search on free pdfwriters and you will find them.