Undefined Function Error

[JonMCrouch]

I am developing in access 2002 on a win98 2nd edition machine. When I
transfer my database to a Windows XP Professional Machine running Access 2002
I encounter errors. For Example the code:

SQLStmt = "SELECT * FROM [GL Transactions] WHERE Left([GL ID],6) = '" & Temp
& "' ORDER BY [GL ID]"
Set GL = CurDb.OpenRecordset(SQLStmt, dbOpenDynaset)

When run this code produces an Undefined Function Error for the Function
'Left' on the XP machine but executes properly on the Win 98 Machine.

I have checked the references and they are the same and in the same order.
Any Ideas

 

[Douglas J. Steele]

You say that the references are the same and in the same order. Does that
mean that none are marked as "MISSING:"?

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)