Bob Lucas said:
I don't know whether this will meet your needs - but I discovered the
following link, when I updated the Java installation on my laptop.
Apparently, openoffice is a freeware office suite of programs, and
includes a pdf writer.
There is a zillion free pdf creations and writer programs on the Internet,
and installing a whole humongous office suite just to get some pdf abilities
is really stupid advice here. Furthermore, since this person is already
using office, you make this case even worse since such a install will hijack
file extensions between the two applications, making this problem even more
difficult to deal with.
Furthermore, we are (in case you did not notice) in an ms-access forum, and
that office suite cannot use any of the forms, code, or even reports from
ms-access, and as a result your suggestion offers nothing in the way of a
solution....
For office and access 2007, the pdf ability is a free download from
Microsoft.
For 2003, and previous, a native and free solution that allows one to set
the output name in code, then I suggest Stephens solution here:
http://www.lebans.com/reporttopdf.htm
The above is nice because you don't even have to install a printer driver.
And, for one of the "many" free pdf creators on the web that will work with
ANY application that prints, I would suggest:
http://www.acrosoftware.com/products/cutepdf/Printer.asp
It is absolutely Free,
And free means no watermarks, no nag screens, no annoying Popup
advertisements, no time limits etc.
And, it is a small lightweight install, not a whole office suite to just get
one feature what will NOT work with ms-access anyway.