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 CodFicheTblGenerale, NumeroFicheTblGenerale, NomFicheTblGenerale, GrandsThemesTblGenerale, SousThemesTblGenerale, ObjectifsTblGenerale, FinanceurTblGenerale, SourceTblGenerale, EtatFinancementTblGenerale, FROM TblGenerale Where TblGenerale!CodFicheTblGenerale <> 0 "
If Not Me.chknum Then
SQL = SQL & "And TblGenerale!NumeroFicheTblGenerale like '*" & Me.txtnum & "*' "
End If
If Not Me.chktitre Then
SQL = SQL & "And TblGenerale!NomFicheTblGenerale like '*" & Me.txttitre & "*' "
End If
If Not Me.chketat Then
SQL = SQL & "And TblGenerale!EtatFinancementTblGenerale = '" & Me.cmbetat & "' "
End If
If Not Me.chkfinanceur Then
SQL = SQL & "And TblGenerale!FinanceurTblGenerale = '" & Me.cmbfinanceur & "' "
End If
If Not Me.chksource Then
SQL = SQL & "And TblGenerale!SourceTblGenerale = '" & Me.cmbsource & "' "
End If
If Not Me.chkgdtheme Then
SQL = SQL & "And TblGenerale!GrandsThemesTblGenerale = '" & Me.cmbgdtheme & "' "
End If
If Not Me.chksstheme Then
SQL = SQL & "And TblGenerale!SousThemesTblGenerale = '" & Me.cmbsstheme & "' "
End If
If Not Me.chkobj Then
SQL = SQL & "And TblGenerale!ObjectifsTblGenerale like '*" & Me.txtobj & "*' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblstats.Caption = DCount("*", "TblGenerale", SQLWhere) & " / " & DCount("*", "TblGenerale")
Me.lstresults.RowSource = SQL
Me.lstresults.Requery
End Sub |
Partager