Obtaining user information

[Phonik]

Hello to you all...

I am just after a bit of assitance if anyone can kindly help?

Basically, I need to redevelop a Complaints database for my employer as the current one is no longer fit for purpose. The current database is a FE/BE database and users are required to login with a username and password. This causes me a massive headache as users constantly forget their password and email me to reset it. I had included a password reminder form which emailed users their password if they got their pre-defined security questions correct but our business standards dept did not want us to store personal data for the reminder questions. Is there a way that the database can obtain the users network login ID from windows without too much difficulty?? We had something similar in a previous database but it dipped into the system registry and our IT dept had a fit when the found out....not surprisingly.
Thanks people. Have a great day!

 

[tehNellie]

Debug.print Environ("USERNAME")

You can make an API call to windows instead if you want, but that seems to work fine for me, it doesn't return the Domain, although you can get that separately using:

debug.print environ("USERDOMAIN")

Lots of other environment information can be obtained using environ without having to resort to API calls.

 

[Phonik]

Thanks I will give this a try.

 

[Phonik]

HI again

If I wanted to link this to a text box do I simply do:

Me.txtbox = Debug.print Environ("USERNAME")

?
Thanks

 

[Phonik]

Sorry...Im being dense...I have worked it out. Thank you so much for your help!