auto add a datetime stamp record

  • Thread starter Thread starter ave
  • Start date Start date
A

ave

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
 
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
 
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,

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

Nikos
 
Back
Top