time and date

[michael goodall]

is there any way to record the date and time in a record so that it
will not change? i.e. i want to record the date and time that an order
is placed. many thanks, michael

 

[fredg]

is there any way to record the date and time in a record so that it
will not change? i.e. i want to record the date and time that an order
is placed. many thanks, michael

Include the [OrderTime] field on the form.
Code the form's BeforeUpdate event:

If Me.NewRecord = True Then
Me.[OrderTime] = Now()
End If

 

[strive4peace]

Hi Michael,

Out this field in your table design:

DateCreated, Date/Time, DefaultValue --> Now()

and then do not let the users do anything but view it

I also put this in my tables:

DateModified, Date/Time

and use the form BeforeUpdate event to change it.

I put DateCreated and DateModified in the form footer and Lock them


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*