SELECT command syntax error

[abdoudiaw]

Hi,
Please help with this SELECT command:

Dim sqlString As String
Dim rs As DAO.Recordset

sqlString = "SELECT * FROM tblUtilisateurs WHERE (tblUtilisateurs.CodeUtilisateur = Me.txtCodeUtilisateur AND tblUtilisateurs.MotDePasse = Me.txtMotDePasse);"
Set rs = CurrentDb.OpenRecordset(sqlString)

Error Message : "Execution error 3061: too few parameters. 3 expected."

Thanks.

 

[bob fitz]

Just guessing, try:
sqlString = "SELECT * FROM tblUtilisateurs WHERE (tblUtilisateurs.CodeUtilisateur =" & Me.txtCodeUtilisateur & " AND tblUtilisateurs.MotDePasse =" & Me.txtMotDePasse & ");"
If txtCodeUtilisateur or txtMotDePasse are NOT numeric you may need:
sqlString = "SELECT * FROM tblUtilisateurs WHERE (tblUtilisateurs.CodeUtilisateur ='" & Me.txtCodeUtilisateur & "' AND tblUtilisateurs.MotDePasse ='" & Me.txtMotDePasse & "');"

 

[abdoudiaw]

Thanks Bob,
This looks better but the instruction
Set rs = CurrentDb.OpenRecordset(sqlString)
is still not happy: "too few parameters. Expecting 1"
Yes txtCodeUtilisateur, txtMotDePasse are text strings.
Thanks.

 

[bob fitz]

Perhaps you could step through the code at run time and check if either txtCodeUtilisateur or txtMotDePasse are null or ZLS.

 

[abdoudiaw]

Thanks Guys,
I found out: one field was misspelled.
Thanks a lot.

 

[bob fitz]

Thanks Guys,
I found out: one field was misspelled.
Thanks a lot.

Glad we could help