Results 1 to 4 of 4
  1. #1
    henry989 is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Posts
    1

    Unhappy display user profile based on logged in user.


    I have login form which takes user name and password from Users Table. Once user logs on I want to show their details on a profile form. Users table have a customerID as foreign key. I can login access fully but I do not know how to just show information for user that logged-in. As of now profile form shows all user records.

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    I usually have a local table in the front end I calll tblLocalSettings. When the user logs in, the table gets updated with the UserID of the currently logged in user. You can then use dlookup to retrieve the id when and wherever needed.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not very clear what you are trying to achieve or the relevance of a customer foreign key in the user table - sounds like a user just has one customer assigned to them.

    If this is the case, when user logs in assign their userID to a global variable or tempvar - then set the profile form to filter on this value - either as a filter or by modifying the recordsource by applying a criteria.

  4. #4
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Please check this link below. See if it can help you with what you trying to do.


    https://www.accessforums.net/showthr...splay+username

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

Similar Threads

  1. Access user profile
    By Monty51 in forum Misc
    Replies: 10
    Last Post: 09-19-2021, 04:49 PM
  2. Replies: 8
    Last Post: 05-16-2018, 08:46 AM
  3. Replies: 4
    Last Post: 10-29-2016, 12:20 AM
  4. Replies: 1
    Last Post: 10-27-2016, 10:51 PM
  5. Replies: 1
    Last Post: 01-04-2014, 11:04 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