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
| Option Compare Database
Option Explicit
'Variables de changement des liste
Private m_blnZ1Change As Boolean
Private m_blnZ2Change As Boolean
Private m_blnZ3Change As Boolean
Private m_blnZ4Change As Boolean
Private m_blnZ5Change As Boolean
'Variables de valeurs des liste
Private m_strZ1Valeur As String
Private m_strZ2Valeur As String
Private m_strZ3Valeur As String
Private m_strZ4Valeur As String
Private m_strZ5Valeur As String
Private Sub Form_Load()
Call RemplirListes
zdl1 = "Toutes"
zdl2 = "Toutes"
zdl3 = "Toutes"
zdl4 = "Toutes"
zdl5 = "Tous"
End Sub
Private Sub RemplirListes()
zdl1.RowSource = "SELECT DISTINCT Departement FROM Recap1 UNION SELECT " & _
Chr(34) & "- Tous -" & Chr(34) & " AS Departement FROM Recap1);"
zdl2.RowSource = "SELECT DISTINCT ... UNION"
zdl3.RowSource = "SELECT DISTINCT ... UNION"
zdl4.RowSource = "SELECT DISTINCT ... UNION"
zdl5.RowSource = "SELECT DISTINCT ... UNION"
End Sub
Private Sub RafraichirListe(Z1Change As Boolean, Z2Change As Boolean, Z3Change _
As Boolean, Z4Change As Boolean, Z5Change As Boolean, m_strZ1Valeur As String, _
m_strZ2Valeur As String, m_strZ3Valeur As String, m_strZ4Valeur As String, _
m_strZ5Valeur As String)
If Z1Change Then
zdl1.RowSource = _
"SELECT DISTINCT Departement FROM Recap1 ... WHERE LeChamp = " & _
m_strZ1Valeur & " ... UNION SELECT " & Chr(34) & "- Tous -" & Chr(34) & _
" AS Departement FROM Recap1);"
Else
zdl1.RowSource = "SELECT DISTINCT Departement FROM Recap1 UNION SELECT " & _
Chr(34) & "- Tous -" & Chr(34) & " AS Departement FROM Recap1);"
End If
If Z2Change Then
zdl2.RowSource = "SELECT DISTINCT ... WHERE LeChamp = " & m_strZ2Valeur & _
" ... UNION"
Else
zdl2.RowSource = "SELECT DISTINCT Champs... FROM Table UNION SELECT " & _
Chr(34) & "- Tous -" & Chr(34) & " AS ...."
End If
'''Etc...
End Sub
Private Sub zdl1_Change()
m_blnZ1Change = True
m_strZ1Valeur = Me!zdl1
Call RafraichirListe(True, False, False, False, False, m_strZ1Valeur, _
m_strZ2Valeur, m_strZ3Valeur, m_strZ4Valeur, m_strZ5Valeur)
m_blnZ1Change = False
End Sub
Private Sub zdl2_Change()
m_blnZ2Change = True
m_strZ2Valeur = Me!zdl1
Call RafraichirListe(False, True, False, False, False, m_strZ1Valeur, _
m_strZ2Valeur, m_strZ3Valeur, m_strZ4Valeur, m_strZ5Valeur)
m_blnZ2Change = False
End Sub
Private Sub zdl3_Change()
m_blnZ3Change = True
m_strZ3Valeur = Me!zdl1
Call RafraichirListe(False, False, True, False, False, m_strZ1Valeur, _
m_strZ2Valeur, m_strZ3Valeur, m_strZ4Valeur, m_strZ5Valeur)
m_blnZ3Change = False
End Sub
Private Sub zdl4_Change()
m_blnZ4Change = True
m_strZ4Valeur = Me!zdl1
Call RafraichirListe(False, False, False, True, False, m_strZ1Valeur, _
m_strZ2Valeur, m_strZ3Valeur, m_strZ4Valeur, m_strZ5Valeur)
m_blnZ4Change = False
End Sub
Private Sub zdl5_Change()
m_blnZ5Change = True
m_strZ5Valeur = Me!zdl1
Call RafraichirListe(False, False, False, False, True, m_strZ1Valeur, _
m_strZ2Valeur, m_strZ3Valeur, m_strZ4Valeur, m_strZ5Valeur)
m_blnZ5Change = False
End Sub |
Partager