Some Expert Coding Required with Reports and print logs

[bdmclennan]

One of my clients has requested a print log be created for a Legal document database. She wants to know when a document has been print previewed (easy) and if that document or any part of it is sent to print (my problem).

There are several hundred print servers available globally and thousand of printers that this document can go to therefore the code has too be fired from the Access side.

I assumed that the on print event would allow me to capture the print job but it fires when previewing.

Any ideas or suggestions would be greatly appreciated.

Cheers

B.

 

[lameid]

You need to associate a custom toolbar with the report whose print button has code to log the printing of the report. The details of writing code for a button eluding me at the moment (I've done it before but not rececntly) but that is the approach I'd take.