Undefined Function Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,
the reason could be that on Windows XP Professional Machine running Access
2002 , even all reference there, but library wersion could be the same. to
fix this - remove all references but access, VBA, DAO, close reference
dialog and add references. then compile project
 
Back
Top