Function not recognized

[mike]

I have two copies of the same database, one live and the other used for
testing. In the live database, a report that was previously running correctly
no longer recognizes the Trim or Format functions. The testing db still
recognizes both of these functions normally. Also, Trim works if I write a
function in a module, just not in the report.

I haven't made any changes to this report in over a year. Additionally, both
databases have the exact same references. Has anyone experienced anything
like this before? Where do you even start to look to figure out what's going
wrong?

I'm running an Access 2002 adp file. The back end is SQL server 2000.

Both databases have the following references:
Visual Basic For Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveXData Objects 2.1 Library
Microsoft Jet and Replication Objects 2.6 Library
JET Expression Service Type Library
Microsoft Office 10.0 Object Library
Microsoft Excel 10.0 Object Library
Microsoft Common Dialog Control 6.0 (SP6)

 

[Jeff Boyce]

Mike

Try taking a look at the References in a code module. Sometimes (?perhaps
related to SPs/updates), Access loses track of its working libraries.

Open the References window and check for any checked references marked
MISSING. Uncheck, close, re-open, re-check, re-close. Run the Debug to
make sure it compiles.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mike]

thanks, that fixed the problem

Try to add another reference, compile, remove the reference and compile again.
Then check the references again for any missing references.

If that's not the problem, which sandbox mode are you using?

http://support.microsoft.com/kb/239482/en-us

Chris
Micros