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
| Private Sub RefreschQuery()
Dim Krit As String
Krit = ""
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT * FROM Recherche " 'where Recherche.ID <> 0"
If Not Me.KHT Then
SQL = SQL & "And ID = '" & Me.KombHT & " ' "
End If
If Not (Me.KProjet) Then
SQL = SQL & " And nomprojet LIKE '*" & Me.TxtProjet & "*'"
End If
If Not IsNull(Me.Kfirme) Then
SQL = SQL & " And nomfirme like '*" & Me.TxtFirme & "*'"
End If
If Not IsNull(Me.KDate) Then Krit = Krit & " AND Date >=" & Format(Me.TxtDatede, "tt-mm-jjjj") & ""
'End If
If Not IsNull(Me.KDate) Then Krit = Krit & " And Date <= " & Format(Me.TxtDatede, "tt-mm-jjjj") & ""
'End If
If Krit <> "" Then SQL = SQL & "WHERE " & Mid(Krit, 5)
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lststats.Caption = DCount("*", "Recherche", SQLWhere) & " / " & DCount("*", "Recherche", SQLWhere)
'Me.lststats.Caption = DCount("*", "Recherche", SQLWhere) & " / " & DCount("*", "Recherche")
Me.Lstrecherche.RowSource = SQL
Me.LstRecherche.Requery |
Partager