Runs on Theirs, Not on Mine

[Christopher Weaver]

A query designed by someone else includes the following:

SELECT Left([Period],4) AS YR

It runs on my client's machine but not on mine. The error message I get is

Function isn't available in expressions in query expression
'Left([Period],4) '.

I'm running Access 97 SR-2 on WinXP. My client is running Access 97 SR-2 on
Win 95. Any ideas will be gratefully appreciated.

 

[Duane Hookom]

Almost always a references issue. Allen Browne has information and links
from his page http://allenbrowne.com/ser-38.html.

 

[Christopher Weaver]

Thanks. I've looked at his and another that he references on his site. He
also has a link to an MS site I'll check out as well.

There's a lot of stuff about this situation that is really bizarre, but the
bottom line turns out to be that on my client's machines Excel 8.0 is
referenced, whereas, on mine, Excel 10 was referenced. What's disturbing
about this is that the application lost its reference to Excel 8.0 when
copied to my machine; instead of marking it as referenced but missing it
simply said "Hey, here's an Excel library; let's use this one!" Not a wise
choice.

So I asked my client to send the Excel 8.0 library to me and now all is
well.

Almost always a references issue. Allen Browne has information and links
from his page http://allenbrowne.com/ser-38.html.

--
Duane Hookom
MS Access MVP

A query designed by someone else includes the following:

SELECT Left([Period],4) AS YR

It runs on my client's machine but not on mine. The error message I get
is

Function isn't available in expressions in query expression
'Left([Period],4) '.

I'm running Access 97 SR-2 on WinXP. My client is running Access 97 SR-2
on Win 95. Any ideas will be gratefully appreciated.