openaccess/test/source/reports/Et_FormDep.bas

Version =20
VersionRequired =20
Begin Report
    LayoutForPrint = NotDefault
    AutoResize = NotDefault
    DividingLines = NotDefault
    FilterOn = NotDefault
    OrderByOn = NotDefault
    AllowDesignChanges = NotDefault
    DateGrouping =1
    GrpKeepTogether =1
    PictureAlignment =2
    DatasheetGridlinesBehavior =3
    GridY =10
    Width =15647
    DatasheetFontHeight =11
    ItemSuffix =114
    DatasheetGridlinesColor =14806254
    Filter ="[Valide]=True AND [CodeAgent]='T8' AND [MoisRH]=8 AND [AnneeRH]=2016"
    OrderBy ="[JourRH] ASC"
    RecSrcDt = Begin
        0x523180d33636e440
    End
    RecordSource ="r_FormDep_SourceEtat"
    OnOpen ="[Event Procedure]"
    DatasheetFontName ="Calibri"
    PrtMip = Begin
        0xf801000038040000f801000038040000000000001f3d0000e100000001000000 ,
        0x010000006801000000000000a10700000100000001000000
    End
    FilterOnLoad =0
    ShowPageMargins =0
    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 Line
            BorderLineStyle =0
            Width =1701
            BorderThemeColorIndex =0
            GridlineThemeColorIndex =1
            GridlineShade =65.0
        End
        Begin Image
            OldBorderStyle =0
            BorderLineStyle =0
            SizeMode =3
            PictureAlignment =2
            Width =1701
            Height =1701
            BorderColor =16777215
            GridlineColor =16777215
            BackThemeColorIndex =1
            BorderThemeColorIndex =1
            BorderShade =65.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 Subform
            BorderLineStyle =0
            Width =1701
            Height =1701
            GridlineThemeColorIndex =1
            GridlineShade =65.0
        End
        Begin EmptyCell
            Height =240
            GridlineColor =12632256
            GridlineThemeColorIndex =1
            GridlineShade =65.0
        End
        Begin FormHeader
            KeepTogether = NotDefault
            Height =2782
            Name ="EntêteÉtat"
            AlternateBackThemeColorIndex =1
            AlternateBackShade =95.0
            Begin
                Begin Label
                    TextAlign =2
                    Left =6122
                    Top =284
                    Width =3966
                    Height =397
                    FontSize =14
                    FontWeight =700
                    BorderColor =8355711
                    Name ="Étiquette0"
                    Caption ="FORMULAIRE DEPLACEMENTS"
                    GridlineColor =10921638
                    LayoutCachedLeft =6122
                    LayoutCachedTop =284
                    LayoutCachedWidth =10088
                    LayoutCachedHeight =681
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    IMESentenceMode =3
                    Left =1757
                    Top =851
                    Width =2725
                    Height =345
                    ColumnOrder =0
                    BorderColor =10921638
                    Name ="Texte1"
                    ControlSource ="Nom"
                    GridlineColor =10921638

                    LayoutCachedLeft =1757
                    LayoutCachedTop =851
                    LayoutCachedWidth =4482
                    LayoutCachedHeight =1196
                    ForeTint =100.0
                    Begin
                        Begin Label
                            Left =850
                            Top =851
                            Width =690
                            Height =315
                            BorderColor =8355711
                            Name ="Étiquette2"
                            Caption ="Agent:"
                            GridlineColor =10921638
                            LayoutCachedLeft =850
                            LayoutCachedTop =851
                            LayoutCachedWidth =1540
                            LayoutCachedHeight =1166
                            ForeTint =100.0
                        End
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    OldBorderStyle =0
                    TextAlign =1
                    IMESentenceMode =3
                    Left =14683
                    Top =624
                    Width =786
                    Height =315
                    ColumnOrder =2
                    TabIndex =1
                    BorderColor =10921638
                    ForeColor =12566463
                    Name ="IDSuivi"
                    ControlSource ="IDSuivi"
                    GridlineColor =10921638

                    LayoutCachedLeft =14683
                    LayoutCachedTop =624
                    LayoutCachedWidth =15469
                    LayoutCachedHeight =939
                    ForeThemeColorIndex =1
                    ForeTint =100.0
                    ForeShade =75.0
                    Begin
                        Begin Label
                            Visible = NotDefault
                            Left =13776
                            Top =624
                            Width =855
                            Height =315
                            BorderColor =8355711
                            ForeColor =12566463
                            Name ="Étiquette5"
                            Caption ="IDSuivi"
                            GridlineColor =10921638
                            LayoutCachedLeft =13776
                            LayoutCachedTop =624
                            LayoutCachedWidth =14631
                            LayoutCachedHeight =939
                            ForeThemeColorIndex =1
                            ForeTint =100.0
                            ForeShade =75.0
                        End
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    IMESentenceMode =3
                    Left =11281
                    Top =284
                    Width =291
                    Height =315
                    ColumnOrder =3
                    TabIndex =2
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="MoisRH"
                    ControlSource ="[MoisRH]"
                    GridlineColor =10921638

                    LayoutCachedLeft =11281
                    LayoutCachedTop =284
                    LayoutCachedWidth =11572
                    LayoutCachedHeight =599
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =1
                    IMESentenceMode =3
                    Left =13662
                    Top =227
                    Width =1821
                    Height =390
                    ColumnOrder =4
                    TabIndex =3
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="AnneeRH"
                    ControlSource ="AnneeRH"
                    GridlineColor =10921638

                    LayoutCachedLeft =13662
                    LayoutCachedTop =227
                    LayoutCachedWidth =15483
                    LayoutCachedHeight =617
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =11678
                    Top =2092
                    Width =3795
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette8"
                    Caption ="Remarque"
                    GridlineColor =10921638
                    LayoutCachedLeft =11678
                    LayoutCachedTop =2092
                    LayoutCachedWidth =15473
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =8674
                    Top =2092
                    Width =1935
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette9"
                    Caption ="Véhicule personnel uniquement (km)"
                    GridlineColor =10921638
                    LayoutCachedLeft =8674
                    LayoutCachedTop =2092
                    LayoutCachedWidth =10609
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =3344
                    Top =2092
                    Width =1695
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette11"
                    Caption ="Déplacement véhicule personnel (km)"
                    GridlineColor =10921638
                    LayoutCachedLeft =3344
                    LayoutCachedTop =2092
                    LayoutCachedWidth =5039
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =5045
                    Top =2092
                    Width =1530
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette12"
                    Caption ="Véhicule de service (km)"
                    GridlineColor =10921638
                    LayoutCachedLeft =5045
                    LayoutCachedTop =2092
                    LayoutCachedWidth =6575
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =6576
                    Top =2092
                    Width =1080
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette13"
                    Caption ="Heures de route"
                    GridlineColor =10921638
                    LayoutCachedLeft =6576
                    LayoutCachedTop =2092
                    LayoutCachedWidth =7656
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =10601
                    Top =2092
                    Width =1080
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette14"
                    Caption ="Repas, Midi ou soir (Nbre)"
                    GridlineColor =10921638
                    LayoutCachedLeft =10601
                    LayoutCachedTop =2092
                    LayoutCachedWidth =11681
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =56
                    Top =2092
                    Width =900
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette19"
                    Caption ="Jour"
                    GridlineColor =10921638
                    LayoutCachedLeft =56
                    LayoutCachedTop =2092
                    LayoutCachedWidth =956
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =3344
                    Top =1417
                    Width =3225
                    Height =675
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette20"
                    Caption ="Déplacement sur site, kilométrage aller-retour avant 7h30 ou aprés 17h"
                    GridlineColor =10921638
                    LayoutCachedLeft =3344
                    LayoutCachedTop =1417
                    LayoutCachedWidth =6569
                    LayoutCachedHeight =2092
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =8674
                    Top =1417
                    Width =1920
                    Height =675
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette21"
                    Caption ="Déplacement pendant heures de travail depuis le site"
                    GridlineColor =10921638
                    LayoutCachedLeft =8674
                    LayoutCachedTop =1417
                    LayoutCachedWidth =10594
                    LayoutCachedHeight =2092
                    ForeTint =100.0
                End
                Begin TextBox
                    OldBorderStyle =0
                    TextAlign =3
                    IMESentenceMode =3
                    Left =11735
                    Top =227
                    Width =1772
                    Height =390
                    ColumnOrder =5
                    TabIndex =4
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte62"
                    ControlSource ="=UCase(MonthName([MoisRH]))"
                    GridlineColor =10921638

                    LayoutCachedLeft =11735
                    LayoutCachedTop =227
                    LayoutCachedWidth =13507
                    LayoutCachedHeight =617
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =7653
                    Top =2092
                    Width =1020
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette69"
                    Caption ="Heures de route (Nuit)"
                    GridlineColor =10921638
                    LayoutCachedLeft =7653
                    LayoutCachedTop =2092
                    LayoutCachedWidth =8673
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =963
                    Top =2092
                    Width =2385
                    Height =690
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette72"
                    Caption ="(Départ) Itinéraire"
                    GridlineColor =10921638
                    LayoutCachedLeft =963
                    LayoutCachedTop =2092
                    LayoutCachedWidth =3348
                    LayoutCachedHeight =2782
                    ForeTint =100.0
                End
                Begin Label
                    TextAlign =2
                    Left =3685
                    Width =8503
                    Height =227
                    FontSize =9
                    BorderColor =8355711
                    ForeColor =4210752
                    Name ="Étiquette57"
                    Caption ="Parc Départemental d'Erstein - Conseil Général du Bas-Rhin"
                    GridlineColor =10921638
                    LayoutCachedLeft =3685
                    LayoutCachedWidth =12188
                    LayoutCachedHeight =227
                    ForeTint =75.0
                End
                Begin Image
                    BackStyle =0
                    PictureType =1
                    Left =283
                    Width =2245
                    Height =805
                    BorderColor =10921638
                    Name ="imgLogo"
                    ControlTipText ="Auto_Logo0"
                    GridlineColor =10921638

                    LayoutCachedLeft =283
                    LayoutCachedWidth =2528
                    LayoutCachedHeight =805
                    TabIndex =5
                End
            End
        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 =225
            Name ="Détail"
            AutoHeight =255
            AlternateBackColor =16777215
            BackThemeColorIndex =1
            Begin
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =11684
                    Width =3795
                    Height =225
                    FontSize =9
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_Remarque"
                    ControlSource ="Remarque"
                    GridlineColor =10921638

                    LayoutCachedLeft =11684
                    LayoutCachedWidth =15479
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =8674
                    Width =1936
                    Height =225
                    ColumnWidth =2550
                    FontSize =9
                    TabIndex =1
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_Distance1_perso"
                    ControlSource ="Distance1_perso"
                    GridlineColor =10921638

                    LayoutCachedLeft =8674
                    LayoutCachedWidth =10610
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =3339
                    Height =225
                    ColumnWidth =2295
                    FontSize =9
                    TabIndex =2
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_Distance2_perso"
                    ControlSource ="Distance2_perso"
                    GridlineColor =10921638

                    LayoutCachedLeft =3339
                    LayoutCachedWidth =5040
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =5034
                    Width =1530
                    Height =225
                    FontSize =9
                    TabIndex =3
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_Distance2_service"
                    ControlSource ="Distance2_service"
                    GridlineColor =10921638

                    LayoutCachedLeft =5034
                    LayoutCachedWidth =6564
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =6577
                    Width =1071
                    Height =225
                    FontSize =9
                    TabIndex =4
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_HeuresDep"
                    ControlSource ="HeuresDep"
                    GridlineColor =10921638

                    LayoutCachedLeft =6577
                    LayoutCachedWidth =7648
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =10604
                    Width =1086
                    Height =225
                    FontSize =9
                    TabIndex =5
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="txt_Repas"
                    ControlSource ="Repas"
                    GridlineColor =10921638

                    LayoutCachedLeft =10604
                    LayoutCachedWidth =11690
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =56
                    Width =906
                    Height =225
                    FontSize =9
                    TabIndex =6
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="JourRH"
                    ControlSource ="JourRH"
                    GridlineColor =10921638

                    LayoutCachedLeft =56
                    LayoutCachedWidth =962
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =7656
                    Width =1020
                    Height =225
                    FontSize =9
                    TabIndex =7
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte70"
                    ControlSource ="HeuresDepNuit"
                    GridlineColor =10921638

                    LayoutCachedLeft =7656
                    LayoutCachedWidth =8676
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =963
                    Width =2376
                    Height =225
                    ColumnWidth =3345
                    FontSize =9
                    TabIndex =8
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Itin"
                    ControlSource ="=IIf(Len([Depart])>0,'(' & [Depart] & ') ' & [Itineraire],[Itineraire])"
                    GridlineColor =10921638

                    LayoutCachedLeft =963
                    LayoutCachedWidth =3339
                    LayoutCachedHeight =225
                End
            End
        End
        Begin PageFooter
            Height =1814
            Name ="ZonePiedPage"
            AlternateBackThemeColorIndex =1
            AlternateBackShade =95.0
            BackThemeColorIndex =1
            Begin
                Begin Label
                    Left =7823
                    Top =396
                    Width =4365
                    Height =285
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette100"
                    Caption ="Certifié exact: Le directeur / Le chef de service"
                    GridlineColor =10921638
                    LayoutCachedLeft =7823
                    LayoutCachedTop =396
                    LayoutCachedWidth =12188
                    LayoutCachedHeight =681
                    ForeTint =100.0
                End
                Begin Subform
                    CanShrink = NotDefault
                    OldBorderStyle =0
                    Left =56
                    Width =4987
                    Height =1759
                    BorderColor =8355711
                    Name ="sEt_BaremeHeuresdeRoute"
                    SourceObject ="Report.sEt_BaremeHeuresdeRoute"
                    GridlineColor =10921638

                    LayoutCachedLeft =56
                    LayoutCachedWidth =5043
                    LayoutCachedHeight =1759
                    BorderThemeColorIndex =1
                    BorderShade =50.0
                End
            End
        End
        Begin FormFooter
            KeepTogether = NotDefault
            Height =283
            Name ="PiedÉtat"
            AlternateBackThemeColorIndex =1
            AlternateBackShade =95.0
            BackThemeColorIndex =1
            Begin
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =11684
                    Width =3795
                    Height =225
                    FontSize =9
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte101"
                    GridlineColor =10921638

                    LayoutCachedLeft =11684
                    LayoutCachedWidth =15479
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =8674
                    Width =1936
                    Height =225
                    FontSize =9
                    TabIndex =1
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte102"
                    ControlSource ="=Sum([Distance1_perso])"
                    GridlineColor =10921638

                    LayoutCachedLeft =8674
                    LayoutCachedWidth =10610
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =3339
                    Height =225
                    FontSize =9
                    TabIndex =2
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte103"
                    ControlSource ="=Sum([Distance2_perso])"
                    GridlineColor =10921638

                    LayoutCachedLeft =3339
                    LayoutCachedWidth =5040
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =5034
                    Width =1530
                    Height =225
                    FontSize =9
                    TabIndex =3
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte104"
                    ControlSource ="=Sum([Distance2_service])"
                    GridlineColor =10921638

                    LayoutCachedLeft =5034
                    LayoutCachedWidth =6564
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =6577
                    Width =1071
                    Height =225
                    FontSize =9
                    TabIndex =4
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte105"
                    ControlSource ="=Sum([HeuresDep])"
                    GridlineColor =10921638

                    LayoutCachedLeft =6577
                    LayoutCachedWidth =7648
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =10604
                    Width =1086
                    Height =225
                    FontSize =9
                    TabIndex =5
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte106"
                    ControlSource ="=Sum([Repas])"
                    GridlineColor =10921638

                    LayoutCachedLeft =10604
                    LayoutCachedWidth =11690
                    LayoutCachedHeight =225
                End
                Begin TextBox
                    TextAlign =2
                    IMESentenceMode =3
                    Left =7656
                    Width =1020
                    Height =225
                    FontSize =9
                    TabIndex =6
                    BorderColor =10921638
                    ForeColor =4210752
                    Name ="Texte108"
                    ControlSource ="=Sum([HeuresDepNuit])"
                    GridlineColor =10921638

                    LayoutCachedLeft =7656
                    LayoutCachedWidth =8676
                    LayoutCachedHeight =225
                End
                Begin Label
                    OldBorderStyle =1
                    TextAlign =2
                    Left =56
                    Width =3288
                    Height =226
                    FontSize =9
                    BorderColor =8355711
                    Name ="Étiquette110"
                    Caption ="Totaux:"
                    GridlineColor =10921638
                    LayoutCachedLeft =56
                    LayoutCachedWidth =3344
                    LayoutCachedHeight =226
                    ForeTint =100.0
                End
            End
        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.imgLogo.Picture = get_lien("logo_cd67")
Me.OrderBy = "[JourRH] ASC"
Me.OrderByOn = True
End Sub