Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    167

    Unanswered: undefined function trim - no broken reference!

    Error:

    "Undefined function 'trim' in expression."

    This is incredibly frustrating. I have no broken references showing, compact/repairing the database doesn't help, and I'm not allowed to drop/re-add any references at all ("Cannot perform requested operation"). When I try to compile my code, I get "File Not Found".

    This error is displayed on any machine that accesses the db.

    This is the second time I've had this happen with this db. The last time I had to dump the current copy and go to a backed-up copy. I've got tons of code written that isn't backed up now, so I'd like to solve this problem.

    Any help with this is greatly appreciated.
    Kit Lemmonds

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    2 options:

    1 Decompile and then recompile ...

    2 Create a new DB and import everything over and recompile ...

    When you try to compile and get the error, what line does it point to?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2003
    Posts
    167
    Unfortunately the "File Not Found" msgbox does not move the cursor/focus from it's current location. I've noticed that double-clicking one of my modules also brings up this error. When I try to remove it (or print, export, etc.) - I keep getting the file not found error.

    How do you decompile?

    Thanks.
    Kit Lemmonds

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by onansalad
    Unfortunately the "File Not Found" msgbox does not move the cursor/focus from it's current location. I've noticed that double-clicking one of my modules also brings up this error. When I try to remove it (or print, export, etc.) - I keep getting the file not found error.

    How do you decompile?

    Thanks.
    Open your database from a shortcut with the /DECOMPILE option ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Nov 2003
    Posts
    167
    No luck with the decompile. I just imported all of the objects into a new database. Too bad the groups/shortcuts don't import too. I had to manually create about 40 (that's after deciding I didn't need all the 100+ shortcuts in the original db)!

    Thanks for your suggestions.
    Kit Lemmonds

Posting Permissions

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