Option Compare Database
Option Explicit
Private Sub chkDate_Click()
If Me.chkDate Then
Me.cmbRechDate.Visible = False
Else
Me.cmbRechDate.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkDic_Click()
If Me.chkDic Then
Me.txtRechDic.Visible = False
Else
Me.txtRechDic.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkRef_Click()
If Me.chkRef Then
Me.txtRechRef.Visible = False
Else
Me.txtRechRef.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkDest_Click()
If Me.chkDest Then
Me.txtRechDest.Visible = False
Else
Me.txtRechDest.Visible = True
End If
RefreshQuery
End Sub
Private Sub cmbRechDate_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT Date_Dep, DIC, Ref, No_Dest, Quantité, REP_BON, Rep_CRPR, Pret, Coût_pret, Délai_annoncé, Prix_journalier, Date_arret, Economie FROM T_Marseille Where T_Marseille!DIC <> 0"
If Not Me.chkDate Then
SQL = SQL & "And T_Marseille!Date_Dep = '" & Me.cmbRechDate & "' "
End If
If Not Me.chkDic Then
SQL = SQL & "And T_Marseille!DIC like '*" & Me.txtRechDic & "*' "
End If
If Not Me.chkRef Then
SQL = SQL & "And T_Marseille!Ref like '*" & Me.txtRechRef & "*' "
End If
If Not Me.chkDest Then
SQL = SQL & "And T_Marseille!No_Dest like '*" & Me.txtRechDest & "*' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblStats.Caption = DCount("*", "T_Marseille", SQLWhere) & " / " & DCount("*", "T_Marseille", SQLWhere)
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub
Private Sub Form_Load()
Dim ctl As Control
For Each ctl In Me.Controls
Select Case Left(ctl.Name, 3)
Case "chk"
ctl.Value = -1
Case "lbl"
ctl.Caption = "-*-*-"
Case "txt"
ctl.Visible = False
ctl.Value = ""
Case "cmb"
ctl.Visible = False
End Select
Next ctl
Me.lstResults.RowSource = "SELECT Date_Dep, DIC, Ref, No_Dest, Quantité, REP_BON, Rep_CRPR, Pret, Coût_pret, Délai_annoncé, Prix_journalier, Date_arret, Economie FROM T_Marseille;"
Me.lstResults.Requery
End Sub
Partager