Version =20
VersionRequired =20
Checksum =45066671
Begin Form
    AutoCenter = NotDefault
    AllowDesignChanges = NotDefault
    TabularFamily =0
    PictureAlignment =2
    DatasheetGridlinesBehavior =3
    GridY =10
    Width =31037
    DatasheetFontHeight =10
    ItemSuffix =68
    Left =405
    Top =900
    Right =11250
    Bottom =6135
    DatasheetGridlinesColor =12632256
    RecSrcDt = Begin
        0xbb6bbb842d62e440
    End
    RecordSource ="qry_EnergieTarifeMonatJahr"
    Caption ="qry_EnergieTarifeMonatJahr"
    DatasheetFontName ="Arial"
    Begin
        Begin Label
            BackStyle =0
            BackColor =-2147483633
            ForeColor =-2147483630
        End
        Begin Rectangle
            SpecialEffect =3
            BackStyle =0
            Width =850
            Height =850
        End
        Begin Line
            Width =1701
        End
        Begin Image
            BackStyle =0
            OldBorderStyle =0
            PictureAlignment =2
            Width =1701
            Height =1701
        End
        Begin CommandButton
            Width =1701
            Height =283
            FontSize =8
            FontWeight =400
            FontName ="MS Sans Serif"
        End
        Begin OptionButton
            SpecialEffect =2
            LabelX =230
            LabelY =-30
        End
        Begin CheckBox
            SpecialEffect =2
            LabelX =230
            LabelY =-30
        End
        Begin OptionGroup
            SpecialEffect =3
            Width =1701
            Height =1701
        End
        Begin BoundObjectFrame
            SpecialEffect =2
            OldBorderStyle =0
            BackStyle =0
            Width =4536
            Height =2835
            LabelX =-1701
        End
        Begin TextBox
            FELineBreak = NotDefault
            SpecialEffect =2
            Width =1701
            LabelX =-1701
            BackColor =-2147483643
            ForeColor =-2147483640
            AsianLineBreak =255
        End
        Begin ListBox
            SpecialEffect =2
            Width =1701
            Height =1417
            LabelX =-1701
            BackColor =-2147483643
            ForeColor =-2147483640
        End
        Begin ComboBox
            SpecialEffect =2
            Width =1701
            LabelX =-1701
            BackColor =-2147483643
            ForeColor =-2147483640
        End
        Begin Subform
            SpecialEffect =2
            Width =1701
            Height =1701
        End
        Begin UnboundObjectFrame
            SpecialEffect =2
            OldBorderStyle =1
            Width =4536
            Height =2835
        End
        Begin ToggleButton
            Width =283
            Height =283
            FontSize =8
            FontWeight =400
            FontName ="MS Sans Serif"
        End
        Begin Tab
            BackStyle =0
            Width =5103
            Height =3402
        End
        Begin FormHeader
            Height =465
            Name ="Formularkopf"
            GUID = Begin
                0x5041b6e46d08dd4a9a0ba57731ca14f1
            End
            Begin
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =1770
                    Top =62
                    Width =1026
                    Height =255
                    Name ="ID_ET_Bezeichnungsfeld"
                    Caption ="ID_ET"
                    FontName ="Arial"
                    GUID = Begin
                        0x7ce588370dfbd248aa6642dbc5f35bb6
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =4485
                    Top =62
                    Width =2211
                    Height =285
                    Name ="Tarif_Bezeichnungsfeld"
                    Caption ="Tarif"
                    FontName ="Arial"
                    GUID = Begin
                        0x3ad06e039dbf3647bf36e7f5ce3dde44
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =6855
                    Top =62
                    Width =1536
                    Height =285
                    Name ="BearbeitungsgebuehrKunde_Bezeichnungsfeld"
                    Caption ="Bea Kunde Vorgabe"
                    FontName ="Arial"
                    GUID = Begin
                        0x877f30d6b7cdb74c9e8f853b897531da
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =9702
                    Top =60
                    Width =681
                    Height =285
                    Name ="GG_Bezeichnungsfeld"
                    Caption ="GG"
                    FontName ="Arial"
                    GUID = Begin
                        0x97b7b2ba13b6ae41a3bc194f8acb485a
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =15540
                    Top =62
                    Width =1041
                    Height =285
                    Name ="Bezeichnungsfeld54"
                    Caption ="Firma"
                    FontName ="Arial"
                    GUID = Begin
                        0x848057a48213364fbaaf896225a2c187
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =8445
                    Top =62
                    Width =1140
                    Height =285
                    Name ="Bezeichnungsfeld37"
                    Caption ="Bea Kunde Ist"
                    FontName ="Arial"
                    GUID = Begin
                        0xcbf4e7ff4e0ca448828cb4f9759632ce
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =10440
                    Top =62
                    Width =846
                    Height =285
                    Name ="Laufzeit_Bezeichnungsfeld"
                    Caption ="Laufzeit"
                    FontName ="Arial"
                    GUID = Begin
                        0x19418dd77d78774f9170cffbbf3bf1d9
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =17415
                    Top =60
                    Width =570
                    Height =285
                    Name ="Bezeichnungsfeld56"
                    Caption ="Anrede"
                    FontName ="Arial"
                    GUID = Begin
                        0xe3b61d80067ee64a8f839036c26110ee
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =18556
                    Top =62
                    Width =1011
                    Height =345
                    Name ="Bezeichnungsfeld58"
                    Caption ="Vorname"
                    FontName ="Arial"
                    GUID = Begin
                        0xef7cbaf8341c0144a9a0d7d4b83469d3
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =20136
                    Top =62
                    Width =861
                    Height =345
                    Name ="Bezeichnungsfeld60"
                    Caption ="Nachname"
                    FontName ="Arial"
                    GUID = Begin
                        0xf38ad27eaaf32245b0c5298e42ead39a
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =21961
                    Top =62
                    Width =2070
                    Height =345
                    Name ="Bezeichnungsfeld66"
                    Caption ="Strasse Hausnr."
                    FontName ="Arial"
                    GUID = Begin
                        0x0301acb0cdb5d442b7738f2d296a0e9b
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =2850
                    Top =62
                    Width =1575
                    Height =285
                    Name ="Bezeichnungsfeld40"
                    Caption ="Zählernummer"
                    FontName ="Arial"
                    GUID = Begin
                        0x8f66d32dc1948841b04501080457794f
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =11355
                    Top =62
                    Width =1245
                    Height =285
                    Name ="Bezeichnungsfeld46"
                    Caption ="Vertragseingang"
                    FontName ="Arial"
                    GUID = Begin
                        0x8f23347cc5914f47a25716955c9b4458
                    End
                End
                Begin Label
                    OverlapFlags =93
                    TextAlign =1
                    Left =12645
                    Top =62
                    Width =1365
                    Height =285
                    Name ="Bezeichnungsfeld48"
                    Caption ="Vertrag versendet"
                    FontName ="Arial"
                    GUID = Begin
                        0x04eb250c7ef48b4b8f1d0c0eb22c5c71
                    End
                End
                Begin Label
                    OverlapFlags =87
                    TextAlign =1
                    Left =14014
                    Top =60
                    Width =1425
                    Height =285
                    Name ="Bezeichnungsfeld52"
                    Caption ="Versendet Ja/Nein"
                    FontName ="Arial"
                    GUID = Begin
                        0x7008ab4bc1a0fd47a6f367ce6553b3e8
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =570
                    Top =62
                    Width =1086
                    Height =285
                    Name ="Bezeichnungsfeld50"
                    Caption ="Status_Nr"
                    FontName ="Arial"
                    GUID = Begin
                        0x96ee07c22cb1c24f8a6b0b41ef881308
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =24516
                    Top =60
                    Width =846
                    Height =345
                    Name ="Bezeichnungsfeld62"
                    Caption ="PLZ"
                    FontName ="Arial"
                    GUID = Begin
                        0x855e0f35a1a2dd49888335cb64a64476
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =25470
                    Top =60
                    Width =1026
                    Height =345
                    Name ="Bezeichnungsfeld64"
                    Caption ="Ort"
                    FontName ="Arial"
                    GUID = Begin
                        0x627f59bb0c79834cb2e53711b54015a9
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =26604
                    Top =60
                    Width =885
                    Height =255
                    Name ="Bezeichnungsfeld67"
                    Caption ="Bemerkung"
                    FontName ="Arial"
                    GUID = Begin
                        0xcfffdf00de3e49488155a5fb927fb0c7
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Top =63
                    Width =510
                    Height =285
                    Name ="Bezeichnungsfeld42"
                    Caption ="Import"
                    FontName ="Arial"
                    GUID = Begin
                        0x2df2293828206849b21ceecbba28c5c7
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =28350
                    Top =60
                    Width =1026
                    Height =405
                    Name ="AngelegtAm_Bezeichnungsfeld"
                    Caption ="AngelegtAm"
                    FontName ="Arial"
                    GUID = Begin
                        0x77eb6f30bbbdec4a9cff6ab9c0fbfdd5
                    End
                End
                Begin Label
                    OverlapFlags =85
                    TextAlign =1
                    Left =29484
                    Top =60
                    Width =1119
                    Height =405
                    Name ="Angelegtvon_Bezeichnungsfeld"
                    Caption ="Angelegt von"
                    FontName ="Arial"
                    GUID = Begin
                        0xfeba3a58af31a74ca77e88b99a455663
                    End
                End
            End
        End
        Begin Section
            Height =522
            Name ="Detailbereich"
            GUID = Begin
                0xf513eed2341d2c4082c6ab70bee8b164
            End
            Begin
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    DisplayWhen =1
                    OverlapFlags =85
                    IMESentenceMode =3
                    Left =19122
                    Top =402
                    Width =120
                    Height =120
                    ColumnWidth =1080
                    TabIndex =15
                    Name ="MonatJahr"
                    ControlSource ="MonatJahr"
                    GUID = Begin
                        0xbbbaca52ccc04b44bd738005781dd349
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =1770
                    Top =49
                    Width =1020
                    Height =285
                    ColumnWidth =1125
                    TabIndex =14
                    Name ="ID_ET"
                    ControlSource ="ID_ET"
                    FontName ="Arial"
                    GUID = Begin
                        0xfd97c096a97f8f41a439991efd5463e6
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =85
                    IMESentenceMode =3
                    Left =18585
                    Top =402
                    Width =120
                    Height =120
                    ColumnWidth =1260
                    TabIndex =22
                    Name ="ProvisionZiel"
                    ControlSource ="ProvisionZiel"
                    GUID = Begin
                        0x147df83713bf0144b4c2f435996d38ea
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =93
                    IMESentenceMode =3
                    Left =21600
                    Top =345
                    Width =120
                    Height =120
                    ColumnWidth =1230
                    TabIndex =23
                    Name ="ProvisionAD"
                    ControlSource ="ProvisionAD"
                    GUID = Begin
                        0xbb9431c4cc91054ab8d9d90c58a0d768
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =6858
                    Top =49
                    Width =1530
                    Height =285
                    ColumnWidth =2565
                    TabIndex =17
                    Name ="BeaKDVorgabe"
                    ControlSource ="BearbeitungsgebuehrKunde"
                    FontName ="Arial"
                    GUID = Begin
                        0x322282c74db08645bff005c393a6986f
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =93
                    IMESentenceMode =3
                    Left =17355
                    Top =345
                    Width =120
                    Height =120
                    ColumnWidth =2445
                    TabIndex =24
                    Name ="BearbeitungsgebuehrMEP"
                    ControlSource ="BearbeitungsgebuehrMEP"
                    GUID = Begin
                        0xf9650b8316e3d243abfff8919c01b184
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =85
                    IMESentenceMode =3
                    Left =24090
                    Top =390
                    Width =120
                    Height =120
                    ColumnWidth =855
                    TabIndex =19
                    Name ="BearbeitungsgebuehrAD"
                    ControlSource ="BearbeitungsgebuehrAD"
                    GUID = Begin
                        0x6ceb3ee7cfad8f47b87a239767b2bf4e
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =85
                    IMESentenceMode =3
                    Left =14970
                    Top =401
                    Width =120
                    Height =120
                    ColumnWidth =2310
                    TabIndex =25
                    Name ="BearbeitungsgebuerBCS"
                    ControlSource ="BearbeitungsgebuerBCS"
                    GUID = Begin
                        0x8978d6331797db4292f77af1bae81a40
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =85
                    IMESentenceMode =3
                    Left =15690
                    Top =390
                    Width =120
                    Height =120
                    TabIndex =26
                    Name ="LfdNr"
                    ControlSource ="LfdNr"
                    GUID = Begin
                        0xb93509a33f573f43a7fa36af5a6f5083
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =9645
                    Top =49
                    Width =675
                    Height =285
                    ColumnWidth =480
                    TabIndex =20
                    Name ="GG"
                    ControlSource ="GG"
                    FontName ="Arial"
                    GUID = Begin
                        0x15e2806e830eb14baef44a046951d850
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =93
                    IMESentenceMode =3
                    Left =20963
                    Top =345
                    Width =120
                    Height =120
                    ColumnWidth =900
                    TabIndex =27
                    Name ="ID_bcs"
                    ControlSource ="ID_bcs"
                    GUID = Begin
                        0xeae22548e328524ebd5a74f9b7d48ec3
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =93
                    IMESentenceMode =3
                    Left =21360
                    Top =345
                    Width =120
                    Height =120
                    ColumnWidth =900
                    TabIndex =28
                    Name ="ID_mep"
                    ControlSource ="ID_mep"
                    GUID = Begin
                        0x929e99aeb6cc784abab67b22d1f13626
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =28407
                    Top =45
                    Width =1035
                    Height =285
                    ColumnWidth =1245
                    TabIndex =29
                    Name ="AngelegtAm"
                    ControlSource ="AngelegtAm"
                    DefaultValue ="=Now()"
                    FontName ="Arial"
                    GUID = Begin
                        0xf046d2b5c1ba764cbc092a25fe378416
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =29540
                    Top =45
                    Width =1497
                    Height =285
                    ColumnWidth =1230
                    TabIndex =30
                    Name ="Angelegtvon"
                    ControlSource ="Angelegtvon"
                    DefaultValue ="=[Forms]![frm_Anmeldung]![Benutzername]"
                    FontName ="Arial"
                    GUID = Begin
                        0x63370c0bacf85b488ed8d82b9423a382
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =10376
                    Top =49
                    Width =900
                    Height =285
                    ColumnWidth =855
                    TabIndex =21
                    Name ="Laufzeit"
                    ControlSource ="Laufzeit"
                    FontName ="Arial"
                    GUID = Begin
                        0x1ce2d872888b4246b98939aa0485d02b
                    End
                End
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    OverlapFlags =93
                    IMESentenceMode =3
                    Left =16841
                    Top =345
                    Width =120
                    Height =120
                    ColumnWidth =960
                    TabIndex =18
                    Name ="BearbeitungsgebuehrAD1"
                    DefaultValue ="=[BearbeitungsgebuehrAD]"
                    GUID = Begin
                        0x854d0c27b662bd4e95a787611e83bad9
                    End
                End
                Begin TextBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =8445
                    Top =49
                    Width =1140
                    Height =285
                    TabIndex =1
                    Name ="BeaKDIst"
                    OnExit ="[Event Procedure]"
                    DefaultValue ="=[BearbeitungsgebuehrKunde]"
                    FontName ="Arial"
                    GUID = Begin
                        0xa71c35333a074e40b9cb35641c62a70c
                    End
                End
                Begin TextBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =2847
                    Top =49
                    Width =1575
                    Height =285
                    ColumnWidth =2475
                    Name ="Zaehlernummer"
                    ValidationRule ="=[Zaehlernummer] Is Not Null"
                    ValidationText ="\"Achtung es muss die Zählernummer eingegeben werden!!!\""
                    FontName ="Arial"
                    GUID = Begin
                        0xc237c75327f3a941b0c33f27b282c512
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    BackStyle =0
                    IMESentenceMode =3
                    Top =60
                    Width =510
                    Height =285
                    ColumnWidth =1650
                    TabIndex =13
                    BackColor =255
                    ForeColor =255
                    Name ="Import"
                    OnDblClick ="[Event Procedure]"
                    FontName ="Arial"
                    GUID = Begin
                        0xbe410d808aaf044592284890a24d8b38
                    End
                End
                Begin TextBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =26604
                    Top =45
                    Width =1695
                    Height =285
                    TabIndex =12
                    Name ="Bemerkung"
                    OnEnter ="Mkr_Zoombx"
                    DefaultValue ="=\"*\""
                    FontName ="Arial"
                    GUID = Begin
                        0x650237857215df478ee684bc8c82e647
                    End
                End
                Begin TextBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =11349
                    Top =49
                    Width =1290
                    Height =285
                    ColumnWidth =1590
                    TabIndex =2
                    Name ="Vertragseingang"
                    Format ="Short Date"
                    FontName ="Arial"
                    GUID = Begin
                        0xf5216bec5e83254e8c320a858a283ee1
                    End
                End
                Begin TextBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =12705
                    Top =49
                    Width =1305
                    Height =285
                    TabIndex =3
                    Name ="VertragVersendet"
                    Format ="Short Date"
                    DefaultValue ="=Date()"
                    FontName ="Arial"
                    GUID = Begin
                        0xa112459ee5670e46a69c37d76d0f4f97
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =570
                    Top =60
                    Width =1140
                    Height =285
                    TabIndex =31
                    Name ="Status_Nr"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![subfrm_Terminierung].[Form]![Status_NR]"
                    FontName ="Arial"
                    GUID = Begin
                        0x0c56ec2243943147925e39392d40f83d
                    End
                End
                Begin ComboBox
                    RowSourceTypeInt =1
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =93
                    TextAlign =1
                    IMESentenceMode =3
                    Left =14070
                    Top =49
                    Width =1365
                    Height =285
                    TabIndex =4
                    GUID = Begin
                        0x77bdcd5c6f7b8748ba25717eccafad71
                    End
                    Name ="VertragVersendetJaNein"
                    RowSourceType ="Value List"
                    RowSource ="\"Ja\";\"Nein\""
                    DefaultValue ="=\"Ja\""
                    FontName ="Arial"
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =215
                    TextAlign =1
                    IMESentenceMode =3
                    Left =15435
                    Top =49
                    Width =1920
                    Height =300
                    TabIndex =5
                    Name ="Firma"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Firma]"
                    FontName ="Arial"
                    GUID = Begin
                        0x89500d21b4816c4f912fdf58ba4d6935
                    End
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =18555
                    Top =49
                    Width =1530
                    Height =300
                    TabIndex =7
                    Name ="Vorname"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Vorname]"
                    FontName ="Arial"
                    GUID = Begin
                        0x52329c8816dc674a9e902816afa979a5
                    End
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =215
                    TextAlign =1
                    IMESentenceMode =3
                    Left =20130
                    Top =49
                    Width =1740
                    Height =300
                    TabIndex =8
                    Name ="Nachname"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Name]"
                    FontName ="Arial"
                    GUID = Begin
                        0x582355eb4d15d04d8622c3797075b9c3
                    End
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =24510
                    Top =49
                    Width =855
                    Height =285
                    TabIndex =10
                    Name ="PLZ"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Text27]"
                    FontName ="Arial"
                    InputMask ="00000;0;#"
                    GUID = Begin
                        0x921cb88dc74d8946a9c7a3c05298d84f
                    End
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =25413
                    Top =45
                    Width =1080
                    Height =285
                    TabIndex =11
                    Name ="Ort"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Ort]"
                    FontName ="Arial"
                    GUID = Begin
                        0x5a51f44fad9d6c48812f4ce22d8fdbcb
                    End
                End
                Begin ComboBox
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =215
                    TextAlign =1
                    IMESentenceMode =3
                    Left =17415
                    Top =49
                    Width =1080
                    Height =300
                    TabIndex =6
                    ColumnInfo ="\"\";\"\";\"10\";\"100\""
                    GUID = Begin
                        0x5319bb138fe7bb49a9094ee284d27a71
                    End
                    Name ="Anrede"
                    RowSourceType ="Table/Query"
                    RowSource ="qry_Anrede"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Anrede]"
                    FontName ="Arial"
                End
                Begin TextBox
                    EnterKeyBehavior = NotDefault
                    ScrollBars =2
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =21960
                    Top =60
                    Width =2490
                    Height =285
                    TabIndex =9
                    Name ="StrasseHausnummer"
                    DefaultValue ="=[Forms]![frm_HauptTerminierungWV]![Strasse] & \" \" & [Forms]![frm_HauptTermini"
                        "erungWV]![Hausnr]"
                    FontName ="Arial"
                    GUID = Begin
                        0xc69061e6f223a149aabd892a81a75424
                    End
                End
                Begin TextBox
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OldBorderStyle =0
                    OverlapFlags =85
                    TextAlign =1
                    IMESentenceMode =3
                    Left =4485
                    Top =45
                    Width =2310
                    Height =270
                    ColumnWidth =1935
                    TabIndex =16
                    Name ="Tarif"
                    ControlSource ="Tarif"
                    FontName ="Arial"
                    GUID = Begin
                        0xbd77aa31e708844e9e58daee2e646326
                    End
                End
            End
        End
        Begin FormFooter
            Height =0
            BackColor =-2147483633
            Name ="Formularfuß"
            GUID = Begin
                0x9b9e4e580bd05a4dbc2bb0fff61e0ccd
            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 BearbeitungsgebuehrKunde_Change()




End Sub

Private Sub Bea_KD_Vorgabe_Change()



End Sub

Private Sub BeaKDIst_Exit(Cancel As Integer)

Dim BeaGebAD As Double

If Me.BeaKDIst - Me.BearbeitungsgebuehrMEP - Me.BearbeitungsgebuerBCS >= 0 Then

        BeaGebAD = Me.BeaKDIst - Me.BearbeitungsgebuehrMEP - Me.BearbeitungsgebuerBCS
        Me.BearbeitungsgebuehrAD1 = BeaGebAD
        
    Else
    
        MsgBox ("Bearbeitungsgebühr ist zu klein!!! Dieser Betrag kann nicht akzeptiert werden!! Bitte setzen Sie sich mit dem Betreuer in verbindung!")
End If



End Sub

Private Sub Import_DblClick(Cancel As Integer)

If IsNull(Me.Zaehlernummer) Then

            MsgBox ("Ohne Angabe des Zälerstandes ist eine Eingabe nicht möglich!")
            
    ElseIf IsNull(Me.Vertragseingang) Then
    
              MsgBox ("Ohne Angabe des Vertragseinganges ist eine Eingabe nicht möglich!")
        
    ElseIf Not IsNull(Me.Zaehlernummer) And Not IsNull(Me.Vertragseingang) And Me.BeaKDIst - Me.BearbeitungsgebuehrMEP - Me.BearbeitungsgebuerBCS >= 0 Then

           CurrentDb.Execute ("Insert into tbl_energievertrag ([Status_Nr], [Tarif], [ProvisionZiel], [BearbeitungsgebuehrMEP], [Bemerkung], [AngelegtVon], [AngelegtAm], [ProvisionAD], [BearbeitungsgebuehrAD], [VertragVersendet], [VertragVersendetDatum], [Vertragseingang], [BearbeitungsgebuerBCS], [GG], [ID_bcs], [ID_mep], [Laufzeit], [Zaehlernummer], [BearbeitungsgebuehrKunde], [Firma], [Anrede], [Vorname], [Nachname], [StrasseHausnr], [PLZ], [Ort] ) values ('" & Me.Status_NR & "', '" & Me.Tarif & "', '" & Me.ProvisionZiel & "', '" & Me.BearbeitungsgebuehrMEP & "', '" & Me.Bemerkung & "', '" & Me.AngelegtVon & "', '" & Me.AngelegtAm & "', '" & Me.ProvisionAD & "'," & _
           "'" & Me.BearbeitungsgebuehrAD1 & "', '" & Me.VertragVersendetJaNein & "', '" & Me.VertragVersendet & "', '" & Me.Vertragseingang & "', '" & Me.BearbeitungsgebuerBCS & "', '" & Me.GG & "', '" & Me.ID_bcs & "', '" & Me.ID_mep & "', '" & Me.Laufzeit & "', '" & Me.Zaehlernummer & "', '" & Me.BeaKDIst & "', '" & Me.Firma & "', '" & Me.Anrede & "', '" & Me.Vorname & "', '" & Me.Nachname & "', '" & Me.StrasseHausnummer & "', '" & Me.PLZ & "', '" & Me.Ort & "' )")
           MsgBox ("Vertrag erfolgreich angelegt")
           
    ElseIf Not IsNull(Me.Zaehlernummer) And Not IsNull(Me.Vertragseingang) And Me.BeaKDIst - Me.BearbeitungsgebuehrMEP - Me.BearbeitungsgebuerBCS < 0 Then
    
        MsgBox ("Bearbeitungsgebühr ist zu klein!!! Dieser Betrag kann nicht akzeptiert werden!! Bitte setzen Sie sich mit dem Betreuer in verbindung!")

End If


                 
               
            
           
'End If
    


End Sub