RE: Code to filter records if regular user; if Admin show all
- From: "Sandy" <Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Jan 2006 19:09:27 -0800
Forgot to add this into my reply:
Would you happen to know how secure just filtering records for the user is?
Is that the recommended way to do it?
--
Sandy
"mscertified" wrote:
> You'll have to store the creator username in the record.
> You'll also need a table of user names saying who is regular and who is an
> admin.
>
> For regular users, in the openevent for the form change the source query
> based on what type of user to include the clause "WHERE UserName = " &
> CurrentUser
> You could also do it through the ApplyFilter statement
>
> -Dorian
>
> "Sandy" wrote:
>
> > Hello -
> >
> > How would I code a form so a regular user would only receive records they
> > entered for the day (way to allow if no records, show new blank record)? The
> > Admin, obviously will be able to see all records. The Record Source for
> > properties in the form for all records is qryCalls.
> >
> > My code currently has fOSUserName as the user name pulled off the system.
> >
> > Any help will be appreciated!
> > --
> > Sandy
.
- References:
- Code to filter records if regular user; if Admin show all
- From: Sandy
- RE: Code to filter records if regular user; if Admin show all
- From: mscertified
- Code to filter records if regular user; if Admin show all
- Prev by Date: RE: Code to filter records if regular user; if Admin show all
- Next by Date: calculating a value in a text box
- Previous by thread: RE: Code to filter records if regular user; if Admin show all
- Next by thread: Re: Code to filter records if regular user; if Admin show all
- Index(es):
Relevant Pages
|
