Results 1 to 6 of 6
  1. #1
    rashima is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    16

    how to get user information

    I have a access database and I want to know which user is logged in, I don't want to let user enter anything like initials.....is there any way to get it automatic

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    If you mean the user logged into the computer, you can use the Environ() function or this type of thing:

    http://access.mvps.org/access/api/api0008.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    rashima is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    16
    getting compile error "can't find project or library" do i need to add any additional reference ?
    thanks for your help

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Did you copy all of that into a standard module? What did you name the module? How are you calling it?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    rashima is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    16
    I called it on button click, but now it worked, i had one broken link sorry
    so now its working well.
    thank you very much for your help.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  2. Replies: 3
    Last Post: 09-22-2011, 03:35 PM
  3. Replies: 1
    Last Post: 08-13-2011, 04:44 AM
  4. Where can I get more information on this pls?
    By Buakaw in forum Programming
    Replies: 6
    Last Post: 02-12-2011, 04:39 AM
  5. Replies: 8
    Last Post: 06-30-2010, 10:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums