David Fenton
dfe at nudgeeinternational.com
Wed Oct 8 00:00:22 CDT 2003
Thanks Marty, I think the code at that URL may come close to helping solve the problem. I haven't had a chance to put it to use and test it yet. The idea of looking for a document in the print queue sounds like the solution. If I can send the report name to a Boolean function which simply tells me if it's in the queue or not, I'd know if the document was printed or simply previewed. My only hope is that it is in the printer queue long enough to be picked up by the code. I may end up with a hybrid, since some of these posted solutions are quite clever. Thank you for your help. Cheers for now David Ô¿Ô¬ Brisbane Australia Your message: Message: 21 Date: Mon, 06 Oct 2003 20:56:05 -0700 From: MartyConnelly <martyconnelly at shaw.ca> Subject: Re:When is a report actually printed (vs previewed only) To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Message-ID: <3F823955.4090406 at shaw.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Here is some vb 6 code to monitor the print queue with some caveats. Microsoft print reports like word documents, may not give you correct no of pages. It only monitors the print drivers unless the print driver for that specific printer continuously polls the machine. You wont get info about paper jams or low toner. Very few low end and medium printers do. http://www.merrioncomputing.com/Programming/index.htm