var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Field Permissions
Does Access allow field permissions? i.e. If a user is restricted to view only a couple of fields, is there any code to view this particular field only if for example, the user is Administrator? and Read Only Users view all fields.
Thanks for your help.
Here's a cute little trick that's easy to use:
Decide how you want to define the user's security level. This is one of the few places a "Public Variable" is appropiate.
Let's say you have 3 levels of security:
1: low - can see few things
2: medium - can see some things
3: high - can see everything
In a module, add the line:
In your initial form's "Open" event, assign the appropiate security level to the public variable.
Public pubSecLevel As Integer
Then, on each form with restricted controls:
In the Tag property of each control you want to respond to security level, put the security level - just the number.
Then in the Open event, put the following:
Actually, this little "control" loop is very useful for a lot of things.
Dim ctl As Control
For Each ctl In Me.Controls
If Len(ctl.Tag & "") > 0 Then
If Val(ctl.Tag) > pubSecLevel - 1 Then ctl.Visible = True Else ctl.Visible = False