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
| Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT numero, numero_QS, societe, chef_prenom, chef_nom, mission, Type_mission, code_mission, date_traitement, date_debut, date_fin, duree, budget, modalite FROM QS Where QS!numero <> 0 "
If Not Me.checknomchef Then
SQL = SQL & "And QS!chef_nom like '*" & Me.txtRechnom & "*' "
End If
If Not Me.Cocher1 Then
SQL = SQL & "And QS!societe = '" & Me.cmbRechsociete & "' "
End If
If Not Me.checkprenomchef Then
SQL = SQL & "And QS!chef_prenom like '*" & Me.txtRechprenom & "*' "
End If
If Not Me.Cocher7 Then
SQL = SQL & "And QS!interlocuteur = '" & Me.cmbRechinterlocuteur & "' "
End If
If Not Me.Cocher11 Then
SQL = SQL & "And QS!Type_mission = '" & Me.cmbRechtype_mission & "' "
End If
If Not Me.checkdebut Then
SQL = SQL & "And QS!date_debut >= #" & Format(Me.cmbRechdebut, "mm/dd/yyyy") & "# "
End If
If Not Me.checkfin Then
SQL = SQL & "And QS!date_fin =< #" & Format(Me.cmbRechfin, "mm/dd/yyyy") & "# "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblStats.Caption = DCount("*", "QS", SQLWhere) & " / " & DCount("*", "QS")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub |
Partager