UserID field

[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

 

[Douglas J. Steele]

Check out http://www.mvps.org/access/api/api0008.htm at "The Access Web".
You can't use this function as a default for a table, but you can for the
bound field in a form (the field doesn't have to be visible).

For the timestamp, you can set the default for the table field to Now().