Show User ID Automatically

[mhisma]

Hi All,
I have developed a simple MS Access application (many thanks for the assistance from this forum) and the application will be used by another member of my team work.
PC's of Team members are connected each other by server. We have shared folder to storing or exchanging files, everyone can access it and I put the application in a subfolder of the shared folder. I put a shortcut there, so by simply clicking the shortcut, user can directly open the form to input data.
To keep the reliability of the data inputted, user who input the data and the time data inputted have to be recorded. What should I do so the ID and the time data inputted can be captured and automatically showed on some textbox in the form ?
Many appreciate for the help, i need it a lot

 

[boblarson]

Hi All,
I have developed a simple MS Access application (many thanks for the assistance from this forum) and the application will be used by another member of my team work.
PC's of Team members are connected each other by server. We have shared folder to storing or exchanging files, everyone can access it and I put the application in a subfolder of the shared folder. I put a shortcut there, so by simply clicking the shortcut, user can directly open the form to input data.
To keep the reliability of the data inputted, user who input the data and the time data inputted have to be recorded. What should I do so the ID and the time data inputted can be captured and automatically showed on some textbox in the form ?
Many appreciate for the help, i need it a lot

In each table I put these 4 fields (unless I need full audit capabilities and then it gets a little more complex):

OriginalUserID (the original user who created the record)
DateTimeStamp (the date and time the data was created)
LastEditedBy (the user who did the last edit after the new record was created)
LastEditedDTStamp (the date and time the data was edited)