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

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
 
T

Tom van Stiphout

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
 
S

silvinha

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top