time-stamp on print?

Topic

New Reply

I have a request to add a time stamp to a couple of reports where the time stamp is the print event. is there a way to do this? i have a time stamp =Now() that is the report open event.

TIA

Reply | Quote

Replies

Here is an option that may work for you. Go to the record source for the report and add a column for the time stamp so it becomes available as a selection in the report. I.e., add a column called TStamp and set it equal to =Now(). All of the data fields in the report would have the same result so it will not effect any groupings. Then just add it as a data field in the main body or header of the report. This will give you the tstamp when the report was generated which may suffice. HTH

Reply | Quote

Put this in the on open event of the report. I am going to assume that you added a Label called TextTS to the report (i.e,. put it in the header) that you want to add to the report as the timestamp.

Me.Controls(“TextTS”).Caption = Now()

HTH

Reply | Quote

Well, what i have is an unbound Textbox on the report with the control source set to =”Printed on: ” & Now(), which reflect the time the report was opened. what i was looking for is some event called ‘OnPrint’. if it doesn’t exist, fair enough, just will have to advise the time stamp is the time the report is opened, not printed.

Reply | Quote

Well, what i have is an unbound Textbox on the report with the control source set to =”Printed on: ” & Now(), which reflect the time the report was opened. what i was looking for is some event called ‘OnPrint’. if it doesn’t exist, fair enough, just will have to advise the time stamp is the time the report is opened, not printed.

Sorry, I needed to read your post closer. You will find the On Print event in the Header portion of the report. (Right Click on Report Header and select Properties) This should get you to where you need to be.

Reply | Quote

thanks – tried it out. seems to work!

Reply | Quote