Date Field with Default Value of Now()

[David]

Hi,

Have a database with a form to input data, the form contains a date entry
which has a default value of Now() which means the date and time are shown.
I need to know the time at the exact time the data is saved does anyone know
how I can do this?

Thanks

 

[Pete D.]

You need to put it on the before update to record it at the time entered.
As default value the person could go to lunch and not complete until
returning from lunch so could be hour or more later.

 

[John W. Vinson]

Hi,

Have a database with a form to input data, the form contains a date entry
which has a default value of Now() which means the date and time are shown.
I need to know the time at the exact time the data is saved does anyone know
how I can do this?

Thanks

The DefaultValue is applied the moment that the form is dirtied (by typing
into any bound control). To record the moment when the record is actually
saved to disk, use the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<put any validation code first>
Me!datefield = Now
End Sub

where datefield is the desired timestamp field. The field should probably NOT
be displayed to the user, or if it is, the Enabled property of the textbox
should be No so that the user can't backdate an entry!

 

[David]

Hi,

Thanks for the quick responses, I will give this a go

 

[liumz]

I don't know

Hi,

Thanks for the quick responses, I will give this a go