Working With Printers

[gnosbush]

I am working on a database that resides on a shared network drive.
About ten individuals, all on different computers, will use this
database. One of the reports needs to be printed in a PDF. It is not
feasible to have the user print the report as the report will create
200 separate PDF files. By using previous posts, I have figured out
that I can install Adobe's PostScript Printer Driver, print to that,
and then run Ghost Script afterwards on the created PostScript file to
create the PDF. In order for each user to do this, I need to have the
PostScript printer driver installed on all computers accessing the
database. I can have each individual run the setup to install the
drivers, but can someone tell me if I can program the following
through VBA to get the driver setup correctly without having the user
do it? When the driver installs, it creates a local printer called
"Generic PostScript Printer".

1. Can I change the port in VBA for "Generic PostScript Printer" to a
filename as is required for Ghost Script? I would prefer to do this
automatically rather than try to explain to each user how to do it.

2. Each time the report is printed, how can I check the port for the
"Generic PostScript Printer" and verify that it is correct? I tried
using application.printers and getting the port but this returns
DOT4_001 when it really should be returning C:\Report.ps (I manually
programmed this port through control panel, printers).

Thank you in advance for your help!
Grant

 

[Albert D. Kallal]

Actually, don't bother with Adobe distiller.

don't bother installing a postscript printer driver.

Don't bother installing ghostscript.

in fact act, don't install anything!

And, further more don't bother with having to change printer.

The above list of long bothers is solved by using the fantastic and
wonderful pdf add-in from
the Wizard of ms-access Stephan Lebans.

You can find his add-in here:

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

The above is free, and does not requite you to configure or setup special
printers, or add adobe or ghostscript.

really, the above makes this so easy, and further is it designed for you to
supply the out put file name...

 

[gnosbush]

Actually, don't bother with Adobe distiller.

don't bother installing a postscript printer driver.

Don't bother installing ghostscript.

in fact act, don't install anything!

And, further more don't bother with having to change printer.

The above list of long bothers is solved by using the fantastic and
wonderful pdf add-in from
the Wizard of ms-access Stephan Lebans.

You can find his add-in here:

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

The above is free, and does not requite you to configure or setup special
printers, or add adobe or ghostscript.

really, the above makes this so easy, and further is it designed for you to
supply the out put file name...

Albert,

That is exactly what I needed and I can't believe I didn't come across
it when I was searching for answers today. This works great! Thank
you very much.

Grant