Me again,
I made a mistake when I wrote,
> You can/should use the UserName automatically by using
> =Application.CurrentUser
> as the DefaulValue in the new field.
You will have to put it in a Module instead like,
Public Function CurrUser() As String
CurrUser = Application.CurrentUser
End Function
Then you will be able to use the function in the
form BeforUpdate for new records.
Also test existing records to make sure the
currentuser is the one that created the record.
An alternative option is to filter the records
and display only those records the were created
by the current user.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Youssef,
>
> You will need to use add the UserName as a new field
> in the Table that is the source for the records.
>
> You can/should use the UserName automatically by using
> =Application.CurrentUser
> as the DefaulValue in the new field.
>
> You can then allow only the user that created the
> record to make changes to it by comparing the saved
> value with the CurrentUser value.
>
> Something else you will need to do is to allocate all
> existing records to each user. To do that may be the
> hardest part of the job.
>
> Hope that helps.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Youssef" <youssef2309@> wrote:
> >
> > I have a multiuser database
> >
> > how to control the user when open a form to "view, edit or delete" ONLY the
> > records that he previously recorded
> >
> >
> > thanks in advance
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar