W
WSF
Access97
I would like to set up user permissions within the Access APP - driven say
on opening the program.
Users in this report program are easily identified by CurrentUser.
The types of permissions are mainly Visible True/False applying to Form
Tabs(pages) and some controls on various forms.
I thought of using a lookup table with DLookup functions running through a
list - a formula for each control?
For example
If DLookup("[Sales]", "[tblPermissions]", "User = '" & CurrentUser & "'") =
True Then Forms!frmMain.tabSales.Visible = True
where [Sales] is the Yes/No fieldname in [tblPermissions] for the page
[tabSales] on the form [frmMain]
But having such a table, assuming a record was based on a user, with
numerous fields (1 for each control), seemed cumbersome.
I have used explicit names for all the objects and controls in my MDB.
Is there a better way of doing this? And in a way I can set up an Admin form
so a designated user can apply changes to the permissions (like clicking
Yes/No checkboxes on a form).
Any example I can be pointed to?
Any help gratefully appreciated.
WSF
I would like to set up user permissions within the Access APP - driven say
on opening the program.
Users in this report program are easily identified by CurrentUser.
The types of permissions are mainly Visible True/False applying to Form
Tabs(pages) and some controls on various forms.
I thought of using a lookup table with DLookup functions running through a
list - a formula for each control?
For example
If DLookup("[Sales]", "[tblPermissions]", "User = '" & CurrentUser & "'") =
True Then Forms!frmMain.tabSales.Visible = True
where [Sales] is the Yes/No fieldname in [tblPermissions] for the page
[tabSales] on the form [frmMain]
But having such a table, assuming a record was based on a user, with
numerous fields (1 for each control), seemed cumbersome.
I have used explicit names for all the objects and controls in my MDB.
Is there a better way of doing this? And in a way I can set up an Admin form
so a designated user can apply changes to the permissions (like clicking
Yes/No checkboxes on a form).
Any example I can be pointed to?
Any help gratefully appreciated.
WSF