Printing and date

[Chi]

Hi,

I have the Letter report that will send to 50 patients.

My question is when I print them off, is there a way to add the printing
date on the to the database?

Thanks
Chi

 

[Stockwell43]

Hi Chi,

You have a report you created in Access and when you print it from Access
you want the current date printed on the document? If so, did you create this
report with the Wizard? If so, access automatically puts that information on
the report. Or am I off in another direction?

 

[Chi]

Thank you for the quick response!
When I print it from Access, I would like the current date added in the
table (or somewhere in the database) since I have the column for the printing
date.

I understand that I need to enter printing date for each record to the
table, but I would like it automatically inserted to the table when I print
the report off.

Thanks
Chi

 

[Stockwell43]

I'm sorry, I have never done that before. I am sure there is a way but you
will need one of the more experience folks to help with that. Sorry I
couldn't be of more help.

 

[Chi]

Thank you so much !! Stockwell43. Talk to you later

 

[Larry Linson]

Thank you for the quick response!
When I print it from Access, I would like the current date added in the
table (or somewhere in the database) since I have the column for the printing

I understand that I need to enter printing date for each record to the
table, but I would like it automatically inserted to the table when I print
the report off.

In the Report, you can use VBA Code in the Print event to keep a record.
You should, however, search the archives of this newsgroup -- you may want
to be very careful, because sometimes your Report can be destroyed by the
printer without sending back any error indication. At least, allow yourself
an option to over-ride the "has been printed" indication and re-print.

Larry Linson
Microsoft Office Access MVP