Function Quote(str As String) If IsNull(str) Then Quote = "''" Else Quote = "'" & Replace(str, "'", "''") & "'" End If End Function
sql = "SELECT * FROM Employés where Nom= Quote(combo1.text);"
sql = "SELECT * FROM Employés where Nom= " & Quote(Text1) & ";"
sql = "SELECT * FROM Employés where Nom= " & Quote(<s>Text1</s>) & ";"
sql = "SELECT * FROM Employés where Nom= " & Quote(combo1.text) & ";"