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 sql As String
Dim sqlWhere As String
Dim strStats As String
Dim iResult As Integer
sql = "SELECT Numproc,RefProc,LibelleProc,LibelleCateg,LibelleSousCateg " _
& "FROM dbo_tbProcedures,dbo_tbCategories,dbo_tbSousCateg WHERE dbo_tbProcedures!NumProc <> 0 " _
& "AND (dbo_tbProcedures.RefCateg=dbo_tbCategories.RefCateg) " _
& "AND (dbo_tbProcedures.RefSousCateg=dbo_tbSousCateg.RefSousCateg)"
If Me.ChkCateg Then
sql = sql & "AND (dbo_tbCategories.LibelleCateg = '" & Me.CbbCateg & "') "
End If
If Me.ChkSousCateg Then
sql = sql & "AND (dbo_tbSousCateg.LibelleSousCateg = '" & Me.CbbSousCateg & "') "
End If
If Me.ChkLibProc Then
sql = sql & "AND (dbo_tbProcedures.LibelleProc LIKE '*" & Me.TxtLibProc & "*') "
End If
If Me.ChkRefProc Then
sql = sql & "AND (dbo_tbProcedures.RefProc LIKE '*" & Me.TxtRefProc & "*') "
End If
sqlWhere = Trim(Right(sql, Len(sql) - InStr(sql, "WHERE") - Len("WHERE") + 1))
sql = sql & ";"
Me.LstResult.RowSource = sql
Me.LstResult.Requery
iResult = Me.LstResult.ListCount - 1
If iResult = -1 Then
strStats = String(1, "0")
Else
strStats = Me.LstResult.ListCount - 1
End If
strStats = strStats & "/" & DCount("*", "dbo_tbProcedures")
Me.LblStats.Caption = strStats |
Partager