Version =20 VersionRequired =20 PublishOption =1 Checksum =-1048227307 Begin Form AutoCenter = NotDefault DividingLines = NotDefault AllowDesignChanges = NotDefault DefaultView =0 ViewsAllowed =1 PictureAlignment =2 DatasheetGridlinesBehavior =3 GridX =24 GridY =24 Width =10040 DatasheetFontHeight =11 ItemSuffix =40 Left =12315 Top =6195 Right =21765 Bottom =13470 DatasheetGridlinesColor =14806254 RecSrcDt = Begin 0x5e5a988e9264e440 End GUID = Begin 0x0d796c08ef47314fb8a6d2251f03dba3 End RecordSource ="MemAvailableFields" Caption ="fsubMemFilterSpecFieldDetails" OnCurrent ="[Event Procedure]" OnOpen ="[Event Procedure]" DatasheetFontName ="Calibri" PrtMip = Begin 0x6801000068010000680100006801000000000000201c0000e010000001000000 , 0x010000006801000000000000a10700000100000001000000 End PrtDevMode = Begin 0x0016160004f3525c000c480680780000d818330007aabc5d000c480611aabc5d , 0x010400069c00001e43ff800701000100ea0a6f08640001000f00580202000100 , 0x5802020001004c657474657200a9bc5d000c4806ffffffff393d345c2c193300 , 0x04000000cb030000000000000000000000000000010000000000000002000000 , 0x0200000001010000ffffffff0000000000000000000000000000000044494e55 , 0x2200d8001403ec1a4c58ce080000000000000000000000000000000000000000 , 0x0000000000000000070000000000000000000000010000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x000000000000000000000000010000000000000000000000d8000000534d544a , 0x000000001000c8004800500020004400650073006b006a006500740020004600 , 0x320034003000300020007300650072006900650073000000496e70757442696e , 0x00464f524d534f5552434500524553444c4c00556e69726573444c4c00506170 , 0x657253697a65004c4554544552004f7269656e746174696f6e00504f52545241 , 0x4954005265736f6c7574696f6e0036303064706900436f6c6f724d6f64650043 , 0x6f6c6f72323400485053696d706c696669656455490054727565000000000000 , 0x00000000000000000000000000000000ec1a000049555048010012001fa83304 , 0xc22f4b43a06a7d0828d0d3215802000058020000550000002900000040130000 , 0x72180000ec130000c81900000100000000000000000000000000000000000000 , 0x0000000000000000000000000000000001000000306c0300433a5c57696e646f , 0x77735c73706c776f7736342e6578650000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x00000000cc060000c40600004009010078daed9ddb6f14551cc77fb3b7b64a2f , 0x5c545a2e2d45a00892b6dbee769102bd02894168ab5609d12008554452c4a82f , 0xf0e0832f1a9f7c82ffc037df4c8c1bf5cd171f7caf26468c21ba264a6268527f , 0x67e637b367a767e8ac6cabe57c3f9bb3bf3333672e7b76f633677666cf1251cb , 0xf30e0574d6136d94fc079c4e73ca725265f6c8f8714e0d541eae06b5fc342fab , 0x8ff37739dd4e12151c6f9d9ca51d69a2351cbb3975a5a397a3b66d2da7692eb3 , 0x8be30d4e33696f7bd5fce90c511dc701552ee3bd06357c8cf31959fe09ce5ce7 , 0xd4c513faea1dbafbfbad60f9a5f79c052afd71445be5cba56bcd924d5ee72d38 , 0x33319e5a3f38bf1041333d7094be75f83d2ab613fd7068fe6f1ee15c57bb4e42 , 0x4d73249d95a8689537d531a45699311131dd4f09437262cce754f9da9c1a2fef , 0xff82b3c2497f5f9255d69b2afb273ffdc5e90ea761fe248f701abd474ad07f93 , 0x5e8f78fdfcc977aaae37c78b4a19d389723d9e956924e3a7135e3eaa8e94f836 , 0x6a65fda46b89bc6d5c38dc1eae7df7b3ec0a39a18dbdcd694ab6732f3f25e74b , 0xd9eca921a2ef38d573ea1e3af0c5ba8373cf7c38a822973ac48bfa524fd7eaa8 , 0x38772b43459ebdc4ae7d9fa8bc0e7d9ff149495ddc8b5738dd94d77453d25999 , 0x9610d9fbcb4d49be59c693e133edcfd325c3451e6822ef00b197e3471cdb387e , 0x2ef17b89bf49acaff30e2c9d1c932977611d726c519b75b491df8a31a24f39a6 , 0x78bda949a20b9ff16c5cb7dff0f4cb750e3d4de7e82d7e9ca3591e334997e94d , 0x7e5c74873b78f82a9de1e777e98a5be60d1e37c4652e73d90bfcfc2a97ba4279 , 0x3eb2bd4dfb789d17f9e14f99a1f39153ce454c516be9e6693d3c65d6dd16a2e3 , 0xbc46e2f59ea24b3c7c89e73d4dc0368ed2304df07b7f89f7186fdf9ce2a8f617 , 0x600323fcd9bfcaeffb8c980ad8853a77fb443b8cba87cb6231882bd1cc6c59c5 , 0x4d72507bc6e81db78d32cb47a197e824a771548a85245005c0e884094ec3a814 , 0x0b49a20a40a4138650291692421500a313c6e0044b49a30a80d1095370029c00 , 0xe0849013f07d029c00e004dd0923a8143801c0099a13702d124e007082ee8423 , 0xa8143801c0099a138ea252e0040027e0ba83e5645005c0e88417e0043801c009 , 0x21278ca2522ca40e55008c4e7816ed043801c0092127e09e251ba9471500a313 , 0x4ee25a2400000052bdc2f9fdaaf87d29f8bf95f4af536642e719f5324f83c487 , 0x243e2c718dc446894d54eeee4eada345e25a89eb24ae97b841e223121f95f898 , 0xc48d12fd2e25db246e92b859e216f27e0bbe555e53bbbca66da13af0bb808bfb , 0xbbf1b9162ffaf5d64759ea757b180580e857de3feeb49487b16700ddab4bf1b3 , 0xd12f795420805f402471ef2bfbd1e8972c2a10c02f2092b8f7a398fdd28b0a04 , 0x815f74e017a0887b1dfb27a35ffa518100ed171049dc6be2bf18fd5240050297 , 0x9349b45fc0621a62967badb1d22ffdae5f065081c0dd2736b4c22f6031ad31cb , 0x7dbd2edc7e19e07da88ff6d3714ede50b70ce5d93e03413e57313e27f9f25c38 , 0xc77a10815f80a26d05fd02a7c02fc02e362dbb5fd066815f80ad6c5e66bfc029 , 0xf00bb0972d35f60bbe6f01f00bf0d9ba8c7e8153e0176037ed35f70bda2c007e , 0x011e1df7e597bcf1fb97f298812057d0c6f72c2ad9c30f3fd7eb8e07ab03ffbe , 0xbaf135f00b58ccb6fbf04b0f65ffc51d2f3d15ad1edf2761d71c876556955f3e , 0xc6fdbbc040e7b2fa054e815f80cd6c5f06bfa0cd02bfc02f40b1a3467ec13911 , 0xfc02bf80303b6bee1738057e815f80c7ae9a9d1fa1cd02bfc02fa092aefbf24b , 0x7fc5d5e89e8aa15ee3d56a3534151826b7a481c0eaf00bae4f0313bb97c12f30 , 0x0afc02bf00c51335f40b5a2cf00bfc0274f6d4c42f653fe01f4becf48b02fdef , 0x8230717d705e3a8a4904f375bbad11001c42ffbbc04cdc1e748b8d26bff4a102 , 0x01fc022289fb0f0033c6f60bfaf706f00b88667fcc72b9905f726ca61cfc0222 , 0xfce2ed1ff836ce769e8aeb21835ff2c115696fa837c8e1bcc976bfe4ddfe3af0 , 0xff58b6732066b9e1905fd0fe054bfb05ed17db198c596ed4d07e19a8b8a3ce1b , 0x837fbc875fca7e41bf85b6733066b963f00ba8da2f384fb69d4331cbbd88f323 , 0x50b55f70b4b19dc331cbdd58d47e51578f72c1efa7bbddebd5007e29fb2587f6 , 0x8bf50cc52cb7b9cd747e54d0ce8d0a410f30de106c63b35fbcfd03f72fd8ce70 , 0xcc72cf19eeafd3ffb111ed17f825ec9702ae4f5bcf48cc7283c6fb5fd4ef1b27 , 0xc52f5e7f51b8ff057e291f7fd07eb19dd198e54e18fc52087aa8f3867035127e , 0xa96cbfe0fb5ddb198b59eeaba64abf64ddd64b2f2a10e0f747000000569c664e , 0x693906a994d1f2eabf1d9392efd4f2bbb5fc935a7e8f96efd2f21d5a7e9f96df , 0xa9e57768f9bd5a7ebb967f5ccbebfc03a22cfbe5000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x000000000000000000000000000000000000000000000000306c0300 End PrtDevNames = Begin 0x0800200038000100000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000005553423030310000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000 End AllowDatasheetView =0 AllowPivotTableView =0 AllowPivotChartView =0 AllowPivotChartView =0 FilterOnLoad =0 NavigationCaption ="Fields" ShowPageMargins =0 DisplayOnSharePointSite =1 DatasheetAlternateBackColor =15921906 DatasheetGridlinesColor12 =0 FitToScreen =1 DatasheetBackThemeColorIndex =1 BorderThemeColorIndex =3 ThemeFontIndex =1 ForeThemeColorIndex =0 AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 PrtDevModeW = Begin 0x00001e031022340000b81e0300000000edacbc5d28000000c01f340084203400 , 0x8422340000000000e45cbc5d3b5cbc5d040000000000000000000000715bbc5d , 0x01040006dc00001e43ff800701000100ea0a6f08640001000f00580202000100 , 0x5802020001004c006500740074006500720000000000000000b81e0305000000 , 0x60203400e4e8b12f0100000084a88e0a6aefb12f84a88e0a84a88e0a54203400 , 0x9020340002000000000000000000000000000000010000000000000002000000 , 0x0200000001010000ffffffff0000000000000000000000000000000044494e55 , 0x2200d8001403ec1a4c58ce080000000000000000000000000000000000000000 , 0x0000000000000000070000000000000000000000010000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x000000000000000000000000010000000000000000000000d8000000534d544a , 0x000000001000c8004800500020004400650073006b006a006500740020004600 , 0x320034003000300020007300650072006900650073000000496e70757442696e , 0x00464f524d534f5552434500524553444c4c00556e69726573444c4c00506170 , 0x657253697a65004c4554544552004f7269656e746174696f6e00504f52545241 , 0x4954005265736f6c7574696f6e0036303064706900436f6c6f724d6f64650043 , 0x6f6c6f72323400485053696d706c696669656455490054727565000000000000 , 0x00000000000000000000000000000000ec1a000049555048010012001fa83304 , 0xc22f4b43a06a7d0828d0d3215802000058020000550000002900000040130000 , 0x72180000ec130000c81900000100000000000000000000000000000000000000 , 0x0000000000000000000000000000000001000000306c0300433a5c57696e646f , 0x77735c73706c776f7736342e6578650000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x00000000cc060000c40600004009010078daed9ddb6f14551cc77fb3b7b64a2f , 0x5c545a2e2d45a00892b6dbee769102bd02894168ab5609d12008554452c4a82f , 0xf0e0832f1a9f7c82ffc037df4c8c1bf5cd171f7caf26468c21ba264a6268527f , 0x67e637b367a767e8ac6cabe57c3f9bb3bf3333672e7b76f633677666cf1251cb , 0xf30e0574d6136d94fc079c4e73ca725265f6c8f8714e0d541eae06b5fc342fab , 0x8ff37739dd4e12151c6f9d9ca51d69a2351cbb3975a5a397a3b66d2da7692eb3 , 0x8be30d4e33696f7bd5fce90c511dc701552ee3bd06357c8cf31959fe09ce5ce7 , 0xd4c513faea1dbafbfbad60f9a5f79c052afd71445be5cba56bcd924d5ee72d38 , 0x33319e5a3f38bf1041333d7094be75f83d2ab613fd7068fe6f1ee15c57bb4e42 , 0x4d73249d95a8689537d531a45699311131dd4f09437262cce754f9da9c1a2fef , 0xff82b3c2497f5f9255d69b2afb273ffdc5e90ea761fe248f701abd474ad07f93 , 0x5e8f78fdfcc977aaae37c78b4a19d389723d9e956924e3a7135e3eaa8e94f836 , 0x6a65fda46b89bc6d5c38dc1eae7df7b3ec0a39a18dbdcd694ab6732f3f25e74b , 0xd9eca921a2ef38d573ea1e3af0c5ba8373cf7c38a822973ac48bfa524fd7eaa8 , 0x38772b43459ebdc4ae7d9fa8bc0e7d9ff149495ddc8b5738dd94d77453d25999 , 0x9610d9fbcb4d49be59c693e133edcfd325c3451e6822ef00b197e3471cdb387e , 0x2ef17b89bf49acaff30e2c9d1c932977611d726c519b75b491df8a31a24f39a6 , 0x78bda949a20b9ff16c5cb7dff0f4cb750e3d4de7e82d7e9ca3591e334997e94d , 0x7e5c74873b78f82a9de1e777e98a5be60d1e37c4652e73d90bfcfc2a97ba4279 , 0x3eb2bd4dfb789d17f9e14f99a1f39153ce454c516be9e6693d3c65d6dd16a2e3 , 0xbc46e2f59ea24b3c7c89e73d4dc0368ed2304df07b7f89f7186fdf9ce2a8f617 , 0x600323fcd9bfcaeffb8c980ad8853a77fb443b8cba87cb6231882bd1cc6c59c5 , 0x4d72507bc6e81db78d32cb47a197e824a771548a85245005c0e884094ec3a814 , 0x0b49a20a40a4138650291692421500a313c6e0044b49a30a80d1095370029c00 , 0xe0849013f07d029c00e004dd0923a8143801c0099a13702d124e007082ee8423 , 0xa8143801c0099a138ea252e0040027e0ba83e5645005c0e88417e0043801c009 , 0x21278ca2522ca40e55008c4e7816ed043801c0092127e09e251ba9471500a313 , 0x4ee25a2400000052bdc2f9fdaaf87d29f8bf95f4af536642e719f5324f83c487 , 0x243e2c718dc446894d54eeee4eada345e25a89eb24ae97b841e223121f95f898 , 0xc48d12fd2e25db246e92b859e216f27e0bbe555e53bbbca66da13af0bb808bfb , 0xbbf1b9162ffaf5d64759ea757b180580e857de3feeb49487b16700ddab4bf1b3 , 0xd12f795420805f402471ef2bfbd1e8972c2a10c02f2092b8f7a398fdd28b0a04 , 0x815f74e017a0887b1dfb27a35ffa518100ed171049dc6be2bf18fd5240050297 , 0x9349b45fc0621a62967badb1d22ffdae5f065081c0dd2736b4c22f6031ad31cb , 0x7dbd2edc7e19e07da88ff6d3714ede50b70ce5d93e03413e57313e27f9f25c38 , 0xc77a10815f80a26d05fd02a7c02fc02e362dbb5fd066815f80ad6c5e66bfc029 , 0xf00bb0972d35f60bbe6f01f00bf0d9ba8c7e8153e0176037ed35f70bda2c007e , 0x011e1df7e597bcf1fb97f298812057d0c6f72c2ad9c30f3fd7eb8e07ab03ffbe , 0xbaf135f00b58ccb6fbf04b0f65ffc51d2f3d15ad1edf2761d71c876556955f3e , 0xc6fdbbc040e7b2fa054e815f80cd6c5f06bfa0cd02bfc02f40b1a3467ec13911 , 0xfc02bf80303b6bee1738057e815f80c7ae9a9d1fa1cd02bfc02fa092aefbf24b , 0x7fc5d5e89e8aa15ee3d56a3534151826b7a481c0eaf00bae4f0313bb97c12f30 , 0x0afc02bf00c51335f40b5a2cf00bfc0274f6d4c42f653fe01f4becf48b02fdef , 0x8230717d705e3a8a4904f375bbad11001c42ffbbc04cdc1e748b8d26bff4a102 , 0x01fc022289fb0f0033c6f60bfaf706f00b88667fcc72b9905f726ca61cfc0222 , 0xfce2ed1ff836ce769e8aeb21835ff2c115696fa837c8e1bcc976bfe4ddfe3af0 , 0xff58b6732066b9e1905fd0fe054bfb05ed17db198c596ed4d07e19a8b8a3ce1b , 0x837fbc875fca7e41bf85b6733066b963f00ba8da2f384fb69d4331cbbd88f323 , 0x50b55f70b4b19dc331cbdd58d47e51578f72c1efa7bbddebd5007e29fb2587f6 , 0x8bf50cc52cb7b9cd747e54d0ce8d0a410f30de106c63b35fbcfd03f72fd8ce70 , 0xcc72cf19eeafd3ffb111ed17f825ec9702ae4f5bcf48cc7283c6fb5fd4ef1b27 , 0xc52f5e7f51b8ff057e291f7fd07eb19dd198e54e18fc52087aa8f3867035127e , 0xa96cbfe0fb5ddb198b59eeaba64abf64ddd64b2f2a10e0f747000000569c664e , 0x693906a994d1f2eabf1d9392efd4f2bbb5fc935a7e8f96efd2f21d5a7e9f96df , 0xa9e57768f9bd5a7ebb967f5ccbebfc03a22cfbe5000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x000000000000000000000000000000000000000000000000306c0300 End PrtDevNamesW = Begin 0x04001c0034000100000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000550053004200300030003100000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000000000000000000000000000000000000000 , 0x0000000000000000000000000000 End NoSaveCTIWhenDisabled =1 Begin Begin Label BackStyle =0 FontSize =11 FontName ="Calibri" ThemeFontIndex =1 BackThemeColorIndex =1 BorderThemeColorIndex =0 BorderTint =50.0 ForeThemeColorIndex =0 ForeTint =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin CommandButton FontSize =11 FontWeight =400 FontName ="Calibri" ForeThemeColorIndex =0 ForeTint =75.0 GridlineThemeColorIndex =1 GridlineShade =65.0 UseTheme =1 Shape =1 Gradient =12 BackThemeColorIndex =4 BackTint =60.0 BorderLineStyle =0 BorderColor =16777215 BorderThemeColorIndex =4 BorderTint =60.0 ThemeFontIndex =1 HoverThemeColorIndex =4 HoverTint =40.0 PressedThemeColorIndex =4 PressedShade =75.0 HoverForeThemeColorIndex =0 HoverForeTint =75.0 PressedForeThemeColorIndex =0 PressedForeTint =75.0 End Begin CheckBox BorderLineStyle =0 LabelX =230 LabelY =-30 BorderThemeColorIndex =1 BorderShade =65.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin TextBox AddColon = NotDefault FELineBreak = NotDefault BorderLineStyle =0 LabelX =-1800 FontSize =11 FontName ="Calibri" AsianLineBreak =1 BackThemeColorIndex =1 BorderThemeColorIndex =1 BorderShade =65.0 ThemeFontIndex =1 ForeThemeColorIndex =0 ForeTint =75.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin ComboBox AddColon = NotDefault BorderLineStyle =0 LabelX =-1800 FontSize =11 FontName ="Calibri" AllowValueListEdits =1 InheritValueList =1 ThemeFontIndex =1 BackThemeColorIndex =1 BorderThemeColorIndex =1 BorderShade =65.0 ForeThemeColorIndex =2 ForeShade =50.0 GridlineThemeColorIndex =1 GridlineShade =65.0 End Begin FormHeader Height =0 BackColor =15849926 Name ="FormHeader" GUID = Begin 0xcf36a0d6259dde4babadba0626afb9e1 End AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =2 BackTint =20.0 End Begin Section Height =6180 Name ="Detail" GUID = Begin 0xbb9c4a8ce7c8ee48b6e89d0d92e7ac61 End AlternateBackColor =15921906 AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 Begin Begin TextBox Enabled = NotDefault OverlapFlags =95 IMESentenceMode =3 Left =120 Top =435 Width =840 Height =300 ColumnWidth =1440 BorderColor =10921638 ForeColor =4210752 Name ="lngFilterFieldId" ControlSource ="lngFilterFieldId" GUID = Begin 0x75ea792334e4ee42848226df5e0f6d50 End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =435 LayoutCachedWidth =960 LayoutCachedHeight =735 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =120 Top =120 Width =840 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="lngFilterFieldId_Label" Caption ="Field Id" GUID = Begin 0xd4af93a105913e47a144a7c4013a053b End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =120 LayoutCachedWidth =960 LayoutCachedHeight =435 End End End Begin TextBox Enabled = NotDefault OverlapFlags =95 IMESentenceMode =3 Left =1080 Top =435 Width =720 Height =300 ColumnWidth =1530 TabIndex =1 BorderColor =10921638 ForeColor =4210752 Name ="lngMemFilterSpecId" ControlSource ="lngMemFilterSpecId" GUID = Begin 0x41b22f4c2c47ee42ace039810ff5fb1d End GridlineColor =10921638 LayoutCachedLeft =1080 LayoutCachedTop =435 LayoutCachedWidth =1800 LayoutCachedHeight =735 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =1080 Top =120 Width =735 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="lngMemFilterSpecId_Label" Caption ="Spec Id" GUID = Begin 0xb0fb9b5a160ad544b6b896dcf5593216 End GridlineColor =10921638 LayoutCachedLeft =1080 LayoutCachedTop =120 LayoutCachedWidth =1815 LayoutCachedHeight =435 End End End Begin TextBox OverlapFlags =87 IMESentenceMode =3 Left =5640 Top =435 Width =3000 Height =300 ColumnWidth =3000 TabIndex =3 BorderColor =10921638 ForeColor =4210752 Name ="FilterFieldDisplayName" ControlSource ="FilterFieldDisplayName" GUID = Begin 0x5a6ab7d564d5f24b813bed738725f66c End GridlineColor =10921638 LayoutCachedLeft =5640 LayoutCachedTop =435 LayoutCachedWidth =8640 LayoutCachedHeight =735 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =5640 Top =120 Width =3000 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="FilterFieldDisplayName_Label" Caption ="Field Display Name" GUID = Begin 0x5858d72ea1f70a4e968800c450a25f1b End GridlineColor =10921638 LayoutCachedLeft =5640 LayoutCachedTop =120 LayoutCachedWidth =8640 LayoutCachedHeight =435 End End End Begin TextBox OverlapFlags =87 IMESentenceMode =3 Left =120 Top =1050 Width =8520 Height =870 TabIndex =4 BorderColor =10921638 ForeColor =4210752 Name ="memFilterFieldDescription" ControlSource ="memFilterFieldDescription" GUID = Begin 0x712269428749d84181effe26228e5512 End GridlineColor =10921638 TextFormat =1 LayoutCachedLeft =120 LayoutCachedTop =1050 LayoutCachedWidth =8640 LayoutCachedHeight =1920 Begin Begin Label OldBorderStyle =1 OverlapFlags =95 Left =120 Top =735 Width =3960 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="FilterFieldDescription_Label" Caption ="Field Description (The user will see this.)" GUID = Begin 0xc12b86233637334ba8d15aea98bcea37 End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =735 LayoutCachedWidth =4080 LayoutCachedHeight =1050 End End End Begin TextBox OverlapFlags =95 IMESentenceMode =3 Left =120 Top =3075 Width =8520 Height =945 TabIndex =9 BorderColor =10921638 ForeColor =4210752 Name ="RowSourceForCombo" ControlSource ="RowSourceForCombo" GUID = Begin 0xee6c1790cf3b77458f1d5887f8b6b133 End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =3075 LayoutCachedWidth =8640 LayoutCachedHeight =4020 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =120 Top =2760 Width =5100 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="cboSelectRowSource_Label" Caption ="Combo tRowSource (Can be query name or SQL Select" GUID = Begin 0xd9902df05fc04646b5bfc3df3a7d9310 End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =2760 LayoutCachedWidth =5220 LayoutCachedHeight =3075 End End End Begin TextBox OverlapFlags =95 IMESentenceMode =3 Left =120 Top =4515 Width =5640 Height =345 TabIndex =13 BorderColor =10921638 ForeColor =4210752 Name ="RowsToAddToCombo" ControlSource ="RowsToAddToCombo" GUID = Begin 0x9e149683a43ee247a7bf8333d67bab6c End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =4515 LayoutCachedWidth =5760 LayoutCachedHeight =4860 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =120 Top =4200 Width =1740 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="txtRowsToAdd_Label" Caption ="RowsToAddToCombo " GUID = Begin 0x42c1e2aa16f2934a908cfe4c26700a30 End GridlineColor =10921638 LayoutCachedLeft =120 LayoutCachedTop =4200 LayoutCachedWidth =1860 LayoutCachedHeight =4515 End End End Begin CheckBox OverlapFlags =85 Left =6000 Top =4260 Width =1320 Height =660 TabIndex =12 BorderColor =10921638 Name ="ysnReverseCompare" ControlSource ="ysnReverseCompare" StatusBarText ="Determine SQL Compare string to use. lngPriority uses Reverse compare because H" "ighest is 1 and lowest is 99" GUID = Begin 0xa7943b838c9c6443b14f700d998c9137 End GridlineColor =10921638 LayoutCachedLeft =6000 LayoutCachedTop =4260 LayoutCachedWidth =7320 LayoutCachedHeight =4920 Begin Begin Label OldBorderStyle =1 OverlapFlags =247 Left =6180 Top =4200 Width =900 Height =600 BorderColor =8355711 ForeColor =8355711 Name ="ysnReverseCompare_Label" Caption ="Reverse Compare" GUID = Begin 0x5ac8c8046daa5f4a9c5b63743cb34e46 End GridlineColor =10921638 LayoutCachedLeft =6180 LayoutCachedTop =4200 LayoutCachedWidth =7080 LayoutCachedHeight =4800 End End End Begin ComboBox RowSourceTypeInt =1 OverlapFlags =215 TextAlign =1 IMESentenceMode =3 ColumnCount =2 ListWidth =2880 Left =180 Top =2340 Width =1200 Height =315 TabIndex =6 BorderColor =10921638 ForeColor =4138256 GUID = Begin 0xc3b3eb41d5fc7744af22df01dfafee1e End Name ="cboSQLType" ControlSource ="lngFilterFieldSQLType" RowSourceType ="Value List" RowSource ="1;\"Boolean\";8;\"Date\";99;\"Like\";4;\"Long\";10;\"Text\"" ColumnWidths ="0;1440" GridlineColor =10921638 LayoutCachedLeft =180 LayoutCachedTop =2340 LayoutCachedWidth =1380 LayoutCachedHeight =2655 Begin Begin Label OverlapFlags =93 Left =180 Top =2040 Width =1200 Height =320 BorderColor =8355711 ForeColor =8355711 Name ="SQL Type_Label" Caption ="SQL Type" EventProcPrefix ="SQL_Type_Label" GUID = Begin 0x10acb4314d66874280b98c3d4725ea07 End GridlineColor =10921638 LayoutCachedLeft =180 LayoutCachedTop =2040 LayoutCachedWidth =1380 LayoutCachedHeight =2360 End End End Begin CheckBox OverlapFlags =85 Left =7560 Top =4320 TabIndex =18 BorderColor =10921638 Name ="ysnFilterField" ControlSource ="ysnFilterField" StatusBarText ="Will be available in the Filter tab." GUID = Begin 0x417bbdec9391ec42b4c288cfc2adff9f End GridlineColor =10921638 LayoutCachedLeft =7560 LayoutCachedTop =4320 LayoutCachedWidth =7820 LayoutCachedHeight =4560 Begin Begin Label OverlapFlags =247 Left =7790 Top =4290 Width =1350 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label23" Caption ="Filter Field" GUID = Begin 0x1ea30252326d494195eefbc9a4afc49c End GridlineColor =10921638 LayoutCachedLeft =7790 LayoutCachedTop =4290 LayoutCachedWidth =9140 LayoutCachedHeight =4605 End End End Begin CheckBox OverlapFlags =85 Left =7560 Top =4740 TabIndex =19 BorderColor =10921638 Name ="ysnReportField" ControlSource ="ysnReportField" StatusBarText ="We be available in the 'Show Columns' list." AfterUpdate ="[Event Procedure]" GUID = Begin 0x2ad45e992992b043a6c2ba2dac49491c End GridlineColor =10921638 LayoutCachedLeft =7560 LayoutCachedTop =4740 LayoutCachedWidth =7820 LayoutCachedHeight =4980 Begin Begin Label OverlapFlags =247 Left =7790 Top =4710 Width =1335 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label24" Caption ="Report Field" GUID = Begin 0x656466556dd23f4faba646020a5ffe21 End GridlineColor =10921638 LayoutCachedLeft =7790 LayoutCachedTop =4710 LayoutCachedWidth =9125 LayoutCachedHeight =5025 End End End Begin TextBox OverlapFlags =85 IMESentenceMode =3 Left =1440 Top =5040 Width =660 Height =315 TabIndex =16 BorderColor =10921638 ForeColor =4210752 Name ="lngColumnOrder" ControlSource ="lngColumnOrder" StatusBarText ="Order the field appears in the report" GUID = Begin 0x21d06f4f9b086148b4e9c9862847a4bf End GridlineColor =10921638 LayoutCachedLeft =1440 LayoutCachedTop =5040 LayoutCachedWidth =2100 LayoutCachedHeight =5355 Begin Begin Label OverlapFlags =85 Top =5040 Width =1320 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label25" Caption ="Column Order" GUID = Begin 0xc911e50d9a555f4880e828b5cf34bcb8 End GridlineColor =10921638 LayoutCachedTop =5040 LayoutCachedWidth =1320 LayoutCachedHeight =5355 End End End Begin TextBox OverlapFlags =85 IMESentenceMode =3 Left =6420 Top =5460 Width =840 Height =315 TabIndex =17 BorderColor =10921638 ForeColor =4210752 Name ="lngDefaultControlWidth" ControlSource ="lngDefaultControlWidth" StatusBarText ="Twips - Column width of the report as designed." GUID = Begin 0xc4fd3d55084dc24aacbb420ddc731173 End GridlineColor =10921638 LayoutCachedLeft =6420 LayoutCachedTop =5460 LayoutCachedWidth =7260 LayoutCachedHeight =5775 Begin Begin Label OverlapFlags =85 Left =5040 Top =5460 Width =1365 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label27" Caption ="Default Width" GUID = Begin 0xa8259e583150e2478efad4a3d3896be3 End GridlineColor =10921638 LayoutCachedLeft =5040 LayoutCachedTop =5460 LayoutCachedWidth =6405 LayoutCachedHeight =5775 End End End Begin ComboBox OverlapFlags =215 IMESentenceMode =3 ColumnCount =2 Left =4740 Top =2280 Width =3840 Height =315 TabIndex =7 BorderColor =10921638 ForeColor =4210752 ColumnInfo ="\"\";\"\";\"\";\"\";\"10\";\"200\"" GUID = Begin 0xcd1e3e1e29b49f41adc541a967b33bb9 End Name ="cboHelpTopics" ControlSource ="lngHelpId" RowSourceType ="Table/Query" RowSource ="SELECT tblHLPHelpTopics.HelpTopicID, tblHLPHelpTopics.TopicTitle FROM tblHLPHelp" "Topics WHERE (((tblHLPHelpTopics.FormName)=\"fdlgMemReportBuildFilter\") AND ((t" "blHLPHelpTopics.ControlName)=\"txtDescription\"));" ColumnWidths ="0" OnDblClick ="[Event Procedure]" OnNotInList ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =4740 LayoutCachedTop =2280 LayoutCachedWidth =8580 LayoutCachedHeight =2595 ForeThemeColorIndex =0 ForeTint =75.0 ForeShade =100.0 Begin Begin Label OverlapFlags =93 Left =4740 Top =1980 Width =3840 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label29" Caption ="'Tell Me more' Help topic" GUID = Begin 0x35f4a41372bd62459e86f83a14ba86f3 End GridlineColor =10921638 LayoutCachedLeft =4740 LayoutCachedTop =1980 LayoutCachedWidth =8580 LayoutCachedHeight =2295 End End End Begin ComboBox RowSourceTypeInt =1 OverlapFlags =87 IMESentenceMode =3 ColumnCount =2 ListWidth =2880 Left =3360 Top =4200 Width =1800 Height =315 TabIndex =10 BorderColor =10921638 ForeColor =4138256 GUID = Begin 0x32f943d43008e34ba822c67e04aac70c End Name ="cboSpecialRows" RowSourceType ="Value List" ColumnWidths ="0;1440" GridlineColor =10921638 LayoutCachedLeft =3360 LayoutCachedTop =4200 LayoutCachedWidth =5160 LayoutCachedHeight =4515 Begin Begin Label OverlapFlags =87 Left =1980 Top =4200 Width =1350 Height =320 BorderColor =8355711 ForeColor =8355711 Name ="Special Rows_Label" Caption ="Special Rows" EventProcPrefix ="Special_Rows_Label" GUID = Begin 0xe67d3efe582adb44b3d793cc3df34295 End GridlineColor =10921638 LayoutCachedLeft =1980 LayoutCachedTop =4200 LayoutCachedWidth =3330 LayoutCachedHeight =4520 End End End Begin CommandButton OverlapFlags =85 Left =5220 Top =4200 Width =480 Height =300 TabIndex =11 ForeColor =4210752 Name ="cmdAddSpecialRow" Caption ="+/-" OnClick ="[Event Procedure]" ControlTipText ="Add or Delete special row" GUID = Begin 0x9f84c1cde17b5040825b4ee2314aed24 End GridlineColor =10921638 LayoutCachedLeft =5220 LayoutCachedTop =4200 LayoutCachedWidth =5700 LayoutCachedHeight =4500 BackColor =14136213 BorderColor =14136213 HoverColor =15060409 PressedColor =9592887 HoverForeColor =4210752 PressedForeColor =4210752 WebImagePaddingLeft =2 WebImagePaddingTop =2 WebImagePaddingRight =1 WebImagePaddingBottom =1 Overlaps =1 End Begin ComboBox RowSourceTypeInt =10 OverlapFlags =215 IMESentenceMode =3 Left =1920 Top =435 Width =3660 Height =315 TabIndex =2 BorderColor =10921638 ForeColor =4210752 GUID = Begin 0x3612e1b8dede53478003ed38c0254e3f End Name ="FilterFieldName" ControlSource ="FilterFieldName" RowSourceType ="Field List" AfterUpdate ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =1920 LayoutCachedTop =435 LayoutCachedWidth =5580 LayoutCachedHeight =750 ForeThemeColorIndex =0 ForeTint =75.0 ForeShade =100.0 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =1920 Top =120 Width =3660 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="FilterFieldName_Label" Caption ="Field Name" GUID = Begin 0x0393cf864990754b9584b6a0fa38c084 End GridlineColor =10921638 LayoutCachedLeft =1920 LayoutCachedTop =120 LayoutCachedWidth =5580 LayoutCachedHeight =435 End End End Begin ComboBox LimitToList = NotDefault OverlapFlags =87 IMESentenceMode =3 Left =5340 Top =2760 Width =3300 Height =315 TabIndex =8 BorderColor =10921638 ForeColor =4138256 ColumnInfo ="\"\";\"\";\"10\";\"510\"" GUID = Begin 0xebb6be38bc534b42a3ec374a459273b1 End Name ="cboQueryList" RowSourceType ="Table/Query" RowSource ="qrySelectionComboQueries" AfterUpdate ="[Event Procedure]" GridlineColor =10921638 LayoutCachedLeft =5340 LayoutCachedTop =2760 LayoutCachedWidth =8640 LayoutCachedHeight =3075 End Begin CheckBox OverlapFlags =85 Left =7560 Top =5130 Width =965 TabIndex =20 BorderColor =10921638 Name ="ysnSortable" ControlSource ="ysnSortable" StatusBarText ="Flag to indicate if the field should be shown as a sort option." DefaultValue ="No" ControlTipText ="Should be checked if this field should be shown as a sort option." GUID = Begin 0x524224632169e94a9bf54609d87125cf End GridlineColor =10921638 LayoutCachedLeft =7560 LayoutCachedTop =5130 LayoutCachedWidth =8525 LayoutCachedHeight =5370 Begin Begin Label OverlapFlags =247 Left =7790 Top =5100 Width =1170 Height =240 BorderColor =8355711 ForeColor =8355711 Name ="Label38" Caption ="Sortable" GUID = Begin 0x094ae8d48355f94ab889764ebfc36546 End GridlineColor =10921638 LayoutCachedLeft =7790 LayoutCachedTop =5100 LayoutCachedWidth =8960 LayoutCachedHeight =5340 End End End Begin CheckBox OverlapFlags =85 Left =7560 Top =5490 Width =1325 TabIndex =21 BorderColor =10921638 Name ="ysnApplyNumericStyle" ControlSource ="ysnApplyNumericStyle" StatusBarText ="Flag to indicate to the report runner if a field should have the Negative number" " styles applied." GUID = Begin 0x5f3cfcf622109d40b87c4164706b3503 End GridlineColor =10921638 LayoutCachedLeft =7560 LayoutCachedTop =5490 LayoutCachedWidth =8885 LayoutCachedHeight =5730 Begin Begin Label OverlapFlags =247 Left =7790 Top =5460 Width =1935 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label39" Caption ="Apply Numeric Style" GUID = Begin 0x44cea320f1eedf4486f006ca06d07472 End GridlineColor =10921638 LayoutCachedLeft =7790 LayoutCachedTop =5460 LayoutCachedWidth =9725 LayoutCachedHeight =5775 End End End Begin ComboBox OverlapFlags =87 IMESentenceMode =3 Left =1500 Top =2355 Width =2580 Height =315 TabIndex =5 BorderColor =10921638 ForeColor =4210752 ColumnInfo ="\"\";\"\";\"10\";\"100\"" GUID = Begin 0x627065e521153b4e92b1f2a506fb3c5c End Name ="cboColumnWidthsForCombo" ControlSource ="ColumnWidthsForCombo" RowSourceType ="Table/Query" RowSource ="SELECT DISTINCT MemAvailableFields.ColumnWidthsForCombo FROM MemAvailableFields " "ORDER BY MemAvailableFields.ColumnWidthsForCombo;" DefaultValue ="\"0 in; 1.5 in\"" GridlineColor =10921638 LayoutCachedLeft =1500 LayoutCachedTop =2355 LayoutCachedWidth =4080 LayoutCachedHeight =2670 ForeThemeColorIndex =0 ForeTint =75.0 ForeShade =100.0 Begin Begin Label OldBorderStyle =1 OverlapFlags =93 Left =1500 Top =2040 Width =2580 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="cboSelectColumnWidths_Label" Caption ="Combo ColumnWidths" GUID = Begin 0xd4490cec25d6fa4d89d05171ea1c93fa End GridlineColor =10921638 LayoutCachedLeft =1500 LayoutCachedTop =2040 LayoutCachedWidth =4080 LayoutCachedHeight =2355 End End End Begin ComboBox RowSourceTypeInt =1 OverlapFlags =87 IMESentenceMode =3 Left =3660 Top =5100 Width =2760 Height =315 TabIndex =14 BorderColor =10921638 ForeColor =4210752 GUID = Begin 0x77c604532d390c4aba2edd19ada1137d End Name ="cboDetailControlName" ControlSource ="DetailControlName" RowSourceType ="Value List" StatusBarText ="Name of the control on the report in the details section" GridlineColor =10921638 LayoutCachedLeft =3660 LayoutCachedTop =5100 LayoutCachedWidth =6420 LayoutCachedHeight =5415 ForeThemeColorIndex =0 ForeTint =75.0 ForeShade =100.0 Begin Begin Label OverlapFlags =93 Left =2280 Top =5100 Width =1380 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label26" Caption ="Detail Name" GUID = Begin 0x78eaaf787dbd7e469a938b23921417ed End GridlineColor =10921638 LayoutCachedLeft =2280 LayoutCachedTop =5100 LayoutCachedWidth =3660 LayoutCachedHeight =5415 End End End Begin ComboBox RowSourceTypeInt =1 OverlapFlags =215 IMESentenceMode =3 Left =1320 Top =5460 Width =3360 Height =315 TabIndex =15 BorderColor =10921638 ForeColor =4210752 GUID = Begin 0x778c71f5f7cbb54f9d586e378abb045f End Name ="cboControlLabelName" ControlSource ="ControlLabelName" RowSourceType ="Value List" StatusBarText ="Name of an associated label used as a column header." GridlineColor =10921638 LayoutCachedLeft =1320 LayoutCachedTop =5460 LayoutCachedWidth =4680 LayoutCachedHeight =5775 ForeThemeColorIndex =0 ForeTint =75.0 ForeShade =100.0 Begin Begin Label OverlapFlags =93 Top =5460 Width =1335 Height =315 BorderColor =8355711 ForeColor =8355711 Name ="Label28" Caption ="Label Name" GUID = Begin 0x1663214aec0af74cba0b738baf2cc169 End GridlineColor =10921638 LayoutCachedTop =5460 LayoutCachedWidth =1335 LayoutCachedHeight =5775 End End End End End Begin FormFooter Height =0 Name ="FormFooter" GUID = Begin 0xcb547b24c31ca949827566231aa76754 End AutoHeight =1 AlternateBackThemeColorIndex =1 AlternateBackShade =95.0 BackThemeColorIndex =1 End End End CodeBehindForm Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = True Attribute VB_PredeclaredId = True Attribute VB_Exposed = False '--------------------------------------------------------------------------------------- ' Module : Form_fsubMemFilterSpecFieldDetails ' Author : Royce Fessenden ' Date : 4/4/2014 ' : Copyright 2014 All rights reserved. ' Purpose : '--------------------------------------------------------------------------------------- Option Compare Database Option Explicit Const mcModuleName = "Form_fsubMemFilterSpecFieldDetails" Const cDETAILS_TABLE = "MemAvailableFields" Public Function SetUpFields(lngSpecId As Long, strObjectName As String, bolIsForm As Boolean) As Boolean '--------------------------------------------------------------------------------------- ' Procedure : SetUpFields ' Author : Royce Fessenden ' Date : 4/7/2014 ' Purpose : Determines the parameters needed, then calls the procedure that preloads ' : fields into the table defined by cDETAILS_TABLE '--------------------------------------------------------------------------------------- ' Dim frm As Form Dim rpt As Report Dim iObj As Integer Dim rstFieldDetails As Recordset Dim strSQL As String Dim intNextColumnOrder As Integer Dim strRecordSource As String On Error GoTo Proc_Err If bolIsForm Then 'Open the form in design view If Not CurrentProject.AllForms(strObjectName).IsLoaded Then DoCmd.OpenForm strObjectName, acNormal, , , , acHidden, acWindowNormal End If Set frm = Forms(strObjectName) strRecordSource = frm.RecordSource Else If Not CurrentProject.AllReports(strObjectName).IsLoaded Then DoCmd.OpenReport strObjectName, acViewDesign, , , acHidden End If Set rpt = Reports(strObjectName) strRecordSource = rpt.RecordSource End If ' JobId # 15 - Does this need to be reworked to scan the Header, Groups, and Detail sections???? ' Takes a report or Form name and sets the RowSource for FilterFieldName combo Me.FilterFieldName.RowSource = strRecordSource strSQL = "SELECT * From " & cDETAILS_TABLE & " Where lngMemFilterSpecId = " & CStr(lngSpecId) intNextColumnOrder = Nz(DMax("lngColumnOrder", cDETAILS_TABLE, "lngMemFilterSpecId = " & CStr(lngSpecId)), 0) + 1 Set rstFieldDetails = dbLocal.OpenRecordset(strSQL, dbOpenDynaset) If rstFieldDetails.BOF And rstFieldDetails.EOF Then If bolIsForm Then AddFilterFieldsFromForm frm, rstFieldDetails, lngSpecId, intNextColumnOrder Else AddFilterFieldsFromReport rpt, rstFieldDetails, lngSpecId, intNextColumnOrder End If Else If MsgBox("Fields Exist - Do you want to autocreate any new ones?", vbYesNo + vbQuestion) = vbYes Then If bolIsForm Then AddFilterFieldsFromForm frm, rstFieldDetails, lngSpecId, intNextColumnOrder Else AddFilterFieldsFromReport rpt, rstFieldDetails, lngSpecId, intNextColumnOrder End If End If End If SetUpFields = True Me.Requery Proc_Exit: On Error Resume Next Exit Function Proc_Err: SetUpFields = False LogError Err.Number, Err.Description, mcModuleName, "SetUpFields", _ CStr(lngSpecId) & "," & strObjectName & "," & CStr(bolIsForm), _ gcGENERAL_ERROR, False Resume Proc_Exit End Function Private Sub AddFilterFieldsFromForm(frm As Form, rst As Recordset, lngSpecId As Long, intColumnOrder As Integer) '--------------------------------------------------------------------------------------- ' Procedure : AddFilterFieldsFromForm ' Author : Royce Fessenden ' Date : 4/7/2014 ' Purpose : Preloads fields into the Filter Setup table Defined by cDETAILS_TABLE '--------------------------------------------------------------------------------------- ' Dim iCtrl As Control Dim rstFrm As Recordset On Error GoTo Proc_Err If Nz(frm.RecordSource, "") = "" Then Exit Sub End If Set rstFrm = dbLocal.OpenRecordset(frm.RecordSource, dbOpenSnapshot) For Each iCtrl In frm.Controls If HasProperty(iCtrl, "ControlSource") Then If HasField(rstFrm, iCtrl.ControlSource) Then rst.FindFirst "FilterFieldName = '" & iCtrl.ControlSource & "'" If rst.NoMatch Then ' The field is not already tied to Spec so Add it. rst.AddNew rst!lngMemFilterSpecId = lngSpecId rst!FilterFieldName = iCtrl.ControlSource rst!lngFilterFieldSQLType = rstFrm.Fields(iCtrl.ControlSource).Type rst!ysnReportField = iCtrl.Visible rst!ysnSortable = iCtrl.Visible rst!ysnFilterField = (UCase(Right(iCtrl.ControlSource, 2)) = "ID") rst!lngColumnOrder = intColumnOrder intColumnOrder = intColumnOrder + 1 rst!lngDefaultControlWidth = iCtrl.Width rst!DetailControlName = iCtrl.Name If HasControl(frm, "lbl" & iCtrl.Name) Then rst!ControlLabelName = "lbl" & iCtrl.Name ElseIf HasControl(frm, iCtrl.Name & "_Label") Then rst!ControlLabelName = iCtrl.Name & "_Label" End If rst.Update End If End If End If Next iCtrl Proc_Exit: On Error Resume Next Exit Sub Proc_Err: LogError Err.Number, Err.Description, mcModuleName, "AddFilterFieldsFromForm", "", gcGENERAL_ERROR, False Resume Proc_Exit End Sub Private Sub AddFilterFieldsFromReport(rpt As Report, rst As Recordset, lngSpecId As Long, intColumnOrder As Integer) '--------------------------------------------------------------------------------------- ' Procedure : AddFilterFieldsFromReport ' Author : Royce Fessenden ' Date : 4/7/2014 ' Purpose : '--------------------------------------------------------------------------------------- ' Dim iCtrl As Control Dim rstRpt As Recordset On Error GoTo Proc_Err If Nz(rpt.RecordSource, "") = "" Then Exit Sub End If Set rstRpt = dbLocal.OpenRecordset(rpt.RecordSource, dbOpenSnapshot) For Each iCtrl In rpt.Controls If HasProperty(iCtrl, "ControlSource") Then If HasField(rstRpt, iCtrl.ControlSource) Then rst.FindFirst "FilterFieldName = '" & iCtrl.ControlSource & "'" If rst.NoMatch Then ' The field is not already tied to Spec so Add it. rst.AddNew rst!lngMemFilterSpecId = lngSpecId rst!FilterFieldName = iCtrl.ControlSource rst!lngFilterFieldSQLType = rstRpt.Fields(iCtrl.ControlSource).Type If HasProperty(rstRpt.Fields(iCtrl.ControlSource), "Caption") Then rst!FilterFieldDisplayName = rstRpt.Fields(iCtrl.ControlSource).Properties("Caption") End If rst!ysnReportField = iCtrl.Visible rst!ysnSortable = iCtrl.Visible rst!ysnFilterField = (UCase(Right(iCtrl.ControlSource, 2)) = "ID") rst!lngColumnOrder = intColumnOrder intColumnOrder = intColumnOrder + 1 rst!lngDefaultControlWidth = iCtrl.Width rst!DetailControlName = iCtrl.Name 'Set the ControlLabelName If HasControl(rpt, "lbl" & iCtrl.Name) Then rst!ControlLabelName = "lbl" & iCtrl.Name ElseIf HasControl(rpt, iCtrl.Name & "_Label") Then rst!ControlLabelName = iCtrl.Name & "_Label" End If rst.Update End If End If End If Next iCtrl Proc_Exit: On Error Resume Next Exit Sub Proc_Err: LogError Err.Number, Err.Description, mcModuleName, "AddFilterFieldsFromReport", "", gcGENERAL_ERROR, False Resume Proc_Exit End Sub Private Sub ShowHideReportSpecificControls() Dim bolShowReportControls As Boolean bolShowReportControls = Me!ysnReportField Me.lngColumnOrder.Visible = bolShowReportControls Me.cboDetailControlName.Visible = bolShowReportControls Me.lngDefaultControlWidth.Visible = bolShowReportControls Me.cboControlLabelName.Visible = bolShowReportControls End Sub Public Sub LoadControlCombos(strReportName) '--------------------------------------------------------------------------------------- ' Procedure : LoadControlCombos ' Author : Royce Fessenden ' Date : 5/24/2014 ' Purpose : Used to load the DetailControlName and the ControlLabelName combos with a list of names ' : from the underlying report '--------------------------------------------------------------------------------------- ' On Error GoTo Proc_Err Dim iCtrl As Control Dim i As Long ' loop counter Dim rpt As Report Dim strDetailItems() As String Dim strLabelItems() As String Dim lngDetails As Long Dim lngLabels As Long lngDetails = 0 lngLabels = 0 If ReportExists(strReportName) Then If Not CurrentProject.AllReports(strReportName).IsLoaded Then DoCmd.OpenReport strReportName, acViewDesign, , , acHidden End If Set rpt = Reports(strReportName) ReDim strDetailItems(rpt.Controls.Count + 1) ReDim strLabelItems(rpt.Controls.Count + 1) For Each iCtrl In rpt.Controls Select Case iCtrl.ControlType Case acTextBox, acCheckBox strDetailItems(lngDetails) = iCtrl.Name lngDetails = lngDetails + 1 Case acLabel strLabelItems(lngLabels) = iCtrl.Name lngLabels = lngLabels + 1 End Select Next QuickSort strDetailItems, 0, lngDetails - 1 i = 0 While i < lngDetails Me.cboDetailControlName.AddItem Item:=gcstrQuote & strDetailItems(i) & gcstrQuote i = i + 1 Wend QuickSort strLabelItems, 0, lngLabels - 1 i = 0 While i < lngLabels Me.cboControlLabelName.AddItem Item:=gcstrQuote & strLabelItems(i) & gcstrQuote i = i + 1 Wend End If Proc_Exit: On Error Resume Next Set iCtrl = Nothing DoCmd.Close acReport, strReportName, acSavePrompt Set rpt = Nothing Exit Sub Proc_Err: LogError Err.Number, Err.Description, mcModuleName, "LoadControlCombos", strReportName, gcGENERAL_ERROR, False Resume Next End Sub Private Sub cboHelpTopics_DblClick(Cancel As Integer) DoCmd.OpenForm "fdlgHelpTextAdd", acNormal, , "HelpTopicId = " & Me!cboHelpTopics, acFormEdit, acWindowNormal End Sub Private Sub cboHelpTopics_NotInList(NewData As String, Response As Integer) '--------------------------------------------------------------------------------------- ' Procedure : cboHelpTopics_NotInList ' Author : Royce Fessenden ' Date : 4/4/2014 ' Purpose : '--------------------------------------------------------------------------------------- ' On Error GoTo Proc_Err Dim intResponse As Integer Dim lngHelpId As Long Dim strSQL As String Dim rst As DAO.Recordset Const conHLPHelpEditForm = "frmHLPHelpEdit" intResponse = MsgBox(NewData & " was not found. Do you want to add it?", vbQuestion + vbSystemModal + vbYesNo, "Help Topic Not Found") If intResponse = vbYes Then strSQL = "Select * FROM " & conHLPTopics Set rst = dbLocal.OpenRecordset(strSQL, dbOpenDynaset, dbAppendOnly) With rst .AddNew !FormName = "fdlgMemReportBuildFilter" !ControlName = "txtDescription" !TopicTitle = NewData !IsToolTip = False ' Following fields are default - Listed here for Reference. ' !ShortDesc = "" ' !ApplicationName = "Default" ' !HeaderTopicText = "" ' Used for Generic topics ' !ImagePath = "" ' !DetailTopicText = "" lngHelpId = !HelpTopicID .Update End With If lngHelpId > 0 Then DoCmd.OpenForm "fdlgHelpTextAdd", , , "HelpTopicID = " & lngHelpId, acFormEdit, acDialog End If Response = acDataErrAdded Else Response = acDataErrContinue End If Proc_Exit: On Error Resume Next rst.Close Set rst = Nothing Exit Sub Proc_Err: LogError Err.Number, Err.Description, mcModuleName, "", "", gcGENERAL_ERROR, False End Sub Private Sub cboQueryList_AfterUpdate() Me.RowSourceForCombo = Me.cboQueryList End Sub Private Sub cmdAddSpecialRow_Click() Dim intPos As Integer Dim strTemp As String Dim strValue As String Dim intDelim As Integer Dim intStart As Integer Const cDELIM = ";" 'cboSpecialRows is a value list in the form ####,Name ' Constants starting with gcstrSRV_ are used for the values. ' The following code uses the Name to see if the row is already set to be used. Const cCOLUMN_SRV_NAME As Integer = 1 strValue = Me.cboSpecialRows.Column(cCOLUMN_SRV_NAME) strTemp = Nz(Me.RowsToAddToCombo, "") ' If it's not in the row do nothing, Else ask if they want to delete it intPos = InStr(1, strTemp, strValue) If intPos = 0 Then Me.RowsToAddToCombo = strTemp & CStr(Me!cboSpecialRows) & cDELIM & strValue & cDELIM ElseIf MsgBox("Do you want to remove " & strValue & "from the Rows To Add?", vbYesNo + vbQuestion, "Remove Row") = vbYes Then intStart = InStr(1, strTemp, CStr(Me!cboSpecialRows)) intDelim = InStr(intPos, strTemp, cDELIM) Me.RowsToAddToCombo = Left(strTemp, intStart - 1) & Mid(strTemp, intDelim + 1) End If End Sub Private Sub DetailControlName_AfterUpdate() 'JobId # 12 Finish this. ' set the lngDefaultControlWidth, and the lngColumnOrder, and cboControlLabelName(if attached or is named lblFieldName.) MsgBox "DetailControlName_AfterUpdate - Unfinished" End Sub Private Sub FilterFieldName_AfterUpdate() 'JobId # 12: Finish this. ' Set the display name ' load description from Table description if table is known ' Set the sql type ' set the combo row source if it is combo on the form or report ' If we can figure out the Control name of the field in the Detail section ' preload the DetailControlName, the lngDefaultControlWidth, the lngColumnOrder, the ControlLabelName ' Set up the combo boxes for the Detail Controls in case the defaults need to be altered somehow ' MsgBox "FilterFieldName_AfterUpdate - Unfinished" End Sub Private Sub Form_Current() ShowHideReportSpecificControls Me.cboQueryList = "" End Sub Private Sub Form_Open(Cancel As Integer) FillSpecialRowsCombo Me.cboSpecialRows End Sub Private Sub ysnReportField_AfterUpdate() ShowHideReportSpecificControls End Sub