Get User log in - API not backwards or forward compatible (1 Viewer)

[basshead22]

Hello All,

I used the code in the link below to get the login id returned on a form but I am having trouble now that I rolled out the database the code gives an error if the user has older than 2010 and even on a new machine that has access 2013 what is the best code to use? to return the log in id to a form?? without worrying about what version of access they have it wont be older than 2003.

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


Much appreciated.

 

[Galaxiom]

Some will pipe up with code to return the Username environment variable.
Avoid it becaus eit is easy to break.

This will return the actual username.

CreateObject("wscript.network").username

 

[basshead22]

Thank you for your reply Galaxiom..

where do I put this code , sorry im fairly new to programming is it VB a Macro / module?

 

[Galaxiom]

Put this function in a Standard Module and you can use it anywhere in the project.

Public Function LoginName()
    LoginName = CreateObject("wscript.network").UserName
End Function