VBA, PrintOut, Checking if PrintQue to printer is done

PrintOut, Checking if PrintQue to printer is done

Author	Message
Olav #1 / 4	PrintOut, Checking if PrintQue to printer is done Hi, From Access i'm printing documents and closing them. However the Network here is not so fast and while Word is still making an PrintFile for the Network, i'm already closing Word. Of Course an error is displayed (Still printing, stopping Word now meens prints are lost (ore something like that because over here it is in Dutch)), but how can i trap it so the user wouldn't see it, and i can let access wait for an wile (say 5 Seconds)? Nothing found yet, in the help files. Greetings, Olav ENgelen
Tue, 18 May 2004 23:15:09 GMT

Jonathan Wes #2 / 4	PrintOut, Checking if PrintQue to printer is done Hi Olav Set the background parameter of the Printout method to False WordApp.ActiveDocument.PrintOut Background:=False When you do this, the next line of code is not executed until the whole file has been sent to the print queue. -- Regards Jonathan West - Word MVP MultiLinker - Automated generation of hyperlinks in Word Conversion to PDF & HTML http://www.multilinker.com Word FAQs at http://www.multilinker.com/wordfaq Please post any follow-up in the newsgroup. I do not reply to Word questions by email Quote: > Hi, > From Access i'm printing documents and closing them. > However the Network here is not so fast and while Word is still making an > PrintFile for the Network, i'm already closing Word. > Of Course an error is displayed (Still printing, stopping Word now meens > prints are lost (ore something like that because over here it is in > Dutch)), but how can i trap it so the user wouldn't see it, and i can let > access wait for an wile (say 5 Seconds)? > Nothing found yet, in the help files. > Greetings, > Olav ENgelen
Wed, 19 May 2004 00:16:00 GMT

Olav #3 / 4	PrintOut, Checking if PrintQue to printer is done Thanks i'm going to try this code Olav Quote: > Hi Olav > Set the background parameter of the Printout method to False > WordApp.ActiveDocument.PrintOut Background:=False > When you do this, the next line of code is not executed until the whole file > has been sent to the print queue. > -- > Regards > Jonathan West - Word MVP > MultiLinker - Automated generation of hyperlinks in Word > Conversion to PDF & HTML > http://www.multilinker.com > Word FAQs at http://www.multilinker.com/wordfaq > Please post any follow-up in the newsgroup. I do not reply to Word questions > by email > > Hi, > > From Access i'm printing documents and closing them. > > However the Network here is not so fast and while Word is still making an > > PrintFile for the Network, i'm already closing Word. > > Of Course an error is displayed (Still printing, stopping Word now meens > > prints are lost (ore something like that because over here it is in > > Dutch)), but how can i trap it so the user wouldn't see it, and i can let > > access wait for an wile (say 5 Seconds)? > > Nothing found yet, in the help files. > > Greetings, > > Olav ENgelen
Fri, 21 May 2004 15:03:06 GMT

Olav #4 / 4	PrintOut, Checking if PrintQue to printer is done Looking better at the helpfiles now (with your help) gives me a clearer look. Probable fixed on one thing, and not clearly looking at the other options. Olav Quote: > Hi Olav > Set the background parameter of the Printout method to False > WordApp.ActiveDocument.PrintOut Background:=False > When you do this, the next line of code is not executed until the whole file > has been sent to the print queue. > -- > Regards > Jonathan West - Word MVP > MultiLinker - Automated generation of hyperlinks in Word > Conversion to PDF & HTML > http://www.multilinker.com > Word FAQs at http://www.multilinker.com/wordfaq > Please post any follow-up in the newsgroup. I do not reply to Word questions > by email > > Hi, > > From Access i'm printing documents and closing them. > > However the Network here is not so fast and while Word is still making an > > PrintFile for the Network, i'm already closing Word. > > Of Course an error is displayed (Still printing, stopping Word now meens > > prints are lost (ore something like that because over here it is in > > Dutch)), but how can i trap it so the user wouldn't see it, and i can let > > access wait for an wile (say 5 Seconds)? > > Nothing found yet, in the help files. > > Greetings, > > Olav ENgelen
Fri, 21 May 2004 16:29:03 GMT

Page 1 of 1

[ 4 post ]