Re: Restricting users from seeing any other records
- From: "Rick B" <Anonymous>
- Date: Thu, 7 Jul 2005 10:01:26 -0500
This is adressed very often. go read the previous posts. Search for
"restrict own records".
--
Rick B
"Shannan Casteel" <forum@xxxxxxxxxxxxxxxxx> wrote in message
news:50F7DE54D8120@xxxxxxxxxxxxxxxxxxxx
> I have several dealers submitting warranty claims. I would like to set up
> security so that there are ID's for each dealer and an ID that allows them
to
> enter claims. While logged on as the ID that allows them to enter claims,
I
> don't want to allow them to view any other records. If they are logged on
as
> their personal ID, I want them to be able to view the claims that they
have
> entered and no one elses. The number of dealers is constantly changing.
>
> I think I might be able to accomplish the second part if in the On_Open
Event
> of the form I put something like RunCommand acFilterByForm. Then I would
> have the DealerNumber field automatically populate by setting its default
to
> cmbDealerNumber = CurrentUser.
>
> Anyone know if this would work?
>
> Thanks for the help,
>
> Shannan Casteel
>
> --
> Message posted via http://www.accessmonster.com
.
- References:
- Restricting users from seeing any other records
- From: Shannan Casteel
- Restricting users from seeing any other records
- Prev by Date: Increment a Variable?
- Next by Date: controling control properties
- Previous by thread: Restricting users from seeing any other records
- Next by thread: Increment a Variable?
- Index(es):
Relevant Pages
|
