Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    error message (Access 2000)

    We have been working on a set of queries and reports for months. In the last week the queries containing the "left([fieldname],3)" function now returns an error message of "undefined function 'left' in expression". This has worked fine until last week - any idea why it suddenly started doing this? Thanks for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: error message (Access 2000)

    This usually means that there is a missing reference.
    - Activate the Visual Basic Editor (Alt+F11)
    - Select Tools | References.
    - If you see a reference starting with MISSING, click on it and take note of the path/filename displayed in the lower half of the References dialog.
    - Clear the check box for the missing reference.
    - If necessary, repeat for other missing references.
    - Click OK.
    - Switch back to Access and test the queries.
    - If you still have problems, you will have to find and set the equivalent(s) of the missing reference(s) on your PC.
    If that still doesn't help, post back.

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Thanks - will try that now.

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Tried that, none of the checked references were showing missing reports. The checked references were: Visual Basic for Applications; Microsoft Access 9.0 Object Library; Microsoft Access Wizard Control Library; Microsoft ActiveX Data Objects 2.1 Library; Microsoft DAO 3.6 Object Library. The error message still occurs.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: error message (Access 2000)

    See what happens if you clear the last three references (you cannot clear those for Visual Basic for Applications and for Microsoft Access 9.0)

  6. #6
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Tried that also, to no avail. The same error message still comes up.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

  8. #8
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    They refer to modules - this statement "left([fieldname],2) id included in a query and has worked up until late last week. I don't think anything has changed in the database or system settings - I am running into brick walls. Thanks for all your help.

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Try to create a new query with the left function.
    If the new query run, then your other query may be corrupted and you may have to recreate it.
    Francois

  10. #10
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Thanks - tried this too. Same error message appeared.

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Can you post a stripped version of the db so we can try it.
    See Hans's <post#=396578>post 396578</post#> to attache db to a post if needed.
    Francois

  12. #12
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    This is really confusing - I created a new database (attached), imported a small one field table with one query. When I opened the new database and tested the query, it worked just like it has and should. Does this indicate a problem with the old database?
    Attached Files Attached Files

  13. #13
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Create a new empty db and import all objects from the old one. Maybe the old one is corrupted.
    Francois

  14. #14
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    Does the error occur when the database is run on a different Computer?

    If so, you might try posting a stripped down version, to see if anyone can see a problem.

    Tom

  15. #15
    New Lounger
    Join Date
    Sep 2001
    Location
    Detroit, Michigan, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error message (Access 2000)

    OK - that apparently was the answer. I created a blank database, imported all the tables, queries, reports and macros. Now all seems to work as it is supposed to. Thanks again for all the suggestions and solutions. We can always count on the Lounger's to supply the answers!

Page 1 of 2 12 LastLast

Posting Permissions

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