Re: VBA and API

Karl E. Peterson wrote:

DS wrote:

Not sure if this is the right place, let me know if its not.  I
recently downloaded code from Jonathan West that kicks back the staus
of your printer before you print.  The problem is it returns the
status of whats in the Print Que, "this works fine",  not whats
connected to the computer either locally or accross the network.  I
need to find if the printer is able to print a report and if it's
not, because it lacks paper or is offline, then send it to another
printer.  Is there a way to do this?  I'm using Access 2002.


I believe the only place Windows exposes this information is through the print queue.
OH Boy, how can I do this? I've seen other applications send up an Error Box whenver a printer is offline, how is this done? Without even sending a print job. Also is there a way to monitor the print spooler, and send a message from there?
Thanks
DS
.

Relevant Pages

  • Re: VBA and API
    ... recently downloaded code from Jonathan West that kicks back the staus of your printer before you print. ... The problem is it returns the status of whats in the Print Que, "this works fine", not whats connected to the computer either locally or accross the network. ... I need to find if the printer is able to print a report and if it's not, because it lacks paper or is offline, then send it to another printer. ... the print queue. ...
    (microsoft.public.office.developer.vba)
  • Re: VBA and API
    ... The problem is it returns the status of whats in the Print Que, "this works fine", not whats connected to the computer either locally or accross the network. ... I need to find if the printer is able to print a report and if it's not, because it lacks paper or is offline, then send it to another printer. ... through the print queue. ... That sample fairly well replicates what Windows shows. ...
    (microsoft.public.office.developer.vba)
  • Re: VBA and API
    ... The problem is it returns the status of whats in the Print Que, "this works fine", not whats connected to the computer either locally or accross the network. ... I need to find if the printer is able to print a report and if it's not, because it lacks paper or is offline, then send it to another printer. ... through the print queue. ... That sample fairly well replicates what Windows shows. ...
    (microsoft.public.office.developer.vba)
  • Re: VBA and API
    ... > recently downloaded code from Jonathan West that kicks back the staus ... > status of whats in the Print Que, "this works fine", not whats ...
    (microsoft.public.office.developer.vba)
  • Re: Patriots | Brady the king of comebacks
    ... If Adam V misses the kicks at the end of the ... Again, whats your point? ... well informed football fans here. ...
    (alt.sports.football.pro.ne-patriots)
Loading