1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
| Private Sub RefreshQuery()
SQL = "SELECT ID_Perso, Name, First_Name, Job_Title, Location, Language, Status, Salary, Last_PRP, Strenght, Weaknesses FROM requete_rechmulti Where requete_rechmulti.ID_Perso <>0 "
If Not Me.chkJobTitle Then
SQL = SQL & "And requete_rechmulti!Job_Title = '" & Me.cmbRechJobTitle & "' "
End If
If Not Me.chkLocation Then
SQL = SQL & "And requete_rechmulti!Location = '" & Me.cmbRechLocation & "' "
End If
If Not Me.chkLanguage Then
SQL = SQL & "And requete_rechmulti!Language = '" & Me.lstLanguage & "' "
Dim v As Variant
Dim temp As String
'Crée la liste des éléments
For Each v In Me.lstLanguage.ItemsSelected
temp = temp & Chr(34) & v & Chr(34) & ","
Next v
If temp <> "" Then
'Supprime la dernière virgule et ajoute au critere
temp = Left(temp, Len(temp) - 1)
SQL = SQL & " AND MonChamp IN (" & temp & ") "
End If
MsgBox SQL
End If
If Not Me.chkStatus Then
SQL = SQL & "And requete_rechmulti!Status = '" & Me.cmbRechStatus & "' "
End If
If Not Me.chkSalary Then
SQL = SQL & "And requete_rechmulti!Salary like '*" & Me.txtSalary & "*' "
End If
If Not Me.chkPRP Then
SQL = SQL & "And requete_rechmulti!Last_PRP like '*" & Me.txtPRP & "*' "
End If
If Not Me.chkStrenght Then
SQL = SQL & "And requete_rechmulti!Strenght = '" & Me.lstStrenght & "' "
End If
If Not Me.chkWeaknesses Then
SQL = SQL & "And requete_rechmulti!Weaknesses = '" & Me.lstWeaknesses & "' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lstResults.RowSource = SQL
Me.lstResults.Requery |
Partager