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
| Public Function CalcPct(IdArt As Long, Nbmois As Long) As Single
Dim Vetuste As Long
Dim Franchise As Long
Dim PctMens As Single
Dim QuotePart As Long
'Dim Nbmois As Long
Vetuste = DLookup("Vetuste", "Req_LisDégra", "IdArticle = " & IdArt)
'Vetuste = DLookup("Vetuste", "R_Trouve_Data", "IdArticle = " & IdCat)
Franchise = DLookup("Franchise", "Req_LisDégra", "IdArticle = " & IdArt)
'Franchise = DLookup("Franchise", "R_Trouve_Data", "IdArticle = " & IdCat)
PctMens = DLookup("PctMens", "Req_LisDégra", "IdArticle = " & IdArt)
'PctMens = DLookup("PctMens", "R_Trouve_Data", "IdArticle = " & IdCat)
QuotePart = DLookup("QuotePart", "Req_LisDégra", "IdArticle = " & IdArt)
'QuotePart = DLookup("QuotePart", "R_Trouve_Data", "IdArticle = " & IdCat)
If Nbmois > Vetuste Then
CalcPct = QuotePart
GoTo Fin:
End If
If Nbmois < Franchise Then
CalcPct = 100
GoTo Fin:
End If
CalcPct = 100 - ((Nbmois - Franchise) * PctMens)
'MsgBox Chx_Art.Value
'MsgBox Chx_Ent.Value
'MsgBox Chx_Sor.Value
Nbmois = DateDiff("m", Chx_Ent, Chx_Sor)
'MsgBox "mois = " & NbMois
CoèfCharge = CalcPct(Chx_Art.Value, Nbmois) & " %"
Fin:
End Function |
Partager