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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
|
Option Compare Database
Private Sub chkNom_Click()
If Me.chkNom Then
Me.cmbNom.Visible = False
Else
Me.cmbNom.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkService_Click()
If Me.chkService Then
Me.cmbService.Visible = False
Else
Me.cmbService.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkFournisseur_Click()
If Me.chkFournisseur Then
Me.cmbFournisseur.Visible = False
Else
Me.cmbFournisseur.Visible = True
End If
RefreshQuery
End Sub
Private Sub chkDate_Click()
If Me.chkDate Then
Me.txtDate.Visible = False
Else
Me.txtDate.Visible = True
End If
RefreshQuery
End Sub
Private Sub cmbNom_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub cmbService_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub cmbFournisseur_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub txtDate_BeforeUpdate(Cancel As Integer)
RefreshQuery
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 userName, nomService, fournisseur, dateEncodage FROM T_BonDeCommande, T_Users, T_Services, T_Fournisseurs WHERE userID=noAgent AND T_Services!noService=T_BonDeCommande!noService AND T_Fournisseurs!noFournisseur=T_BonDeCommande!noFournisseur;"
Me.lstResults.Requery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT userName, nomService, fournisseur, dateEncodage FROM T_BonDeCommande, T_Users, T_Services, T_Fournisseurs WHERE userID=noAgent AND T_Services!noService=T_BonDeCommande!noService AND T_Fournisseurs!noFournisseur=T_BonDeCommande!noFournisseur AND T_BonDeCommande!noBDC <> 0"
If Not Me.chkNom Then
SQL = SQL & "And T_Users!userName = '" & Me.cmbNom & "'"
End If
If Not Me.chkService Then
SQL = SQL & "And T_Services!nomService = '" & Me.cmbService & "'"
End If
If Not Me.chkFournisseur Then
SQL = SQL & "And T_Fournisseurs!fournisseur = '" & Me.cmbFournisseur & "'"
End If
If Not Me.chkDate Then
SQL = SQL & "And T_BonDeCommande!dateEncodage like '*" & Me.txtDate & "*' "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
'Me.lblStats.Caption = DCount("*", "T_BonDeCommande", SQLWhere) & " / " & DCount("*", "noBDC")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub
'Private Sub lstResults_DblClick(Cancel As Integer)
'
'DoCmd.OpenForm "frmAutoMedias", acNormal, , "[CodMedia] = " & Me.lstResults
'
'
'End Sub |
Partager