auto add a datetime stamp record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ave - 24 Sep 2004 19:13 GMT

Is there a way to setup a field so that it automatically time stamps a field

I create a field with datetime type and set the default to NOW().

If I create a new record directly in the db this field get filled out.
However if the record is created through a FORM (actually 3rd party software
that uses access as a backend) it doesnt get filled out.

Any idea why?

thx in advance

Reply to this Message

Nikos Yannacopoulos - 28 Sep 2004 13:03 GMT

Ave,

You should put the Now() function in the default value property of the
control on your form which is bound to the timestamp field.

HTH,
Nikos

> Is there a way to setup a field so that it automatically time stamps a field
>
[quoted text clipped - 7 lines]
>
> thx in advance

Reply to this Message

ave - 29 Sep 2004 19:33 GMT

Yes, unfortunately the form is 3rd party and i dont have access to it. It
not done in Access either.

It only has access backend.

I can add fields to the access tables, but have no control over the
interface.

> Ave,
>
[quoted text clipped - 17 lines]
> >
> > thx in advance

Reply to this Message

Nikos Yannacopoulos - 30 Sep 2004 09:57 GMT

Ave,

AFAIK the answer is you can't do it under the circumstances; it has to be
done in the FE.

Nikos

> Yes, unfortunately the form is 3rd party and i dont have access to it. It
> not done in Access either.
[quoted text clipped - 25 lines]
> > >
> > > thx in advance

Reply to this Message