Last issue.. Hopefully.. Date Stamping

[stupesek]

I have a report with that has two time stamp date fields [DateReceived] and [DateReported]. The [Date Received] is stamped at the time the record is first created. The [DateReported] I want to time stamp at the occurrence of first time printed then that date printed for any subsequent printings. In a earlier version I accomplished this by use of a button that "stamped" the [DateReported] field then opened the report for that record. I want to batch print several records and date stamp them all before printing.

Thanks

[weekend00]

What is your question?
In other word, what do you want us to help?

[stupesek]

I want at print-time, to print the date on the report, store that date in a field that will be the print date for any subsequent printings. Hope I'm more clear.

[stupesek]

Code I used befor

If IsNull([DateReported]) then
[DateReported]= Date
EndIf

I imagine the code needs to run before the report is loaded.

[Access_Blaster]

I doubt this is what you need but, I sometimes put a textbox at the bottom of a report with this in the control source =Now() and set the format to long date which looks like this: Wednesday, September 01, 2010

[stupesek]

Using the Now() function works for printing the report that day, but does not save the original print date for reprints in the future. I need to time stamp a field in a table that holds the original print date, and I would like to have it done seamlessly as the report is printed the first time.

[weekend00]

why didn't you do it just like what you did before? e.g, use a button. didn't it work in new version?

[stupesek]

The process went with the button method of printing..

-Click a button
-Print box comes up
-confirm or change the number of copies (usually 3 copies)
-decollate the copies (for 3 part carbonless)
-click print
-repeat 30 to 40 times (for each report I have to print)


If I could batch print (all 30-40 reports at once) that time stamped the
[DateReported] field, I would only have to do that process once.

[weekend00]

Maybe I misunderstood, why couldn't you put the repeat 30-40 time in a loop in you code if all reports have same number of copies(e.g. 3 )?

[stupesek]

I was considering a button that ran an update query then printed the reports over a range of ReportIDs.

[stupesek]

In fact, for the moment I am going to run an update query by hand to change the [DatReported] to Date(). Then run the report. By hand until I can simplify the process.

[weekend00]

I still didn't get what problem you had and what is the hard point.

you said you had a button which worked fine in earlier version. did you mean your button only work for one report and now you want to deal with many report? So what is different when deal with other reports? can't you just repeat the code 30~ 40 time ( in a loop maybe).?

[stupesek]

Would a loop not give me 30-40 separate print jobs? Important if I need to email a batch of reports in .pdf fromat.

[stupesek]

Can I attach a copy of a batch of reports to a post in this forum? It might be helpful to see what I am working with.

[weekend00]

So you meant your earlier version of report only for one record, and now you want all records in one report? I think you can do it by modifying the datasource, e.g. get rid of the filter to show all records.