What's happened to the findfirst function in Access 2010?

  • Thread starter Thread starter Dadders
  • Start date Start date
D

Dadders

I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a table
runing the following VBA code:
With Me.Recordset
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
Exit Sub
End If
.... FURTHER PROCESSING ...

What must I do to correct this? Go through a record by record search?
End With
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset). In 2010, it stops at record 79
 
On Sat, 5 Dec 2009 15:58:01 -0800, Dadders

What are the values of fld1 and fld2 in both scenarios?

-Tom.
Microsoft Access MVP
 
Dadders said:
I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a
table
runing the following VBA code:
With Me.Recordset
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
Exit Sub
End If
... FURTHER PROCESSING ...

What must I do to correct this? Go through a record by record search?
End With
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset). In 2010, it stops at record 79
Click to expand...
 
Back
Top