topic Re: FindFirst Question in VBA Forum

FindFirst Question

Anonymous — Wed, 01 Aug 2001 04:59:12 GMT

I am using th following code:
rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'")
in VB 6.0 to find a specific record in a recordset. This works fine unless
that record is not present. I want to return a value of zero if the record I
wish to find is not there. How do I do it???

TIA,

--A.T.

Re: FindFirst Question

Anonymous — Wed, 01 Aug 2001 04:59:27 GMT

dim test as interger
if rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'") = "" then
test = 0
end if

should work

Adam Thomas wrote in article
...
> I am using th following code:
> rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'")
> in VB 6.0 to find a specific record in a recordset. This works fine
unless
> that record is not present. I want to return a value of zero if the
record I
> wish to find is not there. How do I do it???
>
> TIA,
>
> --A.T.
>
>
>

Re:

Anonymous — Wed, 01 Aug 2001 05:31:11 GMT

That gives me a "Complie error: Expected function or variable" message.

"Jaime" wrote in message
news:01c11a8a$08e61530$2c6464c0@pfieng04...
> dim test as interger
> if rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'") = "" then
> test = 0
> end if
>
> should work
>
>
>
> Adam Thomas wrote in article
> ...
> > I am using th following code:
> > rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'")
> > in VB 6.0 to find a specific record in a recordset. This works fine
> unless
> > that record is not present. I want to return a value of zero if the
> record I
> > wish to find is not there. How do I do it???
> >
> > TIA,
> >
> > --A.T.
> >
> >
> >

Re: FindFirst Question

Anonymous — Wed, 01 Aug 2001 05:31:44 GMT

You could test if a record was found using the .NoMatch property and return
the appropriate value.

Adam Thomas wrote in message
news:ADDB5AB8B3074F174C5E05487ECB013B@in.WebX.maYIadrTaRb...
> I am using th following code:
> rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'")
> in VB 6.0 to find a specific record in a recordset. This works fine unless
> that record is not present. I want to return a value of zero if the record
I
> wish to find is not there. How do I do it???
>
> TIA,
>
> --A.T.
>
>

Re:

Anonymous — Wed, 01 Aug 2001 06:59:50 GMT

Thanks!

"Marty" wrote in message
news:6C4BFBCA26FEDE13ED365A6C0EEA7B0F@in.WebX.maYIadrTaRb...
> You could test if a record was found using the .NoMatch property and
return
> the appropriate value.
>
>
> Adam Thomas wrote in message
> news:ADDB5AB8B3074F174C5E05487ECB013B@in.WebX.maYIadrTaRb...
> > I am using th following code:
> > rstInvUsed.FindFirst ("Size = '" & cboSize.Text & "'")
> > in VB 6.0 to find a specific record in a recordset. This works fine
unless
> > that record is not present. I want to return a value of zero if the
record
> I
> > wish to find is not there. How do I do it???
> >
> > TIA,
> >
> > --A.T.
> >
> >
>
>