<div>
Not that I know of. <br />
<br />
Remember that Windows normally spools the print jobs. This means that applications then &quot;see&quot; the printer as ready because the spooler will accept the print job even before trying to send it on to the printer.<br />
<br />
/gustav
</div>


Not that I know of.

Remember that Windows normally spools the print jobs. This means that applications then "see" the printer as ready because the spooler will accept the print job even before trying to send it on to the printer.

/gustav

<div>
Here's a link to a MSKB article which contains the code you need:<br />
<a href="http://support.microsoft.com/kb/202480" rel="ugc nofollow">http://support.microsoft.com/kb/202480</a>&nbsp;<br />
JimD.<br />

</div>


Here's a link to a MSKB article which contains the code you need:
http://support.microsoft.com/kb/202480 [http://support.microsoft.com/kb/202480] 
JimD.


<div>
<div class="content wysiwyg-content">
We had a situation where a problem occurred because for some reason there was not communication between a users and printer. &nbsp;Is there any way in code to check to see if that communication exists before sending a print job in code? &nbsp;Currently, we are prompting the user with:<br />
&nbsp; If MsgBox(&quot;The current default printer is &quot;&nbsp;&amp; Application.Printer.Device<wbr />Name &amp;&nbsp;&quot;. Do you want to proceed?&quot;, vbYesNo) = vbNo Then &nbsp; &nbsp; &nbsp;Exit Sub<br />
&nbsp; End If<br />
To allow then to change the printer but this does not let us know if the communication exists.<br />

</div>
</div>


We had a situation where a problem occurred because for some reason there was not communication between a users and printer.  Is there any way in code to check to see if that communication exists before sending a print job in code?  Currently, we are prompting the user with:
  If MsgBox("The current default printer is " & Application.Printer.DeviceName & ". Do you want to proceed?", vbYesNo) = vbNo Then      Exit Sub
  End If
To allow then to change the printer but this does not let us know if the communication exists.


Check if a printer is working before sending a print job to it

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.