Max Wanadoo
max.wanadoo at gmail.com
Mon May 11 14:47:31 CDT 2009
Dan,
I have just pulled this bit of code out which shows how I was using it.
It is referring to a word object
If lngQueuePID > 0 Then
.ActiveDocument.SaveAs strSaveNamePath
.Options.PrintBackground = True
'.ActiveDocument.PrintOut
ActiveDocument.PrintOut Background:=False
' keep here until document is printed
Do While .BackgroundPrintingStatus > 0
StatusBar = .BackgroundPrintingStatus & " print jobs are queued up"
MsgBox .BackgroundPrintingStatus & " print jobs have been sent to
your default printer"
DoEvents
Loop
.ActiveDocument.Close
.Quit
Else
.ActiveDocument.SaveAs strSaveNamePath
'.PrintOut Background
.Visible = True
.Activate
End If
End With
You may be able to pick the bones out of this.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: 11 May 2009 20:34
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] With Events? Detect When a Printer Has Completed?
I need to be able to detect when a printer has completed a print job from
the current PC. Does anyone have a reference where I can look this up?
This sounds suspiciously like a WithEvents solution! ;-)
Thanks!
Dan
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com