Verify Print

[Richard]

hi

Is there a way to verify that a certain report has actually been sent to the
printer? I need to know how many times or if the invoice has been printed.

Many thanks in advance.

Richard

 

[Guest]

Hi Richard,

If you had some sort of Audit trail type table in your system you could add
an On Print event to the report that adds an entry into the Audit trail table
that the report was printed, perhaps recording the user, date, time etc
also...

Is this what you meant?

Damian.

 

[Arvin Meyer [MVP]]

There is no way to know for certain that anything has been printed. The
printer could be out of paper or ink, or be malfuntioning. What you can do
it generate a (possibly random) number and save it to the table, and print
it on the invoice. After the invoice is printed have someone enter the
number from the invoice back in the record. Run a query to check for a
match. If there is no match, something is amiss.

 

[Richard]

Hi damien

Thanks for your help. Shouldn't the On print event fire even when we preview
the report?

regards
richard

 

[Richard]

Hi Arvin

Many thanks for replying. So, what I should do is request the user to
manually confirm a print and save it?

regards
Richard

 

[Arvin Meyer [MVP]]

It's the only way that you can verify that you can be sure that it is
printed and everything is fine. After all, even if you could verify from the
printer, and many printers do return an error if something goes wrong. You
still cannot verify that it was actually mailed. I have a similar situation
with my POs. Even though I save a copy as a PDF, and have an email log,
there is no way I can be sure that the recipient actually got and printed
the PO. We must manually resend a small percentage every week.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Richard]

Thanks Arvin

It's the only way that you can verify that you can be sure that it is
printed and everything is fine. After all, even if you could verify from
the printer, and many printers do return an error if something goes wrong.
You still cannot verify that it was actually mailed. I have a similar
situation with my POs. Even though I save a copy as a PDF, and have an
email log, there is no way I can be sure that the recipient actually got
and printed the PO. We must manually resend a small percentage every week.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com