How to automatically enter print time into a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Musensohn - 04 Oct 2004 17:21 GMT

I need to have the date and time that a report is PRINTED automatically
entered into a field. I know I can display the time printed but I'm using
this information to compare in and out times. I'm entering data through a
form and that is set to show when the form is opened but the print time can
vary.

Thanks.

Reply to this Message

Allen Browne - 04 Oct 2004 17:33 GMT

The best way to do this is to create a table where you record the primary
key values of the records that were printed, along with the batch number of
the print job. This gives you a full history of what was printed when. If
something goes wrong with the print (e.g. paper jam), the user can very
easily reprint the batch.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I need to have the date and time that a report is PRINTED automatically
> entered into a field. I know I can display the time printed but I'm using
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message