Undefined Function "format" in expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We converted a MSAccess 97 (was developed with MSAccess 2.0 and converted a
while back) to MSAccess2000 and then MSAccess2002, all went well in the
convertion. We are getting this error on a machine in Tokyo, they are on
Access 2002 SP3, There was not problems in running the application on same
box with MSAccess 97. The process works just fine in our US office on Access
SP3. We can map to the drive that this sits on in TKY and run it locally and
it works just fine. They sent use screen shot of the References and non are
missing and all seemed OK. The format in question is in the expression
builder of the quary. I wrote a function to display nothing other then the
outcome of a format statement in a module and had then run it and it worked
just fine. I have also had them check there MDAC to see if they are behind
and they are at 2.7, same as the machine that we tried here. My only idea
left is that it's some library that is outdate but I don't know how to see
which one it might be. Any idea or suggestions are appricated.
 
If none of the references has a MISSING: tag in front of them, try selecting
an additional reference at random, back out of the dialog, then go back in
and unselect the reference you just added.

If that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in!)
 
Back
Top