How intercept printing to force numbering ALL pages sequentially

[Roberto Carabajal]

Hello:
I post this questions after thinking a lot about the problem, I can`t find
an easy way. In my job Access 2003 is used to generate and print many
reports, and now it has been decided to implement an strict paper use
control. I have the requirement of numbering EVERY sheet of paper being
printed, no matter from which report it comes. It does not applied to viewed
Reports or Forms, but applied to every document hard-printed. The numbering
should be sequential and insert in the upper rigth sector, overwriting which
can be there if necessary. To make the problem more complicated, the database
is changing, and forms and reports are
continually added. So I suppose that the solution requires not working over
each report but something like a macro/api/costum-control that activates when
printing and insert the requiered data into report data package
automatically. But How can I acomplish this ?. The sequential number must be
preserved between different executions, it is always growing, so I suppose it
must be recorded in a table. Is it possible to make a Visual Basic module and
use it in an event handler triggered by a certain printing event ?.
I will really appreciate any help.
Roberto

 

[Tom van Stiphout]

On Thu, 4 Sep 2008 06:39:01 -0700, Roberto Carabajal

I think some printers can do this. Not the cheap consumer-level ones,
but if you run this problem by a Xerox rep, I think they can suggest a
solution.

What did the sponsor of this idea have to say about how to implement
this?

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Thu, 4 Sep 2008 06:39:01 -0700, Roberto Carabajal

Here is a cheap idea: use pre-printed paper.

-Tom.
Microsoft Access MVP

 

[Roberto Carabajal]

Hi Tom:

Well, it`s a good idea, but there are some intranet printers, so users can
take any one of them. In case of replacement, we should replace all, I thing
it`s not probably.