.FIND whit criteria...right 5

[sal21]

i use this code to find in recordset but not work, as usula:(

Code: Select all

RS1.MoveFirst
RS1.Find "RIGHT(MATRICOLA,5)='" & Right(CODICE_MATR, 5) & "'"

in effect in need to find in right 5 of field MATRICOLA...

[HansV]

You can't use a calculated expression as the first part of the argument to Find. It must be a field name.

You could create a query with a calculated column

Last5: Right(MATRICOLA,5)

You can then open a recordset on this query and use

Code: Select all

RS1.Find "Last5='" & Right(CODICE_MATR, 5) & "'"

If you use DAO instead of ADO, you can use FindFirst which does support expressions such as you're trying to use.

[sal21]

You can't use a calculated expression as the first part of the argument to Find. It must be a field name.

You could create a query with a calculated column

Last5: Right(MATRICOLA,5)

You can then open a recordset on this query and use

Code: Select all

RS1.Find "Last5='" & Right(CODICE_MATR, 5) & "'"

If you use DAO instead of ADO, you can use FindFirst which does support expressions such as you're trying to use.

I just have post this question many time...
But to find value in field wath is the best way in order of speeding search:

-a sql select with wehre
-a .find statement
-a .filter statement
-a seek
or?

in my case a need to scanning a value in a field/column with 14.000 rows!

[HansV]

A query (SQL statement) that selects the records you want is the most efficient way.