Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    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
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    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
    Regards,

    Gary
    (It's been a while!)

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by steve_skelton13 View Post
    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.
    Regards,

    Gary
    (It's been a while!)

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks - tried it out. seems to work!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •