CurrentUser

[Buddy King]

Hi. In one of my input forms I want to default the user and date field to defaults Now() and CurrentUser(). I am not sure where Access gets its machine information. We use XP and everybody's ID is Admin. Do I need to set up individual profiles for everybody? What is the easiest, cleanest way to ID the current user? Our system administrator is hardware oriented and does not know this answer, so I would appreciate any enlightnement.
Thanks.

 

[Rick Brandt]

Hi. In one of my input forms I want to default the user and date field to

defaults Now() and CurrentUser(). I am not sure where Access gets its
machine information. We use XP and everybody's ID is Admin. Do I need to
set up individual profiles for everybody? What is the easiest, cleanest way
to ID the current user? Our system administrator is hardware oriented and
does not know this answer, so I would appreciate any enlightnement.

If you are not using the built in security for Access then CurrentUser() is
useless as everyone will show up as the user "Admin". Code at the link
below will allow you to grab the user's networking UserName.

http://www.mvps.org/access/api/api0008.htm