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 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| Public Sub MajPlanning()
Dim j As Integer
Dim DateJ As Date
DateJ = Forms!F_PlanningSemaines.DateD
For j = 1 To 5
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("NumSem" & j).Caption = "Semaine " & NumSemaine(DateJ)
DateJ = DateJ + 7
Next j
DateJ = Forms!F_PlanningSemaines!DateD
For j = 1 To 35
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).Caption = UCase(Left(Format(DateJ, "ddd"), 1)) & vbCrLf & Day(DateJ) & vbCrLf & UCase(Format(DateJ, "mmm"))
If EstWeekEnd(DateJ) Then
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = rgb(242, 242, 243)
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).BackColor = rgb(242, 242, 243)
ElseIf EstFerie(DateJ) Then
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = rgb(235, 235, 237)
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).BackColor = rgb(235, 235, 237)
ElseIf EstAujourdhui(DateJ) Then
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = rgb(100, 100, 100)
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).BackColor = rgb(100, 100, 100)
ElseIf EstMaintenant(DateJ) Then
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = rgb(223, 219, 231)
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).BackColor = rgb(223, 219, 231)
Else
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = vbWhite
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).BackColor = vbWhite
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).FormatConditions.Item(0).Modify acExpression, , "IsNull([Jour" & j & "])=true"
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).FormatConditions.Item(0).BackColor = 10083238
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).FormatConditions.Item(0).Modify acExpression, , "InStr([" & j & "],'FR')<>0" ' Si l'abréviation "FR" est présente dans la zone de texte "JourJ" on la colorie en vert
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).FormatConditions.Item(0).BackColor = vbGreen
' Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).BackColor = 16761024
' Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Jour" & j).FormatConditions.Item(0).BackColor = 16777164
' Forms!F_PlanningSemaines!SF_PlanningSemaines.Form("Col" & j).FormatConditions.Item(0).Modify acExpression, , "[IDAbreviation]='FR'"
End If
DateJ = DateJ + 1
Next j
Forms!F_PlanningSemaines!SF_PlanningSemaines.Form.Requery
End Sub |
Partager