can u auto populate a name in a form ?

[Guest]

Ok this is the problem, I will start from scratch.

Im making a database that multiple users will need to use to record there
actions, and i need to record the names of the people against every action.

For example, at present i have created a dropdown bow so the user can select
there name when they add a record, but they do this every time. Is there a
way i can make it remember the name they last input? Can this be done while
multiple people are using at the same time?

What id like to do in an ideal world is, have the user open the database and
have the work log populate there name withoutthem even logging in, so they
for example might open the database, enter there employee number then have
the database auto populate there name in the name field of the table but i
dont think this is possible.

Very greatful for any tips

Thanks

Chris

 

[Allen Browne]

If you are okay with VBA code, you can copy the code from here:
http://www.mvps.org/access/api/api0008.htm
and paste it into a module in your database. Then set the Default Value of
the control that should store the user's name to:
=fOSUserName()

 

[Guest]

Im only new to vba but i think i can work it out.

Thanks.

Chris