Help with querying a recordset...

Help with querying a recordset...

Post by Rapier W » Fri, 16 Feb 1996 04:00:00



Here is a code fragment

RecvStock.Recordset.MoveFirst
...
Criteria$ = "ModelNum = '"+ModlNum+"', PONum = '"+POBox.Caption+"'"
RecvStock.Recordset.FindFirst Criteria$

I KNOW that the Criteria is wrong!  I want to know how to query it using
2 or more fields!  Please help me and send e-mail to me at:


Please don't post it here, I don't have the time to wade through all the
posts!

Thanks in advance!

                                        -- Brett Fattori

 
 
 

Help with querying a recordset...

Post by Joe Foster of Bo » Fri, 16 Feb 1996 04:00:00



> Here is a code fragment
> RecvStock.Recordset.MoveFirst
> ...
> Criteria$ = "ModelNum = '"+ModlNum+"', PONum = '"+POBox.Caption+"'"

Criteria$ = "ModelNum = '"+ModlNum+"' AND PONum = '"+POBox.Caption+"'"
                                      ^^^ Use the boolean operators!

> RecvStock.Recordset.FindFirst Criteria$
> I KNOW that the Criteria is wrong!  I want to know how to query it using
> 2 or more fields!  Please help me and send e-mail to me at:

> Please don't post it here, I don't have the time to wade through all the
> posts!

Then learn how to use your newsreader's filtering features, or
get one that has them.

Quote:> Thanks in advance!
>                                    -- Brett Fattori

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!