Time stamp

[Radhika]

Is it possible to determine when a specific entry was made in a database
based on one field?

For example, if I have the following information for patient X:
ID# (Primary key)
Date (Primary key)
Last Name
# Hours worked

Is it possible to determine when the employee (DI#) entered the # Hours
worked in the db based on the '# Hours worked' field, rather than the 'Date'
Field?

If so, how is this possible

 

[John W. Vinson]

Is it possible to determine when a specific entry was made in a database
based on one field?

For example, if I have the following information for patient X:
ID# (Primary key)
Date (Primary key)
Last Name
# Hours worked

Is it possible to determine when the employee (DI#) entered the # Hours
worked in the db based on the '# Hours worked' field, rather than the 'Date'
Field?

If so, how is this possible

Not unless you store that information yourself. Access doesn't track it for
you. You could use the AfterUpdate event of the [# Hours worked] control on
your Form. If the user is entering the data directly in a table, then there's
no way to trap the information.

Are you trying to audit the users, say to detect malicious behavior on the
part of the employees? This can be done but not very easily and a
sophisticated user could detect or bypass the attempt unless you're REALLY
skilful.