Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Posts
    30

    Red face Unanswered: Help!!! Access 2007/2010 functions disabled in Win 7

    I have several Access databases that worked a week or two ago on a Win 7 system that now have error messages opening queries with Left(), Right(), or Mid() functions in the query. I tested this in a new database on both Win 7 and Win XP. I works without error on the Win XP system but I get an invalid function error message on the Win 7 system. Did MS disable this in a recent update to Office or Win 7. Help.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Sounds like you have at least one missing reference.

    On the machines having an issue:

    In the VBA editor go to Tools > References

    Look for any that are check at the top of the list that start with MISSING.

    Is your database split?

    Have you added any new references?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jul 2006
    Posts
    30

    Amazing

    Thanks HiTechCoach

    It was a missing reference to an old add-in for special bar codes that was no longer needed. What is strange is that it would affect the use of some but not all unrelated functions in a query. I would have never guessed that one.

    Experence counts

    Thanks again.

    Jim

    Sounds like you have at least one missing reference.

    On the machines having an issue:

    In the VBA editor go to Tools > References

    Look for any that are check at the top of the list that start with MISSING.

    Is your database split?

    Have you added any new references?[/QUOTE]

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by jimgriggs View Post
    What is strange is that it would affect the use of some but not all unrelated functions in a query.
    Reference libraries are funny that way. A missing reference can make functions whose reference(s) are not missing to act up! Sometimes even the order that references appear/are loaded can make a hash of things!

    It's always a good idea to check for missing references if

    1. Something works on one machine but not another
    2. Worked on a previous Access version but not a later version
    3. Worked on a previous OS but not a later OS

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    May 2010
    Posts
    601
    Jim,

    Glad to hear that you solved the issue.

    Good luck with your project ...
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •