VBA help needed - printing to network printer

[codyDEVAULT]

Hi all,

I've been working on this VBA proejct for quite a while, and I've
tried everythign to my fullest extent.

I have made an access "quiz" and at the end of the quiz, it prints out
a diploma (specified earlier). I'm trying to make it so it prints to
the color printer in our office. The thing is that a lot of the
computers don't have the color printer setup on their computer (it's a
network printer).

Is there a way to have it so it prints automatically to the color
printer, regardless of if it is setup on their computer or not? I
have the IP address and the server path to the printer.

I've tried playing aroudn with PrtDevNames, PrtDevMode, and
practically every other printer method.


Please help!

Thanks,

Cody

 

[Steve Rindsberg]

Hi all,

I've been working on this VBA proejct for quite a while, and I've
tried everythign to my fullest extent.

I have made an access "quiz" and at the end of the quiz, it prints out
a diploma (specified earlier). I'm trying to make it so it prints to
the color printer in our office. The thing is that a lot of the
computers don't have the color printer setup on their computer (it's a
network printer).

Is there a way to have it so it prints automatically to the color
printer, regardless of if it is setup on their computer or not? I
have the IP address and the server path to the printer.

That'd tell you where the printer can be found but not what to send to it;
that'd be the job of the printer driver, and w/o that, you may be stuck.

You might want to haunt the Windows Scripting forums a bit; there may be a way
of installing the needed printer driver via script.

 

[Chay Harley]

You need to use the shell run command and add the printer driver via ...
well, everything you need is here:

http://support.microsoft.com/kb/189105

HTH,

Chay Harley.

 

[Steve Rindsberg]

Beauty. Thanks, Chay

You need to use the shell run command and add the printer driver via ...
well, everything you need is here:

http://support.microsoft.com/kb/189105

HTH,

Chay Harley.