This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:
- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples
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
Thanx in advance!
sc
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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
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
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
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
Chris B
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
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
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.
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.
Private Sub btnStart_Click()
Me![YourStartTimeFieldName
End Sub
Private Sub btnStop_Click()
Me![YourStopTimeFieldName]
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
End Sub
Private Sub btnStop_Click()
Me("YourStopTimeFieldName"
End Sub
Me![YourStartTimeFieldName
End Sub
Private Sub btnStop_Click()
Me![YourStopTimeFieldName]
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
End Sub
Private Sub btnStop_Click()
Me("YourStopTimeFieldName"
End Sub
Premium Content
You need an Expert Office subscription to comment.Start Free Trial