Private Sub bt_mots_Click() If zone.Text = "" Then Exit Sub Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '% & zone.Text & %'") tb.MoveFirst R = tb("mots") End Sub
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '" & w & "'")
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '%" & zone.Text & "%'")
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub bt_mots_Click() If zone.Text = "" Then Exit Sub Dim LikeSTring as String = "%" & zone.Text & "%" Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE 'LikeString'") tb.MoveFirst R = tb("mots") End Sub
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '" & LikeString & "'")
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '%unevraievaleurdetabdd%')
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots = 'abrasif'") Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '%abrasif%'")
Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE 'abrasif'") Set tb = db.OpenRecordset("SELECT * FROM mots WHERE mots LIKE '*abrasif*'")