Default to time???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 31 Mar 2006 13:55 GMT

Hi,,

I have a table with a default value =time$.

Problem is when I enter a new record the time value of the NEXT record
defaults to the time when that previous record is entered. Thus if there is
an entry some minutes or so later the value for that entry is wrong!!

Any thought on what I am doing wrong please??

Ta.
Bill

Reply to this Message

Lynn Trapp - 31 Mar 2006 14:02 GMT

Try changing your default value to Now() and, then, just display the time
portion of the field.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

> Hi,,
>
[quoted text clipped - 8 lines]
> Ta.
> Bill

Reply to this Message

Rick Brandt - 31 Mar 2006 14:06 GMT

> Hi,,
>
[quoted text clipped - 8 lines]
> Ta.
> Bill

That's how defaults work. They are populated the instant the "New" row is
painted on the screen.

Use a form (never use a table as an interface) and populate the field in the
BeforeUpdate event instead of using a default.

If Me.NewRecord Then Me!FieldName = Now()

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Bill - 31 Mar 2006 14:33 GMT

Thanks.

FYI, I am using a form but the default is in the table. I understand what
you have suggested though and will do.

Thanks again.
Bill

> That's how defaults work. They are populated the instant the "New" row is
> painted on the screen.
[quoted text clipped - 3 lines]
>
> If Me.NewRecord Then Me!FieldName = Now()

Reply to this Message