Format function not recognized
This is an Access 97 BUG! Microsoft can you fix this so it works with MDE
files and the runtime? Here is a useful post I found recently...
This problem is due to missing references in the database. These are easy to
fix if you are opening the DB using full access (check references list) and
can be fixed using the Referances wizard (available from
http://home.att.net/~dashish/) when running an mdb using runtime version. If
running an mde file using runtime version I overcame the problem by
stripping out all the problem functions, create a function using fully
qualified references and then call that function in their place eg.
Instead of "Name: Left([AField], 4)"
use: Name: "Name: MyFunction([AField])" where
Function MyFunction(strAField as string) as string
MyFunction = Left(strAField,4)end function
Its not the cleanest of solutions but works fine with minimal impact on
performance.Neil
Quote:
>>Hmm.. All of a sudden the format function doesn't repond in modules...but
>>just in one database...not any others.
>>I get a can't find project or library.
>>Is there a reference unchecked somewhere?
>>Format also doesnt work in queries either.
>>I tried repairing the database, no change.
>Open Tools | References and look for any checked item, that is listed as
>MISSING. Dev's URL explains the general solution for this problem.
>I've seen cases where the missing reference can be safely unchecked.
>Specifically, I once added a reference for purposes of experimenting with a
>new ActiveX control. Copied the working db over to another user's machine,
>and saw problems like you described. I knew the app was not relying on the
>missing reference (I hadn't actually worked the control into the
application),
>so I simply unchecked it, and the problem was fixed.
>Eric
