I need to store the date a record was created, automatically.

[ORCA]

I need to store the date and time a record was created, automatically.

 

[Stefan Hoffmann]

hi,

I need to store the date and time a record was created, automatically.

This is not possible, but you can store the date and time when a record
is created using the forms Before Insert event:

Private Sub Form_BeforeInsert(Cancel As Integer)

Me![CreatedAt] = Now()

End Sub


mfG
--> stefan <--

 

[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()

 

[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