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
| '--------------------------------------------------------------------------------------------------
'Affichage du Graphique IsoOffset en fonction des cases à cocher (U_Offset, U_Spanplus, U_Spanminus)
'--------------------------------------------------------------------------------------------------
If [Forms]![frm_moduleanalyse]![cac_UOffset] = True And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = False And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = False Then
strSQL = "SELECT ID_Appareil, U_Offset, To_U_Offset_Min,To_U_Offset_Max, Moyenne_U_Offset"
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = True And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = True And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = False Then
strSQL = "SELECT ID_Appareil, U_Offset, To_U_Offset_Min,To_U_Offset_Max, Moyenne_U_Offset, U_SpanPlus, To_U_Offset_SpanPlus_Min, To_U_Offset_SpanPlus_Max, Moyenne_U_SpanPlus"
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = True And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = True And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = True Then
strSQL = "SELECT ID_Appareil, U_Offset, To_U_Offset_Min,To_U_Offset_Max, Moyenne_U_Offset, U_SpanPlus, To_U_Offset_SpanPlus_Min, To_U_Offset_SpanPlus_Max, Moyenne_U_SpanPlus, U_SpanMinus, To_U_Offset_SpanMinus_Min, To_U_Offset_SpanMinus_Max, Moyenne_U_SpanMinus "
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = False And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = True And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = True Then
strSQL = "SELECT ID_Appareil, U_SpanPlus, To_U_Offset_SpanPlus_Min, To_U_Offset_SpanPlus_Max, Moyenne_U_SpanPlus, U_SpanMinus, To_U_Offset_SpanMinus_Min, To_U_Offset_SpanMinus_Max, Moyenne_U_SpanMinus "
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = False And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = True And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = False Then
strSQL = "SELECT ID_Appareil, U_SpanPlus, To_U_Offset_SpanPlus_Min, To_U_Offset_SpanPlus_Max,Moyenne_U_SpanPlus"
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = False And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = False And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = True Then
strSQL = "SELECT ID_Appareil, U_SpanMinus, To_U_Offset_SpanMinus_Min, To_U_Offset_SpanMinus_Max, Moyenne_U_SpanMinus"
strSQL = strSQL & " FROM Table_TamponIsoOffset "
ElseIf [Forms]![frm_moduleanalyse]![cac_UOffset] = True And [Forms]![frm_moduleanalyse]![cac_USpanPlus] = False And [Forms]![frm_moduleanalyse]![cac_USpanMinus] = True Then
strSQL = "SELECT ID_Appareil, U_Offset, To_U_Offset_Min,To_U_Offset_Max, Moyenne_U_Offset,U_SpanMinus,To_U_Offset_SpanMinus_Min, To_U_Offset_SpanMinus_Max, Moyenne_U_SpanMinus "
strSQL = strSQL & " FROM Table_TamponIsoOffset "
End If
'--------------------------------------------------------------------------------------------------
'Mise à jour du graphique ("Gra_EvolutionIsoOffset")
'--------------------------------------------------------------------------------------------------
Me.Gra_EvolutionIsoOffset.RowSource = strSQL
Me.Gra_EvolutionIsoOffset.Requery |
Partager