finding out username of record creator

  • Thread starter Thread starter Tiago
  • Start date Start date
T

Tiago

Hello!

I wanted to keep a record on which user creates the orders out of the cellar.
I have a simple order table.
Should I include a field username in this table? I'm completelly lost!
Thanks in advance for the assistance.

Cheers/Tiago.
 
Yes, you have to include a Username field in the table, and you have to
populate it.

If you're using Access User-Level Security, I believe you can set the
default value of the field in the table to CurrentUser().

If you're not using Access User-Level Security, you'll need to grab the code
from http://www.mvps.org/access/api/api0008.htm at "The Access Web", and
then put code in your form's BeforeUpdate event to set the field to the
value of fOSUserName.
 
Back
Top