| | |
|
|
|
Filter by User? |
|---|
| message from Oli on 11 May 2004 |
Hi
I have several users of a split database - which is stored on a remote
server. Now we have identified the need to not let all users get to each
others data.
Is it possible upon opening a form to filter such that each user can only
see data that they have added? and... if an admin user then all records
viewed?
Many thanks in advance
Oli
|
| Kailash Kalyani replied to Oli on 11 May 2004 |
Yes, this is quite easy to do. If you do store the person who added a record
as part of the record info, then you could easily insert a filter in the
onLoad event of the form and make a check on who the current user is by the
currentUser() function..
Releveant commands:
docmd.applyfilter
currentuser()
|
|
Archived message: Filter by User? (Microsoft Access Database)
