Permissions within the appl
From: WSF (someone_at_microsoft.com)
Date: 08/01/04
- Next message: Mike Johnson: "Parameter Question"
- Previous message: kiln: "Audio Recording or Dictation software for Access?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 1 Aug 2004 12:15:42 +1200
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
- Next message: Mike Johnson: "Parameter Question"
- Previous message: kiln: "Audio Recording or Dictation software for Access?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
