Thread: User Name
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
EricG EricG is offline
external usenet poster
 
Posts: 220
Default User Name

Here are methods for getting the user's full name, and their Windows login ID.

HTH,

Eric

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

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


"leungkong" wrote:

I want to make a form, for example a leave application form.
when the staff sumit the form, admin will receive a mail and admin's
database will be marked some information to calculate the balance of annual
leave.

I used Application.UserName to make a form.
But I find that some people have changed their user name or remove the user
name.
for example, the deflaut name should be "mkelly", but their change it to
"Mick Kelly".

So, I cannot match the user ID in database.

Can I get the computer Login name in Macros?
Thanks in advance.