Event program to add date and time of Entry

  • Thread starter Thread starter Hulk
  • Start date Start date
H

Hulk

I have a form which controls a database, I would like to add the date
and time that the new entry was made into the database to be stored for
reference. I have put two records in the database, one is DateModified and
the other is Time Modified. How can I get the form to add the date and time
to the form so that it will not be changed when I get in to edit the form?
I would like to have it be locked once the information is entered so that I
can look and see when the record was added to the database.
Should I use a expression or a macro? I need to know how to build
either.

Thanks In Advance
Bill
 
I have a form which controls a database, I would like to add the date
and time that the new entry was made into the database to be stored for
reference. I have put two records in the database, one is DateModified and
the other is Time Modified. How can I get the form to add the date and time
to the form so that it will not be changed when I get in to edit the form?
I would like to have it be locked once the information is entered so that I
can look and see when the record was added to the database.
Should I use a expression or a macro? I need to know how to build
either.
Click to expand...

First you don't need one field for data and another for time. They are
the same thing - it just depends on how the date/time is formatted.
Besides it doesn't seem logical to have a modified date/time yet not
allow modifications.

So, what you might do is create a field for DateCreated and set its
Default Value in the table to Now(). When a new recorded is created it
will be time stamped with the date/time.

On the form don't allow edits by setting the textbox Locked property
to Yes

- Jim
 
Back
Top