Data Entry Log

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am developing an Access database that will be used for data entry
purposes. The problem that I have is that I want multiple users to be able
to preform data entry simultaneously, and I want the database to keep a log
of who entered which record and on what date and time they entered it. Can
anybody point me in the right direction for accomplishing this?

Thank you
Craig
 
Craig:

First, I will assume you are having your users log in to the db application,
with that you can capture the who, and with either Date() or Time(), can
capture the rest.

I will also assume there is something that identifies the person has
completed entry of a record. Either a specific field triggers the Next
Record, or a button.

Simply add, to whatever triggers the Next Record, code to store the UserID
and Date/Time, to the data record.

HTH

Sharkbyte
 
Back
Top