Need a simple Button to Timestamp

Hello, I am trying to get a button to drive a date/timestamp (mm/dd/yyyy 00:00:00) of a field in Access 2010. I can't seem to figure it out, and however it seems like something I should be able to find by googling or watching YouTubes on Access..... I have had zero luck finding it. (probably because its so simple :)

Thanx in advance!

sc

Gocsteve1

Asked: 2012-12-30

Advertise Here

1 Solution

LVL 22

Tapan PattanaikSenior EngineerCommented: 2012-12-30

Hi Gocsteve1

Please check this link.

Format the date and time field in Access:

http://office.microsoft.com/en-us/access-help/format-the-date-and-time-field-in-access-HA010341474.aspx

LVL 75

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented: 2012-12-30

What do you mean by 'a button to drive a date/timestamp' ?

IF ... you are trying to get when a record was created or last modified - then do this (this is just a wild guess as to what you want):

Private Sub Form_BeforeUpdate (Cancel As Integer)

If Me.NewRecord = True then
Me![DateCreated] = Now() ' assuming field is called DateCreated
Else
Me![DateLastModified] = Now() ' assuming field is called DateLastModified
End If

End Sub

LVL 28

burrcmCommented: 2012-12-30

If you want a button on your form to fill a field with the date when clicked, in design view, place a button on your form then click cancel to get rid of the wizard. Right click the button, select properties (if not already open), look down the list for "On Click". In On Click, click the arrow, select Event Procedure, and click the ellipsis(...). This will open a code area. Type [yourfieldname] = Date where yourfieldname is the field you want to fill in. Save and try it.

Chris B

Gocsteve1Author Commented: 2012-12-30

This is a simple schedule database.... I'm adding a start and stop button to track the work associated with the task shown (the other fields)

There is no other data being manipulated, so I need these two buttons to stamp 2 fields. First now() is the start of the task, the second at the completion of the task. Make sense?

There are 17 tasks this admin is performing, and I'm trying to understand how long they take.

SC

Gocsteve1Author Commented: 2012-12-30

Just to add more clarity....

I only want a start and stop button on my form that link to the start and stop time fields....pressing the start date time stamps to the start time field..... Pressing the stop button date time stamps to the stop time field.

LVL 75

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented: 2012-12-30

Private Sub btnStart_Click()
Me![YourStartTimeFieldName] = Now()
End Sub

Private Sub btnStop_Click()
Me![YourStopTimeFieldName] = Now()
End Sub

This will put the values in a field in your table. If you are just talking about a text box on a Form (and maybe also storing in a field):

Private Sub btnStart_Click()
Me("YourStartTimeFieldName") = Format(Now(), "mm/dd/yyyy 00:00:00")
End Sub

Private Sub btnStop_Click()
Me("YourStopTimeFieldName") = Format(Now(), "mm/dd/yyyy 00:00:00")
End Sub

Gocsteve1Author Commented: 2012-12-30

Perfect! Simple steps if you know where to look :)

Thanx.

sc

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

Need a simple Button to Timestamp

Join & Write a Comment Already a member? Login.

Featured Post