Version =20 VersionRequired =20 Begin Report LayoutForPrint = NotDefault DividingLines = NotDefault AllowDesignChanges = NotDefault DateGrouping =1 GrpKeepTogether =1 PictureAlignment =2 DatasheetGridlinesBehavior =3 GridY =10 Width =10828 DatasheetFontHeight =11 ItemSuffix =30 DatasheetGridlinesColor =14806254 RecSrcDt = Begin 0x3538d5f3f4d2e440 End RecordSource ="SELECT tbl_SuiviRH.CodeAgent, tbl_SuiviRH.MoisRH, tbl_SuiviRH.AnneeRH, r_Agents." "Nom, r_Agents.Matricule, r_IndemnJournalieres.TotalRepas, r_FraisKmSynthese.Dist" "anceMois, r_FraisKmSynthese.SommeDeMontant AS FraisKm FROM r_IndemnJournalieres " "INNER JOIN (r_Agents INNER JOIN (tbl_SuiviRH INNER JOIN r_FraisKmSynthese ON (tb" "l_SuiviRH.AnneeRH = r_FraisKmSynthese.AnneeRH) AND (tbl_SuiviRH.MoisRH = r_Frais" "KmSynthese.MoisRH) AND (tbl_SuiviRH.CodeAgent = r_FraisKmSynthese.CodeAgent)) ON" " r_Agents.CodeAgent = tbl_SuiviRH.CodeAgent) ON (r_IndemnJournalieres.AnneeRH = " "tbl_SuiviRH.AnneeRH) AND (r_IndemnJournalieres.MoisRH = tbl_SuiviRH.MoisRH) AND " "(r_IndemnJournalieres.CodeAgent = tbl_SuiviRH.CodeAgent) WHERE (((tbl_SuiviRH.Ed" "ite)=True)); " 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 =907 Name ="EntêteÉtat" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin Label TextAlign =2 Left =585 Width =8625 Height =390 FontSize =14 FontWeight =700 BorderColor =8355711 Name ="Étiquette0" Caption ="BORDEREAU MENSUEL : ETATS DE FRAIS" GridlineColor =10921638 LayoutCachedLeft =585 LayoutCachedWidth =9210 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 =806 Name ="ZoneEntêtePage" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin Label OldBorderStyle =1 TextAlign =2 Left =4028 Top =56 Width =1650 Height =750 BorderColor =8355711 Name ="Étiquette7" Caption ="Indemnités journalières" GridlineColor =10921638 LayoutCachedLeft =4028 LayoutCachedTop =56 LayoutCachedWidth =5678 LayoutCachedHeight =806 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =5678 Top =56 Width =1650 Height =750 BorderColor =8355711 Name ="Étiquette8" Caption ="Frais de transport" GridlineColor =10921638 LayoutCachedLeft =5678 LayoutCachedTop =56 LayoutCachedWidth =7328 LayoutCachedHeight =806 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =7328 Top =56 Width =1680 Height =750 BorderColor =8355711 Name ="Étiquette9" Caption ="Indemnités kilométriques" GridlineColor =10921638 LayoutCachedLeft =7328 LayoutCachedTop =56 LayoutCachedWidth =9008 LayoutCachedHeight =806 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =9017 Top =56 Width =1605 Height =750 FontWeight =700 BorderColor =8355711 Name ="Étiquette10" Caption ="Total des indemnités" GridlineColor =10921638 LayoutCachedLeft =9017 LayoutCachedTop =56 LayoutCachedWidth =10622 LayoutCachedHeight =806 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =56 Top =64 Width =1078 Height =742 BorderColor =8355711 Name ="Étiquette4" Caption ="Matricule Agent" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedTop =64 LayoutCachedWidth =1134 LayoutCachedHeight =806 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =1133 Top =64 Width =2904 Height =742 BorderColor =8355711 Name ="Étiquette5" Caption ="Nom" GridlineColor =10921638 LayoutCachedLeft =1133 LayoutCachedTop =64 LayoutCachedWidth =4037 LayoutCachedHeight =806 ForeTint =100.0 End End End Begin Section KeepTogether = NotDefault Height =315 Name ="Détail" AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin TextBox IMESentenceMode =3 Left =1133 Width =2904 Height =315 ForeColor =4210752 Name ="Nom" ControlSource ="Nom" GridlineColor =10921638 LayoutCachedLeft =1133 LayoutCachedWidth =4037 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 End Begin TextBox DecimalPlaces =2 IMESentenceMode =3 Left =4028 Width =1650 Height =315 TabIndex =1 ForeColor =4210752 Name ="IndemnJr" ControlSource ="TotalRepas" Format ="#,##0.00 €;-#,##0.00 €" GridlineColor =10921638 LayoutCachedLeft =4028 LayoutCachedWidth =5678 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 CurrencySymbol ="€" End Begin TextBox DecimalPlaces =2 IMESentenceMode =3 Left =5678 Width =1650 Height =315 TabIndex =2 ForeColor =4210752 Name ="Transport" ControlSource ="=0" Format ="#,##0.00 €;-#,##0.00 €" GridlineColor =10921638 LayoutCachedLeft =5678 LayoutCachedWidth =7328 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 CurrencySymbol ="€" End Begin TextBox DecimalPlaces =2 IMESentenceMode =3 Left =7327 Width =1680 Height =315 TabIndex =3 ForeColor =4210752 Name ="FraisKm" ControlSource ="FraisKm" Format ="#,##0.00 €;-#,##0.00 €" GridlineColor =10921638 LayoutCachedLeft =7327 LayoutCachedWidth =9007 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 CurrencySymbol ="€" End Begin TextBox DecimalPlaces =2 IMESentenceMode =3 Left =9017 Width =1606 Height =315 FontWeight =700 TabIndex =4 ForeColor =4210752 Name ="Total" ControlSource ="=[IndemnJr]+[Transport]+[FraisKm]" Format ="#,##0.00 €;-#,##0.00 €" GridlineColor =10921638 LayoutCachedLeft =9017 LayoutCachedWidth =10623 LayoutCachedHeight =315 BorderThemeColorIndex =0 BorderShade =100.0 CurrencySymbol ="€" End Begin TextBox IMESentenceMode =3 Left =56 Width =1086 Height =315 TabIndex =5 ForeColor =4210752 Name ="Matricule" ControlSource ="Matricule" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedWidth =1142 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 =113 Width =3600 Height =315 BorderColor =10921638 ForeColor =4210752 Name ="Texte17" ControlSource ="=\"Page \" & [Page] & \" sur \" & [Pages]" GridlineColor =10921638 LayoutCachedLeft =7086 LayoutCachedTop =113 LayoutCachedWidth =10686 LayoutCachedHeight =428 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