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
| Option Compare Database
Option Explicit
Dim S1Min As Long, S1Max As Long, kS1 As Single
Dim S2Min As Long, S2Max As Long, kS2 As Single
Dim S3Min As Long, S3Max As Long, kS3 As Single
Dim LaptimeMin As Long, LaptimeMax As Long, kLaptime As Single
Private Sub sFrmStint_Enter()
S1Min = DMin("S1", "RqStintLapNoC60")
S1Max = DMax("S1", "RqStintLapNoC60")
Debug.Print S1Min, S1Max
kS1 = 3 * 256 / (S1Max - S1Min)
S2Min = DMin("S2", "RqStintLapNoC60")
S2Max = DMax("S2", "RqStintLapNoC60")
Debug.Print S2Min, S2Max
kS2 = 3 * 256 / (S2Max - S2Min)
S3Min = DMin("S3", "RqStintLapNoC60")
S3Max = DMax("S3", "RqStintLapNoC60")
Debug.Print S3Min, S3Max
kS3 = 3 * 256 / (S3Max - S3Min)
LaptimeMin = DMin("Laptime", "RqStintLapNoC60")
LaptimeMax = DMax("Laptime", "RqStintLapNoC60")
Debug.Print LaptimeMin, LaptimeMax
kLaptime = 3 * 256 / (LaptimeMax - LaptimeMin)
End Sub
Private Sub Détail_Paint()
On Error Resume Next
Me.S1.BackColor = CC((Me.S1.Value - S1Min) * kS1)
Me.S2.BackColor = CC((Me.S2.Value - S2Min) * kS2)
Me.S3.BackColor = CC((Me.S3.Value - S3Min) * kS3)
Me.Laptime.BackColor = CC((Me.Laptime.Value - LaptimeMin) * kLaptime)
End Sub |
Partager