Access 97 Query + WinXP = Error 1

[jbehrne]

Hi all,

I have a database running fine on every Windows OS - except WinXP. The database is in Access 97... Here is the query field that is giving me trouble:

ChargeTruncated: IIf([DecPos]=0,[TxtChargeX100],Left([ChargeX100],[DecPos]-1))

When the database is run on a WinXP computer I get this error message:

Function isn't available in expressions in query expression
ChargeTruncated: IIf([DecPos]=0,[TxtChargeX100],Left([ChargeX100],[DecPos]-1))

If I breakdown the expression the offending party is this statement:

Left([ChargeX100], [DecPos]-1)

Has anyone else had an issue with the Left expression? Any ideas? Thanks for any help,

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[lupins46]

You need to check the references on the problem machine.
Open any module in design view and choose Tools>References from the menu.
If any are marked as missing note what they are, uncheck them, close the dialog, open it again and select the 'missing' entries again from the list.

Compile the application to check that the problem is resolved.

 

[jbehrne]

lupins46,

Thanks for the help. I should have thought of that first -I was missing the Microsoft Visual Basic Applications Extensibility refernce... Now I feel like a big idiot!

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations