Can't use some functions in queries and reports

[Toby]

Hi,

I converting an older access DB from access 2000 to 2003. But when executing
queries it's giving me undefined function error for Trim$([Field1]) the
error message is

Undefined Function Trim$ in expression.

I'm baffled as all the examples say you can do this and it is in the
expression builder. It's almost as if a reference has been lost to the
functions module.

Any help appreciated

Thanks

Toby.

 

[Guest]

I think you probably answered your own question.

Open the VB Editor and select Tools>References. Probably a reference to a
library is missing. You can check what VB thinks it has in the list.

Make sure all of the References that seem to make sense to have are checked.
Uncheeck any that don't make sense, add those that seem to make sense. Copy
down the list of checked references, 'cause when you close this window and
have to reopen it, the references will have been resorted.

Just keep playing with the list until these errors go away.

Maybe one of the heavyweights in the group has a more logical way to go
about determining what's missing?

Good Luck!

 

[fredg]

Hi,

I converting an older access DB from access 2000 to 2003. But when executing
queries it's giving me undefined function error for Trim$([Field1]) the
error message is

Undefined Function Trim$ in expression.

I'm baffled as all the examples say you can do this and it is in the
expression builder. It's almost as if a reference has been lost to the
functions module.

Any help appreciated

Thanks

Toby.

Your PC has a missing or incorrect reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html