Workgroup

[TotallyConfused]

When copying database and using fOSUsername, I only get back an ID. How do I
set it up to be able to use the function fOSUsername and generate the name of
the user. Instead of ID: 123456 - Jane Doe???? Thank you in advance for
your help.

 

[Joan Wild]

You'd have to have a table with two fields - ID and Username. Then you can look up the name that matches the ID that fOSUsername returns.

 

[Douglas J. Steele]

See whether the code in http://www.mvps.org/access/api/api0066.htm at "The
Access Web" returns what you're looking for.