Hi All,
I have a query related Section access/security.
I want my user to access to only certain listbox Values, only admin should have all access. I have attached an excel and qvw file. In the excel sheet, I have a listbox with called "AccountL01" with XXXXX , YYYYY, ZZZZZ values. And the AccountL01 Sheet in excel has the REDUCTION column gives the reduction id.
So in sheet1 of excel says
Sheet1:
USERID | PASSWORD | ACCESS | GROUP | ACCOUNTL01 |
Admin | 123 | ADMIN | * | * |
B | 123 | USER | GROUP1 | 100 |
C | 123 | USER | GROUP2 | 101 |
D | 123 | USER | GROUP3 | 102 |
E | 123 | USER | GROUP4 | 101 |
AccountL01:
ACCOUNTL01 | REDUCTION |
XXXXX | 100 |
YYYYYY | 101 |
ZZZZZZ | 102 |
My requirement is, when User B logs to open, the List box should only show XXXX rest should be disabled or hidden, Same way, when USER C and E log in, the List box should show YYYY and for D it should only see ZZZZZ. The Reduction id identifies the user.
Thanks.
Ranjit