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
| Private Sub RefreshQuery()
Dim strSQL As String
Dim SQLWhere As String
Dim codeD As Integer
Dim codeT As Integer
Dim S As String
S = Me.RecordSource
strSQL = "SELECT * FROM t_activite WHERE id<>0"
If Me.chkFiltrageDiscipline Then
codeD = Me.cboDiscipline
If codeD <> 1 Then
strSQL = strSQL & " AND code_discipline=" & codeD
End If
End If
If Me.chkFiltrageType Then
codeT = Me.cboType
If codeT <> 1 Then
strSQL = strSQL & " AND code_type=" & codeT
End If
End If
SQLWhere = Trim(Right(strSQL, Len(strSQL) - InStr(strSQL, "WHERE ") - Len("WHERE ") + 1))
strSQL = strSQL & " ORDER BY intitule;"
' mise à jour du résultats
Me.lblResultats.Caption = DCount("*", "t_activite", SQLWhere) & " / " & DCount("*", "t_activite")
' mise à jour du listing des activités
Me.RecordSource = strSQL
End Sub |
Partager