printing reports to PDF

[Mark Kubicki]

we have a (not very sophisticated) ACCESS project which produces several
reports.
A few of the users seem to be having a problem printing the reports to PDF
(which is being done thru the menu bar / file / print... (not thru a
command button). )
(The problem seems to be both intermittant and consistent -depends who you
ask...)

The error message is the generic " ...has encountered an error, and needs to
close...")
I suspect that this is an Adobe settings issue, but maybe not...

We are running ACCESS 2003 SP@ under Windows XP

ANY suggestions what-so-ever would be welcome
thanks in advance,
-mark

 

[John Ellis]

Try this utility and making a command button with the On Click event with
something like this. it is just two dll files to keep either in the windows
system folder or the folder with the database. It works great for me hope
this helps

ConvertReportToPDF "NameOfReport", , , True, True

 

[Mark Kubicki]

what are the dll's, are they part of the windows suite, or do the need to be
added?

 

[John Ellis]

here is the link to the site with the utility.

http://www.lebans.com/reporttopdf.htm