openaccess/test/source/reports/Et_BordHS.bas

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