Function not recognized

M

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)
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook code works on my machine but noy others 6
Run-time error '429' ActiveX component can't create object 0
Calculation Error 2
File dialog in Access 2003 doesn't show. 2
Reference/Link not found 0
References Bug 5
Access 2007 Conversion Issue 5
output filter string to text box on form 3

Top