openaccess/test/source/reports/SEt_EFD_IndemnKM.bas

Version =20
VersionRequired =20
Begin Report
    LayoutForPrint = NotDefault
    DividingLines = NotDefault
    AllowAdditions = NotDefault
    AllowDesignChanges = NotDefault
    DateGrouping =1
    GrpKeepTogether =1
    PictureAlignment =2
    DatasheetGridlinesBehavior =3
    GridY =10
    Width =9751
    DatasheetFontHeight =11
    ItemSuffix =42
    DatasheetGridlinesColor =14806254
    OnNoData ="[Event Procedure]"
    RecSrcDt = Begin
        0xf1d68355d43be440
    End
    RecordSource ="SELECT r_FraisKm3.CodeAgent, r_FraisKm3.AnneeRH, r_FraisKm3.MoisRH, r_FraisKm3.P"
        "eriodeBareme, r_FraisKm3.DistanceMois, r_FraisKm3.NomBareme, r_FraisKm3.TypeVehi"
        "cule FROM r_FraisKm3 GROUP BY r_FraisKm3.CodeAgent, r_FraisKm3.AnneeRH, r_FraisK"
        "m3.MoisRH, r_FraisKm3.PeriodeBareme, r_FraisKm3.DistanceMois, r_FraisKm3.NomBare"
        "me, r_FraisKm3.TypeVehicule; "
    OnOpen ="[Event Procedure]"
    DatasheetFontName ="Calibri"
    PrtMip = Begin
        0x0000000000000000000000000300000000000000172600006a08000001000000 ,
        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 PageHeader
            Height =0
            Name ="ZoneEntêtePage"
            AlternateBackThemeColorIndex =1
            AlternateBackShade =95.0
            BackThemeColorIndex =1
        End
        Begin Section
            KeepTogether = NotDefault
            CanGrow = NotDefault
            CanShrink = NotDefault
            Height =2154
            Name ="Détail"
            AlternateBackColor =16777215
            AlternateBackThemeColorIndex =1
            BackThemeColorIndex =1
            Begin
                Begin Label
                    Left =113
                    Top =113
                    Width =1308
                    Height =280
                    FontSize =10
                    BorderColor =8355711
                    Name ="Étiquette1"
                    Caption ="Automobile"
                    GridlineColor =10921638
                    LayoutCachedLeft =113
                    LayoutCachedTop =113
                    LayoutCachedWidth =1421
                    LayoutCachedHeight =393
                    ForeTint =100.0
                End
                Begin Label
                    Left =113
                    Top =1077
                    Width =3360
                    Height =285
                    FontSize =10
                    BorderColor =8355711
                    Name ="Étiquette2"
                    Caption ="Motocyclette (cylindrée sup. à 125 cm3)"
                    GridlineColor =10921638
                    LayoutCachedLeft =113
                    LayoutCachedTop =1077
                    LayoutCachedWidth =3473
                    LayoutCachedHeight =1362
                    ForeTint =100.0
                End
                Begin Label
                    Left =120
                    Top =1424
                    Width =3360
                    Height =285
                    FontSize =10
                    BorderColor =8355711
                    Name ="Étiquette3"
                    Caption ="Vélomoteur (cylindrée de 50 à 125 cm3)"
                    GridlineColor =10921638
                    LayoutCachedLeft =120
                    LayoutCachedTop =1424
                    LayoutCachedWidth =3480
                    LayoutCachedHeight =1709
                    ForeTint =100.0
                End
                Begin Label
                    Left =1530
                    Top =113
                    Width =3120
                    Height =270
                    FontSize =10
                    BorderColor =8355711
                    Name ="jusqu"
                    Caption ="jusqu'à 2000 Km"
                    GridlineColor =10921638
                    LayoutCachedLeft =1530
                    LayoutCachedTop =113
                    LayoutCachedWidth =4650
                    LayoutCachedHeight =383
                    ForeTint =100.0
                End
                Begin Label
                    Left =1530
                    Top =383
                    Width =3120
                    Height =285
                    FontSize =10
                    BorderColor =8355711
                    Name ="de"
                    Caption ="de 2000 à 10000 Km"
                    GridlineColor =10921638
                    LayoutCachedLeft =1530
                    LayoutCachedTop =383
                    LayoutCachedWidth =4650
                    LayoutCachedHeight =668
                    ForeTint =100.0
                End
                Begin Label
                    Left =1530
                    Top =668
                    Width =3120
                    Height =285
                    FontSize =10
                    BorderColor =8355711
                    Name ="apres"
                    Caption ="aprés 10000 Km"
                    GridlineColor =10921638
                    LayoutCachedLeft =1530
                    LayoutCachedTop =668
                    LayoutCachedWidth =4650
                    LayoutCachedHeight =953
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =4988
                    Top =113
                    Width =1009
                    Height =270
                    FontSize =10
                    BorderColor =8355711
                    Name ="NbAuto0"
                    ControlSource ="=IIf([TypeVehicule]=1,Nz(DLookUp(\"[DistanceMoisRepartie]\",\"[r_FraisKm3]\",\"["
                        "CodeAgent]='\" & [CodeAgent] & \"' AND [MoisRH]=\" & [MoisRH] & \" AND [AnneeRH]"
                        "=\" & [AnneeRH] & \" AND [BorneInf]=0\"),0),0)"
                    GridlineColor =10921638

                    LayoutCachedLeft =4988
                    LayoutCachedTop =113
                    LayoutCachedWidth =5997
                    LayoutCachedHeight =383
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =4988
                    Top =396
                    Width =1009
                    Height =270
                    FontSize =10
                    TabIndex =1
                    BorderColor =8355711
                    Name ="NbAuto2000"
                    ControlSource ="=IIf([TypeVehicule]=1,Nz(DLookUp(\"[DistanceMoisRepartie]\",\"[r_FraisKm3]\",\"["
                        "CodeAgent]='\" & [CodeAgent] & \"' AND [MoisRH]=\" & [MoisRH] & \" AND [AnneeRH]"
                        "=\" & [AnneeRH] & \" AND [BorneInf]=2000\"),0),0)"
                    GridlineColor =10921638

                    LayoutCachedLeft =4988
                    LayoutCachedTop =396
                    LayoutCachedWidth =5997
                    LayoutCachedHeight =666
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =4988
                    Top =680
                    Width =1009
                    Height =270
                    FontSize =10
                    TabIndex =2
                    BorderColor =8355711
                    Name ="NbAuto10000"
                    ControlSource ="=IIf([TypeVehicule]=1,Nz(DLookUp(\"[DistanceMoisRepartie]\",\"[r_FraisKm3]\",\"["
                        "CodeAgent]='\" & [CodeAgent] & \"' AND [MoisRH]=\" & [MoisRH] & \" AND [AnneeRH]"
                        "=\" & [AnneeRH] & \" AND [BorneInf]=10000\"),0),0)"
                    GridlineColor =10921638

                    LayoutCachedLeft =4988
                    LayoutCachedTop =680
                    LayoutCachedWidth =5997
                    LayoutCachedHeight =950
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =4988
                    Top =1070
                    Width =1009
                    Height =270
                    FontSize =10
                    TabIndex =3
                    BorderColor =8355711
                    Name ="NbMoto"
                    ControlSource ="=IIf([TypeVehicule]=2,Nz([DistanceMois],0),0)"
                    GridlineColor =10921638

                    LayoutCachedLeft =4988
                    LayoutCachedTop =1070
                    LayoutCachedWidth =5997
                    LayoutCachedHeight =1340
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =4988
                    Top =1417
                    Width =1009
                    Height =270
                    FontSize =10
                    TabIndex =4
                    BorderColor =8355711
                    Name ="NbVelo"
                    ControlSource ="=IIf([TypeVehicule]=3,Nz([DistanceMois],0),0)"
                    GridlineColor =10921638

                    LayoutCachedLeft =4988
                    LayoutCachedTop =1417
                    LayoutCachedWidth =5997
                    LayoutCachedHeight =1687
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =6633
                    Top =113
                    Width =691
                    Height =270
                    FontSize =10
                    TabIndex =5
                    BorderColor =8355711
                    Name ="coutAuto0"
                    ControlSource ="=Bareme([NomBareme],1999,[MoisRH],[AnneeRH])"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =6633
                    LayoutCachedTop =113
                    LayoutCachedWidth =7324
                    LayoutCachedHeight =383
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =6066
                            Top =113
                            Width =510
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette14"
                            Caption ="km à "
                            GridlineColor =10921638
                            LayoutCachedLeft =6066
                            LayoutCachedTop =113
                            LayoutCachedWidth =6576
                            LayoutCachedHeight =383
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =6633
                    Top =396
                    Width =691
                    Height =270
                    FontSize =10
                    TabIndex =6
                    BorderColor =8355711
                    Name ="CoutAuto2000"
                    ControlSource ="=Bareme([NomBareme],9999,[MoisRH],[AnneeRH])"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =6633
                    LayoutCachedTop =396
                    LayoutCachedWidth =7324
                    LayoutCachedHeight =666
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =6066
                            Top =396
                            Width =510
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette16"
                            Caption ="km à "
                            GridlineColor =10921638
                            LayoutCachedLeft =6066
                            LayoutCachedTop =396
                            LayoutCachedWidth =6576
                            LayoutCachedHeight =666
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =6633
                    Top =680
                    Width =691
                    Height =270
                    FontSize =10
                    TabIndex =7
                    BorderColor =8355711
                    Name ="CoutAuto10000"
                    ControlSource ="=Bareme([NomBareme],99999,[MoisRH],[AnneeRH])"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =6633
                    LayoutCachedTop =680
                    LayoutCachedWidth =7324
                    LayoutCachedHeight =950
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =6066
                            Top =680
                            Width =510
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette18"
                            Caption ="km à "
                            GridlineColor =10921638
                            LayoutCachedLeft =6066
                            LayoutCachedTop =680
                            LayoutCachedWidth =6576
                            LayoutCachedHeight =950
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =6633
                    Top =1070
                    Width =691
                    Height =270
                    FontSize =10
                    TabIndex =8
                    BorderColor =8355711
                    Name ="CoutMoto"
                    ControlSource ="=Bareme('Frais Kilométriques (2)',0,[MoisRH],[AnneeRH])"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =6633
                    LayoutCachedTop =1070
                    LayoutCachedWidth =7324
                    LayoutCachedHeight =1340
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =6066
                            Top =1070
                            Width =510
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette20"
                            Caption ="km à "
                            GridlineColor =10921638
                            LayoutCachedLeft =6066
                            LayoutCachedTop =1070
                            LayoutCachedWidth =6576
                            LayoutCachedHeight =1340
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    BackStyle =0
                    IMESentenceMode =3
                    Left =6633
                    Top =1417
                    Width =691
                    Height =270
                    FontSize =10
                    TabIndex =9
                    BorderColor =8355711
                    Name ="CoutVelo"
                    ControlSource ="=Bareme('Frais Kilométriques (3)',0,[MoisRH],[AnneeRH])"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =6633
                    LayoutCachedTop =1417
                    LayoutCachedWidth =7324
                    LayoutCachedHeight =1687
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =6066
                            Top =1417
                            Width =510
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette22"
                            Caption ="km à "
                            GridlineColor =10921638
                            LayoutCachedLeft =6066
                            LayoutCachedTop =1417
                            LayoutCachedWidth =6576
                            LayoutCachedHeight =1687
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =7710
                    Top =113
                    Width =1040
                    Height =270
                    FontSize =10
                    TabIndex =10
                    BorderColor =8355711
                    Name ="MontantAuto0"
                    ControlSource ="=[NbAuto0]*[coutAuto0]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =7710
                    LayoutCachedTop =113
                    LayoutCachedWidth =8750
                    LayoutCachedHeight =383
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =7313
                            Top =113
                            Width =285
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette24"
                            Caption =" ="
                            GridlineColor =10921638
                            LayoutCachedLeft =7313
                            LayoutCachedTop =113
                            LayoutCachedWidth =7598
                            LayoutCachedHeight =383
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =7710
                    Top =396
                    Width =1040
                    Height =270
                    FontSize =10
                    TabIndex =11
                    BorderColor =8355711
                    Name ="MontantAuto2000"
                    ControlSource ="=[NbAuto2000]*[coutAuto2000]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =7710
                    LayoutCachedTop =396
                    LayoutCachedWidth =8750
                    LayoutCachedHeight =666
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =7313
                            Top =396
                            Width =285
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette26"
                            Caption =" ="
                            GridlineColor =10921638
                            LayoutCachedLeft =7313
                            LayoutCachedTop =396
                            LayoutCachedWidth =7598
                            LayoutCachedHeight =666
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =7710
                    Top =680
                    Width =1040
                    Height =270
                    FontSize =10
                    TabIndex =12
                    BorderColor =8355711
                    Name ="MontantAuto10000"
                    ControlSource ="=[NbAuto10000]*[coutAuto10000]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =7710
                    LayoutCachedTop =680
                    LayoutCachedWidth =8750
                    LayoutCachedHeight =950
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =7313
                            Top =680
                            Width =285
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette28"
                            Caption =" ="
                            GridlineColor =10921638
                            LayoutCachedLeft =7313
                            LayoutCachedTop =680
                            LayoutCachedWidth =7598
                            LayoutCachedHeight =950
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =7710
                    Top =1070
                    Width =1040
                    Height =270
                    FontSize =10
                    TabIndex =13
                    BorderColor =8355711
                    Name ="MontantMoto"
                    ControlSource ="=[NbMoto]*[coutMoto]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =7710
                    LayoutCachedTop =1070
                    LayoutCachedWidth =8750
                    LayoutCachedHeight =1340
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =7313
                            Top =1070
                            Width =285
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette30"
                            Caption =" ="
                            GridlineColor =10921638
                            LayoutCachedLeft =7313
                            LayoutCachedTop =1070
                            LayoutCachedWidth =7598
                            LayoutCachedHeight =1340
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =7710
                    Top =1417
                    Width =1040
                    Height =270
                    FontSize =10
                    TabIndex =14
                    BorderColor =8355711
                    Name ="MontantVelo"
                    ControlSource ="=[NbVelo]*[CoutVelo]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =7710
                    LayoutCachedTop =1417
                    LayoutCachedWidth =8750
                    LayoutCachedHeight =1687
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                    Begin
                        Begin Label
                            Left =7313
                            Top =1417
                            Width =285
                            Height =270
                            FontSize =10
                            BorderColor =8355711
                            Name ="Étiquette32"
                            Caption =" ="
                            GridlineColor =10921638
                            LayoutCachedLeft =7313
                            LayoutCachedTop =1417
                            LayoutCachedWidth =7598
                            LayoutCachedHeight =1687
                            ForeTint =100.0
                        End
                    End
                End
                Begin Label
                    Left =4705
                    Top =1757
                    Width =3750
                    Height =345
                    FontWeight =700
                    BorderColor =8355711
                    Name ="Étiquette33"
                    Caption ="Total des indemnités kilométriques:"
                    GridlineColor =10921638
                    LayoutCachedLeft =4705
                    LayoutCachedTop =1757
                    LayoutCachedWidth =8455
                    LayoutCachedHeight =2102
                    ForeTint =100.0
                End
                Begin TextBox
                    FontUnderline = NotDefault
                    OldBorderStyle =0
                    TextAlign =3
                    BackStyle =0
                    IMESentenceMode =3
                    Left =8447
                    Top =1757
                    Width =1087
                    Height =330
                    FontWeight =700
                    TabIndex =15
                    BorderColor =8355711
                    Name ="TotalIndemnKm"
                    ControlSource ="=[MontantAuto0]+[MontantAuto10000]+[MontantAuto2000]+[MontantMoto]+[MontantVelo]"
                    Format ="#,##0.00 €;-#,##0.00 €"
                    GridlineColor =10921638

                    LayoutCachedLeft =8447
                    LayoutCachedTop =1757
                    LayoutCachedWidth =9534
                    LayoutCachedHeight =2087
                    BorderThemeColorIndex =0
                    BorderTint =50.0
                    BorderShade =100.0
                    ForeTint =100.0
                    CurrencySymbol ="€"
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =113
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =16
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="CodeAgent"
                    ControlSource ="CodeAgent"
                    GridlineColor =10921638

                    LayoutCachedLeft =113
                    LayoutCachedTop =1757
                    LayoutCachedWidth =689
                    LayoutCachedHeight =1877
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =793
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =17
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="MoisRH"
                    ControlSource ="MoisRH"
                    GridlineColor =10921638

                    LayoutCachedLeft =793
                    LayoutCachedTop =1757
                    LayoutCachedWidth =1369
                    LayoutCachedHeight =1877
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =1417
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =18
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="AnneeRH"
                    ControlSource ="AnneeRH"
                    GridlineColor =10921638

                    LayoutCachedLeft =1417
                    LayoutCachedTop =1757
                    LayoutCachedWidth =1993
                    LayoutCachedHeight =1877
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =2097
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =19
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte39"
                    ControlSource ="TypeVehicule"
                    GridlineColor =10921638

                    LayoutCachedLeft =2097
                    LayoutCachedTop =1757
                    LayoutCachedWidth =2673
                    LayoutCachedHeight =1877
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =2777
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =20
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte40"
                    ControlSource ="NomBareme"
                    GridlineColor =10921638

                    LayoutCachedLeft =2777
                    LayoutCachedTop =1757
                    LayoutCachedWidth =3353
                    LayoutCachedHeight =1877
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =3458
                    Top =1757
                    Width =576
                    Height =120
                    TabIndex =21
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte41"
                    ControlSource ="PeriodeBareme"
                    GridlineColor =10921638

                    LayoutCachedLeft =3458
                    LayoutCachedTop =1757
                    LayoutCachedWidth =4034
                    LayoutCachedHeight =1877
                End
            End
        End
        Begin PageFooter
            Height =0
            Name ="ZonePiedPage"
            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_NoData(Cancel As Integer)
'si aucune données, on supprime la requête source de manière à ce que le sous-état s'ouvre quand même
'SELECT r_FraisKm3.CodeAgent, r_FraisKm3.AnneeRH, r_FraisKm3.MoisRH, r_FraisKm3.PeriodeBareme, r_FraisKm3.DistanceMois, r_FraisKm3.NomBareme, r_FraisKm3.TypeVehicule FROM r_FraisKm3 GROUP BY r_FraisKm3.CodeAgent, r_FraisKm3.AnneeRH, r_FraisKm3.MoisRH, r_FraisKm3.PeriodeBareme, r_FraisKm3.DistanceMois, r_FraisKm3.NomBareme, r_FraisKm3.TypeVehicule;


End Sub

Private Sub Report_Open(Cancel As Integer)
'méthode utilisée pour des raisons de qualité de la mise en page:
'les étiquettes sont mises à jour en fonction des bornes de la table tbl_baremes
'd'eventuelles nouvelles lignes devront être ajoutées manuellement

Dim rs As DAO.Recordset

'MAJ des etiquettes bornes
Set rs = CurrentDb.OpenRecordset("SELECT * FROM r_baremes WHERE [NomBareme]='Frais Kilométriques (11)' ORDER BY [BorneInf];")
rs.MoveFirst
Me.jusqu.Caption = "jusqu'à " & rs![BorneSup] & " " & rs![UniteBornes]
rs.MoveNext
Me.De.Caption = "de " & rs![BorneInf] & " à " & rs![BorneSup] & " " & rs![UniteBornes]
rs.MoveNext
Me.apres.Caption = "aprés " & rs![BorneInf] & " " & rs![UniteBornes]
Set rs = Nothing


End Sub