Version =20 VersionRequired =20 Begin Form DividingLines = NotDefault OrderByOn = NotDefault AllowDesignChanges = NotDefault PictureAlignment =2 DatasheetGridlinesBehavior =3 GridY =10 Width =17348 DatasheetFontHeight =11 ItemSuffix =72 Right =20835 Bottom =10455 DatasheetGridlinesColor =15062992 Filter ="[MoisRH]=1 AND [AnneeRH]=2015" OrderBy ="frm_syntheseRH.Name" RecSrcDt = Begin 0xefb5dcc035d1e440 End RecordSource ="SELECT r_SyntheseRH_inter.anneeRH, r_SyntheseRH_inter.moisRH, r_SyntheseRH_inter" ".CodeAgent, r_SyntheseRH_inter.Nom, r_SyntheseRH_inter.SommeDeHeureSup1, r_Synth" "eseRH_inter.SommeDeHeureSup2, r_SyntheseRH_inter.SommeDeHeureSupDimanche, r_Synt" "heseRH_inter.SommeDeRepas, r_SyntheseRH_DisTr1.[True] AS DisTr1AVP, r_SyntheseRH" "_DisTr1.[False] AS DisTr1SVP, r_SynteseRH_DisTr2.[True] AS DisTr2AVP, r_SynteseR" "H_DisTr2.[False] AS DisTr2SVP FROM r_SynteseRH_DisTr2 INNER JOIN (r_SyntheseRH_D" "isTr1 INNER JOIN r_SyntheseRH_inter ON (r_SyntheseRH_DisTr1.anneeRH = r_Synthese" "RH_inter.anneeRH) AND (r_SyntheseRH_DisTr1.moisRH = r_SyntheseRH_inter.moisRH) A" "ND (r_SyntheseRH_DisTr1.CodeAgent = r_SyntheseRH_inter.CodeAgent)) ON (r_Syntese" "RH_DisTr2.CodeAgent = r_SyntheseRH_inter.CodeAgent) AND (r_SynteseRH_DisTr2.Mois" "RH = r_SyntheseRH_inter.moisRH) AND (r_SynteseRH_DisTr2.AnneeRH = r_SyntheseRH_i" "nter.anneeRH) ORDER BY r_SyntheseRH_inter.anneeRH, r_SyntheseRH_inter.moisRH; " OnOpen ="[Event Procedure]" DatasheetFontName ="Calibri" FilterOnLoad =0 DatasheetBackColor12 =-2147483643 ShowPageMargins =0 DisplayOnSharePointSite =1 DatasheetAlternateBackColor =16053492 DatasheetGridlinesColor12 =15062992 FitToScreen =1 Begin Begin Label BackStyle =0 FontSize =11 FontName ="Calibri" ThemeFontIndex =1 BackThemeColorIndex =1 BorderThemeColorIndex =1 ForeThemeColorIndex =2 ForeTint =60.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin Rectangle SpecialEffect =3 BackStyle =0 BorderLineStyle =0 Width =850 Height =850 BorderThemeColorIndex =3 BorderShade =90.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin CommandButton Width =1701 Height =283 FontSize =11 FontWeight =400 FontName ="Calibri" ForeThemeColorIndex =2 ForeShade =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 BackColor =-2147483633 BorderLineStyle =0 BorderThemeColorIndex =3 BorderShade =90.0 ThemeFontIndex =1 End Begin TextBox FELineBreak = NotDefault BorderLineStyle =0 Width =1701 LabelX =-1701 FontSize =11 FontName ="Calibri" AsianLineBreak =1 BackThemeColorIndex =1 BorderThemeColorIndex =3 BorderShade =90.0 ThemeFontIndex =1 ForeThemeColorIndex =2 ForeShade =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin ComboBox BorderLineStyle =0 Width =1701 LabelX =-1701 FontSize =11 FontName ="Calibri" AllowValueListEdits =1 InheritValueList =1 ThemeFontIndex =1 BackThemeColorIndex =1 BorderThemeColorIndex =3 BorderShade =90.0 ForeThemeColorIndex =2 ForeShade =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin ToggleButton Width =283 Height =283 FontSize =11 FontWeight =400 FontName ="Calibri" ForeThemeColorIndex =2 ForeShade =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 BackColor =15790320 BackThemeColorIndex =6 BackTint =30.0 BorderLineStyle =0 BorderThemeColorIndex =3 BorderShade =90.0 ThemeFontIndex =1 End Begin FormHeader Height =1927 BackColor =15527148 Name ="EntêteFormulaire" AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin Label OverlapFlags =85 Left =120 Top =60 Width =4170 Height =330 FontWeight =700 BorderColor =16777215 Name ="Étiquette0" Caption ="Vue Synthétique des données RH importées" GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =60 LayoutCachedWidth =4290 LayoutCachedHeight =390 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =93 Left =4365 Top =56 Width =1644 Height =340 BorderColor =16777215 Name ="Étiquette18" Caption ="pour le mois de:" GridlineColor =10921638 LayoutCachedLeft =4365 LayoutCachedTop =56 LayoutCachedWidth =6009 LayoutCachedHeight =396 ForeThemeColorIndex =0 ForeTint =100.0 End Begin ComboBox RowSourceTypeInt =1 OverlapFlags =215 IMESentenceMode =3 ColumnCount =2 ListWidth =2880 Left =5952 Top =56 Width =1984 Height =315 ColumnOrder =1 BorderColor =12835293 ForeColor =4138256 Name ="lst_mois" RowSourceType ="Value List" RowSource ="1;\"Janvier\";2;\"Février\";3;\"Mars\";4;\"Avril\";5;\"Mai\";6;\"Juin\";7;\"Juil" "let\";8;\"Août\";9;\"Septembre\";10;\"Octobre\";11;\"Novembre\";12;\"Decembre\"" ColumnWidths ="0;2268" AfterUpdate ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =5952 LayoutCachedTop =56 LayoutCachedWidth =7936 LayoutCachedHeight =371 End Begin Label OverlapFlags =93 Left =8050 Top =56 Width =1644 Height =340 BorderColor =16777215 Name ="Étiquette21" Caption ="de l'année:" GridlineColor =10921638 LayoutCachedLeft =8050 LayoutCachedTop =56 LayoutCachedWidth =9694 LayoutCachedHeight =396 ForeThemeColorIndex =0 ForeTint =100.0 End Begin ComboBox OverlapFlags =215 IMESentenceMode =3 Left =9354 Top =56 Height =315 ColumnOrder =0 TabIndex =1 BorderColor =12835293 ForeColor =4138256 ColumnInfo ="\"\";\"\";\"3\";\"2\"" Name ="lst_annee" RowSourceType ="Table/Query" RowSource ="SELECT Year([DateRH]) AS Annee FROM tbl_ImportRH GROUP BY Year([DateRH]) HAVING " "(((Year([DateRH]))>=2013)) ORDER BY Year([DateRH]) DESC; " AfterUpdate ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =9354 LayoutCachedTop =56 LayoutCachedWidth =11055 LayoutCachedHeight =371 End Begin CommandButton OverlapFlags =85 Left =15590 Top =56 Width =621 Height =396 TabIndex =2 ForeColor =4138256 Name ="Commande24" Caption ="Commande24" OnClick ="[Event Procedure]" PictureData = Begin 0x2800000010000000100000000100040000000000800000000000000000000000 , 0x0000000000000000000000000000800000800000008080008000000080008000 , 0x8080000080808000c0c0c0000000ff00c0c0c00000ffff00ff000000c0c0c000 , 0xffff0000ffffff00ddddd0dddddddddddddd00ddddddddddddd030dddddddddd , 0xdd0330dddddddddd0033300000000dddd03330ff0dddddddd03300ff0dddd4dd , 0xd03330ff0ddd44ddd03330ff0dd44444d03330ff0d444444d03330ff0dd44444 , 0xd0330fff0ddd44ddd030ffff0dddd4ddd00fffff0dddddddd00000000ddddddd , 0xdddddddddddddddd000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000 End ObjectPalette = Begin 0x000301000000000000000000 End ControlTipText ="Fermer formulaire" GridlineColor =10921638 LayoutCachedLeft =15590 LayoutCachedTop =56 LayoutCachedWidth =16211 LayoutCachedHeight =452 BorderColor =12835293 WebImagePaddingLeft =2 WebImagePaddingTop =2 WebImagePaddingRight =1 WebImagePaddingBottom =1 Overlaps =1 End Begin Label FontUnderline = NotDefault OverlapFlags =93 Left =2892 Top =1043 Width =3315 Height =315 BorderColor =16777215 Name ="Étiquette39" Caption ="Total des Heures Supplémentaires:" GridlineColor =10921638 LayoutCachedLeft =2892 LayoutCachedTop =1043 LayoutCachedWidth =6207 LayoutCachedHeight =1358 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =93 Left =4876 Top =1429 Width =1020 Height =315 BorderColor =16777215 Name ="SÉtiquette40" Caption ="Dimanche" GridlineColor =10921638 LayoutCachedLeft =4876 LayoutCachedTop =1429 LayoutCachedWidth =5896 LayoutCachedHeight =1744 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label FontUnderline = NotDefault OverlapFlags =93 Left =6577 Top =1032 Width =1575 Height =315 BorderColor =16777215 Name ="SÉtiquette41" Caption ="Total des Repas:" GridlineColor =10921638 LayoutCachedLeft =6577 LayoutCachedTop =1032 LayoutCachedWidth =8152 LayoutCachedHeight =1347 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label FontUnderline = NotDefault OverlapFlags =93 TextAlign =2 Left =10148 Top =1021 Width =5445 Height =390 BorderColor =16777215 Name ="SÉtiquette42" Caption ="Distance totale parcourue (avec/sans véhicule personnel):" GridlineColor =10921638 LayoutCachedLeft =10148 LayoutCachedTop =1021 LayoutCachedWidth =15593 LayoutCachedHeight =1411 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =93 Left =8730 Top =1477 Width =1875 Height =315 BorderColor =16777215 Name ="SÉtiquette43" Caption ="Tranche 1 (avec VP)" GridlineColor =10921638 LayoutCachedLeft =8730 LayoutCachedTop =1477 LayoutCachedWidth =10605 LayoutCachedHeight =1792 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =93 Left =4080 Top =1440 Width =675 Height =315 BorderColor =16777215 Name ="SÉtiquette44" Caption ="Type 2" GridlineColor =10921638 LayoutCachedLeft =4080 LayoutCachedTop =1440 LayoutCachedWidth =4755 LayoutCachedHeight =1755 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Rectangle OverlapFlags =223 Left =2381 Top =908 Width =4080 Height =946 BorderColor =12835293 Name ="Boîte45" GridlineColor =10921638 LayoutCachedLeft =2381 LayoutCachedTop =908 LayoutCachedWidth =6461 LayoutCachedHeight =1854 End Begin Rectangle OverlapFlags =223 Left =6459 Top =907 Width =1875 Height =946 BorderColor =12835293 Name ="Boîte46" GridlineColor =10921638 LayoutCachedLeft =6459 LayoutCachedTop =907 LayoutCachedWidth =8334 LayoutCachedHeight =1853 End Begin Rectangle OverlapFlags =223 Left =8334 Top =907 Width =8670 Height =946 BorderColor =12835293 Name ="Boîte47" GridlineColor =10921638 LayoutCachedLeft =8334 LayoutCachedTop =907 LayoutCachedWidth =17004 LayoutCachedHeight =1853 End Begin Label OverlapFlags =215 Left =3289 Top =1440 Width =675 Height =315 BorderColor =16777215 Name ="Étiquette48" Caption ="Type 1" GridlineColor =10921638 LayoutCachedLeft =3289 LayoutCachedTop =1440 LayoutCachedWidth =3964 LayoutCachedHeight =1755 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =93 Left =340 Top =1021 Width =840 Height =315 BorderColor =16777215 Name ="Étiquette50" Caption ="Agent:" GridlineColor =10921638 LayoutCachedLeft =340 LayoutCachedTop =1021 LayoutCachedWidth =1180 LayoutCachedHeight =1336 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Rectangle OverlapFlags =215 Left =56 Top =907 Width =2336 Height =946 BorderColor =12835293 Name ="Boîte51" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedTop =907 LayoutCachedWidth =2392 LayoutCachedHeight =1853 End Begin Label OverlapFlags =215 Left =10710 Top =1477 Width =1860 Height =345 BorderColor =16777215 Name ="SÉtiquette68" Caption ="Tranche 1 (sans VP)" GridlineColor =10921638 LayoutCachedLeft =10710 LayoutCachedTop =1477 LayoutCachedWidth =12570 LayoutCachedHeight =1822 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =215 Left =12867 Top =1474 Width =1875 Height =315 BorderColor =16777215 Name ="SÉtiquette69" Caption ="Tranche 2 (avec VP)" GridlineColor =10921638 LayoutCachedLeft =12867 LayoutCachedTop =1474 LayoutCachedWidth =14742 LayoutCachedHeight =1789 ForeThemeColorIndex =0 ForeTint =100.0 End Begin Label OverlapFlags =215 Left =14847 Top =1474 Width =1860 Height =345 BorderColor =16777215 Name ="Étiquette70" Caption ="Tranche 2 (sans VP)" GridlineColor =10921638 LayoutCachedLeft =14847 LayoutCachedTop =1474 LayoutCachedWidth =16707 LayoutCachedHeight =1819 ForeThemeColorIndex =0 ForeTint =100.0 End Begin CommandButton OverlapFlags =85 Left =113 Top =453 Width =3167 Height =343 TabIndex =3 ForeColor =4138256 Name ="Commande71" Caption ="Revenir à l'affichage standard" OnClick ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =113 LayoutCachedTop =453 LayoutCachedWidth =3280 LayoutCachedHeight =796 BorderColor =12835293 WebImagePaddingLeft =2 WebImagePaddingTop =2 WebImagePaddingRight =1 WebImagePaddingBottom =1 End End End Begin Section Height =566 BackColor =15527148 Name ="Détail" AlternateBackColor =15921906 AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 Begin Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =3284 Top =117 Width =561 Height =315 BorderColor =12835293 ForeColor =4138256 Name ="Texte55" ControlSource ="SommeDeHeureSup1" GridlineColor =10921638 LayoutCachedLeft =3284 LayoutCachedTop =117 LayoutCachedWidth =3845 LayoutCachedHeight =432 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =4134 Top =117 Width =561 Height =315 TabIndex =1 BorderColor =12835293 ForeColor =4138256 Name ="Texte56" ControlSource ="SommeDeHeureSup2" GridlineColor =10921638 LayoutCachedLeft =4134 LayoutCachedTop =117 LayoutCachedWidth =4695 LayoutCachedHeight =432 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =4985 Top =117 Width =561 Height =315 TabIndex =2 BorderColor =12835293 ForeColor =4138256 Name ="Texte57" ControlSource ="SommeDeHeureSupDimanche" GridlineColor =10921638 LayoutCachedLeft =4985 LayoutCachedTop =117 LayoutCachedWidth =5546 LayoutCachedHeight =432 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =6932 Top =112 Width =876 Height =315 TabIndex =3 BorderColor =12835293 ForeColor =4138256 Name ="Texte58" ControlSource ="SommeDeRepas" GridlineColor =10921638 LayoutCachedLeft =6932 LayoutCachedTop =112 LayoutCachedWidth =7808 LayoutCachedHeight =427 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =9236 Top =113 Width =861 Height =315 TabIndex =4 BorderColor =12835293 ForeColor =4138256 Name ="Texte59" ControlSource ="DisTr1AVP" GridlineColor =10921638 LayoutCachedLeft =9236 LayoutCachedTop =113 LayoutCachedWidth =10097 LayoutCachedHeight =428 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =11218 Top =112 Width =966 Height =315 TabIndex =5 BorderColor =12835293 ForeColor =4138256 Name ="Texte60" ControlSource ="DisTr1SVP" GridlineColor =10921638 LayoutCachedLeft =11218 LayoutCachedTop =112 LayoutCachedWidth =12184 LayoutCachedHeight =427 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =13088 Top =112 Width =921 Height =315 TabIndex =6 BorderColor =12835293 ForeColor =4138256 Name ="Texte61" ControlSource ="DisTr2AVP" GridlineColor =10921638 LayoutCachedLeft =13088 LayoutCachedTop =112 LayoutCachedWidth =14009 LayoutCachedHeight =427 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =15460 Top =112 Width =906 Height =315 TabIndex =7 BorderColor =12835293 ForeColor =4138256 Name ="Texte62" ControlSource ="DisTr2SVP" GridlineColor =10921638 LayoutCachedLeft =15460 LayoutCachedTop =112 LayoutCachedWidth =16366 LayoutCachedHeight =427 End Begin TextBox OverlapFlags =93 IMESentenceMode =3 Left =109 Top =117 Width =2106 Height =315 TabIndex =8 BorderColor =12835293 ForeColor =4138256 Name ="Texte63" ControlSource ="Nom" StatusBarText ="Libelle de l'équipe" GridlineColor =10921638 LayoutCachedLeft =109 LayoutCachedTop =117 LayoutCachedWidth =2215 LayoutCachedHeight =432 End Begin Rectangle OverlapFlags =255 Left =56 Top =61 Width =2265 Height =451 BorderColor =12835293 Name ="Boîte64" GridlineColor =10921638 LayoutCachedLeft =56 LayoutCachedTop =61 LayoutCachedWidth =2321 LayoutCachedHeight =512 End Begin Rectangle OverlapFlags =255 Left =2319 Top =56 Width =4140 Height =451 BorderColor =12835293 Name ="Boîte65" GridlineColor =10921638 LayoutCachedLeft =2319 LayoutCachedTop =56 LayoutCachedWidth =6459 LayoutCachedHeight =507 End Begin Rectangle OverlapFlags =255 Left =6462 Top =56 Width =1860 Height =451 BorderColor =12835293 Name ="Boîte66" GridlineColor =10921638 LayoutCachedLeft =6462 LayoutCachedTop =56 LayoutCachedWidth =8322 LayoutCachedHeight =507 End Begin Rectangle OverlapFlags =247 Left =8329 Top =56 Width =8670 Height =451 BorderColor =12835293 Name ="Boîte67" GridlineColor =10921638 LayoutCachedLeft =8329 LayoutCachedTop =56 LayoutCachedWidth =16999 LayoutCachedHeight =507 End End End Begin FormFooter Height =0 Name ="PiedFormulaire" 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 Commande71_Click() DoCmd.Close acForm, "frm_syntheseRH" End Sub Private Sub Form_Open(Cancel As Integer) Me.lst_annee = forms![frm_donneesRH].lst_annee.Column(0) Me.lst_mois = forms![frm_donneesRH].lst_mois.Column(0) filtreRH Me.Refresh End Sub Private Sub lst_annee_AfterUpdate() filtreRH End Sub Private Sub lst_mois_AfterUpdate() filtreRH End Sub Public Sub filtreRH() Dim filtre As String If Me.lst_annee > 2000 And Me.lst_mois <= 12 And Me.lst_mois > 0 Then filtre = "[MoisRH]=" & Me.lst_mois.Column(0) & " AND [AnneeRH]=" & Me.lst_annee.Column(0) Me.Filter = filtre Me.FilterOn = True End If End Sub Private Sub Commande24_Click() On Error GoTo Err_Commande24_Click DoCmd.Close acForm, "frm_DonneesRH" If Me.Dirty Then Me.Dirty = False DoCmd.Close Exit_Commande24_Click: Exit Sub Err_Commande24_Click: MsgBox err.Description Resume Exit_Commande24_Click End Sub