Results 1 to 2 of 2
  1. #1
    shinydiamond is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    31

    Filter Access Web App query by UserDisplayName

    I need to create queries for my web app that filter records based on the logged in users display name. =UserDisplayName(). I have this value stored in a field in my table as [UserName] but applying that to a criteria in the query design view does nothing. Trying to user userdisplayname() in the query gives me a syntax error. Does anyone know the proper way to query by user name in a web app?
    I've googled for this but so far have found nothing. Appreciate any help.

  2. #2
    shinydiamond is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    31
    Solved this myself, I think. Turns out there's a form view of the query. There you can use the "On Load" feature and call a macro that restricts the query to the username. Just a basic macro with a RequeryRecords command is all that is needed. Not very intuitive though to requery a query.

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

Similar Threads

  1. Replies: 0
    Last Post: 03-18-2016, 09:13 PM
  2. Replies: 7
    Last Post: 05-27-2015, 12:45 PM
  3. Replies: 1
    Last Post: 12-22-2014, 11:47 AM
  4. Replies: 9
    Last Post: 05-13-2014, 08:22 AM
  5. Replies: 2
    Last Post: 01-30-2013, 07:34 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