IIf statement in Union Qurey not working on ONE computer

[shacket]

I have an IIf statement in a Union Query that has been working fine forever. (Isn't this always the way?!) On ONE user's computer, this IIf statement doesn't work (causes an error). I have checked the VB references and they are all there (although I had problems with a missing reference on her computer before). I have double checked the problem on other computers and they all work with her login. Only on HER computer, does this not work.

Any ideas?

 

[simongallop]

Ian addition to checking that the correct references are there, check that there aren't any extra references.

 

[shacket]

I literally read the references from one computer and checked hers. The references are identical.

Any other ideas?

 

[simongallop]

What's the error?

 

[shacket]

It is:

Function is not available in expressions in query expression 'The IIf Statement'

 

[simongallop]

This has happened to me. Reasons have been either, missing library, too many libraries or different version of libraries. Main culprite has been Office 9 library

 

[shacket]

That was it. I took the Word 9.0 library out and everything is fine. Thank you VERY much!