UserID field

  • Thread starter Thread starter Derek Wittman
  • Start date Start date
D

Derek Wittman

Good afternoon,
My team of 3 shares a few databases for order process
reporting purposes. What I would like to do is include a
table field that defaults to the current user's (we're on
Access 2000 on NT Workstations) userID and puts it in the
field. I intend to keep this field hidden, but would like
to be able to access it to check on folks (myself) in the
even that a keystroke error is found at a later time. I
currently have 2 fields hidden (date and timestamp - I
know there's some redundancy, but we have reason for both)
with default values, so I'm looking for something similar
with maybe a default value that can be read from the
system somehow.

We do not have any security features turned on. However,
the workstations do require NT userIDs to logon in the
morning. Can someone help?

Thank you!
Derek
 
Back
Top