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
RiRo
-
-
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)> -
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.openrepor t strRepoName
end function
Any suggestions?Comment
Comment