Results 1 to 2 of 2
  1. #1
    foxtet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    23

    Lightbulb logged user name on main form

    Hello friends;

    Here attached is a zipped copy of login sample database. There is a loggin form at start up. I want logged user name to be displayed on the main form and reports given in the database, I tried with DLookup function but I get #name error.

    Can you help me to get a quick solution for this issue


    fox
    Last edited by foxtet; 07-30-2011 at 09:59 PM.

  2. #2
    focosi is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    97
    just create a text box, delete the label, and in property sheet type "=CurrentUser()" in the field "Control Source".

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

Similar Threads

  1. Getusername of currently logged in user
    By nkuebelbeck in forum Access
    Replies: 8
    Last Post: 06-29-2011, 04:06 PM
  2. Replies: 6
    Last Post: 11-05-2010, 10:11 AM
  3. Replies: 6
    Last Post: 07-19-2010, 10:57 AM
  4. Replies: 6
    Last Post: 01-13-2010, 02:41 PM
  5. Currently logged in user into text box
    By ne16428 in forum Security
    Replies: 5
    Last Post: 06-10-2009, 11:46 AM

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