openaccess/test/source/forms/frm_syntheseRH.bas

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