O
ORCA
I need to store the date and time a record was created, automatically.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefan Hoffmann
hi,
is created using the forms Before Insert event:
Private Sub Form_BeforeInsert(Cancel As Integer)
Me![CreatedAt] = Now()
End Sub
mfG
--> stefan <--
This is not possible, but you can store the date and time when a recordI need to store the date and time a record was created, automatically.
is created using the forms Before Insert event:
Private Sub Form_BeforeInsert(Cancel As Integer)
Me![CreatedAt] = Now()
End Sub
mfG
--> stefan <--
G
golfinray
Add a field to your table called Last_Updated. Add a textbox to your form.
Make the controlsource Last_Updated. Go to the afterupdate property of the
field you want to record and add:
Me.last_updated=now()
Make the controlsource Last_Updated. Go to the afterupdate property of the
field you want to record and add:
Me.last_updated=now()
R
Roger Carlson
Unless I'm missing something, all you have to do is add a datetime field to
your table, something like CreatedDate, and set the Default Value to =Now()
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
your table, something like CreatedDate, and set the Default Value to =Now()
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L