undefined function 'replace' in expression

[2007fld]

I just began to use Access 2003, SP3. I got error message: undefined function 'replace' in expression when I run a existing Macro.

I remembered when I first using Access, it was 2002 and I got similar error message. I fixed it by checking off the missing lib.

But this time, I opened the VB window (Alt+F11), Tools->References, did not see any missing libraries. What should I do?

Thanks a lot!

 

[boblarson]

Try unchecking the DAO reference if it is checked.

 

[2007fld]

Thank you.

Originally, I have the following checked:
Visual Basic for applications
Microsoft Access 10.0 object library
IAS Helper COM component 1.0 Type libaryry
IAS RADIUS Protocol 1.0 type library
Acrobat Access 3.0 Type library
AcroIEHelper 1.0 Type Library

The first two are needed all the time. But even I unchecked everything else, still got the error message

 

[boblarson]

You might try applying the Post SP3 hotfix
http://support.microsoft.com/kb/945674