Version =20 VersionRequired =20 Begin Report LayoutForPrint = NotDefault AutoResize = NotDefault DividingLines = NotDefault FilterOn = NotDefault OrderByOn = NotDefault AllowDesignChanges = NotDefault DateGrouping =1 GrpKeepTogether =1 PictureAlignment =2 DatasheetGridlinesBehavior =3 GridY =10 Width =15647 DatasheetFontHeight =11 ItemSuffix =114 DatasheetGridlinesColor =14806254 Filter ="[Valide]=True AND [CodeAgent]='T8' AND [MoisRH]=8 AND [AnneeRH]=2016" OrderBy ="[JourRH] ASC" RecSrcDt = Begin 0x523180d33636e440 End RecordSource ="r_FormDep_SourceEtat" OnOpen ="[Event Procedure]" DatasheetFontName ="Calibri" PrtMip = Begin 0xf801000038040000f801000038040000000000001f3d0000e100000001000000 , 0x010000006801000000000000a10700000100000001000000 End FilterOnLoad =0 ShowPageMargins =0 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 Line BorderLineStyle =0 Width =1701 BorderThemeColorIndex =0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin Image OldBorderStyle =0 BorderLineStyle =0 SizeMode =3 PictureAlignment =2 Width =1701 Height =1701 BorderColor =16777215 GridlineColor =16777215 BackThemeColorIndex =1 BorderThemeColorIndex =1 BorderShade =65.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 Subform BorderLineStyle =0 Width =1701 Height =1701 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin EmptyCell Height =240 GridlineColor =12632256 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin FormHeader KeepTogether = NotDefault Height =2782 Name ="EntêteÉtat" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin Label TextAlign =2 Left =6122 Top =284 Width =3966 Height =397 FontSize =14 FontWeight =700 BorderColor =8355711 Name ="Étiquette0" Caption ="FORMULAIRE DEPLACEMENTS" GridlineColor =10921638 LayoutCachedLeft =6122 LayoutCachedTop =284 LayoutCachedWidth =10088 LayoutCachedHeight =681 ForeTint =100.0 End Begin TextBox OldBorderStyle =0 IMESentenceMode =3 Left =1757 Top =851 Width =2725 Height =345 ColumnOrder =0 BorderColor =10921638 Name ="Texte1" ControlSource ="Nom" GridlineColor =10921638 LayoutCachedLeft =1757 LayoutCachedTop =851 LayoutCachedWidth =4482 LayoutCachedHeight =1196 ForeTint =100.0 Begin Begin Label Left =850 Top =851 Width =690 Height =315 BorderColor =8355711 Name ="Étiquette2" Caption ="Agent:" GridlineColor =10921638 LayoutCachedLeft =850 LayoutCachedTop =851 LayoutCachedWidth =1540 LayoutCachedHeight =1166 ForeTint =100.0 End End End Begin TextBox Visible = NotDefault OldBorderStyle =0 TextAlign =1 IMESentenceMode =3 Left =14683 Top =624 Width =786 Height =315 ColumnOrder =2 TabIndex =1 BorderColor =10921638 ForeColor =12566463 Name ="IDSuivi" ControlSource ="IDSuivi" GridlineColor =10921638 LayoutCachedLeft =14683 LayoutCachedTop =624 LayoutCachedWidth =15469 LayoutCachedHeight =939 ForeThemeColorIndex =1 ForeTint =100.0 ForeShade =75.0 Begin Begin Label Visible = NotDefault Left =13776 Top =624 Width =855 Height =315 BorderColor =8355711 ForeColor =12566463 Name ="Étiquette5" Caption ="IDSuivi" GridlineColor =10921638 LayoutCachedLeft =13776 LayoutCachedTop =624 LayoutCachedWidth =14631 LayoutCachedHeight =939 ForeThemeColorIndex =1 ForeTint =100.0 ForeShade =75.0 End End End Begin TextBox Visible = NotDefault IMESentenceMode =3 Left =11281 Top =284 Width =291 Height =315 ColumnOrder =3 TabIndex =2 BorderColor =10921638 ForeColor =4210752 Name ="MoisRH" ControlSource ="[MoisRH]" GridlineColor =10921638 LayoutCachedLeft =11281 LayoutCachedTop =284 LayoutCachedWidth =11572 LayoutCachedHeight =599 End Begin TextBox OldBorderStyle =0 TextAlign =1 IMESentenceMode =3 Left =13662 Top =227 Width =1821 Height =390 ColumnOrder =4 TabIndex =3 BorderColor =10921638 ForeColor =4210752 Name ="AnneeRH" ControlSource ="AnneeRH" GridlineColor =10921638 LayoutCachedLeft =13662 LayoutCachedTop =227 LayoutCachedWidth =15483 LayoutCachedHeight =617 End Begin Label OldBorderStyle =1 TextAlign =2 Left =11678 Top =2092 Width =3795 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette8" Caption ="Remarque" GridlineColor =10921638 LayoutCachedLeft =11678 LayoutCachedTop =2092 LayoutCachedWidth =15473 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =8674 Top =2092 Width =1935 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette9" Caption ="Véhicule personnel uniquement (km)" GridlineColor =10921638 LayoutCachedLeft =8674 LayoutCachedTop =2092 LayoutCachedWidth =10609 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =3344 Top =2092 Width =1695 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette11" Caption ="Déplacement véhicule personnel (km)" GridlineColor =10921638 LayoutCachedLeft =3344 LayoutCachedTop =2092 LayoutCachedWidth =5039 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =5045 Top =2092 Width =1530 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette12" Caption ="Véhicule de service (km)" GridlineColor =10921638 LayoutCachedLeft =5045 LayoutCachedTop =2092 LayoutCachedWidth =6575 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =6576 Top =2092 Width =1080 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette13" Caption ="Heures de route" GridlineColor =10921638 LayoutCachedLeft =6576 LayoutCachedTop =2092 LayoutCachedWidth =7656 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =10601 Top =2092 Width =1080 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette14" Caption ="Repas, Midi ou soir (Nbre)" GridlineColor =10921638 LayoutCachedLeft =10601 LayoutCachedTop =2092 LayoutCachedWidth =11681 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =56 Top =2092 Width =900 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette19" Caption ="Jour" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedTop =2092 LayoutCachedWidth =956 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =3344 Top =1417 Width =3225 Height =675 FontSize =9 BorderColor =8355711 Name ="Étiquette20" Caption ="Déplacement sur site, kilométrage aller-retour avant 7h30 ou aprés 17h" GridlineColor =10921638 LayoutCachedLeft =3344 LayoutCachedTop =1417 LayoutCachedWidth =6569 LayoutCachedHeight =2092 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =8674 Top =1417 Width =1920 Height =675 FontSize =9 BorderColor =8355711 Name ="Étiquette21" Caption ="Déplacement pendant heures de travail depuis le site" GridlineColor =10921638 LayoutCachedLeft =8674 LayoutCachedTop =1417 LayoutCachedWidth =10594 LayoutCachedHeight =2092 ForeTint =100.0 End Begin TextBox OldBorderStyle =0 TextAlign =3 IMESentenceMode =3 Left =11735 Top =227 Width =1772 Height =390 ColumnOrder =5 TabIndex =4 BorderColor =10921638 ForeColor =4210752 Name ="Texte62" ControlSource ="=UCase(MonthName([MoisRH]))" GridlineColor =10921638 LayoutCachedLeft =11735 LayoutCachedTop =227 LayoutCachedWidth =13507 LayoutCachedHeight =617 End Begin Label OldBorderStyle =1 TextAlign =2 Left =7653 Top =2092 Width =1020 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette69" Caption ="Heures de route (Nuit)" GridlineColor =10921638 LayoutCachedLeft =7653 LayoutCachedTop =2092 LayoutCachedWidth =8673 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label OldBorderStyle =1 TextAlign =2 Left =963 Top =2092 Width =2385 Height =690 FontSize =9 BorderColor =8355711 Name ="Étiquette72" Caption ="(Départ) Itinéraire" GridlineColor =10921638 LayoutCachedLeft =963 LayoutCachedTop =2092 LayoutCachedWidth =3348 LayoutCachedHeight =2782 ForeTint =100.0 End Begin Label TextAlign =2 Left =3685 Width =8503 Height =227 FontSize =9 BorderColor =8355711 ForeColor =4210752 Name ="Étiquette57" Caption ="Parc Départemental d'Erstein - Conseil Général du Bas-Rhin" GridlineColor =10921638 LayoutCachedLeft =3685 LayoutCachedWidth =12188 LayoutCachedHeight =227 ForeTint =75.0 End Begin Image BackStyle =0 PictureType =1 Left =283 Width =2245 Height =805 BorderColor =10921638 Name ="imgLogo" ControlTipText ="Auto_Logo0" GridlineColor =10921638 LayoutCachedLeft =283 LayoutCachedWidth =2528 LayoutCachedHeight =805 TabIndex =5 End End End Begin PageHeader Height =0 Name ="ZoneEntêtePage" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 End Begin Section KeepTogether = NotDefault CanGrow = NotDefault CanShrink = NotDefault Height =225 Name ="Détail" AutoHeight =255 AlternateBackColor =16777215 BackThemeColorIndex =1 Begin Begin TextBox TextAlign =2 IMESentenceMode =3 Left =11684 Width =3795 Height =225 FontSize =9 BorderColor =10921638 ForeColor =4210752 Name ="txt_Remarque" ControlSource ="Remarque" GridlineColor =10921638 LayoutCachedLeft =11684 LayoutCachedWidth =15479 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =8674 Width =1936 Height =225 ColumnWidth =2550 FontSize =9 TabIndex =1 BorderColor =10921638 ForeColor =4210752 Name ="txt_Distance1_perso" ControlSource ="Distance1_perso" GridlineColor =10921638 LayoutCachedLeft =8674 LayoutCachedWidth =10610 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =3339 Height =225 ColumnWidth =2295 FontSize =9 TabIndex =2 BorderColor =10921638 ForeColor =4210752 Name ="txt_Distance2_perso" ControlSource ="Distance2_perso" GridlineColor =10921638 LayoutCachedLeft =3339 LayoutCachedWidth =5040 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =5034 Width =1530 Height =225 FontSize =9 TabIndex =3 BorderColor =10921638 ForeColor =4210752 Name ="txt_Distance2_service" ControlSource ="Distance2_service" GridlineColor =10921638 LayoutCachedLeft =5034 LayoutCachedWidth =6564 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =6577 Width =1071 Height =225 FontSize =9 TabIndex =4 BorderColor =10921638 ForeColor =4210752 Name ="txt_HeuresDep" ControlSource ="HeuresDep" GridlineColor =10921638 LayoutCachedLeft =6577 LayoutCachedWidth =7648 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =10604 Width =1086 Height =225 FontSize =9 TabIndex =5 BorderColor =10921638 ForeColor =4210752 Name ="txt_Repas" ControlSource ="Repas" GridlineColor =10921638 LayoutCachedLeft =10604 LayoutCachedWidth =11690 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =56 Width =906 Height =225 FontSize =9 TabIndex =6 BorderColor =10921638 ForeColor =4210752 Name ="JourRH" ControlSource ="JourRH" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedWidth =962 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =7656 Width =1020 Height =225 FontSize =9 TabIndex =7 BorderColor =10921638 ForeColor =4210752 Name ="Texte70" ControlSource ="HeuresDepNuit" GridlineColor =10921638 LayoutCachedLeft =7656 LayoutCachedWidth =8676 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =963 Width =2376 Height =225 ColumnWidth =3345 FontSize =9 TabIndex =8 BorderColor =10921638 ForeColor =4210752 Name ="Itin" ControlSource ="=IIf(Len([Depart])>0,'(' & [Depart] & ') ' & [Itineraire],[Itineraire])" GridlineColor =10921638 LayoutCachedLeft =963 LayoutCachedWidth =3339 LayoutCachedHeight =225 End End End Begin PageFooter Height =1814 Name ="ZonePiedPage" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin Label Left =7823 Top =396 Width =4365 Height =285 FontSize =9 BorderColor =8355711 Name ="Étiquette100" Caption ="Certifié exact: Le directeur / Le chef de service" GridlineColor =10921638 LayoutCachedLeft =7823 LayoutCachedTop =396 LayoutCachedWidth =12188 LayoutCachedHeight =681 ForeTint =100.0 End Begin Subform CanShrink = NotDefault OldBorderStyle =0 Left =56 Width =4987 Height =1759 BorderColor =8355711 Name ="sEt_BaremeHeuresdeRoute" SourceObject ="Report.sEt_BaremeHeuresdeRoute" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedWidth =5043 LayoutCachedHeight =1759 BorderThemeColorIndex =1 BorderShade =50.0 End End End Begin FormFooter KeepTogether = NotDefault Height =283 Name ="PiedÉtat" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin TextBox TextAlign =2 IMESentenceMode =3 Left =11684 Width =3795 Height =225 FontSize =9 BorderColor =10921638 ForeColor =4210752 Name ="Texte101" GridlineColor =10921638 LayoutCachedLeft =11684 LayoutCachedWidth =15479 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =8674 Width =1936 Height =225 FontSize =9 TabIndex =1 BorderColor =10921638 ForeColor =4210752 Name ="Texte102" ControlSource ="=Sum([Distance1_perso])" GridlineColor =10921638 LayoutCachedLeft =8674 LayoutCachedWidth =10610 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =3339 Height =225 FontSize =9 TabIndex =2 BorderColor =10921638 ForeColor =4210752 Name ="Texte103" ControlSource ="=Sum([Distance2_perso])" GridlineColor =10921638 LayoutCachedLeft =3339 LayoutCachedWidth =5040 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =5034 Width =1530 Height =225 FontSize =9 TabIndex =3 BorderColor =10921638 ForeColor =4210752 Name ="Texte104" ControlSource ="=Sum([Distance2_service])" GridlineColor =10921638 LayoutCachedLeft =5034 LayoutCachedWidth =6564 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =6577 Width =1071 Height =225 FontSize =9 TabIndex =4 BorderColor =10921638 ForeColor =4210752 Name ="Texte105" ControlSource ="=Sum([HeuresDep])" GridlineColor =10921638 LayoutCachedLeft =6577 LayoutCachedWidth =7648 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =10604 Width =1086 Height =225 FontSize =9 TabIndex =5 BorderColor =10921638 ForeColor =4210752 Name ="Texte106" ControlSource ="=Sum([Repas])" GridlineColor =10921638 LayoutCachedLeft =10604 LayoutCachedWidth =11690 LayoutCachedHeight =225 End Begin TextBox TextAlign =2 IMESentenceMode =3 Left =7656 Width =1020 Height =225 FontSize =9 TabIndex =6 BorderColor =10921638 ForeColor =4210752 Name ="Texte108" ControlSource ="=Sum([HeuresDepNuit])" GridlineColor =10921638 LayoutCachedLeft =7656 LayoutCachedWidth =8676 LayoutCachedHeight =225 End Begin Label OldBorderStyle =1 TextAlign =2 Left =56 Width =3288 Height =226 FontSize =9 BorderColor =8355711 Name ="Étiquette110" Caption ="Totaux:" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedWidth =3344 LayoutCachedHeight =226 ForeTint =100.0 End End 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.imgLogo.Picture = get_lien("logo_cd67") Me.OrderBy = "[JourRH] ASC" Me.OrderByOn = True End Sub