convert access report to pdf

[shimul]

Can you please give a code for coverting access report to pdf at <Email Deleted per Site Policy> (acrobat standard)?

I am using access 2000.

Thank you.

[missinglinq]

Stephen Lebans has a hack to do just that:

ReportToPDF

Welcome to Bytes!

Linq ;0)>

[NeoPa]

Nice one Linq. I've got that bookmarked now ;)

PS. This has now been moved to the Answers forum from Insights where it was posted.

[shimul]

Thanks for reply.

I am looking code for acrobat distiller 8.

If you have working code, please reply me.

thanks.

[NeoPa]

I think you may have misunderstood what this site is about. We answer technical questions where we can. We don't look simply to provide ready-made answers or code as a general rule.

Good luck with your search.

[Stewart Ross]

Hi Shimul. Your quest for 'just give me the code' is an odd one in the circumstances, and as NeoPa says you are misunderstanding what this site is about. Linq's reply points you to Stephen Lebans solution - and an excellent one it is too. To explain...

PDF is a proprietary format devised by Adobe. The Adobe readers may be free, but the writers are not - as you will find if you look up the cost of Acrobat Distiller. There are free PDF drivers which act like software-based printers - but in general these are not programmable from within Access. If what you need is a programmable solution, one which can be married to VBA functions to allow you to automate output of reports to PDF, then the Lebans example database is the best solution for doing so. Stephen Lebans has provided a code solution which does not require any proprietary files or DLLs to do its job - instead he has devised code routines which output to snapshot format as an intermediate and then to PDF from the .SNP files. It is a clever approach to a task which is far from simple - as you will find if you take the time to investigate what is in it.

There is no way that we can just 'give you the code' - anyway a meaningless phrase given the years of development which have gone into the Lebans solution.

Perhaps next time you seek assistance you can could do a Google search beforehand which could help you understand the scope of what you are trying to achieve?

-Stewart

[MMcCarthy]

The fact that you specify Acrobat Distiller 8 made me curious. If you have a copy of this software it should include a printer driver for Acrobat Distiller which you would add to your list of printers. Then all you would have to do is select that as your printer for your report.

[shimul]

Thank you for reply.

Actually I was looking for Pseudocode or idea.

Sorry to make you confused.

Thank you.

[tdw]

@msquared
I am also looking to accomplish this. I will check out the link below, but wanted to respond to this comment.

I have thought the same thing (using the pdf printer), but then I don't know how to programatically name the pdf and save it in the correct location. Currently I save the report in .rtf format, but it loses the look of the layout of the report that way. The .rtf file does programatically name itself and save in the correct folder, but it looks to me like to do that with a pdf, I'd have to throw out the old code and do it completely differently.

[htll]

You can create an HTML report and convert it to PDF.
** Link removed **