Access 2003 to 2013 query

[Max P]

I have resisted converting from Access 2003 to 2013 for some time as I find 2003 more user friendly. However I now need to take the plunge. I have converted my 2003 database, relinked all the tables but i am constantly getting an error when I use the vba 'Findfirst' command. I am getting told 'Method or Data Member Not Found', this makes no sense and I can't see what is causing it. Can anybody help?

[pbaldy]

What is the actual code?

[Max P]

I have stripped the code right down to this:-



Dim Criteria As String, MyDB As Database, myset As Recordset


Set MyDB = DBEngine.Workspaces(0).Databases(0)
Set myset = MyDB.OpenRecordset("Test")
Criteria = "Keyfield = '" & [In] & "'"
myset.FindFirst Criteria



It seems quite happy with a 'Movefirst' statement but is now telling me that the operation is not supported for this type of object. The code is very old but works so I am loathe to rewrite too much. Thanks in anticipation for any help.

[pbaldy]

Try these tweaks:

Dim Criteria As String, MyDB As DAO.Database, myset As DAO.Recordset


Set MyDB = DBEngine.Workspaces(0).Databases(0)
Set myset = MyDB.OpenRecordset("Test", dbOpenDynaset)
Criteria = "Keyfield = '" & [In] & "'"
myset.FindFirst Criteria