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
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