Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737

    All I can say is, it worked for me.....
    I'll buy that.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  2. #17
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    I tried ssanfu's suggestion. No joy. The query does run properly if I remove the Left() function from the criteria row.

  3. #18
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This I find odd
    If I open the accde on the problem computer from my computer it runs fine, but if I log on to her computer remotely, I get the error.
    You are the user in this case, logging on to her pc from somewhere else. Did you try any posted solution, e.g. looking for file versions rather than updates? I don't know if you're the IT guy or not, so maybe an update was rolled back and the updated dll remains and is being used as in
    https://answers.microsoft.com/en-us/...2-efb3fd8f3e0d

    I was going to suggest that the query may be corrupt and all you did by importing it into a new db was bring over the corrupted object. However, this quoted statement suggests it's not the cause.

    The
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #19
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    Found the problem! There was a reference to BarCodeWiz ActiveX, but BarCodeWiz had not been installed on this computer. Once installed, everything works.

  5. #20
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Well, I think NoellaG deserves kudos and a prize for that answer way back.

    I learned something - not sure why Left has anything to do with that library, but I guess strange things do happen.
    Given that the user only had runtime, you could not compile the project on that pc, but if you had been able to, you probably would have found the problem sooner.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #21
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Thx for the prize . The explanation is quite simple: if the program isn't installed Access can't find the dll on the moment it is loading all referenced libraries. On that moment it stops loading referenced libraries. And the standard library containing standard functions like left() is one of the remaining dll's that isn't loaded anymore. I found out that when a user complains that the function left() doesn't work anymore it is in 99.9% of the cases a missing referenced library.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-26-2020, 02:46 AM
  2. Replies: 6
    Last Post: 03-30-2018, 09:18 AM
  3. Replies: 7
    Last Post: 03-17-2016, 05:53 PM
  4. Replies: 15
    Last Post: 11-01-2013, 03:24 PM
  5. an aggregate function error message
    By newtoAccess in forum Queries
    Replies: 1
    Last Post: 11-27-2010, 05:18 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