time and date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michael goodall - 20 Mar 2007 19:42 GMT

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

Reply to this Message

fredg - 20 Mar 2007 20:05 GMT

> 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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

strive4peace - 20 Mar 2007 20:07 GMT

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
*

> 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

Reply to this Message