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
|
Sub TraceTrait(frm_Form As Form, dt_HeureDebut As Date, dt_HeureFin As Date, dt_refheure As Date, i_refdebut As Integer, i_top As Integer, lng_Color As Long, i_BorderWidth)
'constante pour l'échelle
Const i_RefHeure As Variant = 28800
Const i_RefCM As Variant = 12
'variable
Dim dt_Duree As Date
Dim dt_Start As Date
Dim i_Longueur As Long
Dim i_Start As Integer
Dim li_line As New line
Set li_line = frm_Form!HeureTrait
'calcul debut du trait
s = Mid(dt_HeureDebut, 1, 10)
dt_Start = DateValue(s) & " " & dt_refheure
dt_Start = dt_HeureDebut - dt_Start
i_Start = dt_Start * 3600 * 24
i_Start = (i_Start * i_RefCM) / i_RefHeure
i_Start = i_refdebut + (i_Start * 567)
'calcul taille trait
dt_Duree = (dt_HeureFin - dt_HeureDebut)
i_Longueur = dt_Duree * 3600 * 24
i_Longueur = (i_Longueur * i_RefCM) / i_RefHeure
i_Longueur = i_Longueur * 567
'Paramétrage du trait
li_line.BorderColor = i_Color
li_line.BorderWidth = i_BorderWidth
li_line.Top = i_top
li_line.Left = i_Start
li_line.Width = i_Longueur
End Sub |
Partager