VBA Script to Pull User IDs into an Access db

[Traci]

Does anyone already have a script written to capture a
network ID to add to an Access table/database? If so, can
they share?

Traci

-----Original Message-----
You can capture a user id programmatically by using VBA.

Sal
www.cedrostec.com


Currently I have a "personnel" table that captures the
individuals name, title, etc. When I want only
one "survey" response per individual, I request that they
select their name from the table that is a look-up.

What I would LOVE to do, is capture their user ID which
they have to log onto the PC/network to access the survey.
If I can capture their user ID, then if they fill out a
survey, I can allow them to preview/change their survey
only, OR allow them to add a survey if they have not
already done so.

Traci