Prev: groetjes uit st vith
Next: hey
From: ORCA on 14 Apr 2010 08:09
I need to store the date and time a record was created, automatically.
From: Stefan Hoffmann on 14 Apr 2010 08:21
hi,

On 14.04.2010 14:09, ORCA wrote:
> 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 <--
From: golfinray on 14 Apr 2010 08:41
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()
--
Milton Purdy
ACCESS
State of Arkansas


"ORCA" wrote:

> I need to store the date and time a record was created, automatically.
From: Roger Carlson on 14 Apr 2010 12:33
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


"ORCA" <ORCA(a)discussions.microsoft.com> wrote in message
news:2C085184-1AEC-4623-A026-5AA86C1D140F(a)microsoft.com...
>I need to store the date and time a record was created, automatically.


 | 
Pages: 1
Prev: groetjes uit st vith
Next: hey