Timestamp in Microsoft Access

[Guest]

I need to know how to set up a timestamp by using a command button.

 

[Jeff Boyce]

"Timestamp" ... in what sense?

Where, and for what purpose? If you want to have the date/time a new record
is created, you don't even need a command button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I want to be able to have an employee click on the command button and have
that time saved on a report.

 

[John W. Vinson]

I want to be able to have an employee click on the command button and have
that time saved on a report.

You can't "save on a report" - a report is just a tool to display data in a
Table.

You can set the value of a field in a table to Now() in the Click event of a
button. Assuming that the button is on a form bound to the table, and that the
proper record (that employee's record...???) is selected, use code like

Private Sub cmdTimestamp_Click()
Me!timestampcontrol = Now
End Sub

using the actual name of the form control bound to the timestamp field in your
table.

John W. Vinson [MVP]

 

[Jeff Boyce]

Me!txtYourTimeStampControl = Now()

(add this as code behind the command button to put the timestamp value in
the control on the form)

Regards

Jeff Boyce
Microsoft Office/Access MVP