Automatically add user's name

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a database which is used by several users on a
network. Is it possible to automatically add the users's
name to the record being created by this user? (I don't
want the user to know that his name is registered)
 
Not directly in a table.

However you can do this in a form, which should be what you give users.
They shouldn't even see/be aware of the tables.

Add a field to your table - CreatedBy

For every form applicable, add a textbox (hidden and bound to CreatedBy) and
set it's default value to either =CurrentUser() (if you've implemented
Access security), or use the function at
http://www.mvps.org/access/api/api0008.htm
to retrieve their network name.
 
Back
Top