Hi
I want to hide a form button (DeleteBtn) for all users except admins.
I have a user login table (tblEmployees) with the following fields:
EmpID
UserName
UserPassword
UserAccess
I have tried to implement VBA found on various sites but none are working for me. Either the button stays visible to all users and admin or it's invisible to both. I have tried setting the default visible property to both Yes and No but this doesn't appear to make any difference with any code I've tried already.
I want to make the button visible only to those users who have "Admin" access (in UserAccess).
Could someone please steer me in the right direction. Thanks.
I want to hide a form button (DeleteBtn) for all users except admins.
I have a user login table (tblEmployees) with the following fields:
EmpID
UserName
UserPassword
UserAccess
I have tried to implement VBA found on various sites but none are working for me. Either the button stays visible to all users and admin or it's invisible to both. I have tried setting the default visible property to both Yes and No but this doesn't appear to make any difference with any code I've tried already.
I want to make the button visible only to those users who have "Admin" access (in UserAccess).
Could someone please steer me in the right direction. Thanks.