Restrict column records based on creteria (1 Viewer)

[sigma788]

Hi,
this seem to be simple for single criteria but i am not able to do it multiple.
i want to restrict user to customer list they r able to see in form combo box drop down list.

users are in employee TBL
employee group criteria is in tbl_Groups which contains value Admin,Read Only, manager etc
employee r grouped through tbl_AssignUsersToGroups.
customer r grouped in customerType TBL. i.e class1, class2 etc
created EmployeesClassTypeRestriction TBL to store restrictions for employees


Restrictions criteria:
1-employee can view only specific class which includes all customers in that class
2- employee can view only specif customers in a class only.
3-employee can view only specif customers in a ANY class.
4- No criteria No restrictions and can view all customers in all classes( For Admin )

Tried to used Tempvar criteria in customer combo box qry but it works for above point 1 only.

need some help from experts to implement such feature in forms.
Regards.

Attached accdb sample also.

 

[GinaWhipp]

Hopefully, this will get you started. One thing... you're going have to have a way to get the Users name when they open the database. So, from your Main Menu/Switchboard then you can have a hidden field there.

http://www.access-diva.com/f10.html

 

[sigma788]

Gina, the linked example is good for user login security.
But multiple criteria problem still remains which starts after user has logged in.

In my case after user successful login (which can be using TempVar OR the above login form example), the drop down combo box in orders forms needs to be show customers based on restriction criteria the user falls in while creating new orders ONLY.


I hope the pic clears what I am referring to.
Regards.

 

[GinaWhipp]

All this time and I didn't realize I mixed up the page names, UGH! :banghead: Here's the page I meant to post a link to...
http://www.access-diva.com/f7.html

 

[sigma788]

thanks Gina
i came up with the same idea.
customer id will be assigned in separate tbl to user when new customer will be added through form.
Admin will be allowed by default and others user policy in separate field which admin can later change.

The new sample also deals with similar idea practically.
Regards

 

[GinaWhipp]

No problem and thank you! All this time and I never noticed that!