Date Time stamp command button

Question

Hi, 

I'm working to create a project time table that documents the number of hours I spend on a particular task - for all intensive purposes, a time clock.  I've created 2 command buttons, one for starttime and the other, stoptime. For the life of me I'm unable to figure out how to connect the command buttons to the text fields. The date picker has been updated in the table to "never" & default is Now().  Any help would be much appreciated. 

Thanks, Ann

Answer 1

Since it looks like your buttons are in the header or on the main form, I would just use the double-click event of the StartTime or StopTime to set the value to either Time() or Now() depending on if you want the time to include the date portion. The code would be something like:

Private Sub StartTime_DblClick(Cancel As Integer)

Me.StartTime = Time()

End Sub

Replace the command buttons with a label with the caption "Double-Click to enter current time".

Answer 2

That got it, thank you so much for the quick reply. Since it's a double click I did not add labels.

Many thanks again! Ann