Function is not available in query expressions

[Guest]

In Access97, I use the following expression in a query: OHRT: "IIf(Right([ShopOrderNumber],3)="999",Val([regulartime]),0)". On my computer it works fine, but on all other computers in our network, it generates an error that the function is not available in query expression (Error 3075)

I run Visual Basic 6.0 on my machine, and I tried installing it on another machine to see if that is why I can use the expression but no one else, but that is not working either.

Does anyone know why this is happening? All the 97 service packs are installed on the machines. I even tried reloading Office using the same disk as my machine, but to no avail.

 

[Wayne Morgan]

This sounds like an error with References. Compare the ones on your computer
to the ones on the other computer. You can access the References by opening
a code window (Alt+F11) and going to Tools|References. You will find more
information on this here:

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
Microsoft Access MVP

In Access97, I use the following expression in a query: OHRT:

"IIf(Right([ShopOrderNumber],3)="999",Val([regulartime]),0)". On my computer
it works fine, but on all other computers in our network, it generates an
error that the function is not available in query expression (Error 3075).

I run Visual Basic 6.0 on my machine, and I tried installing it on another

machine to see if that is why I can use the expression but no one else, but
that is not working either.

Does anyone know why this is happening? All the 97 service packs are

installed on the machines. I even tried reloading Office using the same disk
as my machine, but to no avail.