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
| Private Sub RefreshQuery()
On Error GoTo Err_RefreshQuery
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT numero_contrat, contenu, datefin, delai_resiliation, societe, service, fournisseur, code, date_paiment_theorique, date_paiement_effectif FROM rqy_contrat WHERE societe Is Not Null "
If Not Me.chkSociété Then
SQL = SQL & "And societe = '" & Me.cmbRechSociété & "' "
End If
If Not Me.chkFournisseur Then
SQL = SQL & "And fournisseur = '" & Me.cmbRechFournisseur & "' "
End If
If Not Me.chkNumero_contrat Then
SQL = SQL & "And numero_contrat = '" & Me.cmbRechNumero_contrat & "' "
End If
If Not Me.chkCode Then
SQL = SQL & "And code = '" & Me.cmbRechCode & "' "
End If
If Not Me.chkDate Then
SQL = SQL & "And date_paiment_theorique = #" & Format(Me.cmbRechDate, "mm/dd/yyyy") & "# "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
CurrentDB.QueryDefs("qryTemp").SQL = SQL
Me.lblStats.Caption = DCount("*", "rqy_contrat", SQLWhere) & " / " & DCount("*", "rqy_contrat")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
Exit_RefreshQuery:
Exit Sub
Err_RefreshQuery:
Resume Exit_RefreshQuery
End Sub |
Partager