SP4 install and Trim function not workign

[Pete]

I have recently installed sp4 on Win2k. I am using ACC
2000 and now a report which used the trim function gives
this error #NAME? What can I do?

Thanks

 

[Kristyn Wagoner [MSFT]]

Hi Pete -

The following information should assist you with your issue.
1. Open your database.

2. Open a module in Design view. (By pressing Alt + F11) Make sure you have
a module Opened in that new window.

3. On the Tools menu, click References.

4. Click to clear the check box for the type library or object library
marked as "Missing:."

The following article discusses this issue:

Q194374 ACC97: Error: "Function Isn't Available in Expressions..."

http://support.microsoft.com/support/kb/articles/q194/3/74.asp



This is a really good troubleshooting article as well:

209132 ACC2000: Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Hope that helps!
--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Pete]

Thank you very much!

~Pete

-----Original Message-----
Hi Pete -

The following information should assist you with your issue.
1. Open your database.

2. Open a module in Design view. (By pressing Alt + F11) Make sure you have
a module Opened in that new window.

3. On the Tools menu, click References.

4. Click to clear the check box for the type library or object library
marked as "Missing:."

The following article discusses this issue:

Q194374 ACC97: Error: "Function Isn't Available in Expressions..."
..asp



This is a really good troubleshooting article as well:

209132 ACC2000: Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Hope that helps!
--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.



.