openaccess/test/source/reports/Et_BordEFD.bas

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