Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
System cannot find TRIM function 1
- Thread starter forceflow
- Start date
-
1
- #2
Ricky is right on target. Here is a little more verbose explanation of the same thing if you haven't experienced it before.
If you receive an error such as "Undefined function," "Function not available in query expressions," or you can't find the object or property you're looking for, then you probably lost some of your library references when you last upgraded. Fortunately, problems with missing references are easy to resolve. Simply open a module or the VB Editor and select References... from the Tool menu. Check the listing in the Available References control. If you find one tagged "Missing," uncheck it. Then, from the Debug menu choose Compile and Save All Modules or Compile VBAProject. Doing so should locate and reestablish your missing references.
Ref: Q160870 in the Microsoft Knowledgebase
Steve King
If you receive an error such as "Undefined function," "Function not available in query expressions," or you can't find the object or property you're looking for, then you probably lost some of your library references when you last upgraded. Fortunately, problems with missing references are easy to resolve. Simply open a module or the VB Editor and select References... from the Tool menu. Check the listing in the Available References control. If you find one tagged "Missing," uncheck it. Then, from the Debug menu choose Compile and Save All Modules or Compile VBAProject. Doing so should locate and reestablish your missing references.
Ref: Q160870 in the Microsoft Knowledgebase
Steve King
Steve or Ricks,
I have seen this happen several times here in these forums. We are still using 97, too many applications to go through and change if we upgraded. if we ever change, I am curious about one part of your solution. When you say "If you find one tagged 'Missing,'", where would it say missing? Next to the reference, next to the path or somewhere else?
Thanks guys... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
I have seen this happen several times here in these forums. We are still using 97, too many applications to go through and change if we upgraded. if we ever change, I am curious about one part of your solution. When you say "If you find one tagged 'Missing,'", where would it say missing? Next to the reference, next to the path or somewhere else?
Thanks guys... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
- Thread starter
- #5
Here is a copy of the response I sent to Ricky after trying the fix...I should have posted it here instead of emailing. Next time....
Ricky-
Thanks for the info on how to get the TRIM function in Access 2000 to be recognized. I went into the module and checked the box in libraries next to DAO 3.6 (it wasn't selected) and then when exiting I got error message "NAME CONFLICTS WITH EXISTING MODULE, PROJECT OR LIBRARY" Any ideas around this? When I go back into libraries, DAO 3.6 still unselected.
Thanks
Mike
Ricky-
Thanks for the info on how to get the TRIM function in Access 2000 to be recognized. I went into the module and checked the box in libraries next to DAO 3.6 (it wasn't selected) and then when exiting I got error message "NAME CONFLICTS WITH EXISTING MODULE, PROJECT OR LIBRARY" Any ideas around this? When I go back into libraries, DAO 3.6 still unselected.
Thanks
Mike
- Status
Similar threads
- Locked
- Question
