Prev: Export filtered records
Next: Form different size in form view vs design view
From: Dadders on 5 Dec 2009 18:58
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
From: Tom van Stiphout on 5 Dec 2009 22:17
On Sat, 5 Dec 2009 15:58:01 -0800, Dadders
<Dadders(a)discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP


>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
From: silvinha on 8 Dec 2009 20:17

"Dadders" <Dadders(a)discussions.microsoft.com> escreveu na mensagem
news:9AC62560-1230-4F18-A598-3F5110666C40(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Export filtered records
Next: Form different size in form view vs design view