Sabtu, 13 Desember 2014

Re: [MS_AccessPros] Re: User clicks the X (close) button on a form in the upper-right hand corner and it closes.

 

Norbert,

 

I agree with John to get rid of commented out lines.  I'd first make a backup of the database.  Then, here's what I'd do to get DoEvents in the code:

 

1.   Copy all the code to MS Word.

2.   Press the Ctrl/H keystroke combination so select all the code.

3.  I'd then enter the following into the "Find What" textbox:  ^p^p

4.  I'd then enter the following into the "Replace with"{ Textbox: ^p^pDoEvents^p

5.  Then, I'd select the entire contents of the Word document using Ctrl/A following by a Ctrl/C to get the whole set of code into the clipboard.

6.  Finally, I'd be sure that code in the VBE is all selected and then would do a Ctrl/V to replace it all.

 

Doing this will get a DoEvents everywhere but since this wonderfulness is a pain in the database to debug, this will maybe help to find where the loop is.  'Course if you have code in the subforms this might need to be done there.  I'd start with the main form and id the DoEvents doesn't recognize the Break, then I'd leap into the subforms.  Doing this to the primary form's code actually takes less time than it's taken me to list these steps so it ought not to be a big deal to give this a try.

I understand the wonderfulness of complexity in that my current project has a primary table with a 1 to many relationship with 5 other tables and one of those has a many to many relationship with yet another table.  This results in a primary form with 5 subforms and one of those has its own subform to add a new primary record and a second form to maintain all the tables when needed.

 

Jeff 


From: "drnorbert@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, December 13, 2014 11:09:18 AM
Subject: [MS_AccessPros] Re: User clicks the X (close) button on a form in the upper-right hand corner and it closes.

 

Bill,

As per your suggestion here is the text file of the frmMaster:


This is something new for me, I am interesting in what is what you are looking.


What is the purpose of all this strange characters: 0x00e0fe3f00000000000000003b00000023000000230000000200000000fc5615 ,


Is the form corrupted?


Let me know your comments.

Thanks a lot

Norbert 




Version =20
VersionRequired =20
PublishOption =1
Checksum =-1820188393
Begin Form
    RecordSelectors = NotDefault
    MaxButton = NotDefault
    MinButton = NotDefault
    AutoCenter = NotDefault
    AllowDeletions = NotDefault
    DividingLines = NotDefault
    AllowAdditions = NotDefault
    FilterOn = NotDefault
    AllowDesignChanges = NotDefault
    DefaultView =0
    ScrollBars =0
    ViewsAllowed =1
    TabularCharSet =204
    BorderStyle =3
    PictureSizeMode =1
    DatasheetGridlinesBehavior =3
    Cycle =1
    GridX =24
    GridY =24
    Width =12720
    DatasheetFontHeight =11
    ItemSuffix =1454
    Left =600
    Top =60
    Right =13320
    Bottom =11100
    DatasheetGridlinesColor =-1
    AfterDelConfirm ="[Event Procedure]"
    Filter ="MasterFileNo >=80705 And MasterFileNo<=80745"
    RecSrcDt = Begin
        0x2fa358ae4e78e440
    End
    OnDirty ="[Event Procedure]"
    GUID = Begin
        0x168717763055c643ad480de29a53e93a
    End
    RecordSource ="qryMaster3"
    Caption ="FOUND RANGE OF : 20 MASTERFILES BEFORE AND AFTER "
    OnCurrent ="[Event Procedure]"
    BeforeUpdate ="[Event Procedure]"
    OnClose ="[Event Procedure]"
    DatasheetFontName ="Calibri"
    PrtMip = Begin
        0x6801000068010000680100006801000000000000201c0000e010000001000000 ,
        0x010000006801000000000000a10700000100000001000000
    End
    PrtDevMode = Begin
        0x00e0fe3f00000000000000003b00000023000000230000000200000000fc5615 ,
        0x010409019c00b407032f000001000100ea0a6f08640001000f00580202000100 ,
        0x5802010000004c657474657200000000bb4ab42f1b000000a8131b0023000000 ,
        0xa21f000058040000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000200 ,
        0x0000000001008804bb0201008804bb0200000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000010000010000000000010000 ,
        0x0000010006000000070007000000000000000000010000010001160000000000 ,
        0x0000000002000000070000000000000000190000e40c000000000000b80b0000 ,
        0x7017000000000000dc05000058020000000000000000000000000000feff0000 ,
        0x000000000000000000000000000000000000000000000000370c0000da0c0000 ,
        0x10270000102700001027000010270000a00a0000c2060000b80600002c040000 ,
        0x40010000d2000000180000000000102710271027000010270000000000000000 ,
        0x0000000002000000000002000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000100000000 ,
        0x0000010001000100000000000000ffff00000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000001146400000000000000000000000000 ,
        0xcccccc0000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x00000100010064008910000089100000bb0288040301000000001027e4040000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000004e006f00720062006500720074000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000490053004d005300450052005600450052000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000500050001000000000002000100010002000000 ,
        0x0001010000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000000024000000f5ffffff00000000000000000000000000000000 ,
        0x000000010000000041007200690061006c000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000000000000000ffffff0001000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000001000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0001010002000000020000000100000010270000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000020000000454e474c4953480000000000 ,
        0x0000000000000000b203000054500000bb04000050524956b2c8f1e101ff4d46 ,
        0x432d38343830444e0000000000000000
    End
    PrtDevNames = Begin
        0x0800230029000100000000000000000000000000000000000000000000000000 ,
        0x00000000000000000042524e3030314241393942413243450000000000000000 ,
        0x000000000000000000
    End
    OnLoad ="[Event Procedure]"
    OnError ="[Event Procedure]"
    AllowDatasheetView =0
    FilterOnLoad =0
    ShowPageMargins =0
    DatasheetAlternateBackColor =-2147483610
    PictureSizeMode =4
    DatasheetGridlinesColor12 =-1
    PrtDevModeW = Begin
        0x000000006928bc2f80641c0000000000778fa4784c5c1c0098641c00a797d12f ,
        0x00000000d95abc2fe7c4587560070700e70a00000000000000000000ee572238 ,
        0x01040901dc00b407032f000001000100ea0a6f08640001000f00580202000100 ,
        0x5802010000004c0065007400740065007200000098000000942b592f01000000 ,
        0x010000000400000000000001bc641c0052e4847094000000bc641c0062e48470 ,
        0x0ae484707e850000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000200 ,
        0x0000000001008804bb0201008804bb0200000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000010000010000000000010000 ,
        0x0000010006000000070007000000000000000000010000010001160000000000 ,
        0x0000000002000000070000000000000000190000e40c000000000000b80b0000 ,
        0x7017000000000000dc05000058020000000000000000000000000000feff0000 ,
        0x000000000000000000000000000000000000000000000000370c0000da0c0000 ,
        0x10270000102700001027000010270000a00a0000c2060000b80600002c040000 ,
        0x40010000d2000000180000000000102710271027000010270000000000000000 ,
        0x0000000002000000000002000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000100000000 ,
        0x0000010001000100000000000000ffff00000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000001146400000000000000000000000000 ,
        0xcccccc0000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x00000100010064008910000089100000bb0288040301000000001027e4040000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000004e006f00720062006500720074000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000490053004d005300450052005600450052000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000500050001000000000002000100010002000000 ,
        0x0001010000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000000024000000f5ffffff00000000000000000000000000000000 ,
        0x000000010000000041007200690061006c000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x000000000000000000000000ffffff0001000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000001000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0001010002000000020000000100000010270000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000020000000454e474c4953480000000000 ,
        0x0000000000000000b203000054500000bb04000050524956b2c8f1e101ff4d46 ,
        0x432d38343830444e0000000000000000
    End
    PrtDevNamesW = Begin
        0x04001f0025000100000000000000000000000000000000000000000000000000 ,
        0x0000000000000000000000000000000000000000000000000000000000000000 ,
        0x00000000000000000000420052004e0030003000310042004100390039004200 ,
        0x4100320043004500000000000000000000000000000000000000000000000000 ,
        0x00000000000000000000
    End
    NoSaveCTIWhenDisabled =1
    Begin
        Begin Label
            BackStyle =0
            TextFontFamily =0
            FontSize =9
            ForeColor =-2147483615
            FontName ="Segoe UI"
        End
        Begin Rectangle
            SpecialEffect =3
            BackStyle =0
            BorderLineStyle =0
        End
        Begin CommandButton
            AddColon = NotDefault
            TextFontCharSet =161
            FontSize =9
            FontWeight =400
            ForeColor =-2147483615
            FontName ="Segoe UI"
            BorderLineStyle =0
        End
        Begin OptionButton
            AddColon = NotDefault
            SpecialEffect =2
            BorderLineStyle =0
            LabelX =230
            LabelY =-30
        End
        Begin CheckBox
            AddColon = NotDefault
            SpecialEffect =2
            BorderLineStyle =0
            LabelX =230
            LabelY =-30
        End
        Begin OptionGroup
            SpecialEffect =3
            BorderLineStyle =0
        End
        Begin BoundObjectFrame
            SpecialEffect =2
            BorderLineStyle =0
        End
        Begin TextBox
            FELineBreak = NotDefault
            SpecialEffect =2
            BorderLineStyle =0
            FontSize =10
            FontName ="Arial"
            AsianLineBreak =255
        End
        Begin ListBox
            SpecialEffect =2
            TextFontCharSet =204
            BorderLineStyle =0
            FontSize =11
            FontName ="Calibri"
        End
        Begin ComboBox
            SpecialEffect =2
            TextFontCharSet =204
            BorderLineStyle =0
            FontSize =11
            FontName ="Calibri"
        End
        Begin Subform
            BorderLineStyle =0
            BorderColor =-2147483609
        End
        Begin UnboundObjectFrame
            SpecialEffect =2
            OldBorderStyle =1
            ThemeFontIndex =1
            BackThemeColorIndex =1
            BorderThemeColorIndex =1
            BorderShade =65.0
            ForeThemeColorIndex =2
            ForeShade =50.0
            GridlineThemeColorIndex =1
            GridlineShade =65.0
        End
        Begin ToggleButton
            AddColon = NotDefault
            TextFontCharSet =161
            FontSize =9
            FontWeight =400
            ForeColor =-2147483630
            FontName ="Segoe UI"
            BorderLineStyle =0
        End
        Begin Tab
            TextFontFamily =0
            FontSize =9
            FontName ="Segoe UI"
            BorderLineStyle =0
        End
        Begin Attachment
            BackStyle =0
            OldBorderStyle =0
            BorderLineStyle =0
        End
        Begin EmptyCell
            Height =240
            GridlineColor =12632256
            GridlineThemeColorIndex =1
            GridlineShade =65.0
        End
        Begin FormHeader
            CanGrow = NotDefault
            Height =10590
            BackColor =14277081
            Name ="FormHeader"
            GUID = Begin
                0xea16afff0143ef4a8412d8ccd03d958d
            End
            BackThemeColorIndex =1
            BackShade =85.0
            Begin
                Begin TextBox
                    Visible = NotDefault
                    Locked = NotDefault
                    TabStop = NotDefault
                    SpecialEffect =0
                    OverlapFlags =93
                    TextAlign =2
                    IMESentenceMode =3
                    Left =120
                    Top =10174
                    Width =12480
                    Height =300
                    ColumnOrder =0
                    FontSize =12
                    FontWeight =700
                    TabIndex =3
                    BackColor =2366701
                    ForeColor =16777215
                    Name ="lblApplication"
                    GUID = Begin
                        0xd4cc9f0396c8714abb59fd20f232eb6f
                    End

                    LayoutCachedLeft =120
                    LayoutCachedTop =10174
                    LayoutCachedWidth =12600
                    LayoutCachedHeight =10474
                    ForeThemeColorIndex =1
                End
                Begin Tab
                    TabStop = NotDefault
                    OverlapFlags =247
                    TextFontFamily =34
                    BackStyle =0
                    Width =12720
                    Height =10590
                    FontSize =10
                    FontWeight =700
                    Name ="tabContacts"
                    FontName ="Arial"
                    GUID = Begin
                        0x0c11caac3c9d3447be725ef46c1c8c04
                    End
                    GridlineColor =10921638

                    LayoutCachedWidth =12720
                    LayoutCachedHeight =10590
                    GridlineThemeColorIndex =1
                    GridlineShade =65.0
                    Begin
                        Begin Page
                            OverlapFlags =247
                            Left =105
                            Width =12480
                            Height =10455
                            Name ="General_Page"
                            Caption ="MASTER"
                            GUID = Begin
                                0xe33f0eec8d6d324bb7c1436e2b749dd2
                            End
                            LayoutCachedLeft =105
                            LayoutCachedWidth =12585
                            LayoutCachedHeight =10455
                            WebImagePaddingLeft =2
                            WebImagePaddingTop =2
                            WebImagePaddingRight =2
                            WebImagePaddingBottom =2
                            Begin
                                Begin EmptyCell
                                    Left =465
                                    Top =360
                                    Name ="EmptyCell1432"
                                    GUID = Begin
                                        0x8d44db3c41aed2439897967c2c4badd3
                                    End
                                    GroupTable =14
                                    GridlineColor =10921638
                                    LayoutCachedLeft =465
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1905
                                    LayoutCachedHeight =600
                                    LayoutGroup =14
                                    GroupTable =14
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =195
                                    Top =1950
                                    Width =12384
                                    Height =2370
                                    Name ="Box465"
                                    GUID = Begin
                                        0x31033ac14d3b5849aeab9b2c08ceabbc
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =1950
                                    LayoutCachedWidth =12579
                                    LayoutCachedHeight =4320
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =9648
                                    Top =7632
                                    Width =2895
                                    Height =1020
                                    Name ="Box771"
                                    Tag ="RemitanceInfo"
                                    GUID = Begin
                                        0xabd4961b2227cd4c8f4578e7b46a0c56
                                    End
                                    LayoutCachedLeft =9648
                                    LayoutCachedTop =7632
                                    LayoutCachedWidth =12543
                                    LayoutCachedHeight =8652
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =195
                                    Top =4485
                                    Width =12384
                                    Height =1875
                                    Name ="boxDirectBill"
                                    GUID = Begin
                                        0xcaed64aa6b190747ae740478cfeb5a75
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =4485
                                    LayoutCachedWidth =12579
                                    LayoutCachedHeight =6360
                                End
                                Begin Rectangle
                                    Visible = NotDefault
                                    OverlapFlags =255
                                    Left =195
                                    Top =4500
                                    Width =12384
                                    Height =1860
                                    Name ="boxEFT"
                                    GUID = Begin
                                        0x52f66663e67db2488fa62b5cdfaf1383
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =4500
                                    LayoutCachedWidth =12579
                                    LayoutCachedHeight =6360
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =195
                                    Top =6542
                                    Width =12348
                                    Height =915
                                    Name ="boxRemittance"
                                    Tag ="RemitanceInfo"
                                    GUID = Begin
                                        0x1e74c2243dcd6543ab6ffcb50f68df62
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =6542
                                    LayoutCachedWidth =12543
                                    LayoutCachedHeight =7457
                                End
                                Begin Rectangle
                                    Visible = NotDefault
                                    OverlapFlags =255
                                    Left =195
                                    Top =4488
                                    Width =12384
                                    Height =1875
                                    Name ="boxWDC"
                                    GUID = Begin
                                        0x06bc537f3478c64c9cfcf8d6f25d04bb
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =4488
                                    LayoutCachedWidth =12579
                                    LayoutCachedHeight =6363
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =195
                                    Top =7632
                                    Width =12348
                                    Height =1020
                                    Name ="Box580"
                                    Tag ="RemitanceInfo"
                                    GUID = Begin
                                        0xab4dfae8bd9def40ba6094c9066cac80
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =7632
                                    LayoutCachedWidth =12543
                                    LayoutCachedHeight =8652
                                End
                                Begin Rectangle
                                    Visible = NotDefault
                                    OverlapFlags =255
                                    Left =195
                                    Top =4500
                                    Width =12384
                                    Height =1860
                                    Name ="boxPRD"
                                    GUID = Begin
                                        0x34b034be09ba9b4481cd233849a1261f
                                    End
                                    LayoutCachedLeft =195
                                    LayoutCachedTop =4500
                                    LayoutCachedWidth =12579
                                    LayoutCachedHeight =6360
                                End
                                Begin EmptyCell
                                    Left =405
                                    Top =300
                                    Name ="EmptyCell932"
                                    GUID = Begin
                                        0xd3165a50eb4e6a439662fe4904c8601e
                                    End
                                    GroupTable =1
                                    GridlineColor =10921638
                                    LayoutCachedLeft =405
                                    LayoutCachedTop =300
                                    LayoutCachedWidth =1845
                                    LayoutCachedHeight =540
                                    LayoutGroup =1
                                    GroupTable =1
                                End
                                Begin EmptyCell
                                    Left =450
                                    Top =300
                                    Name ="EmptyCell934"
                                    GUID = Begin
                                        0x6b3c1858cc0a5d4db5c43a36aec873b8
                                    End
                                    GroupTable =2
                                    GridlineColor =10921638
                                    LayoutCachedLeft =450
                                    LayoutCachedTop =300
                                    LayoutCachedWidth =1890
                                    LayoutCachedHeight =540
                                    LayoutGroup =2
                                    GroupTable =2
                                End
                                Begin EmptyCell
                                    Left =450
                                    Top =300
                                    Name ="EmptyCell936"
                                    GUID = Begin
                                        0xf24b1c1e60fb94429c4712a92f176c45
                                    End
                                    GroupTable =3
                                    GridlineColor =10921638
                                    LayoutCachedLeft =450
                                    LayoutCachedTop =300
                                    LayoutCachedWidth =1890
                                    LayoutCachedHeight =540
                                    LayoutGroup =3
                                    GroupTable =3
                                End
                                Begin EmptyCell
                                    Left =450
                                    Top =300
                                    Name ="EmptyCell1324"
                                    GUID = Begin
                                        0x6eb20f338e73864ab405571c682f6587
                                    End
                                    GroupTable =4
                                    GridlineColor =10921638
                                    LayoutCachedLeft =450
                                    LayoutCachedTop =300
                                    LayoutCachedWidth =1890
                                    LayoutCachedHeight =540
                                    LayoutGroup =4
                                    GroupTable =4
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =194
                                    Top =8640
                                    Width =12348
                                    Height =1503
                                    Name ="Box1417"
                                    Tag ="RemitanceInfo"
                                    GUID = Begin
                                        0xc84ec8b355e08f4da34a00391b23e51e
                                    End
                                    LayoutCachedLeft =194
                                    LayoutCachedTop =8640
                                    LayoutCachedWidth =12542
                                    LayoutCachedHeight =10143
                                End
                                Begin EmptyCell
                                    Left =465
                                    Top =360
                                    Name ="EmptyCell1348"
                                    GUID = Begin
                                        0x34f2616c416b6c46917c6a14d57ad030
                                    End
                                    GroupTable =6
                                    GridlineColor =10921638
                                    LayoutCachedLeft =465
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1905
                                    LayoutCachedHeight =600
                                    LayoutGroup =6
                                    GroupTable =6
                                End
                                Begin EmptyCell
                                    Left =465
                                    Top =360
                                    Name ="EmptyCell1401"
                                    GUID = Begin
                                        0x5f2f2bc96cd1e441a87e878afd04067f
                                    End
                                    GroupTable =7
                                    GridlineColor =10921638
                                    LayoutCachedLeft =465
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1905
                                    LayoutCachedHeight =600
                                    LayoutGroup =7
                                    GroupTable =7
                                End
                                Begin EmptyCell
                                    Left =465
                                    Top =360
                                    Name ="EmptyCell1403"
                                    GUID = Begin
                                        0x60ab13c6b8ef994d9d7c9eaa4862c53d
                                    End
                                    GroupTable =8
                                    GridlineColor =10921638
                                    LayoutCachedLeft =465
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1905
                                    LayoutCachedHeight =600
                                    LayoutGroup =8
                                    GroupTable =8
                                End
                                Begin EmptyCell
                                    Left =465
                                    Top =360
                                    Name ="EmptyCell1426"
                                    GUID = Begin
                                        0x3d4d10c347d9014fbd564e190420303d
                                    End
                                    GroupTable =13
                                    GridlineColor =10921638
                                    LayoutCachedLeft =465
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1905
                                    LayoutCachedHeight =600
                                    LayoutGroup =13
                                    GroupTable =13
                                End
                                Begin EmptyCell
                                    Left =540
                                    Top =360
                                    Name ="EmptyCell1424"
                                    GUID = Begin
                                        0xcbbb4bcacf2d4746b7650fedcda2b158
                                    End
                                    GroupTable =12
                                    GridlineColor =10921638
                                    LayoutCachedLeft =540
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =1980
                                    LayoutCachedHeight =600
                                    LayoutGroup =12
                                    GroupTable =12
                                End
                                Begin EmptyCell
                                    Left =615
                                    Top =360
                                    Name ="EmptyCell1422"
                                    GUID = Begin
                                        0x6428b32f58e74e4ab78f4799bec2e4b3
                                    End
                                    GroupTable =11
                                    GridlineColor =10921638
                                    LayoutCachedLeft =615
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =2055
                                    LayoutCachedHeight =600
                                    LayoutGroup =11
                                    GroupTable =11
                                End
                                Begin EmptyCell
                                    Left =690
                                    Top =360
                                    Name ="EmptyCell1420"
                                    GUID = Begin
                                        0x9a0fa1998e87174d86d66a3dabd955c7
                                    End
                                    GroupTable =10
                                    GridlineColor =10921638
                                    LayoutCachedLeft =690
                                    LayoutCachedTop =360
                                    LayoutCachedWidth =2130
                                    LayoutCachedHeight =600
                                    LayoutGroup =10
                                    GroupTable =10
                                End
                                Begin Rectangle
                                    OverlapFlags =255
                                    Left =192
                                    Top =477
                                    Width =12384
                                    Height =1320
                                    Name ="Box385"
                                    GUID = Begin
                                        0x3ff7161da821dd4585d3283c73990970
                                    End
                                    LayoutCachedLeft =192
                                    LayoutCachedTop =477
                                    LayoutCachedWidth =12576
                                    LayoutCachedHeight =1797
                                End
                                Begin TextBox
                                    Visible = NotDefault
                                    AutoTab = NotDefault
                                    OverlapFlags =255
                                    TextAlign =2
                                    Left =11208
                                    Top =5592
                                    Width =1260
                                    Height =274
                                    BackColor =14347005
                                    Name ="LastBill"
                                    ControlSource ="LastBill"
                                    Format ="mm/dd/yyyy"
                                    DefaultValue ="=GetSystemDate()"
                                    InputMask ="99/99/9999;0;#"
                                    Tag ="Audit"
                                    GUID = Begin
                                        0xd752d3ed4bc7da45aeb82945ac22d40a
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =11208
                                    LayoutCachedTop =5592
                                    LayoutCachedWidth =12468
                                    LayoutCachedHeight =5866
                                    BackThemeColorIndex =9
                                    BackTint =20.0
                                    ForeThemeColorIndex =0
                                    Begin
                                        Begin Label
                                            OverlapFlags =255
                                            TextFontFamily =34
                                            Left =9687
                                            Top =5592
                                            Width =1440
                                            Height =255
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label545"
                                            Caption ="Last Bill Date"
                                            FontName ="Arial"
                                            GUID = Begin
                                                0x32628760f4b6f044821e2d28dc8460b3
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =9687
                                            LayoutCachedTop =5592
                                            LayoutCachedWidth =11127
                                            LayoutCachedHeight =5847
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    Visible = NotDefault
                                    OverlapFlags =255
                                    TextAlign =2
                                    Left =11208
                                    Top =5232
                                    Width =1260
                                    Height =274
                                    TabIndex =1
                                    BackColor =15261367
                                    Name ="Nextbilldate"
                                    ControlSource ="Nextbilldate"
                                    Format ="mm/dd/yyyy"
                                    DefaultValue ="=GetSystemDate()"
                                    InputMask ="99/99/9999;0;#"
                                    Tag ="Audit"
                                    GUID = Begin
                                        0x6dc789b5a0031d41a0a3659af5bcd519
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =11208
                                    LayoutCachedTop =5232
                                    LayoutCachedWidth =12468
                                    LayoutCachedHeight =5506
                                    BackThemeColorIndex =8
                                    BackTint =40.0
                                    ForeThemeColorIndex =0
                                    Begin
                                        Begin Label
                                            OverlapFlags =255
                                            TextFontFamily =34
                                            Left =9687
                                            Top =5232
                                            Width =1440
                                            Height =255
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label541"
                                            Caption ="Next Bill Date"
                                            FontName ="Arial"
                                            GUID = Begin
                                                0xc38bf74b4675084eb38e816e2afb0f6d
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =9687
                                            LayoutCachedTop =5232
                                            LayoutCachedWidth =11127
                                            LayoutCachedHeight =5487
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    Visible = NotDefault
                                    Locked = NotDefault
                                    TabStop = NotDefault
                                    SpecialEffect =0
                                    OverlapFlags =247
                                    Left =12180
                                    Width =360
                                    Height =274
                                    TabIndex =2
                                    BackColor =14277081
                                    ForeColor =2366701
                                    Name ="txTab"
                                    GUID = Begin
                                        0x1906b5643e39784ca4d7b5038a57c448
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =12180
                                    LayoutCachedWidth =12540
                                    LayoutCachedHeight =274
                                    BackThemeColorIndex =1
                                    BackShade =85.0
                                End
                                Begin TextBox
                                    Visible = NotDefault
                                    Locked = NotDefault
                                    TabStop = NotDefault
                                    SpecialEffect =0
                                    OverlapFlags =247
                                    TextAlign =1
                                    Left =8325
                                    Top =8715
                                    Width =1110
                                    Height =274
                                    FontWeight =700
                                    TabIndex =3
                                    ForeColor =16711680
                                    Name ="MSeqNo"
                                    ControlSource ="MseqNo"
                                    GUID = Begin
                                        0x4e0d1e7536739b42bf1539a4d2d029e3
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =8325
                                    LayoutCachedTop =8715
                                    LayoutCachedWidth =9435
                                    LayoutCachedHeight =8989
                                    Begin
                                        Begin Label
                                            OverlapFlags =255
                                            TextAlign =1
                                            TextFontFamily =34
                                            Left =7050
                                            Top =8715
                                            Width =1350
                                            Height =240
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label1370"
                                            Caption ="CcardUptake"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0x0459f8d32df4c344a14ec22042becfc2
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =7050
                                            LayoutCachedTop =8715
                                            LayoutCachedWidth =8400
                                            LayoutCachedHeight =8955
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    TabStop = NotDefault
                                    SpecialEffect =0
                                    OverlapFlags =247
                                    TextAlign =2
                                    Left =1452
                                    Top =669
                                    Width =1200
                                    Height =274
                                    FontWeight =700
                                    TabIndex =4
                                    ForeColor =16711680
                                    Name ="MasterfileNo"
                                    ControlSource ="MasterfileNo"
                                    GUID = Begin
                                        0x426f97d4a551064b9a06d513652919c3
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =1452
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =2652
                                    LayoutCachedHeight =943
                                    Begin
                                        Begin Label
                                            OverlapFlags =247
                                            TextFontFamily =34
                                            Left =267
                                            Top =672
                                            Width =1140
                                            Height =252
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label327"
                                            Caption ="Master File"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0x3be886ed77cb794cb77b064ab914b0e6
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =267
                                            LayoutCachedTop =672
                                            LayoutCachedWidth =1407
                                            LayoutCachedHeight =924
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    OverlapFlags =247
                                    TextAlign =1
                                    Left =3822
                                    Top =669
                                    Width =1125
                                    Height =274
                                    TabIndex =5
                                    BackColor =14347005
                                    Name ="Assocmfn"
                                    ControlSource ="Assocmfn"
                                    Tag ="Audit"
                                    GUID = Begin
                                        0x7ba6ed923029fb488de89750577e6a41
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =3822
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =4947
                                    LayoutCachedHeight =943
                                    BackThemeColorIndex =9
                                    BackTint =20.0
                                    Begin
                                        Begin Label
                                            OverlapFlags =255
                                            TextFontFamily =34
                                            Left =2706
                                            Top =672
                                            Width =1116
                                            Height =252
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label329"
                                            Caption ="Assoc MFN"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0xa2311056e506ee44a325381172d8bf9e
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =2706
                                            LayoutCachedTop =672
                                            LayoutCachedWidth =3822
                                            LayoutCachedHeight =924
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    OverlapFlags =247
                                    TextAlign =1
                                    Left =5427
                                    Top =669
                                    Width =975
                                    Height =274
                                    TabIndex =6
                                    BackColor =14347005
                                    Name ="Assoclev"
                                    ControlSource ="Assoclev"
                                    Format =">"
                                    DefaultValue ="\"BASIC\""
                                    Tag ="Audit"
                                    GUID = Begin
                                        0xb41cf3821a8a944b8dbc30f3a2ce6943
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =5427
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =6402
                                    LayoutCachedHeight =943
                                    BackThemeColorIndex =9
                                    BackTint =20.0
                                    Begin
                                        Begin Label
                                            OverlapFlags =255
                                            TextFontFamily =34
                                            Left =4992
                                            Top =672
                                            Width =435
                                            Height =252
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label331"
                                            Caption ="Lev"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0x04abbbcaecd9914b9c277c0698e4f4a5
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =4992
                                            LayoutCachedTop =672
                                            LayoutCachedWidth =5427
                                            LayoutCachedHeight =924
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin TextBox
                                    AutoTab = NotDefault
                                    OverlapFlags =247
                                    TextAlign =2
                                    Left =7905
                                    Top =669
                                    Width =1260
                                    Height =274
                                    TabIndex =7
                                    BackColor =14347005
                                    Name ="Reqissuedate"
                                    ControlSource ="Reqissuedate"
                                    Format ="mm/dd/yyyy"
                                    DefaultValue ="=GetSystemDate()"
                                    InputMask ="99/99/9999;0;#"
                                    Tag ="Audit"
                                    GUID = Begin
                                        0xedf0a920ce0fd845a7c41787300f2f48
                                    End
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =7905
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =9165
                                    LayoutCachedHeight =943
                                    BackThemeColorIndex =9
                                    BackTint =20.0
                                    Begin
                                        Begin Label
                                            OverlapFlags =247
                                            TextAlign =3
                                            TextFontFamily =34
                                            Left =6480
                                            Top =672
                                            Width =1380
                                            Height =252
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label857"
                                            Caption ="Req Issue Dte"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0x063869f05b5d5149af352acf3c35b339
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =6480
                                            LayoutCachedTop =672
                                            LayoutCachedWidth =7860
                                            LayoutCachedHeight =924
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin ComboBox
                                    LimitToList = NotDefault
                                    RowSourceTypeInt =1
                                    OverlapFlags =255
                                    TextFontCharSet =0
                                    TextAlign =1
                                    Left =10185
                                    Top =669
                                    Width =735
                                    Height =274
                                    FontSize =10
                                    TabIndex =8
                                    BackColor =15523798
                                    GUID = Begin
                                        0x4dcce4cff39c704d8fa76906ff1db53d
                                    End
                                    Name ="ScanYet"
                                    ControlSource ="Scannedyet"
                                    RowSourceType ="Value List"
                                    RowSource ="YES;NO"
                                    ColumnWidths ="1008"
                                    FontName ="Arial"
                                    Tag ="Audit"
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =10185
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =10920
                                    LayoutCachedHeight =943
                                    Begin
                                        Begin Label
                                            OverlapFlags =247
                                            TextAlign =3
                                            TextFontFamily =34
                                            Left =9240
                                            Top =672
                                            Width =840
                                            Height =255
                                            FontSize =10
                                            FontWeight =700
                                            BackColor =-2147483613
                                            ForeColor =0
                                            Name ="Label1"
                                            Caption ="Scanned"
                                            FontName ="Arial"
                                            Tag =";RegenerateCaption;"
                                            GUID = Begin
                                                0x215aeca2a0b6f24f85ae7e271a9c74ec
                                            End
                                            TopPadding =23
                                            BottomPadding =23
                                            LayoutCachedLeft =9240
                                            LayoutCachedTop =672
                                            LayoutCachedWidth =10080
                                            LayoutCachedHeight =927
                                            ForeThemeColorIndex =0
                                        End
                                    End
                                End
                                Begin ComboBox
                                    LimitToList = NotDefault
                                    TabStop = NotDefault
                                    RowSourceTypeInt =1
                                    OverlapFlags =247
                                    TextFontCharSet =0
                                    TextAlign =1
                                    Left =11964
                                    Top =669
                                    Width =510
                                    Height =274
                                    FontSize =10
                                    TabIndex =9
                                    BackColor =14806254
                                    GUID = Begin
                                        0x4a01fce2148d2e42845701061b6bf142
                                    End
                                    Name ="Archivestat"
                                    ControlSource ="Archivestat"
                                    RowSourceType ="Value List"
                                    RowSource ="A;O;S"
                                    ColumnWidths ="1008"
                                    FontName ="Arial"
                                    Tag ="Audit"
                                    TopPadding =23
                                    BottomPadding =23

                                    LayoutCachedLeft =11964
                                    LayoutCachedTop =669
                                    LayoutCachedWidth =12474
                                    LayoutCachedHeight =943
                                    BackThemeColorIndex =3
                                End
                                Begin CommandButton
                                    TabStop = NotDefault
                                    OverlapFlags =247
                                    TextFontCharSet =0
                                    Left =210
                                    Top =1053
                                    Width =1218
                                    Height =331
                                    FontWeight =700
                                    TabIndex =10
                                    ForeColor =16777215
                                    Name ="cmdClient"
                                    Caption ="CLIENT SSN"
                                    OnClick ="[Event Procedure]"
                                    GUID = Begin
                                        0x0172160aa4c77e45958061c0da3e1346
                                    End
                                    LeftPadding =72
                                    TopPadding =72
                                    RightPadding =72
                                    BottomPadding =72

           




--
---

Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com

919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net


__._,_.___

Posted by: jpjones23@centurylink.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (16)

.

__,_._,___

Tidak ada komentar:

Posting Komentar