User Logged Id

[rwalle]

I am designing a DB that will be distributed among all users here in our company to retrieve data regarding our labor schedule containing things like Employee info , project info labor hours expended, report load date, and things like that, I think I have all this set up done, I will use a LogIn form to ask for UserId and Pasword so each one can access to load data regarding to themselves , and I am wondering if there is a way to check the windows user Id and pasword against the login data the current user is write down in logIn Form ? so he only can load info about he's work

any help will be appreciated

regards

[Jerry Maiapu]

Hi,

There are many example functions on the net to retrieve current logged in windows user. However, password retrival function was quite not done by many people..

I just answered a post similar to your question ...here........... 2 or 3 days ago. Check Post#10 and onwards . Take note of corrections (Additional Functions)Post#14
I know it will be of great help to your problem..

Check it out:

Regards
Jerry

[munkee]

Why not only have the windows nt username as the method of entering the database?

The userID is going to be just as good as having a password in my opinion. If you wanted to take it a step further you could have all of your usernames selectable in a drop down on the opening form and their password would be set to their windows nt username. No need for a visible password box, that way only the user who has selected their name that matches their nt username can enter.

[rwalle]

Thanks Jerry and munkee for your responses
actually I just need the userId as you said, since everybody have its own PC and will load / review data regarding themselves.
I will give it a try next days and comeback with further doubts if any

[Jerry Maiapu]

Glad I could help..
Always post back if any doubts

Cheers

JM