Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
>Dear Frinds,
>I am facing a problem in the .find syntax. I am trying to find a selected word from a DataCombo.text in the ADO or DAO but keep getting the same error
>
>"OPeration is not supported for this type of object"
>
>the syntax is :
>Data1.Recordset.FindFirst "username_a = cdUser.Text"
>I tried also with .Seek & have the same problem
>'Data1.Recordset.Seek "=", cdUser.Text
>
>Kindly, anyone can help..
>
>Regards
The correct syntax is:
Data1.Recordset.FindFirst "username_a = '" & cdUser.Text & "'"
The syntax on the Seek seems OK but you need to have an index set for the recordset that matches the expression you are searching for.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement