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
|
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT NumTableau, Public_prive, AnScolaire, DegreEnseign, TypeEtablissement, TypePersonne, TypeDonnees, TypeDiplome FROM Tableaux statistiques Where Tableaux statistiques!NumTableau <> 0 "
If Me.chknumtabl Then
SQL = SQL & "And Tableaux statistiques!NumTableau like '*" & Me.cmbrechnumtabl & "*' "
End If
If Me.Chkpubpriv Then
SQL = SQL & "And Tableaux statistiques!Public_prive like '*" & Me.cmbrechpubpriv & "*' "
End If
If Me.chkannscol Then
SQL = SQL & "And Tableaux statistiques!AnScolaire like '*" & Me.txtrechannscol & "*' "
End If
If Me.chkdegrens Then
SQL = SQL & "And Tableaux statistiques!DegreEnseign like '*" & Me.cmbrechdegrens & "*' "
End If
If Me.chktypeetab Then
SQL = SQL & "And Tableaux statistiques!TypeEtablissement like '" & Me.cmbrechtypeetab & "' "
End If
If Me.chktyppers Then
SQL = SQL & "And Tableaux statistiques!TypePersonne like '*" & Me.cmbrechtyppers & "*' "
End If
If Me.chktypdonn Then
SQL = SQL & "And Tableaux statistiques!TypeDonnees like '*" & Me.cmbrechtypdonn & "*' "
End If
If Me.chktypdipl Then
SQL = SQL & "And Tableaux statistiques!TypeDiplome = '" & Me.cmbrechtypdipl & "' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblStats.Caption = DCount("*", "Tableaux statistiques", SQLWhere) & " / " & DCount("*", "Tableaux statistiques")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub |
Partager