DAO FindFirst Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have difficulties in assigning a criteria for a search, I'm using DAO and I get this error message "Syntax error (missing operator) in expression".
My expression is : rst.FindFirst "[fldDate] = #" & Date & "# & " & "[fldInsertDesign] = '" & rstInsertDiscard.Fields("fldInsertDesign") & "'"

Basically, the criteria is to match 2 fields (fldDate and fldInsertDesign) in the table with the values from current date and a fields from another recordset.
Please help.

Cheers,
Djoezz
 
Djoezz,

rst.FindFirst "[fldDate] = #" & Date & "# AND [fldInsertDesign] = '" &
rstInsertDiscard.Fields("fldInsertDesign") & "'"

should do it.

HTH,
Nikos

Djoezz said:
I have difficulties in assigning a criteria for a search, I'm using DAO
Click to expand...
and I get this error message "Syntax error (missing operator) in
expression".
My expression is : rst.FindFirst "[fldDate] = #" & Date & "# & " &
Click to expand...
"[fldInsertDesign] = '" & rstInsertDiscard.Fields("fldInsertDesign") & "'"
Basically, the criteria is to match 2 fields (fldDate and fldInsertDesign)
Click to expand...
in the table with the values from current date and a fields from another
recordset.
 
rst.FindFirst "[fldDate] = #" & Date & "# AND [fldInsertDesign] = '" &
rstInsertDiscard.Fields("fldInsertDesign") & "'"

should do it.
Click to expand...

Not outside the USA it won't.


Tim F
 
Thanks Nikos
I'll give it a try,..

Tim
you mean the date format difference, right? I'll work on that ...thanks.
 
Tim,
you mean the date format difference, right?
Click to expand...

Yes. When sending stuff to SQL, it's advisable to bypass all the regional
setting stuff and format the things yourself:

strWhere = "fldDate = " & Format$(Date(), "\#yyyy\-mm\-dd\#")
strWhere = strWhere & " AND ...."

rst.FindFirst strWhere

B Wishes


Tim F
 
Back
Top