By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

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

P: 4
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?

Oct 17 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
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)>
Oct 17 '07 #2

P: 4
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

docmd.openreport strRepoName

end function

Any suggestions?
Oct 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.