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
|
Private Function ConditionOffre() As String
On Error GoTo Sortie
ConditionOffre = ""
Select Case Me.EtatSélectionné
Case 1
ConditionOffre = "[Index Proposition technique] = " & Me.Index_Proposition_technique
Case 2
ConditionOffre = ""
Case 3
ConditionOffre = ""
Case 4
ConditionOffre = "[Index réservoir] = " & Me.Index_réservoir
Case 5
ConditionOffre = "[Index Rep Diagrammes] = " & DéterminationDiagramme(Me.Taille, Me.Vaporisation, Me.Index_réservoir.Column(6))
'ConditionOffre = "[Index Rep Diagrammes] = " & Me.Taille
Case 6
ConditionOffre = "[Type] = 'AVPM'"
Case 7
ConditionOffre = "[Type] = '" & Me.Type_de_vaporiseur & "'"
Case 8
ConditionOffre = "[Réservoir] = '" & Me.Taille & "' AND [Vaporiseur] = '" & IIf(Me.Vaporisation = "Cryo", "Cryo", Me.Type_de_vaporiseur) & "' AND [Nombre de vaporiseurs] = " & Me.Nombre_de_vaporiseurs
Case 9
ConditionOffre = "[Vaporisation] = '" & Me.Vaporisation & "' AND [Nombre de vaporiseurs] = " & Me.Nombre_de_vaporiseurs
Case 10
ConditionOffre = "[Index Proposition technique] = " & Me.Index_Proposition_technique
Case 11
ConditionOffre = ""
Case 12
ConditionOffre = "[Index Proposition technique] = " & Me.Index_Proposition_technique
Case 13
ConditionOffre = "[Index Proposition technique] = '" & Me.Index_Proposition_technique & "' AND [Index réservoir] = '" & Me.Index_réservoir & "' AND [Index Rep Diagrammes] = '" & DéterminationDiagramme(Me.Taille, Me.Vaporisation, Me.Index_réservoir.Column(6)) & "' [Type] = '" & Me.Type_de_vaporiseur & "' AND [Réservoir] = '" & Me.Taille & "' AND [Vaporiseur] = '" & IIf(Me.Vaporisation = "Cryo", "Cryo", Me.Type_de_vaporiseur) & "' AND [Vaporisation] = '" & Me.Vaporisation & "' AND [Index Proposition technique] = '" & Me.Index_Proposition_technique & "'"
End Select
Sortie:
Exit Function
End Function |
Partager