Query Query

From: Simon Dowse (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 02:54:18 -0700

Hi,

I have a form with a load of person data in it. There is
also a link to another which will display extra
information on that person, which is done by a query that
matches the username for the record on the form to a
record in the new form.

The 2nd form displays codes dependant on what user rights
that person has. The user rights are grouped into 3 areas
and I have a table that lists the codes by area. Is there
anyway to have a query lookup a code and then return what
area it falls into? I want the 2nd form to say the code
(which it does) but also what area the code is from.

Any ideas? (Hope this is clear!)

Relevant Pages

  • RE: User Rights on Local Machine and Installing USB Device Drivers
    ... By default only administrator can load and unload device driver. ... can go to user rights and change this option to all users. ... Click Start, point to Settings, and then click Control Panel. ...
    (microsoft.public.win2000.security)
  • IE 6 unexpected shutdown as power user
    ... Internet access is only available when the user rights ... As a power user IE 6 will ... begin to load and immediately vanish. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Cant see named instance
    ... Yeah, thanks, that was it. ... Was getting burned by the user rights. ... The install is supposed to load version 2.7 but I don't think the user had enough rights on the box to do it. ...
    (microsoft.public.sqlserver.server)