Code: Select all
RS1.MoveFirst
RS1.Find "RIGHT(MATRICOLA,5)='" & Right(CODICE_MATR, 5) & "'"
Code: Select all
RS1.MoveFirst
RS1.Find "RIGHT(MATRICOLA,5)='" & Right(CODICE_MATR, 5) & "'"
Code: Select all
RS1.Find "Last5='" & Right(CODICE_MATR, 5) & "'"
I just have post this question many time...HansV wrote: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
If you use DAO instead of ADO, you can use FindFirst which does support expressions such as you're trying to use.Code: Select all
RS1.Find "Last5='" & Right(CODICE_MATR, 5) & "'"