I am developing two database, one that is linked to anothers table. In the table that has the table that is non-linked I have a simple function in a query that parses out the phone number of an individual so that it will display the way I want it to on a report etc, this works fine, in the other data base with the linked table to the same data I have another query that has the exact same syntax, however when I run this query I get an error stating that this function is not available in expressions. I did some further testing with the Trim function and it creates the same error. I created this function from a different PC and then zipped it and ported it to another PC where I unzipped it, at the other PC it works fine, but here it is a different story. Is there a database setting that needs to be set, or possibly a table property? Any help would be greatly appreciated, wasting too much time on this one.

Never mind, something happened when I zipped the file, I had to rebuild the entire data base from scratch to get it working again, importing all of the tables, forms, reports, etc. and re-linking everything. Not fun.

Actually, the most common problem for a function working on one computer and not the other is a MISSING REFERENCE. Usually, all you have to do is to open the database and go to the code window (in the computer which it doesn't work), select Tools / References and then see which one it says as MISSING. If it does, select that one, note the .dll or .ocx file that it comes from (shown on the bottom of the dialog), uncheck it, close the dialog, re-open the dialog, browse to the .dll or .ocx file location, select the file, click ok, close the dialog and then it should be fixed.

Sometimes it won't say MISSING and in that case I usually find the Microsoft Common Controls reference, uncheck it, and then do the operation as listed above to re-add it in. That usually takes care of the problem too.

BL


[This message has been edited by boblarson (edited 12-20-2001).]