Re: Access 2002 Help required please......

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Simonglencross (simon_glencross_at_hotmail.com)
Date: 11/07/04 

Date: Sun, 7 Nov 2004 16:56:06 -0000

Joan,

I had an unbound list box which displayed my active customers, you could
click once on one of the active customers and there details would populate
my center form but since making the currentuser() changes the list box is
now bound and has loat this functionality, how could I correct this?

Many Thanks

Simon
"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:ek1yKsNxEHA.2016@TK2MSFTNGP15.phx.gbl...
> Simonglencross wrote:
> > Joan is there any way I can implement this without have to scrap the
> > forms which I have done and starting again?
>
> There is no need to delete your existing forms and start over.
>
> I'll assume your forms are based on tables. Create a RWOP query for each
of
> your tables. You can set the run permissions property of the query in
> design view to Owners. This will give you a SQL statement like:
>
> SELECT * FROM Orders WITH OWNERACCESS OPTION;
>
> Change the recordsource of your form to the query. In design view of your
> form, show the field list and drag the new OwnedBy field from the list to
> your form. Set this control's default property to =CurrentUser() and hide
> it if you wish.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>

Relevant Pages

  • Re: Access 2002 Help required please......
    ... I had an unbound list box which displayed my active customers, ... "Joan Wild" wrote in message ... Create a RWOP query for each ... > design view to Owners. ...
    (microsoft.public.access.security)
  • Re: User permissions
    ... I would base the report on a query with just ... FROM (vehiclelistingtbl INNER JOIN usernameregion ON ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: User permissions
    ... This report query has an additional table in it and I'll ... FROM (vehiclelistingtbl INNER JOIN usernameregion ON ... "Joan Wild" wrote: ... Change the recordsource of the report and then open ...
    (microsoft.public.access.security)
  • Re: restriction due to other users
    ... "Joan Wild" wrote: ... you'd need to do what's called a Union query - - more information in Help. ... Medical, Addresses, Next of Kin Contact1, Next of Kin Contact2, Kids. ... and the inner join will cause that person to ...
    (microsoft.public.access.security)
  • Re: Disable control
    ... Joan Wild ... Microsoft Access MVP ... Does it actually say 'query' or does it say the name of some query? ... need to give as a minimum 'Read Data' permission on that query. ...
    (microsoft.public.access.security)