I'm developing an application in Access 2000 which utilizes Microsoft Word. I have several word documents which require merge fields from records within my application. While looping through the recordset to print these jobs I get an error saying word is currently printing, quiting word now will cancel the print. I threw a "dumby" loop inside the procedure to "stall" while word finishes the previous print job. This doesnt always work, as some documents are quite lengthy. Is ther anyway around this error? Is there a method attached to the word object I created in VBA which checks to see if Word is busy printing and to wait until it is done? Thanks.
Using a Word Object in Access 2000
- Thread starter GeoNelix
- Start date
- Local time
- Today, 14:53
- Joined
- Feb 28, 2001
- Messages
- 30,495
In Word you have an Options "object" that includes the property .PrintBackground, which is True/False.
If that is True, then you should test the propery Application.BackgroundPrintingStatus, which is the number of jobs printing in the background. If that isn't 0, your Word print formatter is busy.
I don't know how to test the print status when the Options object is false.
If that is True, then you should test the propery Application.BackgroundPrintingStatus, which is the number of jobs printing in the background. If that isn't 0, your Word print formatter is busy.
I don't know how to test the print status when the Options object is false.
