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
| With Frm_MC_CalendrierAnnuel
Dim NbrAcpt As Byte, NbrPmnt As Byte, NbrLivr As Byte
Dim i As Byte, Box As Byte, NbrChamps As Byte
Dim Valeur(3) As String, Champs As Variant
Dim Trouve As Boolean
Dim Message As String
NbrAcpt = Trim(Right(.Lbl_TotalAcompte.Caption, 2))
NbrPmnt = Trim(Right(.Lbl_TotalPaiement.Caption, 2))
NbrLivr = Trim(Right(.Lbl_TotalLivraison.Caption, 2))
Champs = Array("Acomptes", "Paiements", "Livraisons")
Valeur(1) = NbrAcpt
Valeur(2) = NbrPmnt
Valeur(3) = NbrLivr
For i = 1 To 3
If Valeur(i) > 12 Then
Trouve = True
NbrChamps = NbrChamps + 1
If Box = 0 Then Box = i
Message = Message & Choose(i, "Acomptes", "Paiements", "Livraisons") & vbCrLf
End If
Next i
If Trouve Then
MsgBox "Vous avez atteint la limite maximale de 12 enregistrements annuel sur " & IIf(NbrChamps > 1, "les champs suivants :", "sur le champ :") & vbCrLf & vbCrLf _
& Message, vbOKOnly + vbCritical, "Vérification"
Exit Sub
Else
' Enregistrer
End If
End With |
Partager