Hiding certain fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I have set up access for two users. I want DBAdmins
to have full access and be able to view all fields. Other users will just
use the Admin account an I want to elminiate the ability to view password
fields. Is this possible?
 
You can implement security, such that users don't login and instead use
their default system.mdw.

In the Open Event for your form(s), you can use code to hide controls that
you don't want the general users to see.

If CurrentUser() = 'Admin' then
Me!txtWhatever.Visible = false
Me!txtSomething.Visible = false
Else
Me!txtWhatever.Visible = true
Me!txtSomething.Visible = true
End If
 
Back
Top