Access 2003: keep a log on reports sent to the printer

[RiRo]

I'm working in Access 2003. I would like to find out if there is a way to log a print job from access. In order words, I want to keep a log with the date and time when a report is send to a printer Is this possible?

RiRo

[missinglinq]

How are you printing the reports? I don't know of a way to trap the event if you're previewing a report, then clicking on Print, although someone else here might, but if you're printing from VBA code, such as clicking a command button, you could have a "log" table, with fields PrintDate and ReportName, and run an Append Query against the table each time you print a report.

Welcome to TheScripts!

Linq ;0)>

[RiRo]

Right now I'm using the Preview for the report and then I'm calling a function from the Print tool that will add the information that I want to the log Here is what I have:

Function PrinterLog()
logIt = boolean (flags if the report needs to be log)
type =integer (1: Report1, 2: Report2)
strRepoName = string (global var for each report's name)
(I have 20+ reports and i only want to keep truck of 2 of them)

if LogIt = true and type > 0 then
logtable <-- Type, Date & Time
endif

docmd.openreport strRepoName

end function

Any suggestions?