Jet Database Error

[guamlet]

I get the following error when running a FindNext command in VBA

"The Microsoft Jet Datase Engine Does not Recognize 'F010c' as a valid field name or expression".

I've run FindFirst on other tables, but I was looking for an indexed key number. This time I'm looking for a string that occurs in several different records in a given table. Is there a problem with looking for the string? Do I need some sort of converter command?

Thanks
Guamlet

 

[bat17]

Can you post the code that you are using? By the error msg it is trying to look in a field called F010c

peter

 

[guamlet]

Sure..

strSQL2 = "Select * from [Frozen]"
' Set rst2 = db.OpenRecordset(strSQL2)
' rst2.MoveLast
' Number = rst2.RecordCount
' rst2.MoveFirst
For j = 1 To Number
' rst2.Edit
' If lstFrozenName.Selected(j) = True Then
' rst2.FindNext "[Frozen Name]=" & lstFrozenName.Column(0, j)
' If dtDate <> "" Then
' rst2![Thaw Date] = dtDate
' Else
' rst2![Thaw Date] = Date
' End If
' End If
' rst2.Update
' Next j

The name of the table is Frozen, and the name of the field where FP010c is found is called "Frozen Name". FP010c is an entry in that field.

Thanks

Guamlet

 

[bat17]

I think that you should be using FindFirst still. You are only searching once on each record, FindNext is used without a qualifier to repeat the same search again.

HTH

Peter