So essentially, My switchboard has
Option1-coordinator
Option2-Lead
Option3-Scheduler
I should create a table with usernames, (should these be their windows logon usernames?)
also in the table have the fields Coordinator, Lead and Scheduler (should I set these as yes/no values?)
And the code would look like...
Code:
on click
if dlookup("haspermissions", "switchboardbuttonpermissions",
"[username] = '" & environ(39) & "' AND [option1,2or3] = '" & me.activecontrol.name & "'") = 0 then
msgbox "sorry! you can't access this function!
exit sub else "msgbox "you're in!"
MORE CODE FOR permitted USER. end if
is this right?
and how come my BBCode isn't working?
Im trying to do this to get around having to really set any kind of end user security settings.