Undefined function problem

[Michael D. McGill]

I have a query in a database that runs fine on my machine. When I copy it to
other users machines they get the following error when they try to run the
query:

Undefined function 'FORMAT' in expression.

To resolve it I have to go into Modules/Tools/References and uncheck the box
that says Missing:Microsoft Windows Common Controls.

I am not sure why I do not get this error on my machine but all clients that
I roll it out to do. Is there a way to permanently resolve this issue on the
client machines? How do I get theis Missing component on their PC?

Thanks in Advance,
Mike

 

[John Spencer (MVP)]

The easiest way if you are not using Microsoft Windows Common Controls in your
application is to remove it from the library references for the application on
YOUR computer. That doesn't change whether the library is available for other
applications.