Standard Jet DBnb` Ugr@?~1y0̝cßFNch7ל#(%`{6߱gC*<3y[w&|*O|k Bf_Љ$g'DeFx -bT4.0dvBJ FkP|@T4.0  Y  S  Y  t Y Y  Y Y  Y  Y  Y  4 Y 4 Y  Y  Y 4 Y 24Y  Y   Y  4Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortType444444YYIdParentIdName        actorApprovedDate5O.GE]ވ.jEJE qkContractorSelectedNamevmAAB>SjEJE qkCollectDeductibleOnsite󬡛A;!: ZA|~PropertyAddress%HH)&M ZA|~PropertyCity0k0ED 4} ZA|~PropertyState:I\GGdj ZA|~PropertyZipUAu ZA|~PolicyStartDateMXgy4@  |R ZA|~PolicyEndDate<#V*D \pR6UrLz LinkID<#V*D \pRԳ08C:BaQ!/eLinkID<#V*D \pR[yvG!yDLinkID;Ęp K LVڿ ZA|~PolicyIDy7ϹHZ ZA|~CustID-:E1տ<Rr{@|,0rsubCoverageItemo@Gn\37j`"p{@H` HtblClaimServiceItemFʧt.oIy5PDHC'z@H` HtblCoverageItemG6NJ,Gih-o@Gn\37ClaimIDTDFFʧt.oIy5PDHCoverageItemm I6 oFʧt.oIy5PDHCoverageDetail?[K7so@Gn\37CoverageItemIDw6)Ke3@Fʧt.oIy5PDHCoverageItemID SELECT tblClaim.ClaimID, tblClaim.DateCreated AS ClaimDate, tblClaim.PolicyID, tblClaim.ProblemDesc, [CustFirstName] & " " & [CustLastName] AS [Customer Name], tblCust.CustEmail, tblCust.CustAddress, tblCust.CustCity, tblCust.CustState, tblCust.CustZip, tblCust.CustID, qryPhone_Cust_Home.Home, qryPhone_Cust_Mobile.Mobile, qryPhone_Cust_Work.Work, tblClaim.InvoiceAmt, tblClaim.PaymentAmt, tblClaim.TotalReceivable, tblClaim.RefundAmt, tblCust.Notes, [ContractorApprovedTimeHour] & ":" & [ContractorApprovedTimeMinute] & " " & [ContractorApprovedTimeAMPM] AS ApprovedTime, tblClaim.ContractorApprovedDate, tblClaim.ContractorSelectedName, tblClaim.CollectDeductibleOnsite, tblPolicy.PropertyAddress, tblPolicy.PropertyCiOY:SY Y Y  Y 2ACMFInheritableObjectIdSID YObjectIdustID=qryPhone_Cust_Home.LinkID) LEFT JOIN qryPhone_Cust_Mobile ON tblCust.CustID=qryPhone_Cust_Mobile.LinkID) ON qryPhone_Cust_Work.LinkID=tblCust.CustID) INNER JOIN (tblClaim INNER JOIN tblPolicy ON tblClaim.PolicyID=tblPolicy.PolicyID) ON tblCust.CustID=tblPolicy.CustID WHERE (((tblClaim.ClaimID)=Forms!frmClaim_AddEdit!ClaimID)); Arial8@@@`'ch\\TSHAW\EPSON Stylus COLOR 880`f odhhRL*** xhhDLLName32=E_DU15AE.DLL d 2EPSON Stylus COLOR 880  D>EPSON Stylus COLOR 880\\TSHAW\EPSON Stylus COLOR 880LPT1:d28 Arialk2m5< Arial` "PageHeaderSection\UUK]3S^d8"`<bcde Label0WORKORDERXeOm]+e3ab`'c< Box252r\FtY}A`c DetailZw=Mzm<"F`abci Customer NameCustomer NameCustomer_Name {ΰDXvm<"F`Pabci kHomeHome,!\(999") "000\-0000;;_нG0/ifd8"`abgcd Label9Home7K&L`m<"F`Pabci k Mobile Mobile,!\(999") "000\-0000;;_hcAT)d8"`abcd Label10 Mobile;GM*s#m<"F`Pabci kWorkWork,!\(999") "000\-0000;;_ ك M)AByAFd8"`ab+cd Label11Work56.C[2e3a b`'c< Box35~iHdvEm 2<"F`<ab$'ci kProblemDescProblemDesc*}J3_Hd8"`<aXb%cd eLabel14(Problem Description:\1dKIįs.ybm 0;<"`"a8btci k$txtTotalReceivablel=IIf([CollectDeductibleOnsite]=-1,[TotalReceivable],0)*$#,##0.00;($#,##0.00)0p@lRd8"`Pa8bQ cd Label812Deductible Amt To Collect6A`DEm;<"F`"btci kClaimIDClaimIDl8d,Gfd >d8"`bcd Label12 Claim#mN{ZD/xvm;<"F`"ahbtci kClaimDateClaimDateShort DateXDate record was created; defaulted to Date()]8VNJ Qxd8"`xahb8cd Label13Claim DateG_U@UHm:d8"`xab` cd Label840Contractor Approved Date䯂)L7Xd8"`xahb cd Label870Contractor Approved Time mJ#4m;<"F`P ab4ci k ,ContractorApprovedDate,ContractorA Y,䋭КSY  Y cY Y  Y g Y jY  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order87L 9ʁY"ObjectIdAttribute  !"#$%&'() * + , -./013456789:;<! !!!2!!!!! ! ! ! ! !!! ! ! ! ! !!! ! !!!!!!!! !!!"!#!$!%!& !' !( !) !* !+!,!- !. tblBuyerOptiontblPolicyBuyerOption~@%aU- tblCoverageItem.PreTaxValue: gtblCoverageItem.CoverageItem; gtblPolicyBuyerOption.PolicyID< gtblPolicyBuyerOption999 tblBuyerOption--- tblCoverageItem///   GtblClaimServiceItemtblCoverageItem@%aU7  tblCoverageItem.CoverageDetail= gtblCoverageItem.CoverageItem; gtblClaimServiceItem.ClaimID: gtblCoverageItem/// tblClaimServiceItem777   G tblCoverageItem.CoverageItem; 'tblCoverageItemtblBuyerOptionx@%WK/ tblBuyerOption.CoverageTypeID< gtblCoverageItem.PreTaxValue: gtblCoverageItem.CoverageItem; gtblBuyerOption--- tblCoverageItem///   Gj@% 'tblCusttblPolicy!tblCust. -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipfinest service contractors and call center personnel with the coverage you selected. Your personal service administrator is Michelle. Please feel free to call her with any questions you may have regarding your warranty or for anything concerning the physical aspects of your home. Even if your current concern is something not included in our warranty she will do everything she can to find you a qualified repair contractor. When you contact us to schedule service please be prepared to select three times that would be satisfactory for a service call. Those selected times would typically be a general AM or PM time during normal business hours. We will schedule a time that is as convenient as possible for you. If deficiencies were observed in your  pre-warranty inspection , our coverage of the items identified begins once they have been repaired. Please fax or mail copies of the service receipts to us so that we may remove any restrictions. GaramondpO-FйFfs$m4;<CFa8bxc,i Text3n="Dear " & [CustFirstName] & " " & [CustLastName] & ":"GaramondS:{i!@׮b~P,m4;<CFb@ c;i k Text5`=Forms!frmPolicyCoverLetterPrint!CoverLetterDateLong DateGaramondr8,J.|SGp45`a$b8"cgd rsubPolicyDefect.Report.rsubPolicyDefectPolicyIDPolicyIDP$ڳGwR.d78ab $cd Label19The enclosed contract is for your records. Please review and if we have made any mistakes in the coverage or otherwise in the contract please bring those to our attention as soon as practical. Since Everything Residential is constantly striving to provide services that enhance the pleasure of home ownership, we are happy to offer additional years of coverYv1b N  : k & W  C t/SkoLfWdbQ+YbkfQMmdi"`dOo^Qk +kh+MSkoLfWdbQ+Mokm+kh+MfWdbQmvfQYO hivM^JY`kQiqYMQYmQ` *Si`MJ^QbOJiSi`M^JY`Si`M^JY`+JOOQOYmSi`M^JY`WYkmdivSi`M^JY``JYbSdi`Si`M^JY`sYxJiOkmQf8Si`M^JY`sYxJiOkmQf8+d^OSi`M^JY`sYxJiOkmQf:Si`M^JY`sYxJiOkmQf<Si`M^JY`sYxJiOkmQf> Si`M^JY`sYxJiOkmQf@!Si`M^dkYbUMd+JOOQOYm"Si`M^dkYbUMdMdbmJMm#Si`M^dkYbUMdMdbmJMm+JOOQOYm$Si`MdbmiJMmdi+JOOMYmv%Si`MdbmiJMmdi+JOOMdobmv&Si`MdbmiJMmdiMdMdbmJMm'Si`MdbmiJMmdiMdMdbmJMm+JOOQOYm(Si`MdqQiJUQYmQ`)Si`MdqQiJUQYmQ`+JOOQOYm*Si`MdqQiJUQmvfQ+Si`MdqQiJUQmvfQ+JOOQOYmSi`MokmSi`Mokm+JOOQOYmSi`Ybfom^YkmLdu:Si`YbkfQMmYdbMJmQUdivSi`YbkfQMmYdbMJmQUdiv+JOOQOYmSi`YbkfQMmYdbYmQ`Si`YbkfQMmYdbYmQ`+JOOQOYmSi`YbkfQMmdi+JOOQOYmSi`^dUYb Si``JYbmQbJbMQ Si`fJv`Qbm+JOOQOYm Si`fd^YMv Si`fd^YMv+JOOQOYm Si`fd^YMvMdqQi^QmmQifiYbmSi`fd^YMvYbkfQMmYdbYmQ`+JOOQOYmSi`fidfQimvkQJiMWSi`iQJ^QkmMd+JOOQOYmSi`iQJ^QkmMdJUQbmSi`iQJ^QkmMdJUQbm+JOOQOYmSi`iQfdimSi`iQfdimMiYmQiYJSi`iQfdimMiYmQiYJ+LJ\ @@O   @  @ Si`fd^YMvOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^Qk+kh+MSi`fd^YMv+kh+MMdqQiJUQmvfQYO`kvkJMMQkkdL[QMmk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO 456789:;<=>?@ABCD E!F"G#H$I%J&K'LMNOPQRSTU V W X Y Z[\]^_`abcdefghijkl m!n"o#p$q%r&s't(u)vwxyz{|}~                                          ! " # $ %0000000000 0 0 0 000000000000000000          %& ]]]]]]jj') $ 50 90E wL+EΌBathsdjmodddddddmmjmommh8=Babcgh ibjkg3w@Qܟn}OMh/QP UUU:J]ڏ_`P|@tblPolicyDefectoˈlE+^9-.UU:J]ڏDefectiveItemLZmA'_6UU:J]ڏDefectiveNoteV:N,zGRUUBlob yPropDataTypeInfo BlobDeltal  @ @       KKK$K% K& K' K( K) K* K+ K, K- K. K/ K0 K1 K2 K3 K4K5K6K7K8K9K:K;K<K=K>K?K@KAKBKCKDKEKFKGKHKIKJKKKLKMKNKOKPPPPPPPPPPP P P P P PPPPPPPPPPPP P P P!P!P!P"P "P!"P"#P##P$#P%$P&$P'$P(%P)%P*%P+&P,&P-&P.'P/'P0'P1(P2(P3(P4)P5)P6)P7*P8*P9*P:+P;+P<+P=,P>,P?,P@-PA-PB-PC.PD.PE.PF/PG/PH/PI0PJ0S0S1S1S1S2S2S2S3S3S 3S 4S 4S 4S 5S5S5S6S6S6S7S7S7S8S8S8S9S9S9S:S:S:S;S ;S!;S"<S#<S$<S%=S&=S'=S(>S)>S*>S+?S,?S-?S.@S/@S0@S1AS2AS3AS4BS5BS6BS7CS8CS9CS:DS;DS<DS=ES>ES?ES@FSAFSBFSCGSDGSEGSFHSGHSHHSIISJIYIYJYJYJYKYKYKYLYLY LY MY MY MY NYNYNYOYOYOYPYPYPYQYQYQYRYRYRYSYSYSYTY TY!TY"UY#UY$UY%VY&VY'VY(WY)WY*WY+XY,XY-XY.YY/YY0YY1ZY2ZY3ZY4[Y5[Y6[Y7\Y8\Y9\Y:]Y;]Y<]Y=^Y>^Y?^Y@_YA_YB_YC`YD`YE`YFaYGaYHaYIbYJb[b[c[c[c[d[d[d[e[e[ e[ f[ f[ f[ g[g[g[h[h[h[i[i[i[j[j[j[k[k[k[l[l[l[m[ m[!m["n[#n[$n[%o[&o['o[(p[)p[*p[+q[,q[-q[.r[/r[0r[1s[2s[3s[4t[5t[6t[7u[8u[9u[:v[;v[<v[=w[>w[?w[@x[Ax[Bx[Cy[Dy[Ey[Fz[Gz[Hz[I{[J{c{c|c|c|c}c}c}c~c~c ~c c c c ccccccccccccccccccc c!c"c#c$c%c&c'c(c)c*c+c,c-c.c/c0c1c2c3c4c5c6c7c8c9c:c;c<c=c>c?c@cAcBcCcDcEKKKK KK KKKK!K"K#  @ @ @ @ @ @ @ !"#$%&'()*+,-./0123456 7 8 9     .1:. 8D.1B=1:=BBB::B..:11511151116515511=5:DB.6=1:65151151=81=61D11B11=5BD168111511B61111D18=6511516B=16B15115156B1?=661=DB6556:=86)))))BB)))))58===:655:5))))))))))))))#8B))))))))))))))))))))))))))))))))))#8)))))))))))))))))))))))))))))))))))))))=5)))))))))))))))))))5  @ ( ( ( ( ( (LovQidfmYdb+JOOQOYmSi`MJ^QbOJiSi`M^JY`Si`M^JY`+JOOQOYmSi`M^JY`WYkmdivSi`M^JY``JYbSdi`Si`M^JY`sYxJiOkmQf8Si`M^JY`sYxJiOkmQf8+d^OSi`M^JY`sYxJiOkmQf:Si`M^JY`sYxJiOkmQf<Si`M^JY`sYxJiOkmQf> Si`M^JY`sYxJiOkmQf@!Si`M^dkYbUMd+JOOQOYm"Si`M^dkYbUMdMdbmJMm#Si`M^dkYbUMdMdbmJMm+JOOQOYm$Si`MdbmiJMmdi+JOOMYmv%Si`MdbmiJMmdi+JOOMdobmv&Si`MdbmiJMmdiMdMdbmJMm'Si`MdbmiJMmdiMdMdbmJMm+JOOQOYm(Si`MdqQiJUQYmQ`)Si`MdqQiJUQYmQ`+JOOQOYm*Si`MdqQiJUQmvfQ+Si`MdqQiJUQmvfQ+JOOQOYmSi`MokmSi`Mokm+JOOQOYmSi`Ybfom^YkmLdu:Si`YbkfQMmYdbMJmQUdivSi`YbkfQMmYdbMJmQUdiv+JOOQOYmSi`YbkfQMmYdbYmQ`Si`YbkfQMmYdbYmQ`+JOOQOYmSi`YbkfQMmdi+JOOQOYmSi`^dUYb Si``JYbmQbJbMQ Si`fJv`Qbm+JOOQOYm Si`fd^YMv Si`fd^YMv+JOOQOYm Si`fd^YMvMdqQi^QmmQifiYbmSi`fd^YMvYbkfQMmYdbYmQ`+JOOQOYmSi`fidfQimvkQJiMWSi`iQJ^QkmMd+JOOQOYmSi`iQJ^QkmMdJUQbmSi`iQJ^QkmMdJUQbm+JOOQOYmSi`iQfdimSi`iQfdimMiYmQiYJSi`iQfdimMiYmQiYJ+LJ\Si`kf^JkWkMiQQbSi`kmJmokSi`ksYmMWLdJiOSkoLJfSkoLM^JY`MokmJqJY^JL^QSkoLM^JY`sYxJiOdfmYbSdSkoLMdbmiJMmdixYfMdOQSkoLfWdbQ+LoY^OQiSkoLfWdbQ+M^dkYbUMdMdbmJMmSkoLfWdbQ+MdbmiJMmdiMdMdbmJMm SkoLfWdbQ+Mokm!SkoLfWdbQ+YbkfQMmdi"SkoLfWdbQ+iQJ^QkmMdJUQbm#SkoLfd^YMvOQSQMm$Skofd^YMvYbkfQMmYdbYmQ`%Skofd^YMvYbkfQMmYdbYmQ`dbM^JY`&LJkJmmJMW`Qbmk'LJkJomdQuQMLJkMJ^QbOJiLJkMd``dbOYJ^dULJkMdbkmJbmkLJkMdoikQLJkMiQJmQMdbmid^kLJkQiidiiQfdimQiLJkQqQivmWYbULJkSdi`kQMoiYmvLJkUQmSobMmYdbk LJkUQmsdiOSid`kmiYbU LJkYbfomLdu LJkiQJmmJMW LJkidobO LJkkQmOLLJkkdobOuLJkkh^LJkkmJmokLJkomY^YmYQkM^kSdi`JmLvMiYmQiYJ`dOJOOidS`dOMd^difYM\Qi`dOkoLM^JkkifmMdbmiJMm+LoY^OQiifmMdbmiJMm+LoY^OQi+fJUQ8ifmMdbmiJMm+LoY^OQi+fJUQ:ifmMdbmiJMm+LoY^OQi+fJUQ<ifmMdbmiJMm+LoY^OQi+fJUQ>ifmMdbmiJMm+Ud^OifmMdbmiJMm+Ud^O+fJUQ8ifmMdbmiJMm+Ud^O+fJUQ:ifmMdbmiJMm+Ud^O+fJUQ<ifmMdbmiJMm+Ud^O+fJUQ> ifmMdbmiJMm+kY^qQi!ifmMdbmiJMm+kY^qQi+fJUQ8"ifmMdbmiJMm+kY^qQi+fJUQ:#ifmMdbmiJMm+kY^qQi+fJUQ<$ifmMdbmiJMm+kY^qQi+fJUQ>%ifmOQSQMm^QmmQi&ifmOQSQMm^Ykm'ifmfd^YMv^YkmOQmJY^(ifmfd^YMv^Ykmko``Jiv)ifmkJ^Qk^Ykmifmsdi\diOQiikoLLJkYMMdqQiJUQikoLLoY^OQidfmYdbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO ubPolicyDefect@XNNNBBBBBBB@ @Gam;rw@am;rw@fsubPhone_RealEstCoAgentp@X^^^RRRRRRRP @F*)'.x@*)'.x@fsubPhone_Inspector\@XTTTHHHHHHHF @Df2k;rw@f2k;rw@fsubPhone_ContractorCoContact@Vhhh\\\\\\\Z @Ci;rw@i;rw@fsubPhone_ClosingCoContactx@WbbbVVVVVVVT @Bh;rw@h;rw@fsubPhone_BuilderDDDDDDDDDDB AUg;rw@Ug;rw@fsubContractorZipCode@WXXXLLLLLLLJ @@ȕf;rw@ȕf;rw@fsubClaimWizardOptInfo@WZZZNNNNNNNL @?_e;rw@_e;rw@fsubClaimCustAvailable @ZZZNNNNNNNL @=g(d;rw@g(d;rw@frmSwitchboard@MJJJ>>>>>>>< @<mc;rw@mc;rw@frmStatusT@ M@@@44444442 @;a;rw@a;rw@frmSplashScreenT@ MLLL@@@@@@@> @:2F`;rw@2F`;rw@frmReportCriteria_bakT@ MXXXLLLLLLLJ @9 _J@{@ _J@{@frmReportCriteriad@VPPPDDDDDDDB @7K _;rw@K _;rw@frmRealEstCoAgent_AddEdit@V```TTTTTTTR @6w];rw@w];rw@frmRealEstCoAgent@VPPPDDDDDDDB @5\;rw@\;rw@frmRealEstCo_AddEdit@VVVVJJJJJJJH @4:e[;rw@:e[;rw@frmPropertySearchDDDDDDDDDDB 3lZ;rw@lZ;rw@frmPolicyInspectionItem_AddEdit2@Rlll```````^ @2RFy@RFy@frmPolicyCoverLetterPrintT@ M```TTTTTTTR @1{X;rw@{X;rw@frmPolicy_AddEditRT PPPDDDDDDDB @0DW;rw@DW;rw@frmPolicyd@@@@44444442 @.$S;rw@$S;rw@frmMaintenanceT@RJJJ>>>>>>>< @-+R;rw@+R;rw@frmLoginT@ M>>>22222220 @,w@w@frmInspector_AddEdit@RVVVJJJJJJJH @+LP;rw@LP;rw@frmInspectionItem_AddEditTTTTTTTTTTR *O;rw@O;rw@frmInspectionItemDDDDDDDDDDB )2O;rw@2O;rw@frmInspectionCategory_AddEdit\\\\\\\\\\Z (nN;rw@nN;rw@frmInspectionCategoryLLLLLLLLLLJ ' M;rw@ M;rw@frmInputListBox2BBBBBBBBBB@ &1K;rw@1K;rw@frmCust_AddEdit@RLLL@@@@@@@> @%J;rw@J;rw@frmCustT@M<<<0000000. @$:#J;rw@:#J;rw@frmCoverageType_AddEditPPPPPPPPPPN  SkoLfWdbQ+iQJ^QkmMdJUQbm#SkoLfd^YMvOQSQMm$Skofd^YMvYbkfQMmYdbYmQ`%Skofd^YMvYbkfQMmYdbYmQ`dbM^JY`&LJkJmmJMW`Qbmk'LJkJomdQuQMLJkMJ^QbOJiLJkMd``dbOYJ^dULJkMdbkmJbmkLJkMdoikQLJkMiQJmQMdbmid^kLJkQiidiiQfdimQiLJkQqQivmWYbULJkSdi`kQMoiYmvLJkUQmSobMmYdbk LJkUQmsdiOSid`kmiYbU LJkYbfomLdu LJkiQJmmJMW LJkidobO LJkkQmOLLJkkdobOuLJkkh^LJkkmJmokLJkomY^YmYQkM^kSdi`JmLvMiYmQiYJ`dOJOOidS`dOMd^difYM\Qi`dOkoLM^JkkifmMdbmiJMm+LoY^OQiifmMdbmiJMm+LoY^OQi+fJUQ8ifmMdbmiJMm+LoY^OQi+fJUQ8+LJ\ifmMdbmiJMm+LoY^OQi+fJUQ:ifmMdbmiJMm+LoY^OQi+fJUQ<ifmMdbmiJMm+LoY^OQi+fJUQ>ifmMdbmiJMm+Ud^OifmMdbmiJMm+Ud^O+fJUQ8ifmMdbmiJMm+Ud^O+fJUQ:ifmMdbmiJMm+Ud^O+fJUQ< ifmMdbmiJMm+Ud^O+fJUQ>!ifmMdbmiJMm+kY^qQi"ifmMdbmiJMm+kY^qQi+fJUQ8#ifmMdbmiJMm+kY^qQi+fJUQ:$ifmMdbmiJMm+kY^qQi+fJUQ<%ifmMdbmiJMm+kY^qQi+fJUQ>&ifmOQSQMm^QmmQi'ifmOQSQMm^Ykm(ifmfd^YMv^YkmOQmJY^)ifmfd^YMv^Ykmko``JivifmkJ^Qk^Ykmifmsdi\diOQiikoLLJkYMMdqQiJUQikoLLoY^OQidfmYdbikoLMdqQiJUQYmQ`ikoLUd^OdfmYdbikoLdfmYdbJ^MdqQiJUQikoLfd^YMvOQSQMmikoLfd^YMvOQSQMmOQmJY^ ikoLkY^qQidfmYdb JomdQuQM JomdQuQM+kJ`QOYi JO`Yb OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`Jf+kh+MMdbmiJMmdiMdMdbmJMmYO+kh+MSi`Jf+kh+M^kmJf+kh+MSi`M^JY`WYkmdiv+kh+M^kmM^JY`+kh+MSi`M^dkYbUMdMdbmJMm+JOOQOYm+kh+MM^dkYbUMdYO+kh+MSi`M^dkYbUMdMdbmJMm+JOOQOYm+kh+MSkoLfWdbQ+M^dkYbUMdMdbmJMm+kh+MSi`MdbmiJMmdiMdMdbmJMm+JOOQOYm+kh+MSkoLMdbmiJMmdixYfMdOQ+kh+MSi`Mokm+JOOQOYm+kh+MSkoLfWdbQ+Mokm+kh+MSi`YbkfQMmdi+JOOQOYm+kh+MSkoLfWdbQ+YbkfQMmdi+kh+MSi`fJv`Qbm+JOOQOYm+kh+MfJv`QbmmvfQYO+kh+MSi`fd^YMv+JOOQOYm+kh+MLoY^OQiYO+kh+MSi`fd^YMv+JOOQOYm+kh+MM^dkYbUMdMdbmJMmYO+kh+MSi`fd^YMv+JOOQOYm+kh+MM^dkYbUMdYO+kh+MSi`fd^YMv+JOOQOYm+kh+MMdqQiJUQmvfQYO+kh+MSi`fd^YMv+JOOQOYm+kh+MSkoLfd^YMvOQSQMm+kh+MSi`fd^YMv+JOOQOYm+kh+MYbkfQMmdiYO+kh+MSi`fd^YMv+JOOQOYm+kh+M^kmJqJY^JL^Q+kh+MSi`fd^YMv+JOOQOYm+kh+M^kmkQ^QMmQO+kh+MSi`fd^YMv+JOOQOYm+kh+MfidfQimvxYf+kh+MSi`fd^YMv+JOOQOYm+kh+MiQJ^QkmMdJUQbmLovQiYO+kh+MSi`fd^YMv+JOOQOYm+kh+MiQJ^QkmMdJUQbmkQ^^QiYO+kh+MSi`fd^YMv+JOOQOYm+kh+MiQJ^QkmMdLovQiYO+kh+MSi`fd^YMv+JOOQOYm+kh+MiQJ^QkmMdkQ^^QiYO+kh+MSi`fd^YMv+kh+MMdqQiJUQmvfQYO+kh+MSi`iQJ^QkmMd+JOOQOYm+kh+MWd`QxYf+kh+MSi`iQJ^QkmMdJUQbm+JOOQOYm+kh+MSkoLfWdbQ+iQJ^QkmMdJUQbm+kh+MSi`iQJ^QkmMdJUQbm+JOOQOYm+kh+MiQJ^QkmMdYO`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO)))))6 hivM^JY`kQiqYMQYmQ`fidL^Q` hivMdbmiJMmdikQiqYMQYmQ` hivMdqQiJUQYmQ`SY^mQi hivOQSQMm^QmmQi hivOQSQMm^QmmQikJq hivUd^OdfmYdb hivUd^OdfmYdb+kQ^QMmQO hiv^JmQkmMokmd`QiM^JY` hiv`JkmQifWdbQ+Mokm !hivfWdbQ+MdbmiJMmdi+`dLY^Q "hivfWdbQ+MdbmiJMmdi+fJUQi #hivfWdbQ+MdbmiJMmdi+sdi\ $hivfWdbQ+Mokm+Wd`Q %hivfWdbQ+Mokm+`dLY^Q0hivfWdbQ+Mokm+sdi\0hivfd^YMvLovQidfmYdb0hivfd^YMvMdobm0hivfd^YMvOQSQMm0hivfd^YMviQfdim0hivkY^qQidfmYdb0hivkY^qQidfmYdb+kQ^QMmQO0hoQiv80hofOfJv`QbmJ`m0 mL^JmmJMWQOSY^Q0 mL^Jomd\Qv0 mL^LoY^OQi0 mL^LovQidfmYdb0 mL^M^JY`0mL^M^JY`MokmJqJY^JL^Q0mL^M^JY`dfmYbSd0mL^M^JY`kQiqYMQYmQ`0mL^M^JY`kQiqYMQYmQ`fidL^Q`0mL^M^JY`kmJmok0mL^M^JY`mvfQ0mL^M^dkYbUMd0mL^M^dkYbUMdMdbmJMm0mL^MdbSYUoiQ0mL^MdbmiJMmdiMdMdbmJMm0mL^MdbmiJMmdikQiqYMQYmQ`0mL^MdbmiJMmdixYf0mL^MdqQiJUQYmQ`0mL^MdqQiJUQmvfQ0mL^MoiiQbmkJ^QkmJufQiM0mL^Mokm0mL^YbkfQMmYdbMJmQUdiv0mL^YbkfQMmYdbYmQ`0 mL^YbkfQMmdimL^`JboSJMmoiQimL^`JkmQifWdbQmL^dfmYbSdmQ`f^JmQmL^dfmYbSdmvfQmL^dfmYbSdqJ^oQmL^fJv`QbmmL^fJv`QbmmvfQmL^fWdbQSY^mQimL^fWdbQmvfQ mL^fd^YMv mL^fd^YMvLovQidfmYdb mL^fd^YMvOQSQMm mL^fd^YMvYbkfQMmYdbYmQ` mL^fiQSQiiQOMdbmJMm`QmWdOmL^foiMWJkQimvfQmL^iQJ^QkmMdmL^iQJ^QkmMdJUQbmmL^iQSobOkmJmokmL^iQfdimmL^kQiqYMQYmQ`fidL^Q`mL^okQimL^okQiUidofkm^\fxYfJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOK9x! Qxoh 5h4{(@%P:T%x Lx $Ph'':N!: h:^ pf)xP6 hkf2 Rhx! x 0%:T h:@ "X \/x6h dT%! x! x xb xx 'h  XCxx>|`ǀl+ 2|xx6h$ < |xxPhHK9hx! x h``Cdd 2d`x5hH$ d`xhDK:x X>xFd%t$ `t ,t5dD$ xtdTKoc`%p$ `p PpC\\ /\\>\1x *p'<%'L%`%lx"X Qpt(:t k:8t 4k8p! p p J!4t pl4i$ "#\*# #*#p! p 2\ p5$lxp! p pp! p p $ f`%p$ `p Pp 8 f`%p$ `p Pp $b4 pp '$ \ X%C>\ ` l4+: 2 p6$ t,tx(\ p$ h0K &CttCxx 2xto0$ xtKWt>t1x='0%4F@%'P%:hd _ Z 7 T  _  A I                                                                                                                                      ()*+,-./0 1 2 3 4 56789:;<=>?@ABCDEFG H!I"J#K$L%M&N'O(P)Q*R+S,T-U.V/W0X1Y2Z3[4\5]6^7_8`9a:b;  "PaTb  >Zo|@>Zo|@AccessLayout4MR2KeepLocal T"@*zz:::::::8 @ *o|@*o|@~sq_cfrmPolicy~sq_cCoverageTypeID4MR2KeepLocal Tdddddddb @"n|@"n|@frmPolicyT@@@@44444442 @aCi|@aCi|@DataAccessPages@@@@@@@@@@> aCi|@aCi|@SysRel.........., >bCi|@>bCi|@Modules0000000000. >bCi|@>bCi|@Scripts0000000000. >bCi|@>bCi|@Reports0000000000. >bCi|@>bCi|@Forms,,,,,,,,,,*  >bCi|@>bCi|@UserDefinedA@DDD88888886 @ >bCi|@>bCi|@SummaryInfo@DDD88888886 @>bCi|@>bCi|@MSysAccessObjectsDDDDDDDDDDB $Ci|@$Ci|@MSysRelationshipsDDDDDDDDDDB $Ci|@$Ci|@MSysQueries88888888886 $Ci|@$Ci|@MSysACEs22222222220 $Ci|@$Ci|@MSysObjects88888888886 $Ci|@$Ci|@MSysDb@:::......., @$Ci|@$Ci|@Relationships<<<<<<<<<<: $Ci|@$Ci|@Databases44444444442 $Ci|@$Ci|@Tables.........., :{hUB/A S @ ,  |  B /   l Y 2 o\I"r"E "9#&(')+./43     !"#$%&'()+,-*.012/35   O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp    O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp     O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp   O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp  O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp   O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp  O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp TO1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp TO1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp             LVALRmUB/A S @ ,  C t/OJmJLJkQkiQ^JmYdbkWYfkmJL^Qk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkOLevent that is not success  D B P O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp  O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp   O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp  O1N-`qHA(9)y >E}Y1>R8hOg)P:y\tf6#҂8QB#^/-G4wIp O1N-`qHMR2^ANSI Query ModeAcceMR2 GUIDNameMap0  KEC7  UMR2^ANSI Query ModeAccessVersion BuildProjVerB   08.50  MR2( ReplicateProject MR20 Title AuthorCompanyz update" James B. Shaw8 0Applied Technology Group YNY Y DataIDd@YAOIndex     torCoContactNNNNNNNNNNL C;rw@C;rw@frmContractor_AddCountyPPPPPPPPPPN :C;rw@:C;rw@frmContractor_AddCityLLLLLLLLLLJ @;rw@@;rw@frmClosingCoContactHHHHHHHHHHF /@;rw@/@;rw@frmClosingCo_AddEditJJJJJJJJJJH )u?;rw@)u?;rw@frmClaimWizardStep5HHHHHHHHHHF >;rw@>;rw@frmClaimWizardStep4HHHHHHHHHHF 2=;rw@2=;rw@frmClaimWizardStep3HHHHHHHHHHF ?=;rw@?=;rw@frmClaimWizardStep2HHHHHHHHHHF (G<;rw@(G<;rw@frmClaimWizardStep1_oldPPPPPPPPPPN ;;rw@;;rw@frmClaimWizardStep1HHHHHHHHHHF T:;rw@T:;rw@frmClaimMainFormBBBBBBBBBB@ Pcx@Pcx@frmClaimHistoryV@MLLL@@@@@ @@v1k f   @  @@  @+kh+MSkofd^YMvYbkfQMmYdbYmQ`dbM^JY`+kh+M`JboSJMmoiQi +kh+OifmMdbmiJMm+LoY^OQi+kh+OifmMdbmiJMm+Ud^O+fJUQ8 +kh+OifmMdbmiJMm+kY^qQi+kh+OifmMdbmiJMm+Ud^O+fJUQ8+kh+OifmOQSQMm^QmmQi+kh+OikoLfd^YMvOQSQMm+kh+OifmOQSQMm^Ykm+kh+OikoLfd^YMvOQSQMm+kh+Oifmfd^YMv^YkmOQmJY^+kh+OikoLLJkYMMdqQiJUQ+kh+Oifmfd^YMv^YkmOQmJY^+kh+OikoLdfmYdbJ^MdqQiJUQ+kh+Oifmsdi\diOQi+kh+OikoLMdqQiJUQYmQ`+kh+SSi`M^dkYbUMdMdbmJMm+JOOQOYm+kh+SSi`fd^YMv+JOOQOYmj+kh+SSi`ksYmMWLdJiO+kh+SSkoLM^JY`MokmJqJY^JL^Q+kh+SSkoLMdbmiJMmdixYfMdOQ+kh+SSkoLfWdbQ+M^dkYbUMdMdbmJMm+kh+SSkoLfWdbQ+MdbmiJMmdiMdMdbmJMm+kh+SSkoLfWdbQ+Mokm+kh+SSkoLfWdbQ+iQJ^QkmMdJUQbm +kh+SSkoLfd^YMvOQSQMm +kh+SSkofd^YMvYbkfQMmYdbYmQ` +kh+SSkofd^YMvYbkfQMmYdbYmQ`dbM^JY` +kh+iifmMdbmiJMm+LoY^OQi+fJUQ8 +kh+iifmMdbmiJMm+Ud^O+fJUQ8 +kh+iifmMdbmiJMm+kY^qQi+fJUQ8 +kh+iifmOQSQMm^Ykm +kh+iifmfd^YMv^YkmOQmJY^ +kh+iifmfd^YMv^Ykmko``Jiv +kh+iifmkJ^Qk^Ykm +kh+iifmsdi\diOQi +kh+iikoLLJkYMMdqQiJUQ +kh+iikoLMdqQiJUQYmQ` +kh+iikoLdfmYdbJ^MdqQiJUQ `kvkJMMQkkdL[QMmk `kvkJMMQkku`^ `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhJffMokmfWdbQSY^mQi hJfffd^YMvLovQidfmYdb hJfffd^YMvLovQidfmYdb+d^O hJfffd^YMvYbkfQMmYdbYmQ` hivLoY^OQidfmYdb hivLoY^OQidfmYdb+kQ^QMmQO hivM^JY`Mdobm hivM^JY`kQiqYMQYmQ`   hivM^JY`kQiqYMQYmQ` hivM^JY`kQiqYMQYmQ`fidL^Q` hivMdbmiJMmdikQiqYMQYmQ` hivMdqQiJUQYmQ`SY^mQi hivOQSQMm^QmmQi hivOQSQMm^QmmQikJq hivUd^OdfmYdb hivUd^OdfmYdb+kQ^QMmQO hiv^JmQkmMokmd`QiM^JY` hiv`JkmQifWdbQ+Mokm !hivfWdbQ+MdbmiJMmdi+`dLY^Q "hivfWdbQ+MdbmiJMmdi+fJUQi #hivfWdbQ+MdbmiJMmdi+sdi\ $hivfWdbQ+Mokm+Wd`Q %hivfWdbQ+Mokm+`dLY^Q0hivfWdbQ+Mokm+sdi\0hivfd^YMvLovQidfmYdb0hivfd^YMvMdobm0hivfd^YMvOQSQMm0hivfd^YMviQfdim0hivkY^qQidfmYdb0hivkY^qQidfmYdb+kQ^QMmQO0hoQiv80hofOfJv`QbmJ`m0 mL^JmmJMWQOSY^Q0 mL^Jomd\Qv0 mL^LoY^OQi0 mL^LovQidfmYdb0 mL^M^JY`0mL^M^JY`MokmJqJY^JL^Q0mL^M^JY`dfmYbSd0mL^M^JY`kQiqYMQYmQ`0mL^M^JY`kQiqYMQYmQ`fidL^Q`0mL^M^JY`kmJmok0mL^M^JY`mvfQ0mL^M^dkYbUMd0mL^M^dkYbUMdMdbmJMm0mL^MdbSYUoiQ0mL^MdbmiJMmdiMdMdbmJMm0mL^MdbmiJMmdikQiqYMQYmQ`$Ci|@$Ci|@MSysRelationshipsDDDDDDDDDDB $Ci|@$Ci|@MSysQueries88888888886 $Ci|@$Ci|@MSysACEs22222222220 $Ci|@$Ci|@MSysObjects88888888886 $Ci|@$Ci|@MSysDb.........., $Ci|@$Ci|@Rel  @ @     )   h0h1h2h3h4h5h6h7h8h9h:h;h<h=h>h?h@hAhBhChJiiiiiiiiii i i i i iiiiiiiiiiiiiiiiiii i!i"i#i$i%i&i'i(i)i*i+i,i-i.i/i0i1i2i3i4i5i6i7i8i9i:i;i<i=kkkkk k k k k kkkkkkkkkkkkkkkkkkk k!k"k#k$k%k&k'k(k)k*k+k,k-k.k/k0k1k2k3k4k5k6k7k8k9k:k;k<k=k>k?k@kAkBkCkDkEkFkGkHkIkJwwwwwwwwww w w w w wwwwwwwwwwwwwwww w!w"w#w$w%w&w'w(w)w*w+w,w-w.w/w0w1w2w3w4w5w6w7w8w9w:w;w<w=wAwBwCwDwEwFwGwHwIwJ~~~~~~~~~~ ~ ~ ~ ~ ~~~~~~~~~~~~~~~~~~~ ~!~"~#~$~%~&~'~(~,~-~.~/~0~1~2~3~4~5~6~7~8~9~:~;~<~=~>~?~@~A~B~C~D~E~F~G~H~I               cN cO cPcQcRcScTcUcVcWcXcYcZc[c\c]c^hKhLhMhNhOhPhQhRhShThUhVhWhXhYhZh[h\h]h^h_h`hahbhcc_c`hdiFiGiHiDiEiIkkkkk)i>)i?)i@~)~*~+$iA$iB$iC5w5w5w9w>9w?9w@E~JEEKKKK KK KKKK!K"K#KeepLocal TRRRRRRRP @"w@`w@~sq_rrptContract_Silver_Page14MR2KeepLocal T\\\\\\\Z @K[{hUB/A S @ ,  |  C 0  m Z G ̈[n0ccessObjectsDDDDDDDDDDB =d@ <MR2@@=x=$C=Q+kh+MSi`M^JY`WYkmdiv+kh+M^kmM^JY`(<=  8cXÅPtblBuyerOptionQuery1frmLogin_AddEdit&rptDefectListCreate data access page in Design viewautoexec_SameDirbasGetWordFromString l`D^3K[_K M)-1c @ @ࡱ> *'%BlobDelta/ PropData.PropData;DirData: 02abc%g(h5iZj}7kz{Z@ KEC7 U"[Event Procedure]8 hDad's HP LaserJet IIIP@g,,@MSUDNHP LaserJet IIIPd ENABLE 8(@Dad's HP LaserJet IIIPHPPCL5MSLPT1:"[Event Procedure] d2e12hghMS Sans Serifi1j1k1m4n2o2zbchijMS Sans Serif`@Detail0_ LsD.\ n3U`aPbc5%d llstPolicyTable/QueryF864;2448;1152;648;720;936;1296;1152"[Event Procedure]"[Event Procedure]RD΃Gފ d25U`PabcelblPolicyPolicies:UJBoRh1U2A`L a beci cmdNew&Add New Policy"[EvenModules`{m`{mScripts`{m`{mVBA`{mӎmCmdbars`{m`{mDataAccessPages `{m`{mDatabases `{m/I֎m0 `{m/I֎mBlob t Procedure]BŵzZD*"vXkoz ndhAhEhhhhEkdmdmdodhPB9N9 n3U`aPbc5%d llstPolicyͬ t3AT~2e@4Detail0nlstPolicyd lblPolicyh cmdNewh cmdEdith cmdExith cmdDeleteh cmdFindIth cmdEmailk optSearchByd  Text13m txtNamed  LCustomGroups `{m`{mDirDataVBAProjectӎmӎmAcessVBAData ,$ !+&-)./301245"789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[K[N /   l Y VBAӎmӎmPROJECTwm</PROJECTt_VBA_PROJECTC  !"#$%&'()*+,-=012356789>?@ABCDEFGHIJKLMNOPQRSTUVWXYZijMSysDbID="{3323F3B1-16A3-45E1-B1D4-999C683F6352}" DocClass=Form_frmPolicy/&H00000000 Name="update" HelpContextID="0" VersionCompatible32="393222000" CMG="BCBE1193F18FF58FF58FF58FF5" DPB="B4B6199BE992EA92EA92" GC="ACAE01A3019A029A0265" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmPolicy=0, 0, 0, 0, C 20* pHdupdate$@T=j ä@ J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\Se2.tlb#OLE Automation` hADODB> ADTOBDDE1D10-8DAA006DP2EA4D1DProgram Files\CommonM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 Libra,ryHȏ Form_frmPolicyG rm_(fPi cyBBCHTSZJVCBEGYRoot Entry/I֎m(PropData Forms `{m/I֎mReports`{m`{mabel24m PolicyIDd Label38oCoverageTypeIDd ??????h cmdPrintPolicyListfrmPolicy 0CB0mScriptsForm_frmPolicyForm_frmPolicyx*E/q@8Obdl3AccessVBAWin16~Win32MacBCHTSZJVCBEGYDAOKXSVKSXMBUUD:6xJBlobCopyk%BlobDeltaCopy TypeInfoCopyodir 60בӎm/I֎mBlob k%TypeInfoK[ @ @ @ @ @ @4oDAOKXSVKSXMBU UD28BCHTS ZJV@BEGYJALKXVK@XMBU@DB@1ƒ`6B,B/"(B +BBOS~1\am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#VBA6#Project1 stdole`updateADODBsForm_frmPolicy _Evaluate WhereClauseA PrintingCert7FirstTimeFormActivateH vListBoxCountmDEBUG];cmdDelete_ClickcmdDelete_Click_ErrQIsNull lstPolicy MsgBoxRvbOKOnly vbInformationn APP_TITLEResponseColumni vbQuestion vbOKCancelx?vbOK%SetDBBgDB ExecuteY dbFailOnErrorhRequeryRequeryListBoxLablelerrptcErro cmdEdit_Click gOpenFormArgsՔcmdEmail_Clickrst RecordsetqryvCountmsgQ vEmailList GetSQLStringdb OpenRecordset| dbOpenDynaset EOFBOFy gStopStatusrEmailEdit+ Last EmailedjIMoveNextL!DoCmdƧ SendObject cmdExit_ClickA_FORM|cmdFindIt_ClickYTcmdFindIt_Click_ErrL Hourglassb gshowstatuswDB_OPEN_SNAPSHOT& lblPolicyFCaptionx RecordCount{Str RowSource2 cmdNew_ClickcmdPrint_ClickbfcmdPrint_Click_Err%vbCancel' OpenReport acViewNormal RcmdPrintPolicyList_Click acViewPreview2 Form_Activaten lstPolicy_AfterUpdate>zRestore> Form_Open-Cancel mInitFormOlstPolicy_AfterUpdate_ErrZSetFocuscmdEditaEnabled۪ cmdDeleteVlstPolicy_DblClick mInitForm_ErrtxtNameoGetSQLString_ErrACAddWhere/gAddWhereIfNeededIConvertToSoundexBjPolicyID\CoverageTypeID\ RequeryListBoxLable_Err$H  ta dehijkmnoz ndhAhEhhhhEkdmdmdodhP`{m`{mi9.0#0#C:\Program Files\Microsoft Office\Office10\msacc.olb#Microsoft Access 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\Stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Libraryä@ȏ8BCHTSZJVCBEGYDAOKXSVKSXMBUUD0s40a4c3ddForm_frmPolicy6(K[v1T @ @ dehijkmn6ȏxME (SLS S )& "&B@BA@Dkk|" H !cmdDelete_ClickA@F |o &$$)You must select an item from the list box * , .A@(|8k0frmPolicy_AddEdit "&|A@L|o@]'Z$\'T 'VA@: T ` <%^.P P!b P!d0A@fNo email addresses found. * , .A@(| d send out emails!!!!T P!ba3x P"h$$ PB@j Z P)l Z Z;  P"h'Z|d P"h'Zkh PB@ V 'Vk@ PB@n do until rst.EOF VA@fNo email addresses found. * , .A@(|d K[v1 @ Z pB@r k PB@BTMsgBox Str$(vCount) & " emails have been sent.", vbOKOnly + vbInformation, APP_TITLEk rst.EOF And rst.BOF rst.Close|cmdEmailMessage_Click_Err:6 errpt Err, Error, (Me.Name), "cmdEmailMessage_Click"P0 Exit Subop` v ! pB@Bo@@z0]` pB@|show hourglassPolicy Search...A@~ QStopGet SQL Stringp$\'T`:dA@: T  <%^.P P!d P!b0!if no records found in your query'Policy not found! "(:@d'we found at least 1 record in our query P!'Found $  Policy(s) "(k T "&( ,put our query into rowsource of the list box "&B@B /requery list box to show records found in queryA@f"stop displaying status pB@|"return to orginal mouse pointer' PB@B|zx pB@|A@f H !cmdFindIt_ClickA@F|(o RM 2/96frmPolicy_AddEdit0|A@L|o &$$)You must select an item from the list box * , .A@(|XkP]8P]p'$\'TA@: T  <%^.P P!  Of the $ students selected  P!$* student(s) are eligible for a certificate 6 .$('0 0  rptCEUCert   pB@kdNo students are eligible for certificates with the criteria you selected. Students must have attended and paid for a certificate. Try again. * , .A@(k`' PB@B|@8 H !cmdPrint_ClickA@F|orptPolicyReport  pB@oRM 2/96  )& "&B@BA@ A@DkX pB@k@|8o0RM 2/96'$G'johRM 2/96 "&B@ "&$$ "( "(d "( "(kX|PH H !lstPolicy_AfterUpdateA@F|oA@JoRM 2/96 Policy Search ( "&B@ )& "( "(-cmdFindIt_Click 'fill list box with records "B@''z H ! mInitFormA@Fdzihjs 10/97 J**************************************************************************Ipupose: this code is used to build my query that I will assign to the row source of the lstPolicy list box2EJ**************************************************************************]hqry = "SELECT tblPolicy.PolicyID AS [Contract#], [CustFirstName] & ' ' & [CustLastName] AS [Cust Name], tblPurchaserType.PurchaserType AS [Purchaser Type], tblPolicy.PropertyState AS [Prop St], tblPolicy.PropertyZip AS [Prop Zip], tblRealEstCoAgent.AgentName AS Agent, tblClosingCoContact.ClosingContactName AS [Closing Contact], tblCoverageType.CoverageType "qry = qry & "FROM (tblRealEstCoAgent RIGHT JOIN (tblCust RIGHT JOIN (tblClosingCoContact RIGHT JOIN (tblPolicy LEFT JOIN tblPurchaserType ON tblPolicy.PurchaserTypeID = tblPurchaserType.PurchaserTypeID) ON tblClosingCoContact.ClosingCoContactID = tblPolicy.ClosingCoContactID) ON tblCust.CustID = tblPolicy.CustID) ON tblRealEstCoAgent.RealEstCoAgentID = tblPolicy.RealEstCoAgentID) LEFT JOIN tblCoverageType ON tblPolicy.CoverageTypeID = tblCoverageType.CoverageTypeID "iSELECT tblPolicy.PolicyI K[v1 @D AS [Contract#], [CustFirstName] & ' ' & [CustLastName] AS [Cust Name], tblPurchaserType.PurchaserType AS [Purchaser Type], tblPolicy.PropertyState AS [Prop St], tblPolicy.PropertyZip AS [Prop Zip], tblRealEstCoAgent.AgentName AS [Seller Agent], tblClosingCoContact.ClosingContactName AS [Closing Contact], tblCoverageType.CoverageType 'T TFROM tblRealEstCoAgent RIGHT JOIN (tblCust RIGHT JOIN (tblClosingCoContact RIGHT JOIN ((tblPolicy LEFT JOIN tblPurchaserType ON tblPolicy.PurchaserTypeID = tblPurchaserType.PurchaserTypeID) LEFT JOIN tblCoverageType ON tblPolicy.CoverageTypeID = tblCoverageType.CoverageTypeID) ON tblClosingCoContact.ClosingCoContactID = tblPolicy.ClosingCoContactID) ON tblCust.CustID = tblPolicy.CustID) ON tblRealEstCoAgent.RealEstCoAgentID = tblPolicy.RealEstCoAgentSellerID 'T'Don't add where clause againStop#Continue to create the WHERE clause "$$ TWHERE$'T-,these fuction will add a WHERE or AND to qrySoundX1.Word = Me!Name T(tblCust.FirstNameMetaphone=' $' 'T TOR tblCust.LastNameMetaphone=' $') 'T,k` "$$ TWHERE$'T-,these fuction will add a WHERE or AND to qry TtblPolicy.PolicyID= " 'Tk "$$  TWHERE$'T-,these fuction will add a WHERE or AND to qry.$ TtblPolicy.CoverageTypeID= " 'Tk$Define how your query will be sorted,  TORDER BY tblPolicy.PolicyID'T TWHERE'd T TWHERE TORDER TWHERE  $'k( T'\z H ! GetSQLStringA@Fzi] 8Get SQL String$\'TA@: T  <%^.P P!d P!b0!if no records found in your queryPolicy not found! "(d'we found at least 1 record in our queryFound P!$  Policy(s) "(k PB@B|xp H !RequeryListBoxLableA@F|8o0(Attribute VB_Name = "Form_frmPol@icy" Bas0{C1740D90-1233-419E-AF54-7EC532654034} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$ Option CompA Te\xt ;i  Pub WhereClauAs Sng, Printin@gCert B@ooleanFirstTimeActivX, vListB@oxCoun!Long Const mDEBUG[8!Sub cmdDelete_C(k()@ 'PurL: Cs the curre@s@ ctJrecorPd inl@ box?n Error GoTo_ If IsNu@ll(lstC)P The= Msg4 "You m_  an item from "AbOKOnly + vPbInfah, APP_TITLEA Exit @?AEnd"G$A@%NotE&Me!'Dim RHespWe% Y.("CO 6@ '" & .Column(1")"'?0Qu es”0OKCancel/gAG)v=N SetDB% gDB.Exec"DELETE * FROM tblD'WHEREDID=m!;dbFailOn?< a:Q.RequeryeDWLakC%24d3)6, LVAJ:!er(rptaO,P, (Me.!), " aBn lWEditgcO[/uNB~@2YY iAY i`d&agOpenrgs "Fp_Add` 7&H "| # X#mA#VfR†set, qry!Svʗ, msgE E v@ע!e! = GetS ""JL= *; QJf ט! = R 3If1 upd "+ 1&Q2MoveA! Loopdo @zi/({" ##0pCp +#@D@# DoCmd.S$Object ,Q" ClpD'/8$(Rp) have been`n