by Yvan Mac » Sat, 17 Feb 2001 05:11:43
My problem is :
I use "findfirst" to find a record in a database. There is no problem if i
use one criterion (requirement ?).
But if i want to use two criterions, i've got an error.
What is the link to use between the two criterions ?
Thank you very much for your help
Yvan
by Steven Elliot » Sat, 17 Feb 2001 14:03:35
rs.FindFirst "Fieldname1 = Value1 AND Fieldname2 = Value2"
-Steven Elliott
Quote:> Sorry for my poor english but i'm... french
> My problem is :
> I use "findfirst" to find a record in a database. There is no problem if i
> use one criterion (requirement ?).
> But if i want to use two criterions, i've got an error.
> What is the link to use between the two criterions ?
> Thank you very much for your help
> Yvan
by Yvan Mac » Sun, 18 Feb 2001 06:17:20
I've made a mistake the first time because i put the word AND between ' " '
> rs.FindFirst "Fieldname1 = Value1 AND Fieldname2 = Value2"
> -Steven Elliott
> > Sorry for my poor english but i'm... french
> > My problem is :
> > I use "findfirst" to find a record in a database. There is no problem if
i
> > use one criterion (requirement ?).
> > But if i want to use two criterions, i've got an error.
> > What is the link to use between the two criterions ?
> > Thank you very much for your help
> > Yvan
1. Help: .FindFirst an fieldname with "-"
Situation:
i've got an access-database with a field-name that contains a "-". I don't
know how to use the .FindFirst-method on such kind of field-name.
I've tried the following:
members.findfirst "member-nr = " & 12345
and got the error-message:
"member" is not a valid field-name.
Thank you for helping
2. DBGrid control and column widths
4. Ingres connectivity to DB3 files
6. Empty Record between 2 Records
7. Help with "FindFirst" for Database
8. ADO recordset returns truncated memo field.
9. Help - Move to VB4, Now FindFirst doesn't work
10. Help with SQL and FindFirst!
12. FindFirst Help for Novice Programmer
13. Help: Database Findfirst string problem!