Results 1 to 7 of 7
  1. #1
    MEMFBI is offline Advanced Beginner
    Windows 10 Access 2003
    Join Date
    Apr 2020
    Posts
    45

    GetUser Function "NotInList" no longer working

    Hello
    We have an access database that @30 users are using. Yesterday, for some users the GetUSER() function we are using to return the author of the record has stopped working. Along with oher functions, such as "NotInList"
    Private Sub cbo_job_NotInList(NewData As String, Response As Integer) It does not allow user to add records to the table.
    I would think that it is a machine issue, but our hardware support group feels it is software issue.
    It is a backend database on the server, and then each user has a front end database with queries/forms on their machines.


    Has anyone else encountered this? Could it be a Windows/Office update?

    Thank you!!

  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,518
    When it suddenly stops working and/or when some users have the problem and not others, my first thought is hardware or environment, not the programming. Did the offending machines get a Windows or Office update that working machines didn't? I'd also check references on a machine getting the error. I'd also make sure the front end is in a trusted location on problem machines, unless other code is running fine.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    MEMFBI is offline Advanced Beginner
    Windows 10 Access 2003
    Join Date
    Apr 2020
    Posts
    45
    Paul
    Thank you!!! It was the references that were removed. Any idea how that happens?

  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,518
    Happy to help! What reference was removed?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    MEMFBI is offline Advanced Beginner
    Windows 10 Access 2003
    Join Date
    Apr 2020
    Posts
    45
    A few of them:
    OLE Automation
    Microsoft Office 16.0 Access database engine object Library
    Microsoft ActiveX Data Object Library
    Microsoft Outlook 16.0 Object Library

  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,518
    Wow. The version of Office hadn't changed? I'd have to guess that something in a Windows/Office update caused the problem, but I haven't heard of this particular issue. My reply was a bit of a shot in the dark based on the fact that missing references can cause random functions to fail:

    http://accessmvp.com/DJSteele/Access...nceErrors.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    your tag says you are using Access 2003 - but the missing libraries are Office 2016. Is this because your tag is out of date or is it the case you are running a 2003 mdb in office 2016?

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

Similar Threads

  1. Combo, "NotInList" event doesn't fire
    By GraeagleBill in forum Programming
    Replies: 11
    Last Post: 06-14-2020, 05:50 PM
  2. Replies: 5
    Last Post: 04-22-2019, 08:55 PM
  3. Suppress "Requery" and/or "Repaint" when running function
    By GraeagleBill in forum Programming
    Replies: 3
    Last Post: 12-08-2017, 12:04 AM
  4. Replies: 1
    Last Post: 04-26-2016, 05:24 PM
  5. Replies: 3
    Last Post: 04-20-2016, 02:50 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