Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Queries/Reports based on user (Access 2000 SR1)

    Hi.Currently my queries require the user to input their initials in an "Enter Parameter Value" box to get "personalized" results. I have been asked to automate this so that Access detects the username from the login and then can automatically produces the "personalized" results based on the username. Can Access automatically detect the login username? Thanks for your help.

    Joe

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Queries/Reports based on user (Access 2000 SR1)

    You can get the user's network login in name using the GetNetUser() function from <post:=446,010>post 446,010</post:>.

    If you apply user-level security, you can use CurrentUser() to refer to the Access login name. See WendellB's tutorial The Secrets of Security for an introduction and useful links.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Queries/Reports based on user (Access 2000 SR1

    Another consideration is that you may need a user table. If a user has to input their initials for personalized results but their login doesn't blatantly shout their initials, i.e
    UserName: HazlettJM
    Initials: JH

    Then a table that tracks your users may be the only way to ascertain the initials of your users... just an idea <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •