Date function on print button?

[sdavid74]

I have an input form that I also use to view data. On the form is a button that prints out a report using the current record's data. Is there any way to view the date that the report was last printed?

 

[tlbroadbent]

Does the application record the date in a table or elsewhere? I don't believe Access tracks the date a report was last printed. You should create a table and add logic in the Print button click event to insert a row in the table when the report is printed. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sdavid74]

I'm somewhat new to Access and very new to scripting, so please forgive me if I have trouble communicating....I would like Access to show the date on the input form itself...perhaps beside the print button. Is this possible?

 

[tlbroadbent]

The button test is in the Caption property. Add the following code in the button Click or the form On Load event.

cmdPrint.Caption = Format(date,"dd/mm/yy&quot Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sdavid74]

Thanks...I really appreciate the help.