Switchboard Question

J

Jannie

I have an employee table that has employee confidential data for emp
evaluations. About 400 emp records. I only want each manager to be able to
click on the employee evaluations button on the switchboard and see/do only
their employees evaluation data no one elses. The owner of the company
should be able to see everyone's evaluation however. Please tell me how to
do this. I have a field called "password" set up in my Emptable and I can
assign a password for each manager related to each employee. I need someone
to step me thru doing this. - Jannie
 
G

Guest

in your emp table there should be a department id for each
emp. you will then need a password table showing manager,
department arthorized to veiw and manager password. this
table should be hidden and have a way of viewing, editing,
adding and deleting passwords. You will have to add a
combo box for manager name.
then add this code to a "evaluation" butto
sub lookupPW()
If (DLookup "[Password]", "PWtable", "[Managername] = '" &
Me!cmbomangername & "'")) <> Me!txtPassword Then
MsgBox (" Password not on file!")
Call cmdClearForm_Click 'dumped
Exit Sub
else
run your queries.
end sub
you can use the combo box info as criteria for you fetch
query to get only those department the manager is allowed
to see. that info is in the password table.
 
G

Guest

hi again
the combo box uses the password table as record source and
is limit to list. this way managers will have to see you
to get "on the list".
-----Original Message-----
in your emp table there should be a department id for each
emp. you will then need a password table showing manager,
department arthorized to veiw and manager password. this
table should be hidden and have a way of viewing, editing,
adding and deleting passwords. You will have to add a
combo box for manager name.
then add this code to a "evaluation" butto
sub lookupPW()
If (DLookup "[Password]", "PWtable", "[Managername] = '" &
Me!cmbomangername & "'")) <> Me!txtPassword Then
MsgBox (" Password not on file!")
Call cmdClearForm_Click 'dumped
Exit Sub
else
run your queries.
end sub
you can use the combo box info as criteria for you fetch
query to get only those department the manager is allowed
to see. that info is in the password table.
-----Original Message-----
I have an employee table that has employee confidential data for emp
evaluations. About 400 emp records. I only want each manager to be able to
click on the employee evaluations button on the switchboard and see/do only
their employees evaluation data no one elses. The owner of the company
should be able to see everyone's evaluation however. Please tell me how to
do this. I have a field called "password" set up in my Emptable and I can
assign a password for each manager related to each employee. I need someone
to step me thru doing this. - Jannie

.
Click to expand...
.
Click to expand...
 
Top