Populate combobox

[Hudas]

Hello!

Whenever a user opens the form then vba gets the user login and add it in the combo box row source, with this the user can only access his/her record. My problem is there are users that needs to be given access to other agents record. So what I am hoping is whenever the user opens the form aside from his/her name being listed on the combo box drop down those agents the he/she has been granted access should also be listed. Any ideas on how to accomplish this would be greatly appreciated?


Thank you
Hudas

 

[shutzy]

i have this on my database. i have a login screen. on that there are text boxes that dlookup via the password. the txt boxes contain name and importance. importance what i have dictated each user can have. i have the highest importance and my receptionist has the lowest. you can do it either way but i prefer numbers. then in my reports screen i have the ability to let them only see their own reports. not any other employee but i can see all of them.

this is in the record source of my combo. no.3 in the code only means something to me but you can sort out that if you want

IIf([Forms]![frmPasswordScreen]![Importance]<3,[FirstName],[Forms]![frmPasswordScreen]![FirstName])

basically if the employee logging in has an importance level less than 3 then the criteria for the combo box becomes their firstname. i will have to change this soon as if we get another rachel i will be stuck with 2 rachels and they will be able to see each others reports. but this is basically how i have done it.

just ask if you have any questions.

 

[shutzy]

you could even do it by password. i presume the login screen remain open but invisible after they have logged in. the criteria for the combo box could be their password. you could put an iif expression in excluding your password from the criteria.

 

[Hudas]

Hi shutzy!!

First, Thank you for taking the time to read providing your thoughts on my post!

What I meant by the "user login" is the user logged on the computer. I'm not using any login Form where they will enter their password. What I'm trying to do is add to the combo box dropdown the names of those that he/she has give access to. The problhem is i don't have an slight idea on how i will do this.

Thank you
hudas

 

[shutzy]

In all honesty i dont know how to extract the logged in user info either. you need someway to tell access who is logged in, who the user is. i use a opening screen(password screen) where the user has an individual password and that tells access who that person is. my opinion is you should do something like that. im only saying that because i dont know of anyother way but thats not saying there is not.

if you would like help on what i suggested then i am capable of doing that but anything else you would be better off asking someone that is more intune with the operating system you are using.

 

[shutzy]

just another note. do you have an audit that logs what each user has done?

 

[Hudas]

Hello shutzy!!

Everyone of our agent has his/her login id. Whenever they are logged unto a computer the computer username changes to their login id. To get their login Id I use this code

Environ("Username")

("I know that environ is pretty unstable). I have a list of all their login Id's together with their respective name. Thats how the I determine the user.

I actually don't have audit the logs what each user has done...