Version =20 VersionRequired =20 Begin Report LayoutForPrint = NotDefault DividingLines = NotDefault OrderByOn = NotDefault AllowDesignChanges = NotDefault DateGrouping =1 GrpKeepTogether =1 PictureAlignment =2 DatasheetGridlinesBehavior =3 GridY =10 Width =10828 DatasheetFontHeight =11 ItemSuffix =25 DatasheetGridlinesColor =14806254 Filter ="[MoisRH]=12 AND [AnneeRH]=2013" OrderBy ="[Nom]" RecSrcDt = Begin 0x273893828c56e440 End RecordSource ="SELECT tbl_FormHS.MoisRH, tbl_FormHS.AnneeRH, tbl_FormHS.CodeAgent, r_Agents.Nom" ", Sum(tbl_FormHS.[HeureSup1<=14]) AS [SommeDeHeureSup1<=14], Sum(tbl_FormHS.[Heu" "reSup1>14]) AS [SommeDeHeureSup1>14], Sum(tbl_FormHS.HeureSupNuit) AS SommeDeHeu" "reSupNuit, Sum(tbl_FormHS.HeureSupDim) AS SommeDeHeureSupDim, tbl_FormHS.Valide," " tbl_SuiviRH.Edite, r_Agents.Grade, r_Agents.Matricule FROM tbl_SuiviRH INNER JO" "IN (r_Agents INNER JOIN tbl_FormHS ON r_Agents.CodeAgent = tbl_FormHS.CodeAgent)" " ON tbl_SuiviRH.IDSuivi = tbl_FormHS.IDSuivi GROUP BY tbl_FormHS.MoisRH, tbl_For" "mHS.AnneeRH, tbl_FormHS.CodeAgent, r_Agents.Nom, tbl_FormHS.Valide, tbl_SuiviRH." "Edite, r_Agents.Grade, r_Agents.Matricule HAVING (((tbl_FormHS.Valide)=True) AND" " ((tbl_SuiviRH.Edite)=True) AND ((r_Agents.Grade) Not Like '*' & 'OPA' & '*')) O" "RDER BY r_Agents.Nom; " OnOpen ="[Event Procedure]" DatasheetFontName ="Calibri" PrtMip = Begin 0xf801000038040000f801000038040000000000004c2a00003b01000001000000 , 0x010000006801000000000000a10700000100000001000000 End FilterOnLoad =0 FitToPage =1 DisplayOnSharePointSite =1 DatasheetAlternateBackColor =15921906 DatasheetGridlinesColor12 =0 FitToScreen =1 DatasheetBackThemeColorIndex =1 BorderThemeColorIndex =3 ThemeFontIndex =1 ForeThemeColorIndex =0 AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin Label BackStyle =0 FontSize =11 FontName ="Calibri" ThemeFontIndex =1 BackThemeColorIndex =1 BorderThemeColorIndex =0 BorderTint =50.0 ForeThemeColorIndex =0 ForeTint =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin TextBox AddColon = NotDefault FELineBreak = NotDefault BorderLineStyle =0 Width =1701 LabelX =-1701 FontSize =11 FontName ="Calibri" AsianLineBreak =1 ShowDatePicker =0 BackThemeColorIndex =1 BorderThemeColorIndex =1 BorderShade =65.0 ThemeFontIndex =1 ForeThemeColorIndex =0 ForeTint =75.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin FormHeader KeepTogether = NotDefault Height =1077 Name ="EntêteÉtat" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin Label TextAlign =2 Left =623 Width =8535 Height =390 FontSize =14 FontWeight =700 BorderColor =8355711 Name ="Étiquette0" Caption ="BORDEREAU MENSUEL: HEURES SUPPLEMENTAIRES" GridlineColor =10921638 LayoutCachedLeft =623 LayoutCachedWidth =9158 LayoutCachedHeight =390 ForeTint =100.0 End Begin TextBox OldBorderStyle =0 TextAlign =3 IMESentenceMode =3 Left =2777 Top =453 Width =2166 Height =315 ColumnOrder =0 FontSize =13 BorderColor =10921638 ForeColor =4210752 Name ="txtMoisRH" ControlSource ="=UCase(MonthName([MoisRH]))" GridlineColor =10921638 LayoutCachedLeft =2777 LayoutCachedTop =453 LayoutCachedWidth =4943 LayoutCachedHeight =768 End Begin TextBox OldBorderStyle =0 TextAlign =1 IMESentenceMode =3 Left =5283 Top =453 Height =315 ColumnOrder =1 FontSize =13 TabIndex =1 BorderColor =10921638 ForeColor =4210752 Name ="AnneeRH" ControlSource ="AnneeRH" GridlineColor =10921638 LayoutCachedLeft =5283 LayoutCachedTop =453 LayoutCachedWidth =6984 LayoutCachedHeight =768 End End End Begin PageHeader Height =2050 Name ="ZoneEntêtePage" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin Label OldBorderStyle =1 TextAlign =2 Left =4028 Top =685 Width =1650 Height =1365 BorderColor =8355711 Name ="Étiquette7" Caption ="Nombre d'heures accomplies au cours d'un mois <=14H" GridlineColor =10921638 LayoutCachedLeft =4028 LayoutCachedTop =685 LayoutCachedWidth =5678 LayoutCachedHeight =2050 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =5678 Top =685 Width =1650 Height =1365 BorderColor =8355711 Name ="Étiquette8" Caption ="Nombre d'heures accomplies au cours d'un mois >14H" GridlineColor =10921638 LayoutCachedLeft =5678 LayoutCachedTop =685 LayoutCachedWidth =7328 LayoutCachedHeight =2050 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =7328 Top =685 Width =1620 Height =1365 BorderColor =8355711 Name ="Étiquette9" Caption ="Nombre d'heures accomplies de 22H à 7H" GridlineColor =10921638 LayoutCachedLeft =7328 LayoutCachedTop =685 LayoutCachedWidth =8948 LayoutCachedHeight =2050 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =8957 Top =685 Width =1665 Height =1365 BorderColor =8355711 Name ="Étiquette10" Caption ="Nombre d'heures Dimanche et jours de fête" GridlineColor =10921638 LayoutCachedLeft =8957 LayoutCachedTop =685 LayoutCachedWidth =10622 LayoutCachedHeight =2050 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =4028 Top =340 Width =6585 Height =345 BorderColor =8355711 Name ="Étiquette12" Caption ="TOTAL DES HEURES" GridlineColor =10921638 LayoutCachedLeft =4028 LayoutCachedTop =340 LayoutCachedWidth =10613 LayoutCachedHeight =685 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =56 Top =1323 Width =1089 Height =727 BorderColor =8355711 Name ="Étiquette4" Caption ="Matricule Agent" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedTop =1323 LayoutCachedWidth =1145 LayoutCachedHeight =2050 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =1145 Top =1323 Width =2883 Height =727 BorderColor =8355711 Name ="Étiquette5" Caption ="Nom" GridlineColor =10921638 LayoutCachedLeft =1145 LayoutCachedTop =1323 LayoutCachedWidth =4028 LayoutCachedHeight =2050 ForeTint =100.0 End End End Begin Section KeepTogether = NotDefault Height =315 Name ="Détail" AlternateBackColor =16777215 BackThemeColorIndex =1 Begin Begin TextBox IMESentenceMode =3 Left =1145 Width =2883 Height =315 ForeColor =4210752 Name ="Nom" ControlSource ="Nom" GridlineColor =10921638 LayoutCachedLeft =1145 LayoutCachedWidth =4028 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox DecimalPlaces =0 IMESentenceMode =3 Left =4039 Width =1650 Height =315 TabIndex =1 ForeColor =4210752 Name ="SommeDeHeureSup1<=14" ControlSource ="SommeDeHeureSup1<=14" Format ="Standard" EventProcPrefix ="SommeDeHeureSup1__14" GridlineColor =10921638 LayoutCachedLeft =4039 LayoutCachedWidth =5689 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox DecimalPlaces =0 IMESentenceMode =3 Left =5678 Width =1650 Height =315 TabIndex =2 ForeColor =4210752 Name ="SommeDeHeureSup1>14" ControlSource ="SommeDeHeureSup1>14" Format ="Standard" EventProcPrefix ="SommeDeHeureSup1_14" GridlineColor =10921638 LayoutCachedLeft =5678 LayoutCachedWidth =7328 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox DecimalPlaces =0 IMESentenceMode =3 Left =7327 Width =1621 Height =315 TabIndex =3 ForeColor =4210752 Name ="SommeDeHeureSupNuit" ControlSource ="SommeDeHeureSupNuit" Format ="Standard" GridlineColor =10921638 LayoutCachedLeft =7327 LayoutCachedWidth =8948 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox DecimalPlaces =0 IMESentenceMode =3 Left =8957 Width =1665 Height =315 TabIndex =4 ForeColor =4210752 Name ="SommeDeHeureSupDim" ControlSource ="SommeDeHeureSupDim" Format ="Standard" GridlineColor =10921638 LayoutCachedLeft =8957 LayoutCachedWidth =10622 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox IMESentenceMode =3 Left =58 Width =1071 Height =315 TabIndex =5 ForeColor =4210752 Name ="Matricule" ControlSource ="Matricule" GridlineColor =10921638 LayoutCachedLeft =58 LayoutCachedWidth =1129 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End End End Begin PageFooter Height =428 Name ="ZonePiedPage" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin TextBox OldBorderStyle =0 TextAlign =3 BackStyle =0 IMESentenceMode =3 Left =7086 Top =56 Width =3600 Height =315 BorderColor =10921638 ForeColor =4210752 Name ="Texte17" ControlSource ="=\"Page \" & [Page] & \" sur \" & [Pages]" GridlineColor =10921638 LayoutCachedLeft =7086 LayoutCachedTop =56 LayoutCachedWidth =10686 LayoutCachedHeight =371 End End End Begin FormFooter KeepTogether = NotDefault Height =0 Name ="PiedÉtat" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 End End End CodeBehindForm Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = True Attribute VB_PredeclaredId = True Attribute VB_Exposed = False Option Compare Database Private Sub Report_Open(Cancel As Integer) Me.OrderBy = "[Nom]" Me.OrderByOn = True End Sub