DaFou
asked on
Me.Recordset.FindFirst does not work in access 97
Me.Recordset.FindFirst "SomeField = 'SomeValue'" does work in access 2003 but not in access 97/
How do i get this to work in access 97?
How do i get this to work in access 97?
Oh, and please check the code references - what data access library is used in your app?
1. Microsoft DAO 3.x Object Library (that is DAO) or
2. Microsoft Activex Data Objects 2.x Library (that would be ADO)
broesi
1. Microsoft DAO 3.x Object Library (that is DAO) or
2. Microsoft Activex Data Objects 2.x Library (that would be ADO)
broesi
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
shanesuebsahakarn is right! Didn't see that one...
Please note that the recordsetclone-property always returns an DAO-recordset - even in Access 2003. In order to use this, you need to create a reference to the DAO-library (which is not automatically there).
The recordset var has to be declared like this:
dim rst as dao.recordset
HTH,
broesi
Please note that the recordsetclone-property always returns an DAO-recordset - even in Access 2003. In order to use this, you need to create a reference to the DAO-library (which is not automatically there).
The recordset var has to be declared like this:
dim rst as dao.recordset
HTH,
broesi
ASKER
i am sorry broesi, shane hit the jackpot deadon
Access 2003 uses ADO as the default data access library. ADO does not support the FindFirst-method (it only has a find-method).
Access 97 uses DAO, which surely has the findfirst-method for recordset objects.
Could you post the code that is causing problems?
broesi