Standard Jet DBnb` Ugr@?~1y0̝cßFNa7`ޜ(.,`i{6߱JnC53 y[/|*|I"pmyf_Љ$g'DeFx -bT4.0dv@ Y(0 S (( Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeni     YYIdParentIdName        OYzt t t S'Y Y Y  Y 2 ACMFInheritableObjectIdSID YObjectId Y0 SY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -Y0 SY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship         YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  @@c @@  @ @ @ MWQM\kv`SY^QkMWQM\muxYfMd`fJiQ`OQMd`fJiQkv`QufdimJ^^Y`fdimJ^^OLSY`fdimJ^^u^kY`fdimmum[dYbJ^^YbmddbQkMWQ`J^Yb\mQkmmuOLSOJomdQuQM`dOo^Q8JomdQuQMOQ^QmQJ^^Md`fJMmQufdimJ^^hoQiYQkmdMkq QufdimJ^^mJL^QkmdMkq!iQMdqQiOQ^QmQOmJL^Q"iobkh^SY^Q#OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk`kvkJMMQkkdL[QMmk$`kvkJMMQkku`^%`kvkJMQk`kvkY`QuMd^o`bk&`kvkY`QukfQMk'`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO  @ @ @ @ @           !"#$%&'  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP      !"#$%&'(  !"#    (d _ Z g  J  _4hQNn U_ Տ@ Տ@MSysIMEXSpecs<<<<<<<<<<:  Տ@ Տ@MSysIMEXColumns@@@@@@@@@@> r@r@MSysAccessXML4MR2KeepLocal  T|||<<<<<<<: @ :G@[m:G@MSysAccessObjectsDDDDDDDDDDB ~D@~D@RunSQLFile66666666664 A@A@RecoverDeletedTableHHHHHHHHHHF <@<@Export all Tables to CSVRRRRRRRRRRP XNK<@XNK<@Export all Queries to CSVTTTTTTTTTTR ]F@]F@Delete All & CompactJJJJJJJJJJH c"<@c"<@AutoExec22222222220 n"@n"@Module10000000000. ǔ<@ǔ<@dAutoExec44444444442 }VC@}VC@Test TX DBF~@ DDD88888886 @"@"@Schema & Link~@ HHH<<<<<<<: @IO&@IO&@Join All into One~@ PPPDDDDDDDB @϶n@϶n@Import TXT~@ BBB66666664 @x- #@x- #@Import all XLS~@JJJ>>>>>>>< @+0@+0@Import all DBF~@JJJ>>>>>>>< @ <ȶA@<ȶA@ExportAll~@@@@44444442 @ C72<@C72<@CompareSym~@BBB66666664 @ 3ı;@3ı;@CompareMDE~@BBB66666664 @ ˚PD@˚PD@Check TX ZIP~@FFF:::::::8 @ B%@B%@Check SYM files~@LLL@@@@@@@> @ G@G@UserDefinedA@DDD88888886 @ G@p_X@SummaryInfo4MR20 Title AuthorCompanyxxx88888886 @ [o@"G @@MSysRelationshipsDDDDDDDDDDB @@MSysQueries88888888886 @@MSysACEs22222222220 @@MSysObjects88888888886 @K b<@MSysDb@:::......., @@@Relationships<<<<<<<<<<: @@Databases44444444442 @@Tables..........,  Y NY Y DataID ҉YAOIndexv1K[D 8DM03DTw ctLLS@LL0   0 p                                                                                                                                                                                                                                                           0  p P  Module1)[x p MSysAccountsin( ^3˩(Zx p      N   Y  Y Y Y p  Ym( PNPRPR  l  Ģ p  Ȥ K[ࡱ>  q|zA~  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}Root Entryo0A,miVBA`^$+0A,miVBAProject1/`w*+0A,miVBA`w*+PEHidirk__SRP_0 x__SRP_1" __SRP_2 N+  !#$%&'()*+,-./012345689:;<=>?@ABCDEFGHIJKMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnpqrstuvwxyz{|}~g0* pHd Access9dDb0@ = p I J<  DAO>BDAO *\G{00025E01-:0C  0046}#5.0#0#C:\Program Files\Common Microsoft Shared\w\dao360.dll# 3.6 Object Li`braryH|ADODB>D ADZDB\\C]\10-8\AA006D2EA@4}#2.1\ROGRAM FILES\COMMONSYSTEM\9\msado21.tlbWActiveX DataZs ,\stdole>stdole/h.^/2043\Y -P]2E]WINDOWS\system32\C2)OLE Automation"” @Form_Schema &/nkG$(rm_Sch@+ma &Link@ WICLKGCXXEKOAEE OSKWJ@VN@LZJ28AICLKGXXEOAErS@(WJ@O@VN ZAH@1 ,B,B2?*"B(B+BModule01G4d u^1.KYJVOZFRIBZKZDMTVEABMETEBAVKQ.KY"V)ZFR2BZ+Z@MTVU-AMTBM5V.O.KW! 2Import PTXTG@o1I`2pb3t 1 T`)TBXNTIAGDJHRGUDPENCZXKDVTJKAMUBNIGUJ`+R`2U`PUN3Z`KVJAM<0%0Lall XLSGIa4lXASFFOQVLLCBGTAFEYUCMZIDJKOUMLLF$OQ`2LC2GAE8UM`7IOU%@LLZjYCheck@ SYM fGZQF5hCBhcf @\Y  f hs$CVATNQLMXWVWTDVEIXJYFYXJREK8C`A`NL`XW W DESXY Y8JUm8wb8@(@!bRJoin A7into OneG,[fJ  KlU 8 „t gn@DXOHLWKYSNGDWDQLOZCRFC@VMLUKCUDOSL!pS@UVW`7Q`;O8CUF`:V L`9K`n04 {;"A"4goUDBFU UAF8NQDZXPNUMBMVVDLTDAUEMKYIZJMD7D XP Ua(B@ V D T@K[A E0IJD8/6odZ EypQxMDEECmTp`^rM`E$ VKLNWAKMQFQRAERJCYVYBZQ7U)1OL WjK Q0(Q!^R0)C8V0SQ'q7q/ / dQnExeTcGlduvoLx@ c JJBVp]ZHOQAUDLCDEBNHZMRORVI3J@ BB4a\Z'Dq1CBHjM O0V7 $r ^B5STymo^a_e 0Cy3MXUCUQINEBKRUDAACMGXLYKL@PM3UNUpBI@ EPK ^A CG0LK 'Yqn l ^pB@PTX ZIPGoPkk IP0 HDQBTMNPKJRDCSDDLVIRITHOxHpQ T N0O KRpC@DpL II`QHGxDPo&ƒExAyPG8W Ex`3ztO YGGGCFEIMCASRDKBHQSNFGGZEXRd3YwZG0C2[M@LAkp KpHOF5rZP-X ]$B. )]Tes! RNn @ST3 0XMPLNJXPBMFHYVp4AKJEEKPKGHUR'P %nNPMMF4!&D EK1NHNAB'a?_ ;_ 1 rU~~~~~~~~~~~~~~~a             ( Y8 H bIncFldNamesK*m         rU8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~! B;lWD;7A K[ A a 1#a  j Y9%Q*1Qaa I 1 &a Q 1'a qWRI] q eYX1 BBBEILa Q1ma I WR1BBB oa aўqq QI)1QBBB9YyQya 0ia QiIWQq1#YўR1BBB9YyIa 4 yPzx | WR1NBBBiJa U Y 1a!" 1 1A 5 >> WR1BBB/ Form_IMPORT Access9dbF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  !`J_N? #C:\program files\OFFICE11\msacc.olbAccess  ip^F=C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dllDAO m.4C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\msado21.tlbADODB 10FC:\WINDOWS\system32\stdole2.tlbstdole AT2wENB"4P}gsC&_U}MEtHv MMKӕPr'@C7?Text131?FormSC7?DetailEC7?Command0Command3Command0_ClickCommand3_Click Form_Load PF;|?J?Ph)aN?qy>`}A "Shell.Application Choose a folder c:\BrowseForFolder ItemsItemPath P;|?fĤIx8<VBE6.DLL      no  S  4Scripting.FileSystemObjectGetFolder Files .XLS SYM A1:F10000ɤs  `GXGP   k    0 PLPAd~q] 1Hŝ[zmi5G%=:8 aD*|RL2 3kCIz] Detail_Click>/CS7ӌQ"Nm靺qtT[yGd ^Text5Command4Command4_Click X A1:F60000|DO*0j6/ƽ7^LhFC7?RbtnFLRbtnTXRbtnGA lmn$:yFbͭgiMv]D+`ԒRZHC7?K[Frame14 pk:V&Cދ1H8JJ]ʶ%Option16 h^h@aVf79EF?Db`[C7?Option24Frame18Option20Option22gdKGA|O%RC(F;:f?Tmi\J% MNQRbtnFL_GotFocusRbtnGA_GotFocusRbtnTX_GotFocusR;|? bC:\Program Files\QuickQuote\Common Files\CompzipsFolderExists fC:\Program Files\QuickQuote\Common Files\TXCompZips&Nr}>_N-l1\QCJvvQA]@Ss0J9HB9EFK{CҰBAx@kRbtnFL_MouseDownRbtnGA_MouseDownRbtnTX_MouseDown Results  Year Found RTX , Year table NOT found  fC:\Program Files\QuickQuote\Common Files\gacompzipsaA_FNh:4MxYO:oyTE͢DfWF[$ksYOption2Frame0Option4Option6Command8Option2_GotFocus{ODʿ[_DP1W֨~Ds97cΚH6l_Option0h@KPU7Ws@m':Frame4tltfNI[SJoEI:TFrame18_AfterUpdate UPDATE UPDATE FLV;|?w;|? RbtnFLhWBeWggJZpdj} Option0_Click^21^@,Xw_'O-bM}Z Option2_ClickԯbׁDfDY@+"ztBp:bRGA RFL_Click RGA_Click RTX_Click4h]bMt7kyoOmF=FF Ctl__State FLj(7}Ox'milEFRFL_AfterUpdate~U@o}G)ͳ@SG @E~)C{Q@Z#?X;]WBFVd'hOJ+CEmґ7ˤO -;vxM\\.ayMwl)$Hܞ Change_T1W,K3< ~n0ޘGxAoL bC:\Program Files\QuickQuote\Common Files\CompZips fC:\Program Files\QuickQuote\Common Files\GACompZips  Procedere NExcel file contains INCORRECT structure Wrong file  Wrong file!! JTiHC+йxshmHuXl̕ L All Linked tables will be deleted  dC:\Program Files\QuickQuote\Common Files\GACompZpsQo|Iǀm7MR)aJE C?oTWKAM&Zz85mL373Mb L!}Ÿz^.JҳVN1K['R @;aTbxYearTbxVin xk@pG85 & Procedere Deletum?  Opus Operis! m.yVDFaFB$AYDGŶn}РAӔZ<':?~M4B2ޗF%xol )6@-"TWJ4} Toggle_Btn Vin = ' '1m.  Vin NOT found  ResultseJ%%BGuM]՞m@y7ߚ|SVSJ{ٕ!qCbRGۼlƚ-D ,k{@6A8Wc4dF.V^WhnfCH#@xC^֥'UC= 0 09EvCG*JP-ĜYG2Oy VIN = ' & $Similar Vin found  i V_PC'7Hc & Similar Vin found Connect $All tables deleted Start deletinggagGI'  Incorrect Data Year Found All Good4 Cgд(n 08l.Jdp/^O /[ Command44 |S+&H>ak 3HoB Del_LinksDel_Links_Click2nO'Tt2AO~PӦI=¢۝2DAEd5.6 LdFIC0BbyG嬊AC]@@bFޅ M >̅-qPlB^| C~ElhYZ ^IULI3,/Y Command45Command45_Click Pıpn-K dCE)SEҟS SELECT  AS NAME INTO  FROM   GROUP BY  INSERT INTO   ( NAME ) SELECT   AS NAME FROM d[Cu1 . AS NAME INTO SYM FROM 3OEF1' $INSERT INTOK[ SYM ( 4fLSRWMJ2MJAI]0B, ZIPz&@@vrForm_ACE TAISO.MDBt xC rӪ]?aAOos5ۮii^GqW0U7fIK-d 6CSV (Comma delimited)|*.csvo2a4CRRՙ@JC#H"OpenTextFileReadLineeЁDm> .CSVU 6A:raI:k5m?F* YGetItem A   FileExists  File not found&V2\Kmo%+ҩcvL0( ,'D,IzA&KFS?F^6GetArrayForm_~TMPCLP413391!wLGn!UANi\|Cb$\R 04Form_Compare MDEForm_Import all DBF1ߗa'0Gm4-_)N v+N?%H+[}xǔ&4En-SB7@K•~l}HuVD\㯗Frame22 Command14Text15Option18B+)BWG lGӻD]\z|RTX2RTG2RFL2ۊn8NL޻+}nLZRGA2 ou]BCBvaVNB5txText2 RFL2_Click RGA2_Click RTX2_Click "C:\QuickTX\TX.MDE "C:\QuickGA\GA.MDE "C:\QuickFL\FL.MDEZ,Mhc2'}?|Ax^`3Command14_Click MDE File|*.mdePvOa<ParentFolder# (@f}9TY6OrS,9I~FPɷLu詛 ImpTables 1 2 MSYS*)V]Bnaj|[UM/ӔY" FL.MD FloridaCompanies TX.MD TexasCompanies GA.MD GeorgiaCompanies 2Only For FL, TX or GA MDEEcho TX GA :MDE File|tx.mde;fl.mde;tx.mde FState MDE File|tx.mde;fl.mde;tx.mde3oFU*/,dz*%:DԻy (b"'JoQEu btnDeletebtnDelete_Click C:\temp\ͻ'hKQpp$P![CҳL JSELECT * INTO [text;HDR=Yes;Database= ]. .CSV FROM (,aE DѦ>0 FS XJtG#dNwہ8I%O_d_wGh h!DkбNDpE(M?X_3MGFoh\D1kzL6xNN ѣ0mZF~ü+I\!fA:6ڠEA4C l(DXN~Hfa7)uI~Q:[jI/'0Qr``I Ñ *State MDE File|??.mdeDeleteFileN{Leߠ MYO/m4hC^AX2ˍ%B70HFKLJ+^pȰGRc C$9FmKd5I fc+vH&4eT GE|mۣF+1PGit/7hÎFKԩ?NWɟ5BN O%/E؞:AbO#MUK(ѥ3M3g:,TtFxSG2ΏxRDqbȅ1n"AV.wt R¡3N/N2@9!ڡJNāe D)N ͗oGuQiq;gչZL Gp@DOF lQYCs9A9gMc=o^?|ӭD(p8-*_FajXIB+YH".hg|MX[3䳨Bk>>MNnOr Found Not FoundhAK[sEz bײAZ3Jtx2} Not Found _~C>@jmQ0̘*AJC?GB/A?t|BRKC)KLoGGHߜYkrdENRVwQ(*N1RG1yMf2oE{CGG\np0MF.e~NbdKo(YR1BL W JC:\Program Files\WinMerge\WinMere.exeD O/2^^A CH( DDefault compare utility Not Found  FDo you want to open compare utility $ Program Not found *Compare Utility|*.exe lDefault compare utility Not Found -ޅԶGG}ɋ/L"-|-'(*AwjtKA$0wjl K(j4o{I#W[* mMHwE8#LmFr/ci%OQnݐ*򙟫:F-F}K4G_{7>T%}3B{7J=DԻpg&#ch'L%zMP`;jK4­E uPvvFw Z]!yLb)Y9?GH;іfIvGI1bnq=NiHFA0nԇ7ƭ A0dZ txtCompUtil Command27 V`;MYNAIBGeCommand27_Click 0\\mainnt2\QQData\TestersMr8wNE/N\=BAH $\Texas\Beta\TX.MDE (\Florida\Beta\FL.MDE (\georgia\Beta\GA.MDE  T p% (۽@HONWq & ORDER BY CompanyIDModule2Converted Macro- Macro1Macro100 Yes2 Hello2   % Form_StartUpfU$:HKb%J9rUI@JK#=ZZhK&^TO< HS*[ DConverted Macro- Macro24r IY>bjG.4`R2nA=\}_DCϿ^Z8BwNiϟ-sy>`}A-Eئ@)ݘGd}4v\{J0-رnB߫@R.F`MǕV sO+?9K LN_0tg tI *(L-3A$Ya+)FלGEM+6I:,YE(+l I?N>ecERLSc^̅BJZ"R I>+~ţ:A$@WF@ghyPqLm?t1u frmName cboCategory| Compare MDE Hello Worlda;X,GiبX>WFl OpenCompare Args Detected No Args detectedStartUpCheckCommandLine   AutoExec dAutoExecD23Jzo5b r@?4'@Cu%;^ J q)j~ AkqYH6\yGv1/&ILQ9m.!}ZѣxBt>eRl2m@h1(B<@YVSVH9<I7{s{wH[:X#roOfLEfx|K[L5Irﲅ-XmBM)"zG~;iQ]8qA!Z3AV?EH^:0lt?uRM7$H C: hG:^C | zGuIg/<Nx|'AM쾵^)fJ[ÜI.VˠfF> czNWUBFKVIJi@O)H J#CZKSe`%٧a>pK; :jM9vl<9@?M2w<^FFg`'z LR],t?OafA ]h>VJ9LFxOkRkqFIk+JR0jG5Mq-y͸.G,O8fDGu ( ^%!YE%a ـ'Ho3&Form_CompareMDEn2M^CDQmQ'Mf5Eu&nЩ}>ϭI&.HݙȞ@ÁBڇ{.H%y   h+ 03FwBLLMӦ1Y O]Dq>X+ΌLΣtw| 䴋DϟNyIp&k 8HC~$--@ȧ 1*K휈 Del_Tables=qhNijȂ'8={M%@n .Insuficient parameteres CompareMDE Errorh&cDcIً?HҿߣIi dStringѰaG#Z:g.Iâ' Text1_Change Text2_Changea7Kn?NjŽ{p{/uL)h 9Text1_KeyPressText2_KeyPressԖ OW !q+*LSNΧ-!_Ļ,Dߝd=D@AAϗO7o%4x*Dg3~2/eMBRn#A6]B TaO^9hh'#L޶6`J[JJ¨ACuKNS1seHdForm_CompareSym_[C7=.RA LKʌ@fe%zOX A֙^9 02(gEF_i6CO8")m;JmF8@Frame12`}"SDUQ=4k@vݹK@ApnqMRdmBZPMaFOr-~%J R§uhB hbABTh:$6*\@|NKXDxLۢy 5g0@U\ |7BO疜v4A!Fg6.dCnAl"#@ 1Y]ځH%aT*ۑ$}O΢eq|\K}H0}q:vGG]gNJfY <Q;O`M*&BG 9" 8"˓~NN6qzJremrؾ[C 5O <$qt@L6$ft WOE^9g!C -8  ;jGg]qAq)m  Symbol1 Symbol2LMA: 1.CSV̩}9O0XtW ,E6bXԉ  *E*=_W|`G6}EqT 8 TablesToCSVz8"@N -ȁ0lK<?Z|LP@XM͠EFE? l9L2O&%Ev/a7NL']R 7=u[AHB- uwz>?-Mzx%_ݞ G#a؉ys`KT`8C4=ka6IULny{$,Y{@G,Neer:B>f`$MOjHFwR1a7wOba"7nA?l:Y\Ny@;ACP"XHqR>aJ.Xv"|uq)%H<.#z3ZWs3GB &:k|p(pbmH7\z1V4]k9M~]7b[BA&G5+6N" GX ǻ*i@!=ѵJPHh.b ZĨ%O_Lجl^cäN]QC5C+&yb,9B꠮};WOv(j:$@UO\ QueriesToCSV]HcUWQiLm!u뫸 yLF6n{w, jJ ?"j9veL03 ;J[H(9/N" KIL39V 5y)zqB[ŐW' CA-H0]g~Lٝs?d5SL4ASdh \MZ)0̺FTqB0F TxtOutputwߨeLz*[-mHHwE9Q4LpShowText TxtOutput Testn-AgKCY ix$.I Q S DoHide-ǸLVJ LL @lދym-vN-<~doHide Deleting table *Deleting dBase table |!B2} ello Form_~Test FRuning MAKE-TABLE QUERY with table  >Runing APPEND QUERY with table  Hello worldUbIhj+z Hello (Processing Folder 1 (Processing Folder 2  ~ Linking table ,MAKE-TABLE Query INTO $APPEND Query INTO b!qB4N7"AI>0!^O#G ɤm9!D¥03 Email Email2 Free NEW RENEWAL VERSION STATUS Programmer QualityControl InfoReceived "ReadyForTestingBy Distribution WhatsGoingOn BridgeContact[/HE IT9VqʛWME,l>g $BridgeContactPhone BridgeEmail *BridgeConfidentiality BridgeNotes7k`FZ DiK F! -O t+:|Y bKL3vZG@Vuq,GRI_Y5W#=QM%ύa:0AC + O?3SxM2+65+iB}bL=\A-!O6DekcFs{)qۡDdp~41*@>W+nC)*A'cOCp\IXud@_zsr+ӜYlN#m6l+@8%82 EMAIL EMAIL2 FREE PROGRAMMER QUALITYCONTROL INFORECEIVED "READYFORTESTINGBY DISTRIB K[UTION WHATSGOINGON BRIDGECONTACT $BRIDGECONTACTPHONE BRIDGEEMAIL *BRIDGECONFIDENTIALITY Form_test BRIDGENOTES  Y HB : INTO [text;HDR=Yes;Database= "C:\Temp\debug.ini4(mA x@;y27I<)d$@jFn)HUm)BE(It^ ], an}dI)Y#=D(yGkC]2^BW FloridaFinance TexasFinance GeorgiaFinance Companies 4ZMmeK'Ntnk}gpĹJEa?p "%Fb(y$bNGrQMg/6xtt@3xTJ%AܢeEWZIz/P9NDC5nAY )t6jH|pJy weHmHiE3D2I9NjJXSkWU!F,H[];B_Mi aWNP.BW([G@֏naX MWKJP,7y+)^BG &nqId`*OfKqtf5N2imXwK%Pq.0Dlmv[& AppendFiles Finance 3ReadAllAtEndOfStreamLineWriteBlankLines<*fNUJ.UƹLnᯛf&OJ;MֿC5sOwTV@`z1Wk=K$X47Dfhx3 C]L6a<V@L]O0IopWIa D2M(G"lB`I备ʹFkJj wepGd|Hm3G$n\AQA̞~FXf3tPLpHQFE8 a]JflchH6X:}?ֱJTCуi#$fGJ5Q+<;M a+BG3CQ` C@Ko.,ZpI:KG4W Yl'oB$>[}EN *EoRR;icS'HCacɎɈKA/>\AKAZ3dX'hIW-LpHR {E4^%NS CX iWЗJSk{ lIN. c.CֆDF"taQMbâ?F(O=R$@ EK-NJ2M>߅KC7?List0List29?W6Goa]]]gNJMZٹTLC7?CmbTable\;|?OLK96hpN_rsJV6'c3List1$!@A_00N|(|rudoInitS@aHwSQ95MG%CmbTable_ChangeZ;|?^Eu7/j@B>Command6 TP^(-FΣb^_ekWK2HCommand7Command9(RTGbU}޼k_/N .BM) BtnToRight BtnAllRight BtnToLeft BtnAllLeftBtnAllLeft_ClickBtnAllRight_ClickBtnToLeft_ClickBtnToRight_Click8NA3VCf, C/: List1_KeyPressList2_KeyPressIL'n!1_lDd SIC7G<4)cOM@M8[OllxP7' vG7EDYKfMM/ An]IۅළLabel10 dN>T]BYm=ǫ\$* MBIhLabel111T_A0%;=9(M[ և+68) 6N8&2,E}a_~M M#w  iK ExportAll moreArg HOM2 UNIOtLWb˩+lDro*mB_nYEjG}[-qfkGϩ& 6tMxHYiS(J:9~o BtnExportBtnExport_ClickLNgW6j5NjsZH]{D K[c>$ 1H/QljMuqAnHL;eωcrG.ILK6 PLjܢht2OȵJm٣T<4{~."Jo'핷ZAQ0' } ,@%;r7)%D^a0ds*lNP ÷6#I9PysJA++8 !}lFPR4ͻ 00? H-EC1\CtvQb?BhdR05\:H/HHy ", ""$J@7\PfcNCE{FFM@+B14RFYd ], [ġRKۻj19/ *GHí15g.J@Ĵj'9po;8!iC@9J{?~GC7?Check14 ֯s@\{LYebBG^˯aF~iH:7>Б,}I$L9^ ChkdoExport5ZG3FwJ˽K҇]Ih8N&;K6h!~SfIg~ 2Opening Export Wizard... i-L=o [b;[IqE!"=aKCހӒ[sFki `!KF9U2[{tF_M 8W0!XN_ VEa@&Vwv^)Lk:rPJ0G4nCb Q޸1^LkIRS\|r~b OU^n$LZnk;A17~6\:^Q7I_.Ci CompareSym.lG.]m3eaMIkqJoF G ^!VAzU%iDMIqoz*sK~SPe#Ise |y.G+,0$2иNcN>\= MUf@o~qL?MaPUV\2Jܗ Command15Command15_Click tRkDO;Dq) E*nbtnGoUP btnGoDOWN btnGoUP_ClickbtnGoDOWN_Click?8C#毖0G4Nа@qcK%Ar[EHJpk ^ NAME 8Right([NAME],2) AS [YEAR], [cҔId ɷjZ5EHNJ/bMD)Z l GROUP BY Right([NAME],2), ORDER BY Right([NAME],2), [ 6 ORDER BY Right([NAME],2), OZKJ'O`t Ny")Form_~TMPCLP136631RecoverDeletedTable ~tmp (SELECT DISTINCTROW [ ].* INTO   FROM [ ];pZ^@ L?ELG[_m#YF#$ai\PDz fA deleted table has been restored, using the name ' Restored 6No recoverable tables foundS9cDnZ/0FưMÏ=])3bn^I$kkqOʆ_@l}h/  HAVING (([ ] )<> )ҎdmC@\\dFLvR9]{MuNjAÍM- ])<>Form_Test TX DBF 0AIM 5QFHe?: XrgIй@Rb$VSDźBXEQUds%L:g+yN9ۖk9T@KݎHc3;SKG,ISv^|Lbf9@EBot{wm \GQZMv/1NPI|%[PT-LS%DQ%v{lOn%h@}z\پB]I fDX9Dwϗj~H7~>Gdp\$H3D &C:\Quick95\COMPZIPS ZIPCODE CITY COUNTY INT2SizeType issues.txt ,DBF files with issues  :Name Si K[ze Type Field     ZIPCODE CITY  COUNTY c:\issues.txt  ZIPCODE  CITY  COUNTYMD 'ZɇIitUj  _ V  ZIPCODE  CITY  COUNTY >------------------------------- RunSQLFile SQL File|*.SQL jSELECT * FROM [text;HDR=Yes;Database=C:\temp\].T1.CSV 0Del C:\Quick95\COMPZIPS\ܨF2!mS&ELk+ 99 lSELECT * FROM [text;HDR=Yes;Database=C:\temp\].T1.CSV;ims&d^O`W@-JC'3]8FrM=*Check4w B9Ms$A~Ƙ *K [{Q chkDoBatchCheck6 _L2PŗVJ$؞@\f.6chkDoSQLchkDoBatch_ClickchkDoSQL_Click\Ci#T5 issues.bat ALL.SQLT;|?KlGȓJʡ[u 98 >SELECT ZIPCODE, CITY, COUNTY, " " AS NAME FROM " (C:\Quick95\COMPZIPS\ WHERE CITY <>  OR COUNTY <>  UNION 4 **** Correct Sample **** >AGN2 5 10 ZIPCODE 8AGN2 23 10 CITYyBFK4m_!|KJF l_ <AGN2 14 10 COUNTY notepad Us[$LR90꩗4 D2t=RuZhJ‘#KOgLdOHTJ/F5F'WfeHo Mw BbgGF'S *Hх>bMKj#ʕF`ИAQ;!쒿JA D؋VBQveW@&P-_6 )iM( NbLI:MOpfQ>A ;<O MrjxgM ${4 ALL1.SQL "SELECT CITY FROM  GROUP BY CITY; &SELECT COUNTY FROM " GROUP BY COUNTY;EEuq2Form_Check TX ZIPForm_Test TX DBF1YgX;C #p'~O~d乘PJwJ=OkjCܢ<"UHF#}I%gѥ#mH aZS0WMf CDД/\'tA˂;ENW{6I}rZ31 JnFB}%`c3I(g/ k*>E:k\nqjAG>|FPMFț HA04Ny$+vrA/List10zKphxQD.:TextLogListFiles_Click .Incorrect ZIPCODE field (Incorrect CITY field ,Incorrect COUNTY field=VyJ._)HDLDchkDoAllchkDoAll_Click ( Wrong ZIPCODE field " Wrong CITY field & Wrong COUNTY field Wrong ZIP field All Good!  All Good! " Incorrect fields ( Incorrect structure 0 - Incorrect structure -QO]Kxh%H W .- Incorrect structure -pr GRDO:8ZI1|H%YϹ=CAigclj懇OOC) UPDATE   SET CITY =  , COUNTY =  P WHERE (ZIPCOD K[E In (SELECT ZIPCODE FROM  \ GROUP BY ZIPCODE HAVING (Count(ZIPCODE)=1)));rHN1lG 6pĚbÉ@vw7+h DPgMJÉ)J B&f'{@]x Zx\@H ~K+K<$FC6LIa_wCw*CY/rbmeISW#yLUARIֆJ*pT Fu畜hc RxPOC B(ZIPCODE In (SELECT ZIPCODE FROM  Duplicates FRemove City & County on NON splits?  WHERE  @ZIPCODE In (SELECT ZIPCODE FROM &%Cl- O% X GROUP BY ZIPCODE HAVING (Count(ZIPCODE)=1))  WHERE ( ); *(SELECT ZIPCODE FROM & WHERE (ZIPCODE In (SELECT ZIPCODE FROM  V GROUP BY ZIPCODE HAVING (Count(ZIPCODE)=1) ( WHERE (ZIPCODE In ( )); " GROUP BY ZIPCODE HSELECT ZIPCODE, Count(ZIPCODE) FROM  lSELECT ZIPCODE, Count(ZIPCODE) AS CountOfZIPCODE FROM $ GROUP BY ZIPCODE  > WHERE (CountOfZIPCODE = 1 In ( L WHERE EXISTS (CountOfZIPCODE = 1 In ( V GROUP BY ZIPCODE HAVING Count(ZIPCODE) = 1 Z GROUP BY ZIPCODE HAVING (COUNT(ZIPCODE) = 1) ^ GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = 1)) <SELECT ZIPCODE INTO TEMP FROM  TEMP $SELECT * FROM TEMP 0SELECT ZIPCODE FROM TEMP%/X`JXq67 $ GROUP BY ZIPCODE;yLh>7IQeX8+BNtK b GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = 1)); TSELECT ZIPCODE FROM TEMP GROUP BY ZIPCODE; JRemove City & County from NON splits? Issuesu׍L]"' ( INNER JOIN TEMP ON  F.ZIPCODE = TEMP.ZIPCODE SET CITY = !TFWKy6F.pD 8.ZIPCODE = TEMP.ZIPCODE SET  CITY = qmC6BLmt .CITY =  .COUNTY = -fxZ$TDt8t SET   =  6 SET CITY = '', COUNTY = '' \ SET CITY = '', COUNTY = '' WHERE ZIPCODE <>'' .CITY = '' .COUNTY = '' "UPDATE Employees  ^SET Employees.Title = 'Regional Sales Manager'  NWHERE Employees.Title = 'Sales Manager' 2SET Employees.Title = '' SET Title = '' SET Title = '1'  4SET Title = '', name = ''  UPDATE AIP2  SET CITY = ''p:AǍOa"+ AIP2 LUPDATE AIP2 SET CITY = '', COUNTY = '' d_Baseq^EOJb+]( ?Z`sNQc'0LbN`5> DXDK4`@*EJ2nhEĨTN*am4_dMOHN<~ZFHNOO߹@YbMJv\uCL TڊY?UAoQw)kOK[Y75N6?XKՂPGןGMC7V:N~ι9ԤDDZ"¯vc8Iu%X-5|FeյJ"3Kߪ4j;IN*V)^;YC ү0…nC* CheckStructzIg:N͑?GLUK[nvBzJ)v@)Rh,KI$ A(usJ ؊ckuѭDpNR1iF^J^X}TJYppeͷMY4Br꒜DtLJp\#Fdy҃VJ`TFwa~e setMessagesiBfI&*_ mLD10XOMavremoveNonSplitl~ԕqDNLR9"z@ f3os"L"08t:8dN˵ӛRemoveNonSplit ,CITY = '', COUNTY = '' 2SELECT CITY, COUNTY FROM  \.ZIPCODE = TEMP.ZIPCODE GROUP BY CITY, COUNTY; n GROUP BY ZIPCODE, COUNTY HAVING ((COUNT(ZIPCODE) = 1)) ` GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = 1));i# JMø>=sO;  p GROUP BY ZIPCODE, COUNTY HAVING ((COUNT(ZIPCODE) = 1));7BvhA|o 8Remove City from NON splits? >SELECT ZIPCODE INTO TEMP1 FROM  L.ZIPCODE = TEMP.ZIPCODE GROUP BY CITY; CITY = '' d.ZIPCODE = TEMP.ZIPCODE SET CITY = '', COUNTY = '' J.ZIPCODE = TEMP.ZIPCODE SET CITY = '' 4 GROUP BY ZIPCODE, COUNTY;+ SELECT ZIPCODE INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = 1));!5J^A LSELECT ZIPCODE, COUNTY INTO TEMP FROM  GetSpecialFolderCopyFile V f.ZIPCODE = TEMP.ZIPCODE SET CITY = '', COUNTY = '';! |SELECT ZIPCODE, COUNTY,ZIPCODE + COUNTY + TERR INTO TEMP FROM * INNER JOIN TEMP ON ( <.ZIPCODE = TEMP.ZIPCODE) AND ( J.COUNTY = TEMP.COUNTY) SET CITY = '';+ćNgONXlNj[ 97$ SELECT ZIPCODE, COUNTY,ZIPCODE + COUNTY + TERR AS ALL INTO TEMP FROM $ SELECT ZIPCODE, COUNTY,ZIPCODE & COUNTY & TERR AS ALL INTO TEMP FROM  @ GROUP BY ZIPCODE, COUNTY, TERR;" ~SELECT ZIPCODE, COUNTY,ZIPCODE + COUNTY AS TOT INTO TEMP1 FROM 3 SELECT ZIPCODE, COUNTY INTO TEMP FROM TEMP1 GROUP BY TOT, ZIPCODE, COUNTY HAVING ((Count(TOT))=1); J.COUNTY = TEMP.COUNTY) GROUP BY CITY; JSELECT ZIPCODE, TERR INTO TEMP1 FROM  0 GROUP BY ZIPCODE,TERR); C:\Quick95\ TEMP2.dbf T. SELECT ZIPCODE, TERR INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = 1));. SELECT ZIPCODE, TERR INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING ((COUNT(ZIPCODE) = K[1); . GROUP BY ZIPCODE,TERR;{ >(@$G+7< sAA@8M` hello TEMP2- SELECT ZIPCODE, TERR INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING (COUNT(ZIPCODE) = 1);* SELECT ZIPCODE INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING (COUNT(ZIPCODE) = 1); dSELECT ZIPCODE, CITY, COUNTY, TERR INTO TEMP FROM uF.ИF9M kBd/W L GROUP BY ZIPCODE, CITY, COUNTY, TERR; J GROUP BY ZIPCODE, CITY, COUNTY, TERR L ORDER BY ZIPCODE, COUNTY, CITY, TERR; ` ZIPCODE, CITY, COUNTY, TERR INTO TEMP FROM TEMP DELETE * FROM  4 SELECT TEMP.* FROM TEMP;NRshDkjbழA?L fSELECT ZIPCODE, CITY, COUNTY, TERR INTO TEMP2 FROM  TEMPx bTEMPxM `@j/z xTEMP2 hSELECT ZIPCODE, CITY, COUNTY, TERR INTO xTEMP2 FROM 0 INSERT INTO xTEMP2 (ZIPCODE, CITY, COUNTY, TERR) VALUES (ZIPCODE, CITY, COUNTY, TERR) FROM  bINSERT INTO xTEMP2 (ZIPCODE, CITY, COUNTY, TERR)  .ZIPCODE,  .CITY,  .COUNTY,  .TERR FROM   ORDER BY  .TERR `INSERT INTO TEMP2 (ZIPCODE, CITY, COUNTY, TERR)  vG{[A$,H6B)+O TERRVOLs($fɖ{pHԕ O[DC\A)~voE4wufO?3q- YeartoCode 80 81 B 82 C 83 D 84 E 85 F 86 G 87 H 88 J 89 K 90 L 91 M 92 N 93 P 94 R 95 S 96χ;NKF* <hO.qvFUl=ȅI UsBFswbJ[PCK? ɦ&TJX*GQa jDLW DzĽC UVOBdE s5!Lc¥DY_\Bi  ց$5M)Fyr7mI96Ub5H6d L?QDI&I)v@ ?}?wS 4L 7%OL!fp9LBK':f*GGDv=~`Ta6@5'd<k5LDR4nYdتIrcB\LH($>ڍE|rX:t{.GBsOA1$zsPath sSectionName sTblQryName 14X 5h Q6xButtonShiftXY StrFolderStrFiledFolder strFolderstrItemstrSepaOnlySym strTable1 strTable2dString dCompUtildFile1dFile2KeyAscii doSetFocusdName CSVfldPathdStrShowOutshowHidedoOutputdoComp !dTable   1    Y strLinechrSepastrFileupListstrTabledTableOkhasCityokStructTerrSize myFileNamestrYearrU jVrU $`n*aقa-1y qy 9y  i ! A a .]pIryrrri9sss tq-ɐA Qi1 Y ) 0a-uYvq A0 0 FFI9AY1@414Q~@814!~@ <Yvvv@@14~Q@DaK[@ H5IC@La!@:P@TAppp@ XYrrr@\attt@ `5@ dYI@h@l&@p14/xxxQ@t14;|||@x14BWWW__pI *FXhx! x hH%D! D )xD6XhHx! x x  @8p$ xDhXH.-TX$ X DQT[P\XrLs\=<\=<, , : ]> : ]>'6 <, (: \A<,`Ǩ8/6<,-\A<%X$ `X X5< \sL1/ 4lPL\8 XT<,$.-TX$ X DQT[P\XrL0\A,:<( ]u6,(:<\A,`8/6,-\A,%X$ `X X5, \sL1/ 4lPL\$XT,P.K)X  X4h5XXT! T XD D:4]>$ !   :]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT Tch/T! T (T / P,lh4 T XD$Lh+z<5h$ h`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% f@% f@% cTD6T<''' PP ,>FT !P6T `0ldh$PT`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% 8f@% Pf@% K[cTD6T<''' PP ,>FT !P6T `0ldh$PT$p& :l- $  DQ [8r!08A:(]u68A\:" "\" "L6k&? '%'%%\$  Q / #Q[(rN&l(A:$l6 (s c=#s:%lL:& :'t\d:T(Dl4L$:)`1H6tdD4$7:* :'\`Ǭ8/6:+ :,l:-ltLd:T.D\4:($lL:)`1H6tdD4$7:/ :'\`Ǭ8/6 f%$ ` &'%lHF%$ ` p& 8sA$P8 \8lL(HH tdD4$H0T  TlN 4:D]A"T "T D$" ":41" "" ":1t"d "dTD4"$ "$%l26 T$tdT4$c'':D3N44*FT D$:4::5^!pf6T$kf6T  T4h5T:D7%h8(D%h9 h:hWT;:D]A5T"T "ThW$;" ":D1" "4" "t:1d"T "T4$" "%l26"T$tdT4$chcl,lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD:X<]A5D X%lC=5X lsTj  h h hh h 0h  @X,TlhD4`Kt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@  +\d+<5d@>*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :T?NddT5d d@5d@@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TANddT5d d@5dt! Qtod5dBC8/>:0?%'%'%:TC%t$ `t `t+:TD%t$ `t ,t +\t! t (tcx@cdD6d@<'' '@ tt ,>Fd !t6d@ t! t (t `(x,tPd@ D.pf  TN TBEDN,D=FA G"h 6 DA F4@5 t7@M @ H   :I]46  @W  `1,6 &l,Jl,K? (,M@ :L]45H@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%$ ` 6 kfpf0kflhH@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%K[$ ` 6 kfpf0kflh @ukfh lhM l/DP6 l0,@DTh, tfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$ \Ldfl% 8fl% Pcl% :lP%h h hHfXD6XH4d$ hXHdfl% 8cl% Pfl% :lQ%h h hHfXD6XH4d$ hXHdcl% 8fl% Pfl% :lR%h h hHfXD6XH4d$ hXHdfl% fl% cl% :lS%h h hHfXD6XH4d$ hXHdfl% cl% fl% :lT%h h hHfXD6XH4d$ hXHdcl% fl% fl% :lU%h h hHfXD6XH4d$ hXHTLf\D6\L0$ \LTLf\D6\L0$ \LdX  <  P pxt4@8\L77__SRP_32__SRP_4 0__SRP_53__SRP_6*rU~|  !)A0qy A *4 4$(]u544 4$ $\54\:4UpV54 kVG\4kVD$kV\  `1X64kVD4\$ $ \64$CX\:]A-$   Q[Dr%D=4 $ $\464$KDA4 lXF%'%'%4$ ` ` 54 Ds1<$l\XD(4$k`t $ `x $I`| $` $`$$ `$gk@8a!Q@<14~Q@@14/xxxQ@D14;|||@HatttK[@LAppp@ PYrrrI@T14B@Xa@:\@ `5I@ d5IC@ hY@ lYQ @ pYvvv @ tYy}@ x5a}@|14Q~@14!~WWW___K  !  ( 4M  @  4 5[!  :]>!  :]>')6Oc!   !   ')64 X5n!   !   `)6  :h :(/ $  D Q[xZBx 8>F   :]A6K+x 8lp/kqx8>1$x 8l*Fh/&:h% 6:h% 5$*F% 6*F% 5kil$*#*#*#*Fh:x 8>F:|826 J*#*Fh:x 8>F8/6 f% $ `  #'%8 $ `  kIX:]4< hXG hH xC@/4! ,  6 ! , (:% 5 :():H:X(D6!  (Jch6ech6$*F% 6*F% 5c <'''  , >F !6!  ( gL4 (hX$Hx 8< |b-4:$"l4:#l4:$l4:%l4:&l4:'l4:(l4:)l4:*l4:+ l4:, l4:t- l4:d. l4:T/ l4:D0l4:41l4:$2l4:3l44 44Z6 Y85FH 8'%'%$%l $  Qt/ :$Tt 45kt 5Q[drzp>!d=6 `1@6l8Dv 4l@F$]D4%p>4 Dw k>m1T:$7K[dA6:8T6 dsT($]u3T($T 9T5 T1x/ T: xtd@85hTD%!24H, (,  lN-l @l>:A;H5'H=6 < 85#8 < :]45%HA6:(5((]uRH=6(( 9:=t8d86t' F8%lB6*HA>%(%lB?4X6 (XW@5( XA XB u(d) F8%(T%lB?\N5*HA>%(%lB?4X6%XC:=%XD\AE%XD5 XB \BcXc\ HTcl8P8 H(l\8X$tdpFT  TlN 4:D]A"T GT D$" G:4H" G" G:Ht"d GdTD4"$ G$%lI6 T$tdT4$c'':DJN4KL*FT D$:4L:L:M^!pf6T$kfNT  T4h5T:DO%hP(D%hQ hRhWTS:D]A5T$hWTS% , 5T"T GThW$S" G:DH" G4" Gt:Hd"T GT4$" G%lI6"T$tdT4$chcl,lhTT$tdT4$H lX5l$ l`KNh  h4x5h:XT%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% 8fX% PfX% 8fhh6h8<'' '80 44 , >0Fh !46h8  |(x$04h8 hKNh  h4x5h:XU%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% fX% fX% 8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8 @KNh  h4x5h:XO%xP(X%xQ xRxWhS:X]A5h$xWhS%4 ,4 45h8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8  .-TX $ X D QT[P\XrL?\=<6<,  , : ]A6<,-\A<6%X $ ` X X5< \sL1/ 4lPL\$XT<,<.(<l M\@, 9,  6<, :\V]4q_ :\Wll :\Xl :\Y]4 :\Zl :\[l :\\]4 :\]l :\^l :\l/p,l <,D.3l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , ,6H03l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%,K[ $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P  5P;ld.@M0@P d-P  5P;ld.@M0@P d-P , 5PQ:0% , f0% 8f0% Pf0% f0% f0% f0% kb 4<$   l   $ `  p 4:0% ,  SlH4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'rU XeQA a-*y q ) K[0a-A0a 0 Qy))11IUIOAK a )^ L1LaY`]]`]aqb-c <U!JH HIJ3 8I  i ! A   F 9FI99,a@ 4YrrrI@ 8Yxxx @<azzz@@attt@D|||@H1~~~@LAppp@PaT@TaT@ XYdI@ \Yq @:`@ dYvvv@h14/@l14; @p14B@ t5ICWWWW.-TX$ X DQT[P\XrL0\A,:<( ]u6,-\A,%X$ `X X5, \sL1/ P4lPL\ XT,h.pf, ,TN(! $ ( (3$(! $ (  >$F,%TB DN(5,,D=, A"h 6,DA 4@5t7@M @,  , :]46,J@W@W,( `1<6,^DA,@W'%'%l= :P]1@(0%(%d>= :]1'6 ! $  !   (K[D'@':N4 !*#"*F^#i`P/6@P]4 $5$6 Yx5$ (0'(%0 @d>A5&:%]1:&]1X0"t 0"lt0(0'(%0 @d>A5':`&%(%0 @d>C5!(%0 @d>'C(5p.3.@(%d>A:`%]46 f'.@(%d>A 5+.@(%d>A`16 !   lF%!    $ @    lxv     45 c ΐ w  C?'p%'%%$  Q/!M@ ) `15"*l*#+*# ,2 \,kNM@ ) :-Mp@  @`16@"*l*#+*# ,2 \,kD(:p.%.@0 @d>C5(:p/%.@0 @d>C53lF`%.@0(%d>C6>p(p@0(h` {@"lt.\ , 00-\ D1K#.@@ @d>AK#?2)6(:p2%.@0 @d>C5@"lt:3@"lt.\ , 00-\ D1%.@0(@%d>C)6 @p  @~`k<(:p4%.@0 @d>C5m(:p5%.@0 @d>C5 k.p.3'@':6N0:7N #6@$!   ( 3'@':8N:9N #6@d=:;5 d< 4t\p`@P`t0d xD\@H l$5l $ ld@''$:TNDD4 !*#t"*Fd^#pz/t6dD$kz^ d$5d xd$ tdD$8'@$ `H HlNB<@D! D @ H=>Df,%D! x D >Df,%D! ` D >D6<@D! D @ H=>fD%! x  >fD%! `  >0hldTFX XlN:HG%lCH(H%lCI9,04! 4 0 H=>,FX%lCJ)405X lKlAXL:H%]A5Xl=XL($5X`,lh ,40Xd f`%p! x p >pf`%p! ` p >p(Pp! H p >Pc`]4p5PP P4x5PMCtt@xPN5PtM`@$$p! $ p pf`%p! H p >pp! H p >p:`%NPP$$5P< ,txpP@d f`%p! ` p >pf`%p! H p >p(Pp! x p >Pc`]4p5PP P4x5POCtt@xPN5PtM`@$$p! $ p pf`%p! x p >pK[p! x p >p:`%NPP$$5P< ,txpP@d f`%p! x p >pf`%p! H p >p(Pp! ` p >Pc`]4p5PP P4x5PPCtt@xPN5PtM`@$$p! $ p pf`%p! ` p >pp! ` p >p:`%NPP$$5P< ,txpP@  h%x! $ x x X:h%]A*Hx!  x H:h%]Ax5Hwx!  x (xx!  x (xx!  x xx!  x (xx!  x xD$ xH84 h%x!  x x X:h%]A*Hx! $ x H:h%]Ax5Hx!  x (xx!  x xx!  x (xx! $ x xx!  x (xx! $ x xD$ xH8d\X``8 4 h p l h:0% ,  SlH4 dl$P@ @.K"X # X4h5XXT! T XD D:4$]>$ !   :$]>'V!  (!)T 6XDK6XT T XhD%T6XDT T TcT T T  4IT! T T TT T6XT T XhD%T6XDT T TT T T  4T! T T TT T6XT ,T XhD%T6XDoT ,T TT ,T T TT Tch/T! T (!T / , lh4 T XD$lcl% fl% 8fl% P&cd*FX%h h h5XHfXd6XH4l$  hXHlfl% fl% 8cl% P&ce*FX%h h h5XHfXd6XH4l$  hXHlfl% cl% 8fl% P&cf*FX%h h h5XHfXd6XH4l$  hXHlcl% fl% fl% &gh*FX%h h h5XHfXd6XH4l$  hXHlfl% fl% cl% &gi*FX%h h h5XHfXd6XH4l$  hXHlfl% cl% fl% &gj*FX%h h h5XHfXd6XH4l$  hXHTLf\d6\L0$  \LTLf\d6\L0$  \LplPth  \  @ TD|<H8?4l$  hXHlfl% fl% cl% &gi*FX%h h h5XHfXd6XH4l$  hXHlfl% cl% fl% &gj*FX%h h h5XHfXd6XH4l$  K[hXHTLf\d6\L0$  \LTLf\d6\L0$  \LplPth  \  @ TD|<H8?rU (`/(A`/$`$` $` $A` $`<$`  $` $A ` $ ` $ ` $ `  (A `$/(`(/n@ <Yzzz @:@@DAppp@H  rrr@ LY|||@ PY~~~@ TYI@ XY@ \Y!@`!@d@h  ttt  WWW h! h hh! h h-dh$ h DQd[`lhr\l=Ll=L<  <, ,: ]>    : ]>'6 L<, -'%lALh! h /h5L ls\` 0`\l< hdL<, t('tx! x lt?/tx 'tx! x lt?/tx`tx! x lt *#hlp! p ll*#`d! d 2thl`)xpd4tx! x ltp! p /t)xpx! x x:P%x! x x,($ (tlh`xpdt('tx! x lt?/tx 'tx! x lt?/tx`tx! x lt *#hlp! p ll*#`d! d 2thl`)xpd4tx! x ltp! p /t)xpx! x x:P%x! x x,($ (tlh`xpd@'pt! t lp?/pt8t! t t.`t! t `P(@]ut5`px.z,K[t! t | l,tc(%,kzt! t l,Rtpx zd(kx?'@%`t! t `p$! $ P /p)t$5`5`t! t `$! $ T )t$5`:@%t! t t*kz,t! t | l,t kzpzkzt! t tt! t t6%,t! t | l,t6t! t tX@$ $pt$`P0@'pt! t lp?/pt8t! t t.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(kx?'@%`t! t `p$! $ P /p)t$5`5`t! t `$! $ T )t$5`:@%t! t t*kz,t! t | l,t kzpzkzt! t tt! t t6%,t! t | l,t6t! t tX@$ $pt$`P0'pt! t lp?/pt.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(kxkzt! t t5`t! t `$! $ T )t$5`E`t! t kzD@%`p$! $ P /p)t$5`:@%t! t t kzt! t tX$ $pt$`P0'pt! t lp?/pt.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(.kxkz,t! t | l,tt! t t5`t! t `$! $ T )t$5`E`t! t kzD@%`p$! $ P /p)t$5`:@%t! t t kzt! t tX$ $pt$`P0P  . > $ P  , < $ 0d! d dd! d dZTd! d '%',%<%TLP$ P Qx/L)dP5Tx 4k*dx Qd[hr -'<%hATLd! d P /Ld5T hs d! d dd! d dp04 xh LdPTl,Kx! x xx! x xx! x x:h%x! x x:h%x! x x X! XH(h]u5X&X! Xx! x x5Xx! x x:h%x! x x D,$ xXH8P'tx! +x lt?/tx(  (4<5( (x! +x (DxC@1:D(:%<6((:D(:%<6($*F(%<6( *F(%<5( k:D:]1(tx! +x lt! + l'2t)x51Ttx! +x  lt #*#*F(T2txtx! +x ! + | HL! +L  lt #*#*#*F(l! + (: " !" !p:"`:#P lH F8(:`1@2 tH)xL6(p`P8K[(Ttx! +x $ lt #*#*F(T2txC@u:%T(:&::'D::(Dpl@F`: Pd6(p`A''''d:N:N(( ,1t/t6 ( f%x$ `x )xD:]4 :*Dp:p:k:qc<I8  @TD<ddtHxL(p`P8(@TLP<8\Hh 4 @ X5h:XU%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% fX% fX% 8fhh6h8cx<'' '80 #44 ,$>0Fh %46h8  |(x$04h8 @KNh  h4x5h:XO%xP(X%xQ xRxWhS:X]A5h$xWhS%4 ,4 45h8fhh6h8cx<'' '80 #44 ,$>0Fh %46h8  |(x$04h8  .-TX $ X D QT[P\XrL?\=<<,  , : ]A6<,-\A<%X $ ` X !X5< \sL1/ 4lPL\$XT<,<.(<l M\@, ,  6<, :\V]4q_ :\Wll :\Xl :\Y]4 :\Zl :\[l :\\]4 :\]l :\^l :\l/p,l <,D.3l AH0+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , !,6H03l AH0+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , !,6H03lAH0+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , !,6H03lAH0+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , !,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P m 5P;ld.@M0@P d-P m 5P;ld.@M0@P d-P ,m 5PQ:0"% ,m f0% 8mf0% Pmf0% mf0% mf0% mf0% mkb 4<$ # $l   $ `  p! 4:0"% ,m  SlH4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T #TT $T6XT T XhDT6XDT T TT T T  4T! T T #TT $T6XT ,T XhDT6XDoT ,T TT ,T T #TT $Tch/T! T (T /K[ ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'rU iXqy qqy 9y I9 i ! A a Ai1 YA *Qaق ) 0a-uYvA0 q 0a-.]pIryrrri9sss tq1-ɐA  FFAq@414Q~@814!~@<14B@@14~Q@Da@ H5IC@La!@:P@TAppp@ XYrrr@\aK[ttt@ `5@ dYI@h@l&@ pYvvv@t14/xxxQ@x14;|||WWW__pI *FXhx! x hH%D! D )xD6XhHx! x x  @8p$  xDhXH.-TX$ X D$QT[P\XrLs\= % :(]>'6 <, (: )\A$ !   :]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT Tch/T! T (T / P, lh4 T XD$Lh+z<5h$  h`K T  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A`1d6Tchcl ld?ldF@%P! P Pf@% f@% f@% cTD6T<''' PP , >FT P6T `0 ldh$PT`K T  TlNG(@%: %(%TP! GP TlB4hP6T lhc#hWT=A`1d6Tchcl ld?ldF@%P! GP Pf@% 8Gf@% PGf@% GcTD6T<''' PP , >FT P6T `0 ldh$PT$p& :l- $  D$Q [8r!08A6:7(]u68A!\:" 8\" 8L6k&? '%'%%\$  $Q / 9Q[(rN&l(A!::l6 (s c=9s:;lL:< :=t\d:T>Dl4L$:?`1H6tdD4$7:@ :=\K[`Ǭ8/6:A :Bl:CltLd:TDD\4:>$lL:?`1H6tdD4$7:E :=\`Ǭ8/6 f%$ ` &'%lHF%$ ` p& 8sA$P 8 \8lL(HH tdD4$HHT  TlN 4:D]A"T 8T D$" 8:4I" 8" 8:It"d 8dTD4"$ 8$%lJ6 T$tdT4$c'':DKN4L*FT D$:4::M^pf6T$kfNT  T4h5T:DO%hP(D%hQ hRhWTS:D]A5T"T 8ThW$S" 8:DI" 84" 8t:Id"T 8T4$" 8%lJ6"T$tdT4$chcl, lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD!:X"]A5D X%lC#5X lsTj  h h hh h 0h  @X, TlhD4`Kt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@  +\d+<5d@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TNddT5d d@5d@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TNddT5d d@5dt! Qtod5dC8/>:0%'%'%:T%t$ `t `t+:T %t$ `t ,t +\t! t (tcx@cdD6d@<'' '@ tt , >Fd t6d@ t! t (t `( x,tPd@ 4.$  $\N \B$*LN,L=$+A,"  6$LA+4 H5t7HM @$ - $ &:.]46$ HW$! &`146$&l4/l40?HHW!HW$!( 186$8 2F$885$ (4M@$ % $:3]45$':4HW$!`Ǥ8/6$[LA$HW!'%'%8$:5%$ ` 6$':4HW$!`Ǥ8/6$[LA$HW!'%'%8$:5%$ ` 6$ Hu}/bP 6 l 84HL\ lei,$tfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$  \Ldfl% 8Gfl% PGcl% G:lT%h Gh hHfXD6XH4d$  hXHdfl% 8Gcl% PGfl% G:lU%h Gh hHfXD6XH4d$  hXHdcl% 8fl% Pfl% :l % K[h h hHfXD6XH4d$  hXHdfl% Gfl% Gcl% G:lV%h Gh hHfXD6XH4d$  hXHdfl% Gcl% Gfl% G:lW%h Gh hHfXD6XH4d$  hXHdcl% fl% fl% :l %h h hHfXD6XH4d$  hXHTLf\D6\LM0$  \LTLf\D6\L0$  \LdX  p  P t<x4@8\L7__SRP_7F+__SRP_8 &__SRP_9'")__SRP_a <2      !"#$%&()*+,-./0123456789:;=>?@ABCDEFGHIJKLMNOPQRSTUXYZ[\]^_`abcdefghijklmnopstuvwxyz{|}~rU (`9)0,A`<y#/(`@/,`D//$`H$A`L $`P (`T/0` XIi///(A `\Y#$ `` 0 ` d///$  `h $I `l $`p $`t $ `x $I`| $` $`$$ `$n!!a" y AA*i** +9+, ,]!-x0 dT(D]u8l T T`1t5TG  d1tltC0 l02iCx+ l02Cx+ l02Cx+ l02Cx+ l0 2 Cx+ l0 2 Cx+ l0 2Cx+ l02Cx+ l02)Cx+ l02ACx+ l02YCx+ l02qCx+ l02Cx+ l02Cx+ l02Cx+ l02 Cx+ l0!2"Cx+ l0#2!K[$Cx+ l0%2&Cx+ l0'21(Cx+ l0)2I*Cx+ l0+2a,Cx+ l0-2y.Cx+ l0/20Cx+ l0122Cx+ l0324Cx+ l0526Cx+ l0728Cx+ l092 :Cx+ l0;2!<Cx+=CxL00Dx0tT4l$:4=]4h> ? \N:4@%\CA(4%\CB \C\ADbE ? LN$:4=]AdLBF5b (4%LBG4H5HWH`1D53lDJiDM4@ I`1D6cH f4%J$K `L M&'$%lDF4%J$K `L M |l8 l\HLDTD(4$Upj$(Dkjl$ I$`1d6D$ldFT]4A` kjpj)ldFT]4>Dkj'$5 kjDTlh,ldD$E4 ? 44X54-,0J$K L0 DNQ,[(\0r$s\=4O\=O4 P  Q:R]> P :S]>'6 4\A4O:TH54'FH4%XF64FH4%XU54DV*#W*F4H:X\AO`1D/6 4F''''DM@:=N:=N44 Y1/6 4 f%0J$K `L0 M0&'%lDF%0J$K `L0 M0 \s$McX cl <@(l($H\XD8 0,4HE4 ? 44X54-,0J$K L0 HNQ,[(\0r$s\=4O\=O4 P  Q:R]> P :S]>'6 4\A4O:TH54'FH4%XF64FH4%XU54DV*#W*F4H:X\AO`1D/6 4 f%0J$K `L0 M0&'%lDF%0J$K `L0 M0 \s$McX cl @(l($HDX\8 0,4lKTJ$K LQTl'4 Zp`54[*#0k`]/0#\*#0]*#,k`^ 20,H: _N:`N44l MD @ a:bk`c 64dk`^ ek`^ (FD%Tl DNT 0fQhT lh,bT `gT hkTc(kbDD%T `gT 0iQdT ld0 ,j>01\ $jkpkkCXklCXkmCXknCXkoCXkpCXk6qCXkPrCXk :s' 4jli4 t#0*1X/064k uCXk vCXkwCX'kbD4 t1 x1y>#0*#,z*#l\*#{*#>#*#lX*#k`^ 20,64c bd)c*'''|*F4 }64pzk`=P~' TT li4 t#0*#,*1t20,T64%lt0 TT ,l0*1t/0T&'''4tMD@ }64 lH0 td\plXhL0,T4ztKXJ$K LQXh,^VXh DNX hkVXcR7881d)X<(dM@@( P (:]45(fld*#8*F'(dM@@ I:ldF:`1`/86( f@%XJ$K `LX MX&'%l`F@%XJ$K `LX MX['(dM@@ I''"K[:N:: }6(p\ ^dRI k\+''':@N(( }6(c@%XJ$K `LX MX c=Nh<'''8 XX ,>8F( }X6( t4l`hd4 8X<(ML:)`1H6tdD4$7:/ :'\`Ǭ8/6 f%$ ` &'%lHF%$ ` p& 8sA$P8 \8lL(HH tdD4$H0T  TlN 4:D]A"T "T D$" ":41" "" ":1t"d "dTD4"$ "$%l26 T$tdT4$c'':D3N44*FT D$:4::5^!pf6T$kf6T  T4h5T:D7%h8(D%h9 h:hWT;:D]A5T"T "ThW$;" ":D1" "4" "t:1d"T "T4$" "%l26"T$tdT4$chcl,lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD:X<]A5D X%lC=5X lsTj  h h hh h 0h  @X,TlhD4`Kt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@  +\d+<5d@>*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :T?NddT5d d@5d@@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TANddT5d d@5dt! Qtod5dBC8/>:0?%'%'%:TC%t$ `t `t+:TD%t$ `t ,t +\t! t (tcx@cdD6d@<'' '@ tt ,>Fd !t6d@ t! t (t `(x,tPd@ D.pf  TN TBEDN,D=FA G"h 6 DA F4@5 t7@M @ H   :I]46  @W  `1,6 &l,Jl,K? (,M@ :L]45H@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%$ ` 6 kfpf0kflhH@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%$ ` 6 kfpf0kflh @ukfh lhM l/DP6 l0,@DTh, tfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$#K[ \Ldfl% 8fl% Pcl% :lP%h h hHfXD6XH4d$ hXHdfl% 8cl% Pfl% :lQ%h h hHfXD6XH4d$ hXHdcl% 8fl% Pfl% :lR%h h hHfXD6XH4d$ hXHdfl% fl% cl% :lS%h h hHfXD6XH4d$ hXHdfl% cl% fl% :lT%h h hHfXD6XH4d$ hXHdcl% fl% fl% :lU%h h hHfXD6XH4d$ hXHTLf\D6\L0$ \LTLf\D6\L0$ \LdX  <  P pxt4@8\L7rU f6y !qa**Qy (I((( )))) )*A #*!$I3 ) aI 1  IIq!@ 4Yrrr@ 8Yxxx@<Appp@@attt@Dazzz@:HI@ LYvvv @P|||@T1~~~W8l  l\NX! $X X#TX! $X >TFlDXD @\Bl$N$Al$AlX! X X#TX! X >TFlXl  lNl  l\Nf4%C" @=l B N5lMTX!  X   H lT*Fl%c%\BN/T)X5l*:4l:%6l:4%:4%:4% (43 @(%>lA:p]46l' @(%>lAP5l' @(%>lA@5lP:(4l:`P0:p @%6 `0 (4l X$ QX%X'p%'%'%:4% l QX6:4!l:"D`T ,#/T6$K[l`T D#/T#lX D X ($)XX D X $%X &\D@D\$P0 TXl`0  l  l\NBPTX!  X  T H >PFl%\B '0N)XT5l0Al(2l ) l * :@+]46l X! $X XX! $X XX PX! $X /PXX! $X XX2l ) l * :@,]46l X! X XX! X XX PX! X /PXX! X XX y<$0\$PXTl -l  l\N:L.%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! $8 8\Al3:L]A5l~8! $8 X8)\Al308! $8 /085l8! $8 X88! 8 8'08! 8 l0?/08b8! 8 (48|8! 8 (48l,\  084l-l  l\N:L5%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! 8 8\Al3:L]A5l~8! 8 X8)\Al308! 8 /085l8! 8 X88! $8 8'08! $8 l0?/08b8! 8 (48|8! 8 (48l,\  084lLH84@( f@%X $ `X X&'%l`F@%X $ `X X['(dM@@ '':JN:K:L @6(p\ ^dRI k\+''':@MN(( @6(c@%X $ `X X c=h<'''8 BXX ,C>8F( @X6( t4l`hd4 8X<(R !   lF%!    $ @    lxv     45 c ΐ w  C?'p%'%%$  Q/!M@ ) `15"*l*#+*# ,2 \,kNM@ ) :-Mp@  @`16@"*l*#+*# ,2 \,kD(:p.%.@0 @d>C5(:p/%.@0 @d>C53lF`%.@0(%d>C6>p(p@0(h` {@"lt.\ , 00-\ D1K#.@@ @d>AK#?2)6(:p2%.@0 @d>C5@"lt:3@"lt.\ , 00-\ D1%.@0(@%d>C)6 @p  @~`k<(:p4%.@0 @d>C5m(:p5%.@0 @d>C5 k.p.3'@':6N0:7N #6@$!   ( 3'@':8N:9N #6@d=:;5 d< 4t\p`@P`t0d xD\@H l$5l$ ld@''$:TNDD4 !*#t"*Fd^#pz/t6dD$kz^ d$5dxd$ %K[ tdD$8$ `H HlNB<@D! D @ H=>Df,%D! x D >Df,%D! ` D >D6<@D! D @ H=>fD%! x  >fD%! `  >0hldTFX XlN:HG%lCH(H%lCI9,04! 4 0 H=>,FX%lCJ)405X lKlAXL:H%]A5Xl=XL($5X`,lh ,40Xd f`%p! x p >pf`%p! ` p >p(Pp! H p >Pc`]4p5PP P4x5PMCtt@xPN5PtM`@$$p! $ p pf`%p! H p >pp! H p >p:`%NPP$$5P< ,txpP@d f`%p! ` p >pf`%p! H p >p(Pp! x p >Pc`]4p5PP P4x5POCtt@xPN5PtM`@$$p! $ p pf`%p! x p >pp! x p >p:`%NPP$$5P< ,txpP@d f`%p! x p >pf`%p! H p >p(Pp! ` p >Pc`]4p5PP P4x5PPCtt@xPN5PtM`@$$p! $ p pf`%p! ` p >pp! ` p >p:`%NPP$$5P< ,txpP@  h%x! $ x x X:h%]A*Hx!  x H:h%]Ax5Hwx!  x (xx!  x (xx!  x xx!  x (xx!  x xD$ xH84 h%x!  x x X:h%]A*Hx! $ x H:h%]Ax5Hx!  x (xx!  x xx!  x (xx! $ x xx!  x (xx! $ x xD$ xH8d\X``8 4 h p l ghXHlfl% cl% fl% &@C*FX%h h h5XHfX`6XH4l$ hXHTLf\`6\L0$ \LTLf\`6\L0$ \LplPth \  @ T D|<H8GrU `$`H $A`L $`P&K[ $`T n )))) )*A #*!$I3 ) aI 1  uIvu@ 4Yrrr @ 8Yxxx @<Appp@@attt@Dazzz@:HI @ LYvvv  @P|||@T1~~~ W   8l  l\NX! $X X#TX! $X >TFlDXD @\Bl$N$Al$AlX! X X#TX! X >TFlXl  lNl  l\Nf4%C" @=l B N5lMTX!  X   H lT*Fl%c%\BN/T)X5l*:4l:%6l:4%:4%:4% (43 @(%>lA:p]46l' @(%>lAP5l' @(%>lA@5lP:(4l:`P0:p @%6 `0 (4l X$ QX%X'p%'%'%:4% l QX6:4!l:"D`T ,#/T6l`T D#/T#lX D X ($)XX D X $%X &\D@D\$P0 TXl`0  l  l\NBPTX!  X  T H >PFl%\B '0N)XT5l0Al(2l ) l * :@+]46l X! $X XX! $X XX PX! $X /PXX! $X XX2l ) l * :@,]46l X! X XX! X XX PX! X /PXX! X XX y<$0\$PXTl -l  l\N:L.%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! $8 8\Al3:L]A5l~8! $8 X8)\Al308! $8 /085l8! $8 X88! 8 8'08! 8 l0?/08b8! 8 (48|8! 8 (48l,\  084l-l  l\N:L5%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! 8 8\Al3:L]A5l~8! 8 X8)\Al308! 8 /085l8! 8 X88! $8 8'08! $8 l0?/08b8! 8 (48|8! 8 (48l,\  084l'K[LH84@t! t `$! $ T)t$5`:@%t! t t*kz,t! t |l,t kzpzkzt! t tt! t t6%,t! t |l,t6t! t tOX@$  $pt$`P0'pt! ,t lp?/pt.`t! ,t `P(@]ut5`px.z,t! ,t |l,tc(%,kzt! ,t l,Rtpx zd(kxkzt! ,t t5`t! ,t `$! ,$ T)t$5`E`t! ,t kzD@%`p$! ,$ P/p)t$5`:@%t! ,t t kzt! ,t tyX$  $pt$`P0'pt! .t lp?/pt.`t! .t `P(@]ut5`px.z,t! .t |l,tc(%,kzt! .t l,Rtpx zd(.kxkz,t! .t |l,tt! .t t5`t! .t `$! .$ T)t$5`E`t! .t kzD@%`p$! .$ P/p)t$5`:@%t! .t t kzt! .t tX$  $pt$`P0P  . > $  P  , < $  0d! d dd! d dZTd! d '%',%<%TLP$ P Qx/L)dP5Tx 4k*dx Qd[hr -'<%hAT Ld! d P/Ld5T hs d! d dd! d d_p04  xh LdPTl,Kx! x xx! x xx! x x:h%x! x x:h%x! x x X! XH(h]u5X&X! Xx! x x5Xx! x x:h%x! x x D,$  xXH80'tx! .x lt?/tx(  (4<5( (x! .x (DxC@1:D(:%<6((:D(:%<6($*F(%<6( *F(%<5( k:D:]1(tx! .x lt! . l'2t)x51Ttx! .x lt #*#*F(T2txtx! .x ! . |HL! .L lt #*#*#(*F(l! . (:-" *" *p:+`:PlH F8(:`1@2 tH)xL6(p`P8(Ttx! .x  lt #*#*F(T2txC@u:!T(:"::#D::$Dpl@F`:Pd6(p` f%x$ `x %x#'%dx$ `x %xD:]4p :'Dp:yp:k:qc<8 @TD<ddtHxL(p`P8(@TLP<8\Hh 4 @ X@ :TANdd$5d d5d +,t! t (tcx@cd6d@<'' '@ tt ,>Fd !t6d@ (K[t! t (t ((x,tPd@ \.pf  TN TBBDN,D=CA D"h 6 DA C4@5 t,7@M @ E   :F]46  @W  `1,6 &l,Gl,H? (,M@ :I]45H@W@W ( J06':K@W `Ǡ/6 [DA @W '%'%0 :L%$ ` 6 kfpf0kflh @ukfh lhM l/\P6 l0,@DTh, tfl% 8fl% Pfl% fl% fl% fl% Lf\6\L0t$ \Ldfl% 8fl% Pcl% :lM%h h hHfX6XH4d$ hXHdfl% 8cl% Pfl% :lN%h h hHfX6XH4d$ hXHdcl% 8fl% Pfl% :lO%h h hHfX6XH4d$ hXHdfl% fl% cl% :lP%h h hHfX6XH4d$ hXHdfl% cl% fl% :lQ%h h hHfX6XH4d$ hXHdcl% fl% fl% :lR%h h hHfX6XH4d$ hXHTLf\6\L0$ \LTLf\6\L0$ \L8lD  p  < \d`PTLHh8rU~|  ayYyѨ )Aayѩ !AYyɪ!9Yqɫ?S;G{okgc_ A *aق !Yѽ  9y y x A0xq1وrq 9!) i!Iq 1a!!a" y AA*i** +9+, ,]!-x0 dT(D]u8l T T`1t5TG  d1tltC0 l02iCx+ l0)K[2Cx+ l02Cx+ l02Cx+ l0 2 Cx+ l0 2 Cx+ l0 2Cx+ l02Cx+ l02)Cx+ l02ACx+ l02YCx+ l02qCx+ l02Cx+ l02Cx+ l02Cx+ l02 Cx+ l0!2"Cx+ l0#2$Cx+ l0%2&Cx+ l0'21(Cx+ l0)2I*Cx+ l0+2a,Cx+ l0-2y.Cx+ l0/20Cx+ l0122Cx+ l0324Cx+ l0526Cx+ l0728Cx+ l092 :Cx+ l0;2!<Cx+=CxL00 Dx0tT4l$:4=]4hQ R \N:4S%\CT(4%\CU \V\AWbX R LN$:4=]AdLBY5b (4%LBZ4H5HW[`1D53lDJiDM4@ \`1D6cH f4%>$? `@ F&'$%lDF4%>$? `@ F |l8  l\HLDTD(4$Upj$(Dkjl$ \$`1d6D$ldFT]4A` kjpj)ldFT]4>Dkj'$5 kjDTlh, ldD$X4 R 44X54-,0>$? @0 DAQ,[(\0r$s\=4B\=B4 C  D:E]> C :G]>'6 4\A4B:]H54'FH4%XY64FH4%X^54D_*#`*F4H:a\AB`1D/6 4F''''DM@:=N:=N44 b1/6 4 f%0>$? `@0 F0&'%lDF%0>$? `@0 F0 \s$McX cl <@ (l($H\XD8 0,4HX4 R 44X54-,0>$? @0 HAQ,[(\0r$s\=4B\=B4 C  D:E]> C :G]>'6 4\A4B:]H54'FH4%XY64FH4%X^54D_*#`*F4H:a\AB`1D/6 4 f%0>$? `@0 F0&'%lDF%0>$? `@0 F0 \s$McX cl @ (l($HDX\8 0,4lKT>$? @QTl'4 cp`54d*#0k`]/0#e*#0f*#,k`g 20,H: hN:iN44l MD @ j:kk`l 64mk`g nk`g (FD%Tl DAT 0oQhT lh,bT `pT qkTc(kbDD%T `pT 0rQdT ld0 ,s>01\ $skpktCXkuCXkvCXkwCXkxCXkyCXk6zCXkP{CXk :|' 4sli4 }#0*1X/064k ~CXk CXkCX'kbD4 }1 1>#0*#,*#l\*#*#>#*#lX*#k`g 20,64c bd)c*'''*F4 64pzk`=P' TT li4 }#0*#,*1t20,T64%lt0 TT ,l0*1t/0T&'''4tMD@ 64 lH 0 td\plXhL0,T4*K[ztKX>$? @QXh,^VXh DAX qkVXcR7881d)X<(dM@@( C (:]45(fld*#8*F'(dM@@ \:ldF:`1`/86( f@%X>$? `@X FX&'%l`F@%X>$? `@X FX['(dM@@ \'':N:: 6(p\ ^dRI k\+''':@N(( 6(c@%X>$? `@X FX c=Ah<'''8 XX ,>8F( X6( t4 l`hd4 8X<(H-TX>$? @X DAQT[P\XrLs\= C :G]>'6 <,-\A$? `@X FX5< \sL/-TX>$? @X HAQT[\XrA-\A$? `@X FX5< \s H< $lPL\4 XT<,v: H%:,I%<:@J%PT:XK%h>$? L@h HLT MP ,NOP)hTP<6( l(hTP<CtdT4$c'':DJN4KL*FT D$:4L:L:M^!pf6T$kfNT  T4h5T:DO%hP(D%hQ hRhWTS:D]A5T$hWTS% , 5T"T GThW$S" G:DH" G4" Gt:Hd"T GT4$" G%lI6"T$tdT4$chcl,lhTT$tdT4$H lX5l$ l`KNh  h4x5h:XT%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% 8fX% PfX% 8fhh6h8<'' '80 44 , >0Fh !46h8  |(x$04h8 hKNh  h4x5h:XU%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% fX% fX% 8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8 @KNh  h4x5h:XO%xP(X%xQ xRxWhS:X]A5h$xWhS%4 ,4 45h8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8  .-TX $ X D QT[P\XrL?\=<6<,  , : ]A6<,-\A<6%X $ ` X X5< \sL1/ 4lPL\$XT<,<.(<l M\@, 9,  6<, :\V]4q_ :\Wll :\Xl :\Y]4 :\Zl :\[l :\\]4 :\]l :\^l :\l/p,l <,D.3l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ +K[` , ,6H03l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P  5P;ld.@M0@P d-P  5P;ld.@M0@P d-P , 5PQ:0% , f0% 8f0% Pf0% f0% f0% f0% kb 4<$   l   $ `  p 4:0% ,  SlH4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'__SRP_b,K[W2__SRP_cr2__SRP_dF+__SRP_e 2rU ( `/( `/, `//( ` 0(! ` 08I `)Ai#000$q `$ `$ `n Qi1 Y ) 0a-uYvq A0 0 FFI9Aɳy@414Q~ @814!~ @ <Yvvv @@14~Q @Da@ H5IC@La! @:P @TAppp@ XYrrr @\attt @ `5@ dYI @h@l&@p14/xxxQ @t14;||| @x14B  W    W    W    _    _    pI *FXhx! x hH%D! D )xD6XhHx! x x  @8p$ xDhXH.-TX$ X DQT[P\XrLs\=<\=<, , : ]> : ]>'6 <, (: \A<,`Ǩ8/6<,-\A<%X$ `X X5< \sL1/ 4lPL\8 XT<,-K[$.-TX$ X DQT[P\XrL0\A,:<( ]u6,(:<\A,`8/6,-\A,%X$ `X X5, \sL1/ 4lPL\$XT,P.K)X  X4h5XXT! T XD D:4]>$ !   :]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT Tch/T! T (T / P,lh4 T XD$Lh+z<5h$ h`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% f@% f@% cTD6T<''' PP ,>FT !P6T `0ldh$PT`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% 8f@% Pf@% cTD6T<''' PP ,>FT !P6T `0ldh$PT$p& :l- $  DQ [8r!08A:(]u68A\:" "\" "L6k&? '%'%%\$  Q / #Q[(rN&l(A:$l6 (s c=#s:%lL:& :'t\d:T(Dl4L$:)`1H6tdD4$7:* :'\`Ǭ8/6:+ :,l:-ltLd:T.D\4:($lL:)`1H6tdD4$7:/ :'\`Ǭ8/6 f%$ ` &'%lHF%$ ` p& 8sA$P8 \8lL(HH tdD4$H0T  TlN 4:D]A"T "T D$" ":41" "" ":1t"d "dTD4"$ "$%l26 T$tdT4$c'':D3N44*FT D$:4::5^!pf6T$kf6T  T4h5T:D7%h8(D%h9 h:hWT;:D]A5T"T "ThW$;" ":D1" "4" "t:1d"T "T4$" "%l26"T$tdT4$chcl,lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD:X<]A5D X%lC=5X lsTj  h h h.K[h h 0h  @X,TlhD4`Kt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@  +\d+<5d@>*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :T?NddT5d d@5d@@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TANddT5d d@5dt! Qtod5dBC8/>:0?%'%'%:TC%t$ `t `t+:TD%t$ `t ,t +\t! t (tcx@cdD6d@<'' '@ tt ,>Fd !t6d@ t! t (t `(x,tPd@ 4.$  $\N \B$ELN,L=$FAG"  6$LAF4 H5t7HM @$ H $ :I]46$ HW$ `146$&l4Jl4K?HHWHW$( M86$8 VF$885$ (4M@$ $:L]45$':NHW$`Ǥ8/6$[LA$ HW'%'%8$:O%$ ` 6$':NHW$`Ǥ8/6$[LA$ HW'%'%8$:O%$ ` 6$ Hu}/YeP6 l 84HL\ YearCo,$tfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$ \Ldfl% 8fl% Pcl% :lP%h h hHfXD6XH4d$ hXHdfl% 8cl% Pfl% :lQ%h h hHfXD6XH4d$ hXHdcl% 8fl% Pfl% :lR%h h hHfXD6XH4d$ hXHdfl% fl% cl% :lS%h h hHfXD6XH4d$ hXHdfl% cl% fl% :lT%h h hHfXD6XH4d$ hXHdcl% fl% fl% :lU%h h hHfXD6XH4d$ hXHTLf\D6\L0$ \LTLf\D6\L0$ \LdX  <  P pxt4@8\L7dX  <  P pxt4@8\L7 TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XH/K[fXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'ˁSrU 8j 7 y  ٷA *aق]?y xyq"i#IiY (A.a/..(ѶIrوrI-qɐ -ٷ@4@ 8Yzzz  @ <Y||| @ @Y~~~ @ DY!I @H@:L @ PY! @TAppp@X  ttt  @\!0K[@`1  Y vvvI @ dY @h  rrr @ lYI  W    W    W    h! h hh! h h-dh$ h D Qd[`lhr\l=L l= L< <, ,: ]>   :]>'6 L<, -'%lAL h! h /h5L ls\`287 0 `\l< hdL<, t('tx! 6x lt?/tx 'tx! 6x lt?/tx`tx! 6x lt*#hlp! 6p ll*#`d! 6d 2thl`)xpd4tx! 6x ltp! 6p /t)xpx! 6x x:P%x! 6x x,($  (tlh`xpdt('tx! 6x lt?/tx 'tx! 6x lt?/tx`tx! 6x lt*#hlp! 6p ll*#`d! 6d 2thl`)xpd4tx! 6x ltp! 6p /t)xpx! 6x x:P%x! 6x x,($  (tlh`xpd@'pt! 6t lp?/pt8t! 6t t.`t! 6t `P(@]ut5`px.z,t! 6t |l,tc(%,kzt! 6t l,Rtpx zd(kx?'@%`t! 6t `p$! 6$ P/p)t$5`5`t! 6t `$! 6$ T)t$5`:@%t! 6t t*kz,t! 6t |l,t kzpzkzt! 6t tt! 6t t6%,t! 6t |l,t6t! 6t tX@$  $pt$`P0@'pt! t lp?/pt8t! t t.`t! t `P(@]ut5`px.z,t! t |l,tc(%,kzt! t l,Rtpx zd(kx?'@%`t! t `p$! $ P/p)t$5`5`t! t `$! $ T)t$5`:@%t! t t*kz,t! t |l,t kzpzkzt! t tt! t t6%,t! t |l,t6t! t tX@$  $pt$`P0'pt! 6t lp?/pt.`t! 6t `P(@]ut5`px.z,t! 6t |l,tc(%,kzt! 6t l,Rtpx zd(kxkzt! 6t t5`t! 6t `$! 6$ T)t$5`E`t! 6t kzD@%`p$! 6$ P/p)t$5`:@%t! 6t t kzt! 6t tX$  $pt$`P0'pt! 6t lp?/pt.`t! 6t `P(@]ut5`px.z,t! 6t |l,tc(%,kzt! 6t l,Rtpx zd(.kxkz,t! 6t |l,tt! 6t t5`t! 6t `$! 6$ T)t$5`E`t! 6t kzD@%`p$! 6$ P/p)t$5`:@%t! 6t t kzt! 6t1K[ tX$  $pt$`P0P  . > $  P  , < $  xd! d dd! d dZTd! d '%',%<%TLP$ P Qx/L)dP5Tx 4k*dx Qd[hr -'<%hAT Ld! d P/Ld5T hs d! d dd! d dILd! d lLP! P /L)dPpx4  xh LdPTh(Kx! 6x xx! 6x xx! 6x x:h%x! 6x x:h%x! 6x x X! XH(h]u5X&X! Xx! 6x x5Xx! 6x x:h%x! 6x x D($ xXH8L'tx! x lt?/txF   N x! x Dx :4p1:D:% B6*:D:% 6$*F% B6*F% 5 )qtx! x lt!  l2t)xD:]1'BTtx! x lt #*#*FT2txPtx! x  lt #*#*102txx! x |t!  :!l!  :""x #xh"X #XH:$8:(%lt F:4/t)x6xhXH8Ttx! x &lt #*#*FT2txC0 :4+x! x 'x5'-'(Tt FT/t")(l0 10~:*T:+::(,xDh:X:-HD8l0F4:d6xhXH8 f%x$ `x .x#'%dx$ `x .xQD:]1tx! x lt/'/tx5o :/D c :0% BVp5{ f   wc kD1  45>" #:0" #x`16xIl2*#t*#3*#2*#*#4*F%52 t5cLL 4 04TD d \txxhXH8l<@8DPhX ` L d%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P  5P;ld.@M0@P d-P  5P;ld.@M0@P d-P , 5PQ:0% , f0% 8f0% Pf0% f0% f0% f0% kb 4<$   l   $ `  p 4:0% ,  Sl2K[H4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'rU x$ `$A ` $ ` $ ` $ ` $A ` $ ` ( `3K[<&( `<&$A `$ ` $ ` n///$ `d ,  `h//$I `l $ `p $ `t $  `x $I `| $ ` $ `$  `$$I `$ `$@@14~Q @Da@ H5IC@La! @:P @TAppp@ XYrrr @\attt @ `5@ dYI @h@l&@p14/xxxQ @t14;||| @x14B  W    W    W    _    _    pI *FXhx! x hH%D! D )xD6XhHx! x x  @8p$ xDhXH.-TX$ X DQT[P\XrLs\=<\=<, , : ]> : ]>'6 <, (: \A<,`Ǩ8/6<,-\A<%X$ `X X5< \sL1/ 4lPL\8 XT<,$.-TX$ X DQT[P\XrL0\A,:<( ]u6,(:<\A,`8/6,-\A,%X$ `X X5, \sL1/ 4lPL\$XT,P.K)X  X4h5XXT! T XD D:4]>$ !   :]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T 4K[T TT Tch/T! T (T / P,lh4 T XD$Lh+z<5h$ h`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% f@% f@% cTD6T<''' PP ,>FT !P6T `0ldh$PT`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% 8f@% Pf@% cTD6T<''' PP ,>FT !P6T `0ldh$PT$p& :l- $  DQ [8r!08A:(]u68A\:" "\" "L6k&? '%'%%\$  Q / #Q[(rN&l(A:$l6 (s c=#s:%lL:& :'t\d:T(Dl4L$:)`1H6tdD4$7:* :'\`Ǭ8/6:+ :,l:-ltLd:T.D\4:($lL:)`1H6tdD4$7:/ :'\`Ǭ8/6 f%$ ` &'%lHF%$ ` p& 8sA$P8 \8lL(HH tdD4$H0T  TlN 4:D]A"T "T D$" ":41" "" ":1t"d "dTD4"$ "$%l26 T$tdT4$c'':D3N44*FT D$:4::5^!pf6T$kf6T  T4h5T:D7%h8(D%h9 h:hWT;:D]A5T"T "ThW$;" ":D1" "4" "t:1d"T "T4$" "%l26"T$tdT4$chcl,lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD:X<]A5D X%lC=5X lsTj  h h hh h 0h  @wX,TlhD4`Kt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@  +\d+<5d@>*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :T?NddT5d d@5d@@*F@dt! t d `8/t6@d =dt! t P!  QPo@ddt6d@ :TANddT5d d@5dt! Qtod5dBC8/>:0?%'%'%:TC%t$ `t `t+:TD%t$ `t ,t5K[ +\t! t (tcx@cdD6d@<'' '@ tt ,>Fd !t6d@ t! t (t `(x,tPd@ D.pf  TN TBEDN,D=FA G"h 6 DA F4@5 t7@M @ H   :I]46  @W  `1,6 &l,Jl,K? (,M@ :L]45H@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%$ ` 6 kfpf0kflhH@W@W ( M06':N@W `Ǡ8/6 [DA @W '%'%0 :O%$ ` 6 kfpf0kflh @ukfh lhM l/DP6 l0,@DTh, tfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$ \Ldfl% 8fl% Pcl% :lP%h h hHfXD6XH4d$ hXHdfl% 8cl% Pfl% :lQ%h h hHfXD6XH4d$ hXHdcl% 8fl% Pfl% :lR%h h hHfXD6XH4d$ hXHdfl% fl% cl% :lS%h h hHfXD6XH4d$ hXHdfl% cl% fl% :lT%h h hHfXD6XH4d$ hXHdcl% fl% fl% :lU%h h hHfXD6XH4d$ hXHTLf\D6\L0$ \LTLf\D6\L0$ \LdX  <  P pxt4@8\L7rU hj6 i ! A a Ѿq y y 9! 8 *A a-.]pIrtrius t) 0a-uYvA0 aq 0 FFI9 o!Ѿ@:4 @8Appp@ <Yrrr @@attt6K[@ DYvvvI@ H5IC@L14/xxxI@P14;|||@T14BWWKWT  TlN((D%:$%(%lBT4h5T lhcy#hWT=A`1d6Tchcl!   ld ?ld!  fD% 8fD% PfD% '!  l ?/8!  ( R!  ( <'''  , >FT 6T T0ldh$T0K0 !    !  (   @  4x57 !  >F%x 6 5 !  !  ! 0 ! H l||>F) 6 |lp< !  >F%xA8 6- $  DQ[hh rd : H0hA:(T]u6hA(:" (" 6?'@%'T%%( $  QP/  P Q [<Xr8&HXA:H6 Xs8k\:H:T(:@ H|:(!l`16|lp:"H:T#H:@$(:( |Hl:!`16|l f% $ ` % &'T%lF% $ ` % p hsd 5 !  (  +  !   <'''   , >F  6 !  (   -X@ hd<8(8HPhxXH |l.-TX$ X DQT[P\XrL0\A,:<( ]u6,-\A,%X$ `X %X5, \sL1/ 4lPL\ XT,h.$  $\N \B$LN,L=$&A'"  6$LA&4 H5t`7HM @$ ( $ ):*]46$S HW$ )`146$&l4+l4,?QHHWHW$( -86$8 .F$885$ (4M@$ / $:0]45$[LA$HW'%'%8$:1%$ ` %6$O[LA$HW'%'%8$:1%$ ` %6$ Hu}/hP6 l 84HL\ ($x! x xAptx! x t H2lpl! l /p)xtlf\% 8f\% Pf\%  $ pxtlxDfl% 8fl% P:l3%h h hD$ hxDfl% 8fl% :l4%h h hD$ hxDfl% fl% P:l5%h h h7K[D$ h<D4LTP :3 \:6LT6 \#',%T$ ` % c=x%h,]1 46p'%'%'%:,7%$  lQpd ld(B(% %:,%( p8Q[$p( `8p (9)$pB(% %:,%( p8Q[$p( `8p (9)$pB(% %:,%( p8Q[$p( `8p (9)$pC% %:,!%( p8Q[$p( `8p (9)$pc(3ld$p$  Dp (9)$p*p$  Dp $:)p;<*F  ,:= :>\ L:? :t@ <:,A := t:d>T D4:$? :B:C :=t dT:D?4 $:> :BT66 \LtT4tT4#',%T$ ` %D   45 (,% E`1P5 G'%'%%:7%lPF%:,F%$ ` %^lPG*F ,%!  lG*F%c%H/6 c<D,(x@TdhP p$ \LtT4tT4I8K!  !  (   @"C<:%!  !  !  D  4x57!  >F%xI6 J5 f%$ ` %! Qo5!  !  K! 0 K! H Kft>FJ)6 tZ ! x @p! x @ L 'D%'T%:dM%:F%$ ` %)6-$  DQ[@hr<hA`1<5\hAN:O(d]r'6%:VMd@F 6!  (  $L8L4 @<<Ph,x@XD4th.-TX$ X DQT[P\XrL\=\A,N:dFJ)x\`(6 FT 6T T0ldh$T0K0 !    !  (   @  4x57 !  >F%x 6 5 !  !  ! 0 ! H l||>F) 6 |lp< !  >F%xA8 6- $  DQ[hh rd : H0hA:(T]u6hA(:" (" 6?'@%'T%%( $  QP/  P Q [<Xr8&HXA:H6 Xs8k\:H:T(:@ H|:(!l`16|lp:"H:T#H:@$(:( |Hl:!`16|l f% $ ` % &'T%lF% $ ` % p hsd 5 ! :K[ (  +  !   <'''   , >F  6 !  (   -X@ hd<8(8HPhxXH |l.-TX$ X DQT[P\XrL0\A,:<( ]u6,-\A,%X$ `X %X5, \sL1/ 4lPL\ XT,h.$  $\N \B$LN,L=$&A'"  6$LA&4 H5t`7HM @$ ( $ ):*]46$S HW$ )`146$&l4+l4,?QHHWHW$( -86$8 .F$885$ (4M@$ / $:0]45$[LA$HW'%'%8$:1%$ ` %6$O[LA$HW'%'%8$:1%$ ` %6$ Hu}/hP6 l 84HL\ , r($x! x xAptx! x t H2lpl! l /p)xtlf\% 8f\% Pf\%  $ pxtlxDfl% 8fl% P:l3%h h hD$ hxDfl% 8fl% :l4%h h h%D$ hxDfl% fl% P:l5%h h hD$ h<D4LTP h hD$ h<D4LTPrU xf SI i ! A a q y y 9 8 *)?4I(H?4A(Q599A a-]p3a44!;-5- 86y838 48H9III @@@YA.AA!BB1C D*Dɐ) aA0 0Q3 FFI9 qY+I@414/xxx@814;|||I@<14B @@attt@D> @ H5IC@ LYvvv@P>I;K[@TAppp@ XYrrr@:\ WWWh0x! xQxoh5h) fX%! $0$ xhh0x! Qxoh5h) fX%! $0$ xhK^l  l\N$(L%:,%( %\BlNqcv"=l=A6lcc\!  :L ]A !  /fL% 8fL% PfL% '!  l ?/?!  ( Y!  ( <'''  , >Fl 6l [0\$l Kk P! P PP! P ( P  @@  @0N7,P! P >,F@%0B P6@ K @5@,P! P  !   @! 0 @! H >,F)P6 @<,P! P >,F@%0> AP6@ P! xQPo@5@CXCXX@c%0B@pNP! QPo@5@:%c%0B@PN(@P! xP @ P5@U*F@%p5@:%p:%p-P$ !P D"Q[LlPrH : \0lA@#:$ (]u6@  lA@8D'%%%8,P$ !P "Q4/,PpVP4 %QP[ $r&\$A@ :&\6@ $A@  :']48$A@((]> $A)( ]>6@P! xQPo@5@*:*8@:+ %p6@ $A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,0%p6@ \L<pV :1]4R8$A@((]> $A)( ]>6@MP! xQPo@5@m*:*8@:+ %p6@ D$A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,2%p6@ \L<pV :3]48$A@((]> $A)( ]>6@P! xQPo@5@*:*8@:+ %p6@ $A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,4%p6@ \L<pV $s5P! QPo@5@ c 1]'%`%%:58@:6 ,P$ !P "Q4/,P6@ 4 p%l| f]'%`%%:78@:8 ,P$ !P "Q4/,P6@ 4 p%l 1"kVlF@' 5 T:98@:: :;8:`+:<%P6 @ :="@ >@ " >:?" >" >%P6@ :@%P lsH @5@(@P! xP @ P5@ *F@%p5@:A%p:<K[%p:%p:B%p:C%p:D%p pEP! P ( Pc0F@  @NGlX*F@%H5@cf  P! P P<''' , PP , >,F@ P6@ P! P ( P h  lTLH  8\4l0$PXpl,P@ |\L<h.-TX$ !X D"QT[P\XrL0\A,#:<$( ]u6,-\A,%X$ `!X IX5, \sL1/ P4lPL\ XT,\4  4lN lB4\N\A$J4 X5$tVWXM @4 K 4$ L$:+]1XW(]1'64$IHXWXW4$(  MH64[\A4XW$'%'%H$4: N%$ `! I64$ XuO) \@( HDX\l,4$hx! x xch% 8:hO%x x xfh% Pfh% h$ xxDfl% 8fl% P:lP%h h hD$ hxDfl% 8fl% :lQ%h h hD$ hxDfl% fl% P:lR%h h hD$ hDPXL\4< 8::'D::(Dpl@F`: Pd6(p` f%x$ `x )x#'%dx$ `x )xD:]4p :*Dp:yp:k:qc<8 @TD<ddtHxL(p`P8(@TLP<h\H8 4 @ XrU h$` $A` $` $` (`/,A`//$` $` $` $A ` b-c <U!JH HIJ3 8I  i ! A   F 9FI9v,vv@ 4YrrrI@ 8Yxxx @<azzz@@attt@D|||@H1~~~@LAppp=K[@PaT@TaT@ XYdI@ \Yq @:`@ dYvvv@h14/@l14;@p14B@ t5ICWWW_.-TX$ X DQT[P\XrL0\A,:<( ]u6,-\A,%X$ `X X5, \sL1/ 4lPL\ XT,h.pf, ,TN(! $ ( (3$(! $ (  >$F,%TB DN(5,,D=, A"h 6,DA 4@5t7@M @,  , :]46,J@W@W,( `1<6,^DA,@W'%'%l= :P]1@(0%(%d>= :]1'6 ! $  !   (D'@':N4 !*#"*F^#i`P/6@P]4 $5$6 Yx5$ (0'(%0 @d>A5&:%]1:&]1X0"t 0"lt0(0'(%0 @d>A5':`&%(%0 @d>C5!(%0 @d>'C(5p.3.@(%d>A:`%]46 f'.@(%d>A 5+.@(%d>A`16 !   lF%!    $ @    lxv     45 c ΐ w  C?'p%'%%$  Q/!M@ ) `15"*l*#+*# ,2 \,kNM@ ) :-Mp@  @`16@"*l*#+*# ,2 \,kD(:p.%.@0 @d>C5(:p/%.@0 @d>C53lF`%.@0(%d>C6>K[>p(p@0(h` {@"lt.\ , 00-\ D1K#.@@ @d>AK#?2)6(:p2%.@0 @d>C5@"lt:3@"lt.\ , 00-\ D1%.@0(@%d>C)6 @p  @~`k<(:p4%.@0 @d>C5m(:p5%.@0 @d>C5 k.p.3'@':6N0:7N #6@$!   ( 3'@':8N:9N #6@d=:;5 d< 4t\p`@P`t0d xD\@H l$5l $ ld@''$:TNDD4 !*#t"*Fd^#pz/t6dD$kz^ d$5dxd$ tdD$8.$ `H HlNB<@D! D @ H=>Df,%D! x D >Df,%D! ` D >D6<@D! D @ H=>fD%! x  >fD%! `  >0hldTFX XlN:HG%lCH(H%lCI9,04! 4 0 H=>,FX%lCJ)405X lKlAXL:H%]A5Xl=XL($5X`,lh ,40Xd f`%p! x p >pf`%p! ` p >p(Pp! H p >Pc`]4p5PP P4x5PMCtt@xPN5PtM`@$$p! $ p pf`%p! H p >pp! H p >p:`%NPP$$5P< ,txpP@d f`%p! ` p >pf`%p! H p >p(Pp! x p >Pc`]4p5PP P4x5POCtt@xPN5PtM`@$$p! $ p pf`%p! x p >pp! x p >p:`%NPP$$5P< ,txpP@d f`%p! x p >pf`%p! H p >p(Pp! ` p >Pc`]4p5PP P4x5PPCtt@xPN5PtM`@$$p! $ p pf`%p! ` p >pp! ` p >p:`%NPP$$5P< ,txpP@  h%x! $ x x X:h%]A*Hx!  x H:h%]Ax5Hwx!  x (xx!  x (xx!  x xx!  x (xx!  x xxD$ xH84 h%x!  x x X:h%]A*Hx! $ x H:h%]Ax5Hx!  x (xx!  x xx!  x (xx! $ x xx!  x (xx! $ x xD$ xH8d\X``?K[8 4 h p l grU  g i ! A a q y y ) aI q A Ay+@4attt@:8@<Appp@ @Yrrr @ DYvvvIWKOl  l\N$(L%:,%( %\BlNqcv"=l=A6lcc\!  !  X !  /!  X'!  l ?/0!  ( J!  ( <'''  , >Fl 6l L0\$lpKl  l\NX! X X3TX! X >TFl%\B$4NX5l4Al 2l  l$ $:D]46l$IAl'%'%c%l:D%X$ `X X5l T'''T XX , lT*FlA$ /TX6 l$ p<$4\,TXl$x! x xx! x XxAptx! x t Hlpl! l /p)xtlx! x Xx$ pxtl@D8Hx! Qxoh5h) fX%! $0$ xhK^l  l\N$(L%:,%( %\BlNqcv"=l=A6lcc\!  :L ]A !  /fL% 8fL% PfL% '!  l ?/?!  ( Y!  ( <'''  , >Fl 6l [0\$l Kk P! P PP! P ( P  @@  @0N7,P! P >,F@%0B P6@ K @5@,P! P  !   @! 0 @! H >,F)P6 @<,P! P >,F@%0> AP6@ P! xQPo@5@CXCXX@c%0B@pNP! QPo@5@:%c%0B@PN(@P! xP @ P5@U*F@%p5@:%p:%p-P$ !P D"Q[LlPrH : \0lA@#:$ (]u6@  lA@8D'%%@K[%8,P$ !P "Q4/,PpVP4 %QP[ $r&\$A@ :&\6@ $A@  :']48$A@((]> $A)( ]>6@P! xQPo@5@*:*8@:+ %p6@ $A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,0%p6@ \L<pV :1]4R8$A@((]> $A)( ]>6@MP! xQPo@5@m*:*8@:+ %p6@ D$A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,2%p6@ \L<pV :3]48$A@((]> $A)( ]>6@P! xQPo@5@*:*8@:+ %p6@ $A($A)8:,@$A (:-N(" . :`/$A):l-N\\(|"L . L<:,4%p6@ \L<pV $s5P! QPo@5@ c 1]'%`%%:58@:6 ,P$ !P "Q4/,P6@ 4 p%l| f]'%`%%:78@:8 ,P$ !P "Q4/,P6@ 4 p%l 1"kVlF@' 5 T:98@:: :;8:`+:<%P6 @ :="@ >@ " >:?" >" >%P6@ :@%P lsH @5@(@P! xP @ P5@ *F@%p5@:A%p:%p:%p:B%p:C%p:D%p pEP! P ( Pc0F@  @NGlX*F@%H5@cf  P! P P<''' , PP , >,F@ P6@ P! P ( P h  lTLH  8\4l0$PXpl,P@ |\L<h.-TX$ !X D"QT[P\XrL0\A,#:<$( ]u6,-\A,%X$ `!X IX5, \sL1/ P4lPL\ XT,\4  4lN lB4\N\A$J4 X5$tVWXM @4 K 4$ L$:+]1XW(]1'64$IHXWXW4$(  MH64[\A4XW$'%'%H$4: N%$ `! I64$ XuO \@( HDX\l,4$hx! x xch% 8:hO%x x xfh% Pfh% h$ xxDfl% 8fl% P:lP%h h hD$ hxDfl% 8fl% :lQ%h h hD$ hxDfl% fl% P:lR%h h hD$ hDPXL\4< 8$  \LD@`dT H PAK[ L X h\l8W__SRP_13&__SRP_14")__SRP_15%~&__SRP_16#92      !"#$&'()*+,-./012345678:;<=>?@ABCDEFGHIJKLMNOPQRUVWXYZ[\]^_`abcdefghjklmnopqrstuvwxyz{~rU P$` $A` $`  n *aقxq1وrq 9!) i!Iq 1a!!a" y AA*i** +9+, ,]!-l$:4]4h  \N:4%\C(4%\C \\Ab  LN$:4]AdLB 5b (4%LB 4H5HW `1D53lDJiDM4@ `1D6cH f4% $ ` &'$%lDF4% $ `  |l8 l\HLDTD(4$Upj$(Dkjl$ $`1d6D$ldFT]4A` kjpj)ldFT]4>Dkj'$5 kjDTlh,ldD$4  44X54-,0 $ 0 DQ,[(\0r$s\=4\=4   :]>  :]>'6 4\A4:H54'FH4%X 64FH4%X54D*#*F4H:\A`1D/6 4F''''DM@:N:N44 1/6 4 f%0 $ `0 0&'%lDF%0 $ `0 0 \s$McX cl <@(l($H\XD8 0,4H4  44X54-,0 $ 0 HQ,[(\0r$s\=4\=4   :]>  :]>'6 4\A4:H54'FH4%X 64FH4%X54D*#*F4H:\A`1D/6 4 f%0 $ `0 0&'%lDF%0 $ `0 0 \s$McX cl @(l($HDX\8 0,4lKT $ QTl'4 p`54*#0k`]/0#*#0 *#,k`! 20,H: "N:#N44l MD @ $:%k`& 64'k`! (k`! (FD%Tl DTBK[ 0)QhT lh,bT `*T +kTc(kbDD%T `*T 0,QdT ld0 ,->01\ $-kpk.CXk/CXk0CXk1CXk2CXk3CXk64CXkP5CXk :6' 4-li4 7#0*1X/064k 8CXk 9CXk:CX'kbD4 71 ;1<>#0*#,=*#l\*#>*#>#*#lX*#k`! 20,64c bd)c*'''?*F4 @64pzk`=PA' BTT Cli4 7#0*#,D*1t20,T64%lt0 BTT ,Cl0*1t/0T&'''4tMD@ @64 lH0 td\plXhL0,T4ztKX $ QXh,^VXh DX +kVXcR7881d)X<(dM@@(  (:E]45(fFld*#8G*F'(dM@@ :HldF:I`1`/86( f@%X $ `X X&'%l`F@%X $ `X X['(dM@@ '':JN:K:L @6(p\ ^dRI k\+''':@MN(( @6(c@%X $ `X X c=h<'''8 BXX ,C>8F( @X6( t4l`hd4 8X<(R:`/$A):l-N\\(|"L . L<:,4%p6@ \L<pV $s5P! QPo@5@ c 1]'%`%%:58@:6 ,P$ !P "Q4/,P6@ 4 p%l| f]'%`%%:78@:8 ,P$ !P "Q4/,P6@ 4 p%l 1"kVlF@' 5 T:98@:: :;8:`+:<%P6 @ :="@ >@ " >:?" >" >%P6@ :@%P lsH @5@(@P! xP @ P5@ *F@%p5@:A%p:%p:%p:B%p:C%p:D%p pEP! P ( Pc0F@  @NGlX*F@%H5@cf  P! P P<''' , PP , >,F@ P6@ P! P ( P h  lTLH  8\4l0$PXpl,P@ |\L<h.-TX$ !X D"QT[P\XrL0\A,#:<$( ]u6,-\A,%X$ `!X IX5, \sL1/ P4lPL\ XT,\4  4lN lB4\N\A$J4 X5$tVWXM @4 L 4$ M$:+]1XW(]1'64$IHXWXW4$(  NH64[\A4XW$'%'%H$4: O%$ `! I64$ XuO! \@( HDX\l,4$hx! x xch% 8CK[:hP%x x xfh% Pfh% $h$ xxDfl% 8fl% P:lQ%h h h$D$ hxDfl% 8fl% :lR%h h hD$ hxDfl% fl% P:lS%h h hD$ hDPXL\4< 8\4< 8 $ `  p 4:0;% ,  SlH4dX$l$$P@ @.KX  X4h5XXT! T XD :D:4]>$ !   ::]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&<=*FX%h h h5XHfX`6XH4l$ hXHlfl% fl% 8cl% P&<>*FX%h h h5XHfX`6XH4l$ hXHlfl% cl% 8fl% P&<?*FX%h h h5XHfX`6XH4l$ hXHlcl% fl% fl% &@A*FX%h h h5XHfX`6XH4l$ hXHlfl% fl% cl% &@B*FX%h h h5XHfX`6XH4l$ hXHlfl% cl% fl% &@C*FX%h h h5XHfX`6XH4l$ hXHTLf\`6\L$0$ \LTLf\`6\L0$ \LplPth \  @ T D|<H8GrU l$` $A` (`)/0`  //#<`Ia/////$A` (`/0` ///$` $A `$$ ` $ ` $ DK[ ` n@<Appp@ @Yrrr @DanxxxWpj-`d$ d DQ`[\ldrXtl=Hl=(H8  8 (   : ]1'6 H8(kj0t: "H H8lA(" : lA: x6H8(pjt:"H H8lA(" :lA: x6H8(3'%xt`d! d ` \/t)d` lsX6+''('8:NHH 6H8(4\Xlx@ td`H8(P{:\ "l lL:<,"  : :: %!  6lL, {:\"l lL:<,"  ::: %!  6lL, $ 0 lL, @8P:4%:4% (43 @(%>lA:p]46l' @(%>lAP5l' @(%>lA@5lP:(4l:`P0:p @%6 `0 (4l X$ QX%X'p%'%'%:4% l QX6:4!l:"D`T ,#/T6l`T D#/T#lX D X ($)XX D X $%X & \D@D\$P0 TXl`0  l  l\NBPTX!  X  T H >PFl%\B '0N)XT5l0Al(2l ) l * :@+]46l X! $X XX! $X XX PX! $X /PXX! $X XX2l ) l * :@,]46l X! X XX! X XX PX! X /PXX! X XX y<$0\$PXTl -l  l\N:L.%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! $8 8\Al3:L]A5l~8! $8 X8)\Al308! $8 /085l8! $8 X88! 8 8'08! 8 l0?/08b8! 8 (48|8! 8 (48l,\  084l-l  l\N:L5%\C/(L%\C09048!  8  4 H >0Fl%\C1)845l\Al2 8! 8 8\Al3:L]A5l~8! 8 X8)\Al308! 8 /085l8! 8 X88! $8 8'08! $8 l0?/08b8! 8 (48|8! 8 (48l,\  084lLH84@! T T TT Tch/T! T (T / P,lh4 T XD$Lh+z 5h$ h`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=EK[A `1d6Tchcl ld?ldF@%P! P Pf@% f@% f@% cT6T<''' PP ,>FT !P6T e`0ldh$PT`KT  TlNG(@%: %(%TP! P TlB4hP6T lhc#hWT=A `1d6Tchcl ld?ldF@%P! P Pf@% 8f@% Pf@% cT6T<''' PP ,>FT !P6T `0ldh$PT$p& :l- $  DQ [8r!08A:(]u68A\:" "\" "L6k&? '%'%%\$  Q / #Q[(rN&l(A:$l6 (s c=#s:%lL:& :'t\d:T(Dl4L$:)`1H6tdD4$7:* :'\`Ǭ/6:+ :,l:-ltLd:T.D\4:($lL:)`1H6tdD4$7:/ :'\`Ǭ/6 f%$ ` &'%lHF%$ ` p& 8sA$P8 \8lL(HH tdD4$H0T  TlN 4:D]A"T "T D$" ":41" "" ":1t"d "dTD4"$ "$%l26 T$tdT4$c'':D3N44*FT D$:4::5^!pf6T$kf6T  T4h5T:D7%h8(D%h9 h:hWT;:D]A5T"T "ThW$;" ":D1" "4" "t:1d"T "T4$" "%l26"T$tdT4$chcl,lhPT$tdT4$4 Zh h 0h:X%h h hh h hllrTlAD:X<]A5D X%lC=5X lsTj  h h hh h 0h  @X,TlhD4KGt! t tt! t (t  @d  d4x5dcdt! t dx @P! P @x')tP6d@ & +,d+ 5d@>*F@dt! t d `/t6@d 0dt! t  c@d4t6d@ :T?Ndd$5d d5d@@*F@dt! t d `/t6@d 0dt! t  c@d4t6d@ :TANdd$5d d5d +,t! t (tcx@cd6d@<'' '@ tt ,>Fd !t6d@ t! t (t ((x,tPd@ \.pf  TN TBBDN,D=CA D"h 6 DA C4@5 t,7@M @ E   :F]46  @W  `1,6 &l,Gl,H? (,M@ :I]45H@W@W (FK[ J06':K@W `Ǡ/6 [DA @W '%'%0 :L%$ ` 6 kfpf0kflh @ukfh lhM l/\P6 l0,@DTh`, tfl% 8fl% Pfl% fl% fl% fl% Lf\6\L0t$ \Ldfl% 8fl% Pcl% :lM%h h hHfX6XH4d$ hXHdfl% 8cl% Pfl% :lN%h h hHfX6XH4d$ hXHdcl% 8fl% Pfl% :lO%h h hHfX6XH4d$ hXHdfl% fl% cl% :lP%h h hHfX6XH4d$ hXHdfl% cl% fl% :lQ%h h hHfX6XH4d$ hXHdcl% fl% fl% :lR%h h hHfX6XH4d$ hXHTLf\6\L0$ \LTLf\6\L0$ \L8lD  p  < \d`PTLHh7rU Xh _ ?  q i ! A a y AQR TA ]*3a44Q3 Q 4aQYQy|j}IjiU Y Ha)!$I1Ir!Qr ɥy i 0 9Y 8a@a-9III1f ) a-A0Q3 FFI9 1LY @:4 @8Appp@ <YrrrI@@14/xxx@D14;|||@H14B@LaqN@PatttGK[@TYP @ X5IC@ \YvvvI@` LI WWW\:hx! x hXVT! xT H)xT5h:D%x! x x8\$ xThXKWT  TlN((D%:$%(%lBT4h5T lhcy#hWT = A `1d6Tchcl!   ld?ld!  fD% 8fD% PfD% '!  l?/8!  ( R!  ( <'''  ,>FT 6T T0ldh$T`  l$*FX%h! h h5Xh! h hh! h hh! h XhI*FHXh! h X8%4! 4 )h46HX8h! h hh! h hh! h XhH$ h4XH8DG'%(%8% LH\$ \ Qt/H\pr\t Q\[`r `A:L]4(8`A(L]>`A(8 ]>6#Y 8:L:(\! \ %!  )\6pr:L]48`A(L]>`A(8 ]>6Y 8:L:(\! \ %!  )\6pr:L]48`A(L]>`A(8 ]>6}Y 8:L :(\! \ %!  )\6pr:L!]4`Ab  @" `s l t  c=tkrpz/8d  t`,H\4 <!:,#  :$T5 #',%T$ ` % :,&T#',%T$ ` %wp't%%%:,'  :( :)$  Qpx/6 lx pll,@ x  @;'':*N:,+N  ^ih6 h,]4::,,  :( :-T6 #',%T$ ` %3@ @h,]1''\!:,.  :/T5 #',%T$ ` % :,0T#',%T$ ` %p',%<%t%:,1  :2 :3 \:4L$  Qpx/6 \Llx pllp> x k>h,]Ax;'':*N:,5N  ^ih6 h,]4Q:,,  :2 :3 \:6LT6 \#',%T$ ` % c=x%h,]1 46p'%'%'%:,7%$  lQpd ld(B(% %:,%( p8Q[$p( `8p (9)$pB(% %:,%( p8Q[$p( `8p (9)$pB(% %:,%( p8Q[$p( `8p (9)$pC% %:,!%( p8Q[$p( `8p (9)$pc(3ld$p$  Dp (9)$p*p$  Dp $:)p;<*F  ,:= :>\ L:? :t@ <:,AHK[ := t:d>T D4:$? :B:C :=t dT:D?4 $:> :BT66 \LtT4tT4#',%T$ ` %D   45 (,% E`1P5 G'%'%%:7%lPF%:,F%$ ` %^lPG*F ,%!  lG*F%c%H/6 c<D,(x@TdhP p$ \LtT4tT4I8K!  !  (   @"C<:%!  !  !  D  4x57!  >F%xI6 J5 f%$ ` %! Qo5!  !  K! 0 K! H Kft>FJ)6 tZ ! x @p! x @ L 'D%'T%:dM%:F%$ ` %)6-$  DQ[@hr<hA`1<5\hAN:O(d]r'6%:VMd@F 6!  (  $L8L4 @<<Ph,x@XD4th.-TX$ X DQT[P\XrL\=\A,N:dFJ)x\`(6 !  :]>')6Oc!   !   ')64 X5n!   JK[!   `)6  :h :(/ $  D Q[xZBx 8>F   :]A6K+x 8lp/kqx8>1$x 8l*Fh/&:h% 6:h% 5$*F% 6*F% 5kil$*#*#*#*Fh:x 8>F:|826 J*#*Fh:x 8>F8/6 f% $ `  #'%8 $ `  kIX:]4< hXG hH xC@/4! ,  6 ! , (:% 5 :():H:X(D6!  (Jch6ech6$*F% 6*F% 5c <'''  , >F !6!  ( gL4 (hX$Hx 8< |b-4:$"l4:#l4:$l4:%l4:&l4:'l4:(l4:)l4:*l4:+ l4:, l4:t- l4:d. l4:T/ l4:D0l4:41l4:$2l4:3l44 44Z6 Y85FH 8'%'%$%l $  Qt/ :$Tt 45kt 5Q[drzp>!d=6 `1@6l8Dv 4l@F$]D4%p>4 Dw k>m1T:$7dA6:8T6 dsT($]u3T($T 9T5 T1x/ T: xtd@8TD24aH, (,  lN-l @l>:A;H5'H=6 < 85#8 < :]45%HA6:(5((]uRH=6(( 9:=t8d86t' F8%lB6*HA>%(%lB?4X6 (XW@5( XA XB u(d) F8%(T%lB?\N5*HA>%(%lB?4X6%XC:=%XD\AE%XD5 XB \BcXc\ HTcl8P8 H(l\8X$tdpFT  TlN 4:D]A"T GT D$" G:4H" G" G:Ht"d GdTD4"$ G$%lI6 T$tdT4$c'':DJN4KL*FT D$:4L:L:M^!pf6T$kfNT  T4h5T:DO%hP(D%hQ hRhWTS:D]A5T$hWTS% , 5T"T GThW$S" G:DH" G4" Gt:Hd"T GT4$" G%lI6"T$tdT4$chcl,lhTT$tdT4$H lX5l$ KK[l`KNh  h4x5h:XT%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% 8fX% PfX% 8fhh6h8<'' '80 44 , >0Fh !46h8  |(x$04h8 hKNh  h4x5h:XU%xP(X%xQ xRxWhS:X]A5h"xWhS%4! 4 45hfX% fX% fX% 8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8 @KNh  h4x5h:XO%xP(X%xQ xRxWhS:X]A5h$xWhS%4 ,4 45h8fhh6h8cx<'' '80 44 , >0Fh !46h8  |(x$04h8  .-TX $ X D QT[P\XrL?\=<6<,  , : ]A6<,-\A<6%X $ ` X X5< \sL1/ 4lPL\$XT<,<.(<l M\@, 9,  6<, :\V]4q_ :\Wll :\Xl :\Y]4 :\Zl :\[l :\\]4 :\]l :\^l :\l/p,l <,D.3l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , ,6H03l AH60+BH`D\0`1h/D6H0[l AH>'%'%lh_*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H03lAH60+BH`D\0`1h/D6H0[lAH>'%'%lha*F0%lhF %H:`%, $ ` , ,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P  5P;ld.@M0@P d-P  5P;ld.@M0@P d-P , 5PQ:0% , f0% 8f0% Pf0% f0% f0% f0% kb 4<$   l   $ `  p 4:0% ,  SlH4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ LK[hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'__SRP_17T)__SRP_18i$__SRP_19}2__SRP_1a!7rU $`< 4A`9=0(`@q00` DIi///$`H $A`L $`P $`T (`X/0A ` \10#/0 ` `///$ `d ,  `h//$I `l $`p $`t $ `x $I`| $` $`$ `$$I`$`$n@L@:P@ TY!@XAppp@\  tttMK[ @`!@d1  Y vvvI@ hY@l  rrr WWW h! h hh! h h-dh$ h DQd[`lhr\l=Ll=L<  <, ,: ]>    : ]>'6 L<, -'%lALh! h /h5L ls\` 0`\l< hdL<, t('tx! x lt?/tx 'tx! x lt?/tx`tx! x lt *#hlp! p ll*#`d! d 2thl`)xpd4tx! x ltp! p /t)xpx! x x:P%x! x x,($ (tlh`xpdt('tx! x lt?/tx 'tx! x lt?/tx`tx! x lt *#hlp! p ll*#`d! d 2thl`)xpd4tx! x ltp! p /t)xpx! x x:P%x! x x,($ (tlh`xpd@'pt! t lp?/pt8t! t t.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(kx?'@%`t! t `p$! $ P /p)t$5`5`t! t `$! $ T )t$5`:@%t! t t*kz,t! t | l,t kzpzkzt! t tt! t t6%,t! t | l,t6t! t tcriX@$ $pt$`P0@'pt! t lp?/pt8t! t t.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(kx?'@%`t! t `p$! $ P /p)t$5`5`t! t `$! $ T )t$5`:@%t! t t*kz,t! t | l,t kzpzkzt! t tt! t t6%,t! t | l,t6t! t tX@$ $pt$`P0'pt! t lp?/pt.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(kxkzt! t t5`t! t `$! $ T )t$5`E`t! t kzD@%`p$! $ P /p)t$5`:@%t! t t kzt! t tX$ $pt$`P0'pt! t lp?/pt.`t! t `P(@]ut5`px.z,t! t | l,tc(%,kzt! t l,Rtpx zd(.kxkz,t! t | l,tt! t t5`t! t `$! $ T )t$5`E`t! t kzD@%`p$! $ P /p)t$5`:@%t! t t kzt! t tX$NK[ $pt$`P0P  . > $ P  , < $ xd! d dd! d dZTd! d '%',%<%TLP$ P Qx/L)dP5Tx 4k*dx Qd[hr -'<%hATLd! d P /Ld5T hs d! d dd! d dILd! d lLP! P /L)dPpx4 xh LdPTDKx! 1x xx! 1x xx! 1x x:h%x! 1x x:h%x! 1x x X! XH(h]u5Xx! 1x x:h%x! 1x x D$  xXH80 X  4<@8HTl\ d P h6*:D:% 6$*F% B6*F% 5 )qtx! 1x lt! 1 l2t)xD:]1'BTtx! 1x  lt #*#*FT2txPtx! 1x   lt #*#*102txx! 1x | t! 1 :!l! 1 :""x #xh"X #XH:$8:(% lt F:4/t)x6xhXH8Ttx! 1x & lt #*#*FT2txC0 :4+x! 1x 'x5'-'(Tt FT/t")(l0 10~:*T:+::(,xDh:X:-HD8l0F4: d6xhXH8 f%x$ `x .xQD:]1tx! 1x lt/'/tx5L :/D c :0% BVp5X f   wc k!2  45>" #:0" #x`16xIl3*#t*#4*#3*#*#5*F%62 t5c(L 4 04TD d \txxhXH84<@8HTl\ d P htfl% 8fl% Pfl% fl% fl% fl% Lf\D6\L0t$  \L0 `  0   dcl% 8Efl% PEfl% E:lF%h Eh hHfXD6XH4d$  hXH0   0   dcl% Efl% Efl% E:lG%h Eh hHfXD6XH4d$  hXHTLf\D6\L0$  \LTLf\D6\Le0$  \LdX  <  P pxt4@8\L8HOK[dcl% 8Gfl% PGfl% G:lU%h Gh hHfX,6XH4d$  hXHdfl% fl% cl% :l %h h hHfX,6XH4d$  hXHdfl% Gcl% Gfl% G:lV%h Gh hHfX,6XH4d$  hXHdcl% Gfl% Gfl% G:lW%h Gh hHfX,6XH4d$  hXHTLf\,6\L40$  \LTLf\,6\L 0$  \Lh@  l  8 X`\HPLDd7rU iA *aAmaq h.Qhii lm nq!fٲ@4attt@:8I@<Appp@ @Yrrr @DanxxxWpj-`d$ d DQ`[\ldrXtl=Hl=(H8  8 (   : ]1'6 H8(kj0t: "H H8lA(" : lA: x6H8(pjt:"H H8lA(" :lA: x6H8(3'%xt`d! d ` \/t)d` lsX6+''('8:NHH 6H8(4\Xlx@ td`H8(P{:\ "l lL:<,"  : :: %!  6lL, {:\"l lL:<,"  ::: %!  6lL, $ 0 lL, @8P WW- J4l MX@H HhB FXhh88:X]4hCx8:X]4Cx8:X]4Cx8:X]4Cx8:X ]4 Cx8:X ]4 Cx8:X ]4 Cx8:X]4%Cx8:X]4@Cx8:X]4[Cx8:X]4vCx8:X]4Cx8:X]4Cx8:X]4Cx8:X]4Cx8:X]4 Cx8:X!]4"Cx8:X#]43$Cx8:X%]4N&Cx8:X']4i(Cx8:X)]4*Cx8:X+]4,Cx8:X-]4.Cx8:X/]40Cx8:X1]42Cx8:X3]4 4Cx8:X5]4&6Cx8PK[:X7]4A8Cx8:X9]4\:Cx8:X;]4w<Cx=Cx/ D0@x8hH=KW>T ? TlN((D%:$@%(%lBTA4h5T lhcy#hWTB=CAD`1d6Tchcl! E F ld=?ld! E FfD% 8EfD% PEfD% E'! E Fl=?/8! E (GR! E (G<''' H ,I>FT J6T T0ldh$T0K0 ! E F  ! E (G  @KL ? 4x57 ! E F>F%xM 6 N5 ! E F! E O! 0E O! HE Ol||>FN) 6 |lp< ! E F>F%xPAQ8 6- R$S T DUQ[hh rd :=H0hAV:W(T]u6hAQ(:" X(" X6?'@%'T%%( R$S T UQP/  P YQ [<Xr8&HXAQ:ZH6 Xs8k\:[H:T\(:@]H|:(^l`16|lp:_H:T`H:@a(:(]|Hl:^`16|l f% R$S `T b &'T%lF% R$S `T b p hsd N5 ! E (G += ! E F <''' H  ,I>F J 6 ! E (G  -eX@ hd<8(8HPhxXH |l.-TXR$S TX DUQT[P\XrL0\A,V:'6%:VMd@F '6!  ( L(L 4 @<<Ph,x@XD4th.-TX$ X DQT[P\XrL\= \A,:<( ]r  :(]1\A (|]1l\6 ,-\A, %X$ `X X5, \sL1/  4 lPL\@ XT,l\H  HlN lBH\N\A844X58t0WXM @H H8 8: ]1XW (]1'6H8  ,' %XWH ! x P /5H}\AXW XW XWH 8(  '%'%:%$ ` 6 H Xu0O8 40X\l4 H8\x! x xch% 8:h%x x xfh% Pfh% dx! x <`! ` L\! 0\ (! H( c<L,>dF)x\`(6 2+?Cx- l0@2CACx- l0B2[CCx- l0D2sECx- l0F2GCx- l0H2ICx- l0J2KCx- l0L2MCx- l0N2OCx- l0P2QCx- l0R2SCx- l0T23UCx- l0V2KWCx- l0X2cYCx- l0Z2{x- l0\2]Cx- l0^2_Cx- l0`2aCx- l0b2cCx- l0d2eCx- l0f2 gCx- l0h2#iCx-Cx/ L80 Dx0tT40 0  0K0 !    !  (  @  4x57 !  >F%x 6  5 !  !  ! 0 ! H l||>F ) 6 |lp< !  >F%xA8 6- $  DQ[hh rd :H0hA: (T]u6hA(:" !(" !6?'@%'T%%( $  QP/  P "Q [<Xr8&HXA:#H6 Xs8k\:$H:T%(:@&H|:('l`16|lp:(H:T)H:@*(:(&|Hl:'`16|l f% $ `  &'T%lF% $ `  p hsd  5 !  ( + !   <''' +  ,,>F - 6 !  (  -eX @ hd<8(8HPhxXH |l.-TX$ X DQT[P\XrL0\A,:< ( ]u6,-\A,%X$ `X X5, \sL1/ 4 lPL\ XT,p.$  $\N \B$LSK[N,L=$A"  6$LA4 H5tf7HM @$  $ :]46$Y HW$ `146$&l4 l4 ?WHHWHW$( 86$!8x >F$885$ (4M@$ $:]45$[LA$HW'%'%8$:%$ ` 6$U[LA$HW'%'%8$:%$ ` 6$ Hu}/ipP 6 l 84HL\ nn;,$x! x xAptx! x t Hlpl! l /p)xtlf\% 8f\% Pf\% e $  pxtl0   0   xDfl% fl% P:l%h h heD$  h<D4LTP:H:I :C td:TED 4$:D :H`1`68l\$dD$dD$&',%l`F<% $ `  F'%'%%: =%:,J%:<% $ `   <$8xP`dh 4l\$dD$dD$K(K!  !  (  @C<:%!  !  !    4x57!  >F%x6 5 f% $ `  ! Qo5!  !  ! 0 ! H ft>F)6 tZ ! x @p! x @  'D%'T%:d%:% $ `  )6- $  DQ[@hr<hA`1<5\hA:(d]r'6%:VMd@F 6!  ( L(L 4 @<<Ph,x@XD4th.-TX $ X DQT[P\XrL\=\A,:<( ]r  : ]1\A(|]1l\6 ,-\A,%X $ ` X X5, \sL1/  4 lPL\@ XT,l\H  HlN lBHT\N\A8U44X58t0WXM @H V H8 W8:X]1XW(]1'6H8  ,' %XWH! x P/5H}\ASXWXWXWH8(  Y'%'%:% $ `  6 H Xu0O8 4TK[0X\l4 H8\x! x xch% 8:hZ%x x xfh% Pfh% dx! x <`! ` L\! 0\ (! H( c<L,>dF)x\`(6 '%'%lha*F0%lhF %H:`%, $ ` , ,6H0/D,lhD,H0HK $P! P@(0]r Vpb5Pkb1JP! :0bN@@P c 6 Yd/6P@ ;ld.@M0@P d-P  5P;ld.@M0@P d-P  5P;ld.@M0@P d-P , 5PQ:0% , f0% 8f0% Pf0% f0% f0% f0% kb 4<$   l   $ `  p 4:0% ,  SlH4dl$P@ @.KX  X4h5XXT! T XD dD:4]>$ !   d:]>'V!  ()T 6XDK6XT T XhDT6XDT T TcT T T  4IT! T T TT T6XT T XhDT6XDT T TT T T  4T! T T TT T6XT ,T XhDT6XDoT ,T TT ,T T TT Tch/T! T (T / ,lh4 T XD$lcl% fl% 8fl% P&ef*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% 8cl% P&eg*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% 8fl% P&eh*FX%h h h5XHfXh6XH4l$ hXHlcl% fl% fl% &ij*FX%h h h5XHfXh6XH4l$ hXHlfl% fl% cl% &ik*FX%h h h5XHfXh6XH4l$ hXHlfl% cl% fl% &il*FX%h h h5XHfXh6XH4l$ hXHd4fl% fl% 8fl% P4$ TLf\h6\L0$ \Ld4UK[fl% fl% fl% 4$ TLf\h6\L0$ \LplPth   \  @TD|<HH88'I A # &!Y$$I9Y@ 4YtttI@8Appp@ <Yrrr @:@W`Zptx! x t HC``Cddlp*h+n 2phd`)xt`$ $phd`xt p$ Qpx%p'0%'@%'P%:`%x l QptJ (,p! p , Hl(*#$ *# t , 2($ )p,  t D #lt,px D p (),ppx D p $p\,tx ($ p,<4PrU L$`  $A` n &!Y$$I99a@ 4Y__SRP_1bL_VBA_PROJECT "aBXNTIAGDJHRGUDPENCZXKDVTJKAM:(,CVATNQLMXWVWTDVEIXJYFYXJREKM:'ttttI@8Appp@ <Yrrr @:@W`Zptx! x t HC``Cddlp*h+n 2phd`)xt`$ $phd`xt p$ Qpx%p'0%'@%'P%:`%x l QptJ (,p! p , Hl(*#$ *# t , 2($ )p,  t D #lt,px D p (),ppx D p $p\,tx ($ p,<4P/0!  ( J!  ( <'''  , >Fl 6l L0\$lpKl  l\NX! VK[X X3TX! X >TFl%\B$4NX5l4Al 2l  l$ $:D]46l$IAl'%'%c%l:D%X$ `X X5l T'''T XX , lT*FlA$ /TX6 l$ p<$4\,TXl$x! x xx! x XxAptx! x t Hlpl! l /p)xtlx! x Xx$ pxtl@D8H 8/ a ?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}#9.0#0#C:\program files\OFFICE11\msacc.olb#Microsoft Access 11.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll#Microsoft DAO 3.6 Object Library*\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*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation  I    8WICLKGCXXEKOAEEOSKWJEOSVNLZJ05491d8b37e$Form_Schema & Link?(H 8KYJVOZFRIBZKZDMTVEABMETEBAVK0<491ac26dModule1KW(O8BXNTIAGDJHRGUDPENCZXKDVTJKAM0i4916bac2yForm_Import TXT%8FFOQVLLCBGTAFEYUCMZIDJKOUMLJ0j4916bac2&Form_Import all XLSjYhZ8CVATNQLMXWVWTDVEIXJYFYXJREKM0k4916bac25(Form_Check SYM fileswb8DXOHLWKYSNGDWDQLOZCRFCVMLUKC1y4916be44%,Form_Join All into One{;08NQDZXPNUMBMVVDLTDAUEMKYIZJMD06491d8b375&Form_Import all DBFZ(/68VKLNWAKMQFQRAERJCYVYBZQMLJUM07491d8b37Form_CompareMDEq8JJBVETEZHOQAUDLCDEBNHZMRORVI204916be44dAutoExec0$8MXUCUQINEBKRUDAACMGXLYKLYVYJ06491ac25a7Form_CompareSym(l8HDQBTMNMONKJRDCSDDLVIRITHOVK224916be447 "Form_Check TX ZIPb8YGGGCFEIMCASRDKBHQSNFGGZEXRM0=491ac2a9 Form_ExportAll.PB8PLNJXPBMFHYVDEBAKJEEKWK[PKGHURJ0s4916bac2 Form_Test TX DBF;a?pH(P0hxD wT5Ad ǣF,qXq( pN ُwRjHbSjI= pOehɫEzIL4KKJ2/$H%RGH "SCqB9 OW)B:GG=0yV*Px}CE\TIp]V#jF1~w/T AccessAliasAnd As BBooleanCallCase=dim@DoCEachDelseGendPexplicitQfRFalseTForYFunction\Go^GoTo_ifbIncInputjIntegerkIsyLoop{MeNotNothingNullonOptionOrPrivatePublicReDimResumereturnSelectSubTabthenToTrueUntilWith VBAWin16~Win32MacVBA6# Access9dbDAOADODBsstdole` Form_Form16 _EvaluateFormDetail2Command0Command0_ClickF[Err_Command0_ClickDoCmdƧ GoToRecordM6acNextٜExit_Command0_Click<"MsgBoxRErro Description traClickTransferSpreadsheeteSa_ CreateObjectBrowseForFolder  PickFolderv=Items`hItemzPath2WScriptEcho  _B_var_Sa_B_var_f_B_var_PickFolder_B_var_WScriptLABEeText1~TE>_ Form_IMPORT?SetFocusCommand3Command3_Clicklo ^Locked  _B_var_IfP _B_var_EndFcomma0KEnabled۪Err_Command3_ClickzExit_Command3_ClickobjshellCFSOFldr GetFoldern directorymGFile%FileswXcnt+arFilesG_B_var_objShellK _B_var_FSOL_B_var_directoryP _B_var_FldrBd _B_var_FileRU _B_var_cnt<<_B_var_arFilesXKstrNames@p_B_var_strNamesstrNc5Right  _B_var_Right9Uright,UCase5  _B_var_UCasea_B_var_TransferSpreadsheet#acImport+sacSpreadsheetTypeExcel3vbCrLfA1k\F10000}+ Form_Load{wm Application*cu\curr# CurrentDbSpgCurrentProject$Currente Detail_Click/Command4Text5~Command4_ClickIZErr_Command4_ClickExit_Command4_Click?!ObjFSOe6 FilterIndex˟ InitialDir1InitFSOShowOpen~FileNamejFilter; _B_var_ObjFSOL2^L1^T1*_T2+_L2_Click= _B_var_Text1BLabel6,Label7,L1_Click_B_var_InitFSO`ObjExcel+ objWorkbookȺ WorkbooksBText2~VisibleTransferDatabase) TransferTexte>TxtFile_B_var_TxtFile(XlsFilek_B_var_XlsFile_ acImportFixedQTxtFilR XK[_B_var_Text2B_B_var_ObjExcelo_B_var_objWorkbook*Rigthile _B_var_rigthle^ Module1b(CreateSchemaFilee bIncFldNamesP@sPath sSectionName' sTblQryName,MsgQCreateSchemaFile_ErrrJws_ Workspace3db\tblDefn&TableDefmfldDefnfield3I`HandlefldName$ fldDataInfoIIfz TableDefs%iFields7Count0v dbBooleanfdbByte_ dbIntegerbdbLong dbCurrencyMdbSingledbDoublevdbDate=dbText Size dbLongBinarydbMemodbGUIDs:Space CreateSchemaFile_EndINumber- Form_Schema Form_Schema & LinkdCommand1 _B_str_Format" _B_str_SpaceCommand1_ClickVtblPCreateTableDefjConnect\SourceTableNameRefresh Form_Import TXTCellsintRow}ValueKcA\cB\cC\InfoZoutFileCreateTextFile WriteLinee_B_var_outFile2colC colA _B_var_intRow5Char) _B_var_colAK$ _B_var_colCM$dFileGetFile: TxtFileNamed_B_var_TxtFileName _B_var_dFileTxtNameo_B_var_TxtNameForm_Import XLSH Form_Import all XLSc/Form_Link All DBFAForm_Import TXT1"_B_var_DatabasePschema _B_var_schema  SchemaEnums_B_var_Gdbo _B_var_dbo? _B_var_dbvbo _B_var_vboacLinkG%ACSrAC}\aXFileAttr  DateCreated _B_var_Path _B_var_ile[acImpor^acImpoacImpacImSacIracLinChrK~ _B_var_Chr\;NamNa\^NePatPa^Filufi<] _B_var_MidppathsH tName _B_var_tNameinc0 _B_var_incA\_B_var_I  dTables_B_var_dTables! _B_var_ForjLsTab2 _B_var_sTabN _B_var_ReDimStr _B_var_StrStr1F5 _B_var_Str1TABLESTableTABLSta:_TkintColK- _B_var_intColdCol E _B_var_dColvstrMb5 _B_var_strMΚQuit9Year6nfOUND+ YearFound;_B_var_YearFound _B_var_ExitMsgBosR _B_var_MsgBos;dHeaders_B_var_dHeaders"Label9,RbtnFL\Label11ALabel13CRbtnTX'^RbtnGA/\Frame14Label15EOption16dLabel17GFrame18Label19IOption20eLabel21fOption22eLabel23hOption24eLabel25jRbtnFL_GotFocusRbtnGotFocusKRbtnGA_GotFocusRbtnTX_GotFocus folderExist FLfolderT)_B_var_FLfolder FolderExists RbtnTX_KeyPress)KeyAscii#RbtnTX_uRbtnGA_MouseDown4ButtonShiftXoYlKeyPressqRbtnGA_RbtnTX_MouseDown.RbtnFL_MouseDownT MouseDownsOption2Frame0Label1,Label3,Option4Label5,Option2_GotFocusJhOption6Command8RiVALU Option0Frame4Frame18_AfterUpdate AfterUpdate _B_var_MsgbrSectionGControlsKcouQ Option0_Clickt Option2_ClickU7Option26eLabel27lOption26_GotFocusOption28eLabel29nOption28_ClickLabel31Label33RFL2RTXDRGAL RGA_Click> RTX_ClickĻ RFL_Click _B_var_RbtnFL _B_var_RbtnTXLabel35 Ctl__StatedFolderFdF\_B_var_dFolderIRFL_AfterUpdateNRFL_$d1Folder_B_var_d1Folder md2Folder Change_T1; strFolderԻd[ _B_var_Callcha:~ _B_var_On6Nex vbCritical+}ErroQ[Er ]e\WYK[rongh{ActiveWorkbookSaveAsf; strDesktop(Save vbExclamationstrFile X Change_T2<Columnsp9HorizontalAlignmentS@Answb/ _B_var_AnswΔVbThenVb_VbY vbYesa?vbYesNo DeleteObjectTacTableansxtAndThen?2strT2a _B_var_strT2%Tehn Form_Check SYM filesRf^ Link_Tablesw _B_var_TablenStrFolde{T1_BeforeUpdateCancelva_setfdYearR _B_var_dYearvi_TruRE^RepaintLabel41Label43TbxYearTbxVinqtxbYearJ_B_var_txbYearNtbx\FalMValcatalog#_B_var_catalogcatJ}currenetabeLvbNo% Properties+ AttributesintDel21 _B_var_intDel۫ LinkTableM_B_var_LinkTablezDelOnlyDel_Link_TablesaDel_Link_Tables90|[ Form_Close[VBEAccrDBEngineQCompactDatabasedNamew _B_var_dNameddPathc _B_var_dPath'CloseCurrentDatabase3Toggle Toggle_BtnCZ_B_var_c _B_var_cAmdTableu _B_var_dTablerstrsh5 OpenRecordset| dbOpenDynaset  FindFirstM=strState` _B_var_strsԚstrMyRec); RecordsetNoMatch/3 _B_var_Untilٰ _B_var_DoResultur _B_var_ResultResults_B_var_Results4TempHead{_B_var_TempHead^S _B_var_Optionsex&]Inte\BoolDimed _B_var_Dime;toString_B_var_toString1aobjexmyFilemyVin _B_var_LeftQSimilarurrentDb_B_var_urrentDbmyTableIAllGood_B_var_AllGood״dVinɩ _B_var_dVin _B_var_myVin Command44 Del_Links<Del_Links_ClickN9DinŃ _B_var_Din@isFirst~_B_var_isFirstr BookmarkEnumI{BooleCreateM _B_var_CreategtrK_FROM~ Sym00zVINSym01{ QueryDefs&SQL"dQuerymB _B_var_dQuery _B_var_Sym00INSERTrINTO\ IsNumeric$*ExecuteY dbFailOnErrorh Form_Join All into OneLabel2,Text3~Label4,tex_B_var_myTable Command45Command45_Click^ Form_Import all DBF/Form_Import all XLS1ten csvTablesD csvFields. strFields strFieldsAs*jQuery%Forf _B_var_field(MyK^ _B_var_MystrQueryM?_B_var_strQueryUVIC505 cNamejE _B_var_cNameW VIC506 InputBox Run_RunStRunSQL _B_var_RunSQL"%Beep SetWarningsDoC SetMenuItemcfsF]SYMCommanzipmuFile _B_var_uFileIForm_ACEhinFile} OpenTextFiledLinevReadLine _B_var_inFile3 _B_var_dLine:PathT1~GetItemstrItemIntPosrstrSepaMdArrayiniPosfinPos>Trim@ _B_var_dArrayt MsgBoxGetItemT5_B_var_strSepaA _B_var_iniPosn _B_var_finPos- _B_var_TrimmT FileExistsGetArray _B_var_ItemC_B_var_GetItem}Form_~TMPCLP413391;TxtPath_B_var_TxtPatht ParentFolder7@OnlySymU1OnlymeRFLS_rt_Rg^Form_Compare MDE@Form_Import all DBF1 Command14Text15rOption18dFrame22˓RFL2#RTX2pRTG2nRGA2' RFL2_Click RGA2_Click RTX2_ClickCommand14_Click$Err_Command14_Click(Exit_Command14_Clickdan\ ImpTablesF strTable1a strTable2 a_B_var_ImpTablesOtempRDBPathe _B_var_ZK[DBPath> btnDelete6btnDelete_Click Del/ CSVDirPath _B_var_Constg MyCommand9 CSVFileName_ DeleteFileO_B_var_CSVFileNameUQCSVFile_B_var_CSVFileCSCFile1BR_B_var_CSCFile1)CSCFile2CRCSVFile2GCSVFile1FCSCVile1p_B_var_CSVFile2_B_var_CSVFile1_B_var_CSCVile1dHGetTable}dString}DefaultCompare_B_var_DefaultCompareOdefadN vbCritica`vbCriticnvbCriti/vbCritNvbCri5vbCr$vbCvbYe&Resp _B_var_Resp! btnComparebtnCompare_ClickErr_btnCompare_ClickExit_btnCompare_ClickE changeStatuszNOtNull@Exit_changeStatusɘErr_changeStatusfldLocale_B_var_fldLocalhfldRemot{Frame25ΓLabel26k Command27 txtCompUtil;Command27_ClickKErr_Command27_ClickBExit_Command27_Clicktxt _B_var_txt _B_var_False-Module2cConverted Macro- Macro1Macro1N Macro1_Err{vbOKOnly Macro1_Exit_Macro100 _B_str_ErrorR Form_StartUp CloseButton_Converted Macro- Macro2FormsmyForm _B_var_myForm'q CurrentData7AllStoredProcedures_B_var_AllStoredProcedures.i AllTablesdAllDatabaseDiagramsd_B_var_AllDatabaseDiagramsV6 AllFunctions _B_var_AllFunctionsYAllForms) _B_var_temparguOpenArgsB Parameters`FindWindowParametersstrTitlestrWindowTitle5OpenForm txtCategoryIDqfrmName_B_var_frmNamef"RneS _B_var_RnedMsgbo OpenCompare dCompUtilqdFile1dFile2Ebd _B_var_Ebd"E strCompUtilpResomsgBocR _B_var_msgBoc+ acQuitSaveAll.d(CheckCommandLineCommand]StartUp'_B_var_CommandXaempAutoExec dAutoExecSepa _B_var_SepaAJthe'sameEase#uoneH _B_var_intPosPos _B_var_PosmoreArgsfirstArg_B_var_MyCommand CformArgmoreArgx_B_var_moreArg+| Form_CompareMDEdSepainter<MyArgs( ArrayArgs`Split)_B_var_d Del_TablesExit_Form_Load gothasArgsCompaK _B_var_Select'E _B_var_the8myFSO{Txtc ForeColorBlack& Text1_ChangeXChange Text2_ChangeText1_KeyPressdText1_sText2_KeyPressText1_LostFocusbText2_LostFocus} LostFocusMSsetfoof^ doSetFocus_B_var_Err_btnCompare_ClickisLoad isLoad_FormuisLoadMeWisLoaiUsageUcutility1JKeepmindW Form_CompareSymKFrame12saa_B_var_Command3ddom _B_var_domA _B_var_Change BCalB} _B_var_CalS:chan%Err_Command1_ClickExit_Command1_ClickiSun _B_var_SunɒabcrallToOneall'tallt#Replacef_B_var_strCompUtil_B_var_CSVDirPathEmyQuery,_B_var_OpenComparefqmyQuer?DelTableKxTable; myDbfTablev (TablesToCSVdFSOUfd7]so#_ _B_var_fd CSVfldPath 9asVarian asVariant+myETableK mySQLQuery (QueriesToCSV<$myEQuery[qFSOo__B_var_myETablef TxtOutput=ShowTextf"dStrYForm_UpTestVerSSelStartZdItem^_vm_B_var_Form_UpTestVerdoHide(ShowOut= _B_var_dItemK#showHideHide9z _B_var_HideobjectsLshowHi,shodohi0 ShowOutputmdoOutput myETableThenColtoDel_B_var_ColtoDel2i DelColumnHq_B_va[K[r_DelColumnzisFirst(_dColsMyRecEOFColumniRecordseGdColumn]ok^OktoAddw _B_var_ok3_B_var_OktoAddp{dColdmyColEk _B_var_myCol2/ _B_var_StringӊdComp٣doComp6m _B_var_inXisComp;& _B_var_isComp AppendFiles1_B_var_AppendFilesmyFolderT_B_var_myFolder ,dPos _B_var_dPosutFiledReadAllU CSVFile110n AtEndOfStreamintCountP_B_var_intCountنintMax` _B_var_intMaxtJaWriteBlankLinesClean_B_var_FunctionO CleanColNamebasd"umyCols̤ _B_var_dColsgArraD Err_Form_LoadErr_CForm_LoadY Form_ExportAllhList0List2CmbTableeenabegenabkCexitsMList1 _B_var_MyRec}Calll\v _B_var_CalllI:doInit@ AddItem var _B_var_VarItemData IteDFirstidFirstB*ValidationRule%1H RowSource2CmbTable_ChangetList*Command6Command7Command9 BtnToRight BtnAllRightp BtnToLeftBR BtnAllLeftyBtnToRight_Clicky|BtnToLeft_Click4gBtnAllRight_ClickBtnAllLeft_Click RemoveItemZSelectedYlISList1_KeyPressX\List2_KeyPressU46,62  BtnToLeft__B_var_BtnToLeft_>oBtnToLeft_ClicMk5_B_var_BtnToLeft_ClicMkLabel10@ ExportAll_B_var_ExportAllM Form_testu Form_~TestJ Command12Command12_Click BtnExportlBtnExport_ClickBcmb~Li^ ListCount6Check14< ChkdoExportSchkD~cl\ CompareSym*_B_var_CompareSym acForm acSaveYes Command15Command15_ClicklVarian0~btnGoUP btnGoDOWN5 btnGoUP_ClickӲbtnGoDOWN_ClickisFound/_B_var_isFound#Intege6Boolear _B_var_LoopdoNext޷doNe doSort _B_var_doSort9CFa4]dT\ableadSortr _B_var_dSort_(GetLaststrLinechrSepa;PdChar| _B_var_dChar@Check16> chkSymOnlyCb _B_var_ListListcForm_~TMPCLP136631:(RecoverDeletedTable=ExitHereP$ strTableNamestrSQLF blnRestored  ErrorHandlerOfoB]ORDERA Form_Test TX DBFissuesAGN2 Correct'SampleZIPCODE;CITYDCOUNTYG8vbcrfl׫ (RunSQLFile._B_var_RunSQLFilec _B_var_SubAllInfouENOthieng publicSubCheck4  chkDoBatchK?Check6  Check6_Click@6chkDoSQLchkDoSQL_ClickechkdchkDoBatch_ClickgooisTable isTableOK*chkdoSqSQLfile_B_var_SQLfile dbReadOnlySMC3 SMCSM!_Sj RecordCount{hashasCityE hasCountylcCitycCountyH Form_Check TX ZIPKAForm_Test TX DBF1SrList8 ListFilesupListT_B_var_chkDoBatch_B_var_chkDoSQLaList10(ListFiles_BeforeUpdateListFiles_Click~ BeforeUpdate6ListLogTextLog3textl~Check13;Label14D Check13_Click:chkDoAllݖchkDoAll_ClickListFFontSizevbBvbBlackvbGreen_vbRedG/test4AIP2 _B_var_AIP2~y _B_var_strSQLdResp< _B_var_dResphHAVING Y _B_var_HAVING_B_var_OpenRecordsetsP_B_var_ZIPCODE> dbExecDirectM7 _B_var_SQL3Chek CheckStructv1strTabler_B_var_isTableOKTableOKOFiel) _B_var_FielVTVari _B_var_strMyRec1 setMessagesa>dTableOkCmyreRemoveNonSplitRemoveNonSplit\K[BothRemoveNonSplitCityzcallRemoveNonSplitBothDdoBoth _B_var_doboth"doRunSQLy8ot^dRes֓dre Ed] _B_var_EdGroup doRunSQL2/ doRunSQL1/_B_var_doRunSQL _B_var_GroupճDeletexUAI2Y _B_var_INSERT wasChanged_B_var_wasChanged^ isTableOKThen' dbOpenTableBvdbInconsistentRY LockEdits badStructǰokStructrtrQuestionsTableDefCTempDefk_B_var_TempDefde\ApptAppen" CreateField AppendTempDefagtDB TerrSize_B_var_TerrSize dFileName_B_var_dFileName myFileNameCacExporth] filesysAs5filesys>GetSpecialFolderQ\tempFolderfilesys tempFolder__B_var_tempFolderG _B_var_FROMCopyFilehasName_B_var_hasName (YeartoCodecaraustrinT`VarCharstrYearpdGroup0t _B_var_dGroupuseVin10usevinuseuseThenDefault (DeleteAllacQueryh (CompactDB CommandBars accDoDefaultActionAnswer,PRIVDBF ConstrainedN AuxTablesHRunModeMfWORKk LiveAnswer'dSQLFile#it] _B_var_it^ 7 %e5 7 y%   5&@@ x&%Ň\^ #TJO|Cv:U}MEtHvJ(GO8xJ(GO8^ #TJO|Cv:ME\04[LS S6<<<<<< <$<(!)L<,<8<<<@0M( *$$X$  3''HP  x   % 46   #  ^K[ NH  "*`B  2    0 @ 2     P X  "*X X9  8   )   '     "*p8 9h  8   0)  @  '8 P` hx` xUserAccounts.CommonDialog$6.0Excel File|*.xls (  ( !!@ (mp !' B@Vdcted` ! (d(oH@ (^d\vH (^k B@Vh8@`Xx XPhh`o  !!@ ( B@Vdked dh X(f dx X(fk !d'ing. B@V  !%.UserAccounts.CommonDialog$6. (cted !'oXo B@Vk B@V*. ! (d (^lected (^ X(fd X(fk !2MsgBox "You selected the file: " & ObjFSO.FileName2MsgBox "You selected the file: " & ObjFSO.FileName ! !d !dText File|*.txt ( (^etFocu v (d  (^  v$$.TXT B@V.Path v p!x v$$.XLS (^v!@ v (d A1 (^ B@2kXPScripting.FileSystemObject$6.n !!@ n%r.pkp B@Vl.ApplExcel.Application$6.cripts (0HGDoCmd.TransferText acImportFixed, "ImpSpec", Rigth(TxtFile, 8), TxtFile | %z!~a | %z!~''| | '| B@B%z | %z!~' !!@ \schema.ini n%.CharacterSet = ANSI B@ ColNameHeader = True B@ | [ ] B@Format = FixedLength B@\xCol | ="  " Char Width   B@0Scripting.FileSystemObject$6.nt08Create the schema.ini file with the info in the WorkbookX  n%.Scripting.FileSystemObject$6.n !d'FullPath to the file !' File Name ]@ X $.( CurrentDRS (%p.n n (!<B@ (!<B@v  n(tABAS B@, !'̰$Text;DATABASE= ;TABLE=  n(r@ zAttribute VB_Name = "Form_Import TXT" Bas0{7DDCFF55-844D-459B-B99F-741A014876E6} |GlobalSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT` P&* Submand3_Click(0) Se`t FSO]teObject("Scri/ng.FileSyst4em " T1.!Focus xt1.Text 'FullPath to the f(>Fd@!.Ge(TD@ .' =  PDntFold,erC 2 ,XlsD T2, &<`Exce_K[lNGB.App@TaaEA S.VisiÛykobjWorkbook$ s.Open(3N'Cu]schema.iniB` widcinfpo in EAoutAhuM(@.Current(Pro.Bc& "\", &.WriteLine ("[" & =]+CowHea`<@"a haracter)= ANS&Iat FixedLength#intRo w 3Do U ntil 3Cells(, 1@).Valua";acolAלC C3 Gt'A-$- 2."x=""/Ca@& Wid E$C77=G!+ 1Loop#eCl!Dim db As DAO., tblTADef6= dLDbŘg!~b.SD(2"RS6.CXonn ("Y;DATABASE= PW;L^CaSourc6eBb=EWCdb.sendARefresh#'DoCmd.Transfer1 ac#Q, B"Spec@jRiSE, 8)l# JQuitC0 EġLoadi,q3Fldr,8& 0 Each  In Qidg If UCp(ht(, 4))1. Then1kALock)ybPl01IEuq? e7 XLS"? j?xwRD    (); A#I9N0& Z;-'A$O0[S a!' (b )+.En!Za11(\ (ǵqM L2o'? cPo'o'bjh't'xls'er'1'c2tbq''''S''` p_G Fqe.I' )_'R'T_'/$B_'/ _' P^'      !"%&'()*+,-./123456789:;<=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxy|}~T//22qbxV|׾Gbu؆* dd~L``tUxвA~LTA6xвA~LTA6׾GbuME[LS S<<< ><<<< <$<(<,<0<4<8<<<@3    H3X   ` "  "@   " ZX & 2 B "h *pB     ( 6  7        "(@8 "04.X #  X        ( "0X *8h 9  8  8@ "   (0* :H  `    @  x    "   ` ( * <x @    P  (    "(    (p*<@    ( `     8 0 "   P  *         ` "    @ *p  `  @P   X    P0  x0!Delete Link tables logic here ...  "", "'z] '8oScripting.FileSystemObject$6.n !!@ n%r.p v p!x !!@Ad v$$.XLSkpohShell.Application$6.46.Choose a folderc:\ 4%8.  !<!>!@':k0..4 :AdK[ B@V X(fd X(fkko0UserAccounts.CommonDialog$6.Excel File|*.xls ( ( !!@ (2MsgBox "You selected the file: " & ObjFSO.FileName ! B@V X(fd X(fkkpoh` : h @pHh@HPX`xPxh0  '|H`P | '|Va Open the Excel file !~ !%. Fald'   %z!~'az@  ' ]p  %z!~'+< @<8 kd k !B@ If | %z!~ax  zy 2'2'2k 0 0)Check to See if Year Exists in the tablesH /Get the headers (First Row) from the Excel fileil Get the info from the RowsX    %(k Year table NOT found |  %z(~ (~ !~ (~End If  n%tkk (~Ifk (~If (~rExist  n%tScripting.FileSystemObject$6.nk !~T13C:\Program Files\QuickQuote\Common Files\TXCompZips'teOb  n%tkp (~ op (~nFL.SeoP (~nFL.Va (~,Ndk(1C:\Program Files\QuickQuote\Common Files\CompZips'Object !~TrScripting.FileSystemObject$6.n FL@@Scripting.FileSystemObject$6.n(Xo Ad = Fa  (~_ A PH@HPoP A P0 (~lcn (~cu (~ B@, Ms XDefault Message''`XPy@  (~5o !AA vA2)OLResults  %z(~Form_!Delete all existing Linked tablesx ,Delete existing tables and Link the new oneserisA@dAdAdAdk@xP . X(fpx !~  dk X(f !~d (fd (fd (fh B@V B@V B@V@ (~ (~ (~x3C:\Program Files\QuickQuote\Common Files\GACompZips'ik  z+F z 'zol aDoCmd.TransferDatabase acLink, "Microsoft Access", "C:\QuickGA\Quotes.Mdb", , "Quotes", "Quotes" v! v! $' v$$.DBF v p!xr.Path p!x!@ !d n%r.p B@Vosoft Scripting.FileSystemObject$6.nes", "%Link all the .DBF files in the folder $ F' z@,Compare the last 2 digits(chars) of the year v X(f XB@VetFocu B@V B@VFalse eK[`P` F V(~%z !B@P` X(f B@V#o$ X($x"AA V(  X( !B@P=  X(~%z | %z!~'Fr.Valu F$'F0Process Completed successfully  Opus Operis!A@(& All Linked tables will be deleted  Do you want to proceed $   Procedere Deletum?$('`000`xX (Set Ob $& $'d 2  y'Excel file contains INCORRECT structure  Wrong file!! A@(0@X  dBase III p!@ v!  B@Excel.Application$6.H@A~i$8's Bool "Show the Progress in the TextBoxes o8 MsgBox "Full Name: " & dNameS dName = Application.CurrentProject.Path & "\" & Application.CurrentProject.Name+ Access.Application.CloseCurrentDatabase< Access.Application.DBEngine.CompactDatabase dName, dName8oX X( thend@k8 V( X( X! dkk] ' !   %. Vin NOT found |  %z(~ "Vin  %z!~$YEAR %z!~$VIN 2$<$X | 2 %z!~X   +<z] ]@] ]  Resultsaal]Xp@]]  (] D ]H D]0   B]   ]( ] ] ] ] ]  0  B@8 Call Del_Link_Tables(VIN = ' ' B@VIN !"'"VIN = ' ' B@k Similar Vin found |  %z(~  |  %z(~0@]8 X !rdBase n Cu ( ! B@&kx8  !<V X 2$<  2$<$ |  %z(~ Incorrect Data |  %z(~xAll Good |  %z(~k(Search for the vin in the tablee  $One of the fields has incorrect infoGet only the first 8 chars:If vin is not found try replacing the 4th char with an "&"Display proper messagep | %z!~' $' TbxV0Check all dHeaders to make sure info is accuratex]pD'o ( (& All Linked tables will be deleted  Do you want to proceed $   Procedere Deletum?$('  "kA~]P oA8dAttribute VB_Name = "Form_Check SYM files" Bas0{18202A86-6464-4C7E-9E60-60741C5578A0} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT   0 0Then DoCmd.%ObjQ ac,.yG End IfNexBHEGRLTKdB PcntOIntegerVFSO, Fldr@iX+t*BingCA= 0'_fK[@all th]DDBF inBfoldSet Be("Scring.F@#System""DT1.Fo|cui0@.PGetF(@ TR (Re=G=svunt ?a@#DCUC@[(Right(AA, 4))".`"B#)= M idB@, 1, Len') - G JTransxferjJ.Q III"9.Path, :  'U MicrosofGccess "C:\Qu ickGAot@es.Mdb, "Qu$ F+ 1K2(c"9 serve I #'ĉ3 kSub Togglep_Btnmand3.VisiGl<}sa ,TbxY8ear, g%VinEE %j lI6Me.jm.Repai-/%4_Ck)e;), dHea sExcel, objWorkbxookCaAnsw, I,tCoRowAp a`&\{P!S%QaFound, Al lGoodQBoolea$babl 'OpeS 2T Nu,S.AppatS#H1= Us. (T2.ValueT1(cPfCells(0M 1) "YEARrAPn2 VINu_,F,EnaXe.AAjexistl ?1B`s" MsgBox("( winb`GelЇd" & vbCrLf_7" Do you w to proceed`SvbYesNo +` lam^ PAp/e =etum?% "g ftPNb"{new oneCEU:X:!1'Shp7 grea{@Y 2 hA trst =) fromR2(5@@@ Li@.CD+Until (((""-Or *Results")t5 qmuO+Q` 3 y? Loop+p"]0lumns(uHorizontalAliglnm`P2'U"infog!@"<.0@ "!9cxYId1/ 'myaj(]Y V6_oT_ , 20 'SSee if E\sCm\FwDJ { 'Compare the last 2 digits(chars) oflyear If Right(Table, 2) = dY^ ThenhD Found/True)dZ&b'Exit FoEiIf=Nex>t tYmDim strMyR@ec As o0rdse1Set = CurrentDb.Open&(, dBb Dyna1)[)'G)onl"yfir8  myVin\ Left(, 8Szch ftorv@AtkH.FindF!B$"VIN'" &  & "'"4cBs nottry replacing#4th9 wi@an "&$NoMat4(= I3)/@C , 4OAg#BBxDis=y proper messagԯ; ObjExcel.Cells(intRow, Col).Val$ue@8" GNOT2T.! ElshSimila:rbf> + 1'83Q! ub:AllGoo I@+3 Toa- - 1WA'Check all dHeaders to ma ke suinf s accurat<1`F(CS(tr(%V( (I))) <> }DI) kAOnefield s hasco`ct fo; VVIn DataG> H(%! (GFFagRqrr'Default MGy P$ o y GG q4O?:_?K q oR WJ{ LoopMsgBox@ "Proc AletedAcfully", vb_lama tion,p+Opus 0ris!CFTogglPe_Bt'Del_Link_2sG  mand3.EnQR i file contains INCORRECT1uctPOB Critical1 Wroq!! $  ActiveWorkbook.SavS1Qui aSub Pri:v V  45_Click(ԁUsAnswqIntegeB= x(" 2qB(s@bbe deS `&!JvbCrLfK_(Q" Do you wa nteЇceedYesNo@P$"'he ` etum?"A =P' #e#QsmoseB' dNamAlpp-. ject.Pa6\qtu R(F3 q:r^$A5.l {egb*8.DBEngineb.;actj RLoad%'!#FSO, FldrP3P`,?03Saɀ GCrep,("Script𶐼leSystemU.Fol(OFD!#RFL枨oRGAAo RTXo  $Change_T1nqSјEaFInM,UC(".X(LS" z 2(1h!|Gz & / " L1DCX) Dim Sa, myFile As O bjectPickFoldertStringt Set = @Create|("Shell.Application"^=8.BrowseFord(0, "Choose aD fx", c:\DIf (NDotIs h) Then =-.Items.PathEnd If Q, Sav  H5<> ""DCall Change_T1(VRFL.Value0Fals&e. GA TX hSub @ Priv A L2_Cfk(AoFSO, Init ̓#GC )K}UserAccounts.CommonDialogn .t= "E xcel |*`.xls" Index3)1Dir.CurrentProAxShowOpE'MsgBox "You seled the f@: " &ĀCA-eNamDe#~*B ^2( `\l@liPdRӒRH RTrSlBn`criptr"'Syso  ,A![EAC:\6graBm"Bs\QuQuote\IpZipE`.Exists(D q%:FEo!T1. Focus#vAEnablJ= e>K,"e&DGAD }|St ADJD'ſD'.EEGA?F?F Dw  ?Fb4p?FϠ?FA =FTX#<E #_ 2#b#G# E]#mE "Ent"TX"` EsFE E"4E?8 "U"ESNjstԚT 9P ŋS(Sr!T2ԌrgK[tand3.#S`m,Z ^O] q/F2c V= 1Qe OO!0 KqFo+&/*4 e1+g dDXOHLWKYSNGDWDQLOZCRFCVMLUKC:$RFFOQVLLCBGTAFEYUCMZIDJKOUMLJ:$&0HDQBTMNMONKJRDCSDDLVIRITHOVK:>vJJBVETEZHOQAUDLCDEBNHZMRORVI:%){ ( : *{;LoJLPAK(ޅ M >̅-ZD CS%xZD CS%oJLPAK(MEP@[LS S6!@':7SkX..4 PB@V}ME P(^ : P(d? P(^ P!d X(fd X(fk$DoCmd.TransferSpreadsheet , , acNext&| *!,A@(&ho`phPScripting.FileSystemObject$6.n PB@V P!d n%r.p v p!x v$$.XLS  SYM v!@ B@2 strNames = strNames + File + " "kh`MsgBox strNamesj@|8h0 *!,  v!@ A@(jo PB@V P(^ !!@ P(d P(^oX`Choose a folder 4%8.pAttribute VB_Name = "Form_Import all XLS" Bas0{FA066499-7171-4221-8051-73C9D2E27ECE} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT P&* Submand0_Click() On Error GoTo_! Set SakeObject("Shell.App'aA")fSa.@BrowseFolder(0, "Cho a f ", 0If (Not f Is hing) Then P/@f.ItemsB .Path End If/#B4JText1. FocusC LockIe"CA"G% ÃA 8`<> "" 8`3.EnyEA ĄAEAC$'DoCmd.TransferSp!@dshev, `, acN@?A|Exit :A B rr MsgBoxA.Desc riBResuP aU! pW3Wdd! ?8FSO@4W#ng.FileSys?H[X4A ldr .GetZg:@Y^ Each  In F DKAUCu(Right(A , 4)) ".ρCa9acC9d4JJ + vbCrLfF/?pM$ LA)M6m_Loada@cH.CurrentProhl 1`156bhph'Ey.a1NF<#ݢƷNKMJ,PxݢƷNKMJ,Pph'Ey.ME, [LS S(L><<<<< <$<(<,<0<4<8<<<@  pLH  `&hk $`h  %6 P%`0X @2  X x`:d` r `  X < N 8@ x p@%` V@ @ @ T I 0  P` 4kH,`<  `kpVV_`0` , ` k  %%:I  i  I.  I  I  0I  P00pXP00pX @ h @X @T @D 6PX*(@p T @8 D @P 4 @h $ @@   `p h   @X  @ @ @ ( @ @ @ H @l N d f @ h @ X @ H @8 @4 h  ` 0 z  N Px @\ `4 ( PH  8hx 0PHH ` @@L @H x@8 @( @ @ @  @ _ 8< `lK[H@p @ H @ N P@ @ @  0pX 80 @, @ @  dh@H @`  $("R@ @x @ @ @8 @ @ @ @ht 0@p X@l @@P\ @L @< @P, ( `8 @$ @ @ @  @8 @h @ @ @ @ @ @t @d @(T @@D @X4 @p$ @ @ @ @ @ @ @ @0 @H @` @xt @d @T @D @4 00@ @ ` > @0$ @H @ @ @(px@ @ @ X@ 6 P@PXPN b 6~ @H ` P@x @ @ p@ X 8< @ `hpx@ @ @ @ @ @H P0X XHP0X XHP0X XHP0X XHP0X XH@` @t @d @T @D x `XP0p 08H0  0@`xhPp@(`0  *(@X@ @<_ @: @4 @0 X5mK[ @ 8 H~ @~hl P h ( @ X @T @` P TY 8  @L_  H"`  @!< @ , @ ! @h! @8! @P! @! @! @! @! @! @! @| @"l @\ 0("0"8"`  xph$P$##@#"X#6<  @(#H @#8 @h#4 #@#@0? $h#@# @$ @# @# @ $ @$ @8$ @$ @ @ @ @ h#%x%%%`%P8<@%x @h @d @%` @8&\ @&L @ &< @P&, @( @h& @& @& @& @ ''h'N @x @h (h(P(P@l @h h)P)8)P@l @h P@l @h )))() X0(l"I$*\Rffff*224916be44*\R2*#2e*\R1*#a:*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#..\..\..\..\..\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*#f*\R1*#4b*\R1*#4d*\R2*#26*\R1*#8*\R2*#1f*\R2*#1e*\R2*#6*\R2*#27*\R2*#27*\R0*#2*\R0*#1*\R1*#25*\R1*#c1*\R2*#24*\R1*#98*\R1*#99*\R2*#2*\R2*#0*\R0*#21*\R0*#e*\R0*#19*\R0*#13*\R1*#48*\R0*#14*\R1*#5b*\RnK[1*#5e*\R1*#50*\R1*#52 4p8r<x@|DHLtPTXv\`9x "8 :H  ` @ "  ( "0,(X #      ('0 @P Xh *p  <  "   $       4I       0 P B p(` G0PX (H  p$82Y  $84Y8px  $86Y       08x " H  2R!h#x Z #X w     B;h  x:h &#  &3 *t!#j `#@     P 8;  Q  >#p X   %h 06  $B B  "B@ Cx3*  00 * xI (`# *  0G8  8 @`4^h   "@P     x    *(7X p h `  p   Lph  -  8\ % ( &JR@  (NRX  0 X  x    8   @ P Xh px <  B   (-X -(@ H P " X`  ,* 6W  ,  P   "  2  $(  P  `  pp "    "x     B  "     D ` "h  p   oK[D  xdk > Shell.Application$6.4Choose a folder 4%8.  !<!>!@':k..4 PB@V91 : : P(d (Pro ( (k P!d X(fwdp X(fkX$DoCmd.TransferSpreadsheet , , acNext& | *!,A@(;&ok]ph PB@V X(fG B@PScripting.FileSystemObject$6.n P!d n%t P!d   A8d8Loop through all tables  !<] !'d_Ba !rdBase  $~]P  %.@ ' 0 !>Pi 0! 0!T 0!l !l' k X k  Wrong ZIP field  N !~ N (~(~ 0!T 0!l !l  Wrong CITY field  N !~ N (~N !' k N (~ Goo N (^ N ! b N ( 0!T 0!l !l' k n B@P d Check if the table contains CitySELECT CITY FROM  GROUP BY CITY;  %.o"Check if the table contains CountySELECT COUNTY FROM  GROUP BY COUNTY;  %. !*  '2 '. X(fd P(dkj|h *!,A@( X(f"xhjo]@!Delete Link tables logic here ...  !<%"#  B@^ B@B ( ! B@&ki0]'] %Link all the .DBF files in the folderScripting.FileSystemObject$6.n  n%r.p v p!x v$$.DBF v!]0x  p " ]  B@^.qkoxp PB@V,Text1.Text = Application.CurrentProject.Path (C:\Quick95\COMPZIPS !P(~ ( (o (=̷ (s 1C:\Program Files\QuickQuote\Common Files\CompZips !P(~NO;oP (=.շ (= 3C:\Program Files\QuickQuote\Common Files\GACompZips !P(~o0 (=շ (3C:\Program Files\QuickQuote\Common Files\TXCompZips !P(~IN o`X v! < B@.  N (~Log.o(0 Xo0 X  < (f X kX P!d   A8  Wrong COUNTY field  N !~ N (~  All Good! N (~ N (^ k p o N (~ ] !*  ' k_Tabl . d N ( Goo N (^~ isT N (^ ODE) f N ( N (^ Tep - Incorrect structure -  N !~ N (~ & "  2 4  B@d  B@^88h`pk k,Remove City & County from NON split ZipCodesBY ZIP  B@^%SELECT ZIPCODE, TERR INTO TEMP1 FROM  GROUP BY ZIPCODE,TERR;' ZIPCOk  B@BCT ZIPkP(hh]x !*  '4 hpK[(hhh`x .  p " ok p "en p " !<B@vk8]``]A~  2  A uick95]P]8]@(](  A@  B@BmyTabl B@B "d_Ba B@B( ' "All field should be text type = 10ZIPCODEKT 5 charsCITYKT 23 charsCOUNTYKT 14 chars !*  ' ON #Remove City from NON split ZipCodes CITY SELECT CITY, COUNTY FROM  INNER JOIN TEMP ON  ..ZIPCODE = TEMP.ZIPCODE GROUP BY CITY, COUNTY;  %.8?SELECT ZIPCODE, COUNTY,ZIPCODE + COUNTY AS TOT INTO TEMP1 FROM  GROUP BY ZIPCODE, COUNTY, TERR;'   B@^ kP%Remove City & County from NON splits? $Issues$('p p "kRemove City from NON splits? $Issues$('p 8InputBox "", "", strSQL ' 75169,WILLS POINT,Van Zandt,79ZIUPDATE  INNER JOIN TEMP ON  3.ZIPCODE = TEMP.ZIPCODE SET CITY = '', COUNTY = '';'  UPDATE  INNER JOIN TEMP ON ( .ZIPCODE = TEMP.ZIPCODE) AND ( %.COUNTY = TEMP.COUNTY) SET CITY = '';' h SELECT CITY FROM  INNER JOIN TEMP ON ( .ZIPCODE = TEMP.ZIPCODE) AND ( %.COUNTY = TEMP.COUNTY) GROUP BY CITY;  %.bSELECT ZIPCODE, COUNTY INTO TEMP FROM TEMP1 GROUP BY TOT, ZIPCODE, COUNTY HAVING ((Count(TOT))=1);' II;x B@^  75027,,Denton,97QSELECT ZIPCODE INTO TEMP FROM TEMP1 GROUP BY ZIPCODE HAVING (COUNT(ZIPCODE) = 1);' NG ((C B@^]ux !<B@. ZIPCODE R7 5>B@ FRO < !~' ^#GROUP and sort to remove duplicatesCITY R7 5>B@COUNTY R7 5>B@B@  dBase III p!@ v! v! v! $ B@TEMP2 %p.  !rdBase !$TEMP ! `TERR R 7 5>B@TERRKTODE,  $ ' Terr 0!T' .Z]]X8 % ' )Create a table with the correct structure*Insert all the info into the correct table!InputBox "", "", strSQL ' 79701@ *0INSERT INTO TEMP2 (ZIPCODE, CITY, COUNTY, TERR) SELECT   .ZIPCODE,  .CITY,   .COUNTY,   .TERR FROM   GROUP BY   .ZIPCODE,  .CITY,   .COUNTY,  .TERR ORDER BY   .ZIPCODE,   .COUNTY,  .CITY,  .TERR'  dBase IIIC:\Quick95\COMPZIPS\ < !~ $ B@0:copy the DBF file to the destination with the correct case1windows always make the name of the DBF Uppercase`Export table to DBF7p9p9pScripting.FileSystemObject$6. ("Scri dBase III TEMP2 B@ \  P!d\  B xtA~EAttribute VB_Name = "Form_Check TX ZIP" " Bas0{F51461E0-C831-4E08-8C46-F3C8B23AB} |GlobalSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT  "" $C A A,Me.R@= GA FLI4$$q3HhEq!aP'DoCmd.TransferSp`xdsheC, , acNXFExitlI:C!eZ`OMsgBoxR.Desc riqResu0  aqssetMessages(dTqC .1"ZIPCOD@E" ' 5 ha^r(Q1F(.B,F5) Or DT@10Yq)U3Wrong /*p+ wh&q&`yhITY"A' 2N3//23?> ?S?r 8CO0OO?CVOO@OUNb' 14OO14OOUOOooo< o 2TERR]uUIzW2G87!epaiFr?ClHډ"#Rd neT=oRemoveNon"S0t(dAA, hasCity, okV, my4LVVdypT2X De #@SQL,9MmpQdohRunp1U2ױ`C' 4County from NON s ZipCode4O3"SELECTIQ INTO TEMP1 FROM0& ":GRO`UP BYF";" c0 OY] HAVING (C!1J(\)0 1)Q~LOnOn%H,* Yo"P NE@R JOIN {\_q9. y; vv"p5c{ HcN71 0MGǓ.= ("' 's? vbYesNo, "IssueseA4`!#UPDATE|(IN* dName & ".ZIPCODE = TEMP8SET CITY\'', COUN;"  DoCmd.RunSQL str ' 75027,,Dent on,973Enpd If If hasCity A(((Not do^1) 0Or ("dRespvbYes)) ThenK'Remove (from NON split ZipCod es_= "SELECT  ,+AS TOT INTO1 FROM " GROUP BY'RR (G)OCC1?@*, HAVING ((C ount())=1)h%'Set@ MyReccCurr@Db.Openords8et(VBKINNER JOINT k(S_]) AND _7FC)MA*;", dbA2Dyna1ReadOnlyDh(E2A C.?X > 1 CloseGAA(x<> C JdMsgBox("b s?`b No, "Issues"PA )wE aq3glUPDATEle? @@A*c5D 'Input, " )ad169,WILLS P@\T,Van Zandt,79. pk0ishing;I=eI!ok@StructΫCreate a table with the c2octur[TempDe6fʄC T@("q2NW $#e7.Fields.Ap@d .C  ("d@1dbText, 5Yh23 "dCI 14TERRTerrSizeH<"!E)" sJfresh-sert allBinfo i~* Ho . soto r3ydu`xcxAxINSERu2| (x6yBt)bD?b |*yuMz.>]~d? s$?! _QORDtP__.&Сy".B)J!NA b N970nQL,GDim filesys As Object!D= >3`criptMP=leSystemD@pFolder0H.GetS@pecial(2 G'Exp,c"O,DBF TransferDa0 acS0dBIII=w , 3O, myFA'wi ndows8wamake"8nQLof@ UPrccopy=  ![`ation\KC@UC (8#\a'w , W1.Q +"ruM+jmSub PPrivD Comm0G3_C`lick(q%FLSO=%amyR,p'dVariand'!WInteger0~֮d, tc`-Str&x!is"OK, caAs Boolea On Error GoTo_SSSFocuV(.En!,d 0FalMe0`pap] YLog@.Value"a|FontQj87ForeCol BlackS!===.S;Exist 0) A](Ln*, 1) <> "~Then +>isSOKI Check;uct((TerrSxize#%\Not chkDo.AA'5 i fe contains Ci tyT Set strMyRecC+ZOpenordset("SELECT CITY FROM 0" & B4" GROUP BY%;dbDyn@YdbRea`dOnly=!c( ".Cou4ntf1S/F CloseFFFOUNGG*?H?a-&S*R5Ord cB4y 7S C}RemoveNonSplia" $, f, %d, ?&FMVMessages (  mNextg!'Del__~Comma@nd3.End17TruT EleiWT@ 1.""DrK[a Exit_ _Cl:d  Sub  rrMsgBox Err.Descript ioĚResuxme  Private Func! #(0DimfAs V`arianD,' e !+s logic her`e ..._eKƠW0 `[_# Jȁ, 4)4TEMP `>nfAcDo(Cmd`0l`Obj`рH,iRQ?#/E->/1nkDR(Folder, AXSym, upa}FSO`, Fld@} op cS'{hAPDBF f ingfbe@ CreP!ds'ng.qSystem".Get 6 r 0Q 8p(UCh(Right(". ; n8)?M #7AdtdI Hc %  @U"TransfPath,  , MidWЌ - ,F c'(>&@m_Load5>CLFocu''CQAp`caEB.dPro0. Me.RTX?S s⨠"C'SGA0FavV1FL;\-53Q, R=qaGAPj\@(1X#Z)Logc] A r ; c1G`gr0am F:SQuote\A_ontpZips_ YS GA_ _ .=^ )_ k_ \GA N -\  s\TX ˁ@ xMEH@6 %K@  xHPx* Check value returned by Command function.kkHi@8 t !@` ` $'` t!$ @]|C] u  'e ] t!  B@e of tk(] D8 Read the Argumentsoxi# First argument is the form to open file"7If the Argument = (one of the forms) then Open the form O   $$'     $$'H Arguments should be separated by a char not allowed in file names ex: |C sample below: P !MsgBox moreArg & vbCrLf & formArg "C:\Program Files\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\hsepulveda\My Documents\stuff\vbs\Tools.mdb" /cmd "CompareMDE |File1 |File2"  kd'tAttribute VB_Name = "dAutoExec" Option Compare Database`Explicit ' Read the Arguments*sample below: E"C:\Program F-s\OFFICE11\MSACCESS.EXE"" (Doc and Settings\hsepulveda\My $\stuff\vbs\Tools.mdb"Z E"|Q|;1j 2'Kt @shoulds A2aratey a char not al $inw ns ex: |%Firs isform to o FunBcheckOmqLine() D Con#dSepa|U 0Dim &X, more As Sng IntPosA@egermyF# VarianG}' CA$ value re0turn@) f.. If Len(D) > 0 ThenC+y1UC G+= In1(8?DwA <ED= Trim(MidD+ 1,B,D) -K)H?-- 1 'MsgBoxg& vbCr0Lf &n>Elo0"}AEIf GE%"""/= Ea(ch D?Iurr`{qject.xAllB@}i' !(one $of&[s)An }a @z.A) FiDoCmd. ,`s:='m'A Nex^)et KYJVOZFRIBZKZDMTVEABMETEBAVK:_MXUCUQINEBKRUDAACMGXLYKLYVYJ:(+NQDZXPNUMBMVVDLTDAUEMKYIZJMD:@PLNJXPBMFHYVDEBAKJEEKPKGHURJ:*-N"}+ OKWxME  L&(LX , 0!LL*LPLL*LPLLLLLLLL6 LL<!@ x 27>.. .5'65l BKTBit'8 DKTByte'8 FKTShort'8 HKTInteger'8 JKTCurrency'8 LKTSingle'8 NKTDouble'8 PKTDate'8 RKT Char Width 5T$ '8 VKTOLE'8 XKTLongChar'8 ZKT Char Width 16'8n  4Col 2 $ =" 6"$ \ 8q( 2q SCHEMA.INI has been created.A@('^ 4Vz" Error #: *!`$  '   *!,'  A@(^`iXP] Loop through all tables | !< |!.CSV' v  n% v  nB@k 4Export tables to a CSV file in the CSVDirPath folder%SELECT * INTO [text;HDR=Yes;Database= v].  FROM  |!'~ B@d ~ B@^]Phe k8 i]8Scripting.FileSystemObject$6.n.n'xK[lP]]] 8Scripting.FileSystemObject$6.Loop through all Queries  ! !.CSV' v  % v  B@k 4Export tables to a CSV file in the CSVDirPath folder%SELECT * INTO [text;HDR=Yes;Database= v].  FROM  !'~ B@d ~ B@^k.'iExport all Tables to CSV filesExport all Queries to CSV filesh |!$$MSYS |!$~ !$$MSYS !$~ 1Temp tables or system tables will not be exported3Temp Queries or system Queries will not be exported ]H  '2_ 2$'  2 '2kH  2 2 2' i Get Last Char ]0X i  *!,A@(ti pzh.( B@d H *EXIT/ERROR*$k(No recoverable tables found dA@(<!@  ' k' 3A deleted table has been restored, using the name ' $' dRestoredA@(]; B@^ B@dSELECT DISTINCTROW [  ].* INTO  $ FROM [ ];'  $~tmp  (%<!'  (!<!@ *Procedure*$.(*Init*]]`]x]]*Declarations*  iUserAccounts.CommonDialog$6.kk   n% k ( B@ !'SQL File|*.SQL (Scripting.FileSystemObject$6.n  n%z.x x!'Lif I B@dts.x L B@^ p]X]pXExecute a SQL file ~A@Xp L L $'L remove Cr LF[text; h]@   $'F0`Jd 'Fk F80KTFA' 81KTFB' 82KTFC' 83KTFD' 84KTFE' 85KTFF' 86KTFG' 87KTFH' 88KTFJ' 89KTFK' 90KTFL' 91KTFM' 92KTFN' 93KTFP' 94KTFR' 95KTFS' 96KTFT' 97KTFV' 98KTFW' 99KTFX' 00KTFY' 01KTF1' 02KTF2' 03KTF3' 04KTF4' 05KTF5' 06KTF6' 07KTF7' 08KTF8' 09KTF9' SF' tn i ]Delete tables logic here ... f !<Delete query logic here ... ( f! B@&i f !0  f! B@&xCompact and repair database...Database utilitiesToolsMenu Bar$ %%%B@" ik f!$$MSYS f!$~4Attribute VB_Name = "Module1" Option Compare Da@tabase`Explicit FuncZYeartoCo@de(str) As Sng Dim d2 0If (Len8> 2) pThen8<8=@ Right),'"El( ,A"nd If Select CkI  "80": UiAU1B2CU3D4EU5F6 GU 7 H 8 JU 9 K 9O\L O\M O\N O\P O\R O\S mO\T O\V O\W O\X 0/.Y/.a a0/.2/ /.3/.4/.5m/.6/.7/.8{/.9dEs aa'Execa S@QL fil`Pub yK[Run݀F`)cObjFSO, inaQuery@ ",Set  Create ("UserAccounts.monDialog"Hc. 8ter |*.@(*Index3( ShowOpǧGeg#A/gt&@ Scri ngAeSystem  )E<> ""@1Existsf6l++d6 =.aTexta$, 1H* 9= .Rea0dAllga'remove Cr LFMidg, z)< -vx!1J NothiUDoCmd.pWarns (FaP|l c- 6H)qE4G0*Lash 0%0 I?H PHport all Tables to CSVIs SICTo (0fldPath78myEVariantt!236w00, my_`B(a Q(d=_-I?<9<3'throughbp`For Ea,ch I urrentDb. 8Defp1'TPemp 3 sCwipnot@ be exend U`ft(.!L, 4)) aFMSYSR"bLe_1C~[ & ".(XAK@& MO1Dtea !1I-1)(a( O thAPMSVDirr'fxold<%#mSELECT * INTO [t V;HDR=Yes2;E="@"].1_ q FROM InputBoxc,2g /T/T+T8! 1NP4 ].sr>$TruЉqjX%D:i?D\TOD_KDҋNDqOD q\ODrkqODCOD$ YD ZD"_Dp gDDDse(Left(myEQuery.Name, 4)) <> "MSYS" And 1~" T@hen CSVFile = & ".6" ZIf qFSO.2Exists($fldPath3 )hs;Delete& < rEIf 'Export tables to a = fd@in theDirKfolder !mySQL}"SELECT * INTO [text;HDR=Yes;Da3ase="pv"]. _,Bt FROM  DoCmd.SetWarnings (False)Run}0 2  QN7Cs@@NothEiesToT= True  Functio Public  CreateS chema>(b@IncFlds As Boolean, MPsqStr@) "MSYS") A3 1 ~I5/Object acB,)s w I qpuerybHQD:F:CompacXtDBE:mGBars("Menu @").Co ntrolTo3*Da_ 2 utilitiesd epai8r d$@@accDoaultADY* l:l=F>l\:(Cz|LzOX A֙zK[^9 HZEx HZE\:(Cz|LME [LS S(L>< <<<< <$<(<,<0<4<8<<<@ l `l &C:\Program Files\WinMerge\WinMerge.exe ~@`$k@ @ i  @l 8  `k d I xI gi  @0\ @L H: @n\ @pL `vH @8 `r4 @:Hl  ` `Lkh -  `p-Hkl 7 `p.Hkp? `HktG@4l `h  %%6% `1Hk|W ` Hk_ :`xoh D&&!`:d 4x `(k` 00X `/HkxO X`f\ I" i  `nx ` & H i LP`LkgL`1Lkk6P2*  l0`8kLLL` 'hkHG@4l `h `:d BHi  WinM i @\ @RL {K[h `@Dk8 T `p!k T&&I `LHI  i  2*0 @ll `h `.0 f@X X @`T   `)k XI  I @ `P p 0 Px P  p0 P`px@  `Pp0P @ h x   `H$k\  `Pp0P @ h x  `k < @(  `Pp0P @ h x  `Pp0P @ h x  `Pp0P @ h x  `Pp0P @ h x `phx ` 0@HD @4 @x$ @ @ @ @ @ @ @ P:@@l @h @X @H :@l X@h @@ X @H (X@ 6:*(@T @P @8@ @P0 @h @ @ @ @ @ @ @ @ 0P2P6@(t @@d @XT @P @p@ @0 @ @ @ @  8T~  @ @ @ :*(H|K[0 PP @h @xX @T_ @`D @4 @$ 0 pX@:@l @\ @L xX(pXpH @@l X @ ( @X @T @P @L_ 0@@< @X, @ @ @ @ @ @ @@ @ @  P @@px @(h @XX X+H@H @D @h!0!p @!XH8 (@8(l h@ 8 (`h\ @j8 6 @ $  H @  @H ` @? `!H @ $(@H! @ @ @ @ @  @@ @ H 8+8#@"""p"(""@"   @X" @ @" "p" @h#_ #"@" @# @P# @ # @# @ @# @# #h#@@_ ##$#_ @$ @#t @($d @p$T @@$D @X$4 @$$ @$ @$ @$ @ @ "#`P%&&&&0&%%%H~ @~%l %% H&%( (@&X @T @X&P p&0&@L_ 'X&@&< @&, @& @ @ H@ X&''' @z @h (@}K[)((((6P:*(@)T @P @)@ @ )0 @8) @P) @h) @) @ @) @) @ @  H ***6$("@*T @*D @+4 @+$ X@(+ @@@+ (@+ `- @h+p+x+@+ @+ @@, 8+`0( +@, @(, @X, @, @p,t @,d @,T @-D @,4 @,$ @0- @- @ @ P:H*(.@..H-@l @h @X.X @H @/X/(//P:(/@l @h @p/X @H : @l @h @0X *////H/@H : @l @h 000100@1X @H (0122281:@l @2\ @L 22 pPp`8"PI$*\Rffff*06491ac25a*\R2*#2e*\R0*#2*\R0*#1:*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#..\..\..\..\..\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*#f*\R0*#19*\R1*#5b*\R2*#0*\R1*#8$*\Rffff*0<491ac26d*\R2*#24*\R1*#a*\R1*#25*\R1*#98*\R1*#99*\R0*#e*\R1*#c1*\R0*#19*\R0*#13*\R1*#48*\R0*#f*\R1*#5b*\R0*#1448vp@DHLPpTrXt\`dhlxt|x<n2 " I~K[   B   "-0@s .0@ -H  B  (-0 *( -  (0 B * $(8p (0 F ( 6  #@  P  6X p   #    `h p x  " P"8@(8 "@4G@ h#x        < 08 h" "4G @#Phpx       HP X<`p x " h (h  p  8-X 0x   : H H?&  @ x Pls87  847    &  p " 8  0X ~2 c@   *( "X      X `hpx " (  "H8 p8    0 ("    * "(c   p.@=  .@=x @  $H (> +     H P0X `<h x B 8@X  ,h* ,"7  8 0&P&H8 ("'`2[`0"'P2[x8  @ H  P X "`  x      X  h  x  "       B  "(  0  0  @ DP  "  @     D  "      K[ <H  "    (  8 <  "       <  " 8 "@  x0hShell.Application$6.4LYV  !<!>!@':k`..4 : : P(~ ( ( (xk@@]pScripting.FileSystemObject$6.!~>oP&p|h` *!,A@(&Ho@dk6 PB@V 2(f B@PScripting.FileSystemObject$6.n.n]]']+Loop through all tables j !<'> j!rdBase Get all fields in table j!'"$ "$'R]8   %. 0 !> > 0!, '>  SELECT VIN, VIN7, LS, PD, OS, CS, PIP, "VIC505" AS NAME INTO SYM FROM VIC505 GROUP BY VIN, VIN7, LS, PD, OS, CS, PIP, "VIC505";Choose a folder P!~ 4%8. d INSERT INTO SYM ( VIN, VIN7, LS, PD, OS, CS, PIP, NAME ) SELECT VIN, VIN7, LS, PD, OS, CS, PIP, "VIC506" AS NAME FROM VIC506 GROUP BY VIN, VIN7, LS, PD, OS, CS, PIP, "VIC506";k8 B@d L B@^'k 2(fA:Jk@88|06( *!,A@( 2(f8o]P!Delete Link tables logic here ... f !< f!rdBase ( f! B@&kix]h]%Link all the .DBF files in the folderScripting.FileSystemObject$6.n  n%r.p p!x!@ v p!x v$$.DBF v!$'r rZIP r TAISO.MDB  r$SYM v! v! $'  dBase III p!@ v!  B@ !(](@cLBoth Textboxes must have info *(`es"k] P!~$ !~$ 2(f?If one of the required files is not found change the font colorui !!~ %t !(BlackzFolder2kkki P o ( ( (oH` ( (1C:\Program Files\QuickQuote\Common Files\CompZips !P(~o ( (3C:\Program Files\QuickQuote\Common Files\GACompZips !P(~oX ( (3C:\Program Files\QuickQuote\Common Files\TXCompZips !P(~o ( ( ( (rfilep (rogram (Done\ (# (## (+\\Carfilepc\public\Programmer Files\Done\GA !(~(do  ( (## (+\\Carfilepc\public\Programmer Files\Done\FL !(~!ko  (# ( (+\\Carfilepc\public\Programmer Files\Done\TX !(~!oo !(!Redblic\P "G B@Vj\ !P!~ %t !P(Black !P(!Red "G PB@Vj# *(`Folder1UtA:A:h ]xDelete tables logic here ... h !<#؀K[# ( h! B@&.zH @@ If an error disable button 2(f> i A:k i A:A:A:A:A:A:oA~](@]XShell.Application$6.46.  !<!>!@':!@k(..4 : : (~ (  (  ( kA:L|J *!,A@(LxopChoose a folder !~ 4%8.er",]D + P!~ n%t !~ n%tSELECT > R AS NAME INTO   FROM   GROUP BY  > R;'L INSERT INTO  (  >NAME ) SELECT  > R AS NAME FROM   GROUP BY  > R;'L ] 0 ]H ]&C:\Program Files\WinMerge\WinMerge.exep WScript.Shell$6.l)Open default Compare utility If it exists"$ "$ "$ "$ "$ "$ lB@Zd *Default Compare utility not found ask UserC\ 6Default compare utility Not Found    #Do you want to open compare utility  $  Program Not found$('. . " Locate Compare utilityUserAccounts.CommonDialog$6.Compare Utility|*.exe (C^ ( B@ !Open Compare utility!"$ !"$ "$ "$ "$ "$ lB@Zk@ .k0 k( .lo @ AIf is the first time, run the MAKE-TABLE QUERY else 'APPEND QUERYAAA:(p H`. (! !B@V  B@P#oP k(   !~ (~  o kA~Hide all objects in the formagingB  (se !(dg !PB@Vrk  B@Pze [12 !(~Hide the TxtOutputShow the TxtOutputADeleting dBase table f!Adict dSelect Folder 2Select Folder 146MAKE-TABLE Query INTO  FROM  A]P!Event Click on the button compareCheck if the folders exists tablep ! TxtOutputgeSizeLinking table v!At2.ValAPPEND Query INTO  FROM  Ax h!$$MSYS h!$~8Process Folder2To8 GDeleting table h!AjProcess Folder1_TProcessing Folder 2  !~Aro8AProcessing Folder 1  P!~A dk ExportAllSymbol1 B@HOpening Export Wizard... ASymbol2ATe("Sym( CompareSym B@BP|XPSymbol1ATx P!~ A8 !~ A8Pdx $  'Linking table v!A  dBase III p!@ v!  B@XAttribute VB_Name = "Form_CompareSym" Bas0{4F8EB87A-A158-410D-B41B-D699D75EEE39} |GlobalSpacI False dCr@eatablTru PredecldId"Expose_Template DerivCustomizD$Option DT  <licit Const str!UtilC:\Program Files\WinK[Merge.exe Pub$ Sub ShowText(dStr As ing)  TxtOutput.Valu& vbCr`Lf &  SelStart(0Me.Repain1End! $KM FuncADel_TaHs(do!'B@oolean'D0im xB VaXriaC'e{s logic here . .. Eac hI_urre ntDb.De fs CIf UCd(Left(C., 4)) <> "MSYS" A@61~" Then9A Callg"3@f "^CDoCmd.?Object ac3,:B-SG AbIfN  AchLinkEid 2E22& ?3 In`W*(%.dn, "dA") > 0/,- =--?._2.chaHngeitubSetFocus`On Error GoToA_iaemyFSO2B = e("Scring.!Syshtemc"' Both Abo xes m` have infocbtn.Enaz((Trim(!1Ëc5g2 AI Txit :@!ResucYBO`wone of the requi fa is not 8fouwc'font colorFolder2@ '.Exists( k}3`eC! a 'Black Ea255 '8Red`doEB\22.eG@E.Number@1 '$&71rOeO`G OOB1OA0OQN#v/N@,U%h8&!'!an e7dis- Pto]/~D*p#,WrS@{pPEm_Cp|k($1LYw` 'y` p,Pwq@:man|d1gE;ES0a, fEPi|ckcSaSaGhell.Appa!GAfSa.Br0owse4(0^Cho a<:", P8SF(@ Is )a = f.IOsR.Pathsy3 A Zq=( SARTX2(%GA FL r$ dXue$4W+ PWAA,Ŝ2OPMsgBox9Dese200,X @J,d0,q4#,a ,StrB&,,@,*,er,VS,`,7,,~ ,:,=, Y, (TX,q*GA+{++a++ +K+I+U(J,)+`ToOne(da'Fields, t, ccQuery V(QmyDbffA%-isF|ir0YS u= v"1A'Looppr`ough ʳ  For Each myDbfTable In CurrentDb.HDefs $IfXStr(z.Connect, "dBase") > 0 Thenn'Get all fields in t~ %tName =. $c$Chr(34) & 6&  0'@is the>rst time, ruA MAKE-TABLE QUERY else 'APPEND ''Fi$tvDim strMyRec As ordset#S=POpen(p, db Dyn|t)&-.F] ! ^n&jB`Y"xNex_5Nothi4ngO'ASELECT VIN,7, LS,@ PD, OC IP VIC505" AS NAME INTO SYM FROM@A GROUP BYA;'A@BQueryE"'"A H& L#} dB%"N ';"$CAShowT](~"ɭ)BBA,FE\ i2INSERTG,()B2) 9P96'g86$_BAB6"|8$(8&!v`& "> ""~.`+֠ؠ"S_ChCd%G_s2A 'Dlqnot fouPask UsUq = MsgBox("%cS0a F" [7o4vbCrLf IF"Do you wano ov nExclamation + v@bYesNoi Program $!_ 'Loc1|&?,+/,Acc`tsmmonDialogi@ltern7|*.exe "TAISO.M?CDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~h) )6Z\[~TMhNWB QG!.]q4LeI<3x]q4LeI<3[~TMhNWMEX`[LS SL<<<<<< <$<(<,<0<4<8<<<@<<<<<<<<<<<<<<<<<<<<<<N0{2042858C-DBE8-4751-99CD-7F2196A42EE6} p(% p`kx%% Zp`k|;;(  `\k0p8%4h% ~H`8 k   c`\ @4l  L`Hhk6PX*(`:d`nx  p0@n\ `@pL `vH `h ` i  @XT `%p0pH p0pH ( L`HhkL`@hkp0pH p0pH @ 8p0pH  p0pH Xp0pH p0pH p0pH p0pH @XD K[@4  @h @$ 8@ @ **@  `0X @@>H @(8 @ p@ @( @RX `L@@@(@ @ @ @h ( PXP6~@ (@ @ @X @( @ @@ @X @ @p @ h 8 *(@  @8 X`r4@ | @ l @@ h @ d_ @p T @ @ @ < @8_ ( @ ( @  @ @ @ *  @ p (  H~ ~@~ l    (  @X X X@T @ P  p  @L_ 8 @< @ , @  @ @@  H8  xPXH 888pP@8Hl `8HX6  @$  @ @ ( @? h @P @  @ @ @ @ @ @ (P @x @t @p 8@l @\ P@l @h P  8`k oh I I i  8@l @h ((P @l @h (K[l h @P(l h @P(l h 0@`x I$*\Rffff*06491d8b37*\R1*#af*\R1*#8*\R2*#2e$*\Rffff*0<491ac26d*\R1*#a*\R1*#25*\R2*#0:*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#..\..\..\..\..\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*#f*\R2*#24*\R1*#98*\R1*#99*\R1*#4b*\R1*#4d*\R1*#c1*\R0*#19*\R0*#13*\R1*#48*\R1*#5b*\R0*#14 4p8r<t@vDHxL|PTH "P  ",(  @#Phpx         '   * (0 8<@P X "`p  x     *h78  <P -  x 0   :0?P&  F d\ h~p 8&p      ( P0   (<x  08 B   (-0 -    B @X  ,x*( ,"7   8  0&P &H  ( 2[0 hh  2[ h      "@ HAX p     p "     B  "  0  @ D  "  P  ` D0   x0hShell.Application$6.4IZJ  !<!>!@':kX..4 PB@V : : P(dk P!d X(fd X(fk$DoCmd.TransferSpreadsheet , , acNext&| *!,A@(&ho`pScripting.FileSystemObject$6.n PB@VA~K[  !<= 1 to !rdBase UCakXP > 0!, '>j@|8h0jo PB@V !!@ P(doXp]!Delete Link tables logic here ...  !< Do !rdBase  ( ! B@&?k0(i  n%r.pH]@]]X%Link all the .DBF files in the folderScripting.FileSystemObject$6.n p!x!@x v p!x v! v! $'  dBase III p!@ v!  B@aDoCmd.TransferDatabase acLink, "Microsoft Access", "C:\QuickGA\Quotes.Mdb", , "Quotes", "Quotes"]]k]xixdk P!d n%t P(d'>'' dkLoop through all tables   %. !'Get all fields in tablen p]h"$ "$'R 0 !> L B@^`A~@If is the first time run the MAKE-TABLE QUERY else 'APPEND QUERYW SELECT VIN, VIN7, LS, PD, OS, CS, PIP, "VIC505" AS NAME INTO SYM FROM VIC505 GROUP BY VIN, VIN7, LS, PD, OS, CS, PIP, "VIC505"; INSERT INTO SYM ( VIN, VIN7, LS, PD, OS, CS, PIP, NAME ) SELECT VIN, VIN7, LS, PD, OS, CS, PIP, "VIC506" AS NAME FROM VIC506 GROUP BY VIN, VIN7, LS, PD, OS, CS, PIP, "VIC506";H  B@d P!d n%r!' n% *!,A@(SELECT > R AS NAME INTO SYM FROM   GROUP BY  > R;'LINSERT INTO SYM ( >NAME ) SELECT  > R AS NAME FROM   GROUP BY  > R;'L h( H X(fmmand3 X(f= fals B@P0(  X(fx@ o` oP  o@ ( ( ( ( ( ( ( ( (1C:\Program Files\QuickQuote\Common Files\CompZips !P(~3C:\Program Files\QuickQuote\Common Files\GACompZips !P(~3C:\Program Files\QuickQuote\Common Files\TXCompZips !P(~ ( ( ( Choose a folder 4%8.F%H ]  Pk v$$.DBF v!$'r rZIP r TAISO.MDB( kdk P!d   A8n](@  dBase III p!@ v!  B@aDoCmd.TransferDatabase acLink, "Microsoft Access", "C:\QuickGA\Quotes.Mdb", , "Quotes", "Quotes" r$SYMx $  ' @"Attribute VB_Name = "Form_Import all DBF" Bas0{2042858C-DBE8-4751-99CD-7F2196A42EE6} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT  <licit P/3 Submand0_Ck()n Error GoTo_* Dim Sa, f As Objec- PickFolder2SngSe.t!e"("Shell.App$a5"%A f Sa.BrowseC(0, "ChoV a fB", 0If (Not*Is hing) Then#,= f.ItemsB.Path End Ifg#Sa(JT ext1. Fo8cusC $H<> "" $C A A,Me.RTXODGAF~LI4$$ā3.EnǸE?A )3'DoCmd.TransferSpldsheC, ,0 acN(VExitQ:C!YrrMsgBox!Z.DescriBfResu0  af! g3g!cFSObAmyT& fieldVarianCfstrFs, d, tcQueryjisFirstBoolea`ZxxA5>S7!Oepaia!e` != ,yc,ng.FileSysj|Ez`N.xa/stK[s(PmtCel_Link~_)i( , R _Or fGADE(= #aa0eSO.GetD.A3C)bG'Loop throughb` Each mB Iurr@entDb.bDef! D"`ا@)In C( `.Conn d") > 0-'fbP in DR L VChr(34) &Y$ `MyRec,`ordse1D?f&@'fOpenv(4dbaDynpthq`+:<e@;`& R!@hlLu'4is@#e0!=ti Iruhe MAKE-TABLE QUERY eV 'APPEND#?An'SELECT VIN,A7, LS, PD, OpCIP%VIC505" AS NAME INTO SYM` FROM GROUP BYӑ, ; O "I&&   +1 o ;_ nH INSERT() 66 P6"r  ]" OD"" a/& /r uH`BWarbns (҇? RunSQL ( Wb*5 kehEvhk'g`G%`@~ KO ;H dFunc D|!`f`'e~js logic here ...sovovjv SototT$c Cr|,5~I##1? q2EnlpySymt+p, FldrPЗqc !7, uљ_uhat0h.cilesfQy@p)__tݑ ²FSO.GetFolder(strH) (ReDim dTables(Fl dr.Fi(.CountTFor@ Each 4 8In NIf (UCase(@Right(V, 4)) = ".DBF") TXhen15uR= 9 .Namex![InStr(/, "ZIPO= 0) And  <> "TAIMDBo&t0JMidR8, 1, Len) -_ W YeartoCode(() & _OnlyxSym)L(eftq3SY M"DoCmd.TransferDatab€ acLinkJdBIII",nPath, _z>-'Microsoft Access"C:\QuickGAotes.Mdb, "QuA DLEvIfElseS ?C,q?B3BANext AFunctio @n !Private Sub `zm_Load(EdmT1.Sc<<<<< <$<(<,<0<4<8<<<@ @ `4 @ @ (P6~@ P @2 `4 8p @ ( X  8p @ ( X  8x (  @ @  p @` p P @L ` !p H_ @ ! @8 @0$ @  * _  *  x-@x @ @ @ @ `@ @ @ | @l 8h@\ @L @< @, ( @ (M( H (0g8 `8H~ @~l XP(  @ X @T p@`P x8@L_ p` @< @, @ @ @ `hH6  @4 @$ @  H @? X8 `K[  (`hpx@ @ @ @@ @ @ @0 @@ @   P@@x 0@h P8p0@l @h P@l @h 0P @l @h HH @`hI$*\Rffff*0s4916bac2*\R2*#2e*\R1*#8*\R1*#25*\R1*#a*\R0*#f*\R2*#2*\R2*#0*\R2*#24*\R1*#98*\R1*#99*\R0*#e*\R1*#50*\R1*#52*\R1*#4b*\R1*#4d*\R1*#c1*\R0*#19*\R0*#13*\R1*#48*\R1*#5b*\R0*#14 x4|8<t@DHvLPpTrX\ "  "  " ",$@p"      ' (8 @P *X  <  "x     *7@  <X P  @    @    *  "  ` ( "H P 8 H (  ,  .  0   x-   0   Dp( &( 8$8  $8*  $    p  H$8  $8*8  $H    x X$8  $8*p  $8      H H 0p    &J]K[ X (N]   "~Tbh `8  P X  (    *0  .  0`  0  ,  .     `0  ` &8 p x  <  B   (-0( -H` h p " x  ,*  6WP &H 2[  "  2 ($ 8 HX "` h xB "  DH "P X hDxx0hShell.Application$6.4GHUChoose a folder 4%8.  !<!>!@':k`..4 PB@V : : P(d ( ( (xk P!d X(fd X(fk$DoCmd.TransferSpreadsheet , , acNext&p|h` *!,A@(&Ho@p]  h PB@V X(f B@PScripting.FileSystemObject$6.n P!d n%t P!d n%r!'Loop through all tables  !<'> !rdBase Get all fields in table !'] 0 !> > 0!, '>Hkx X(fdX P(dk@j8|0h( *!,A@( X(fjo]`!Delete Link tables logic here ...  !< !rdBase ( ! B@&kh`iX]h]%Link all the .DBF files in the folderScripting.FileSystemObject$6.n  n%r.p v p!x 0! n v$$.DBF v!TAZIPCODEKT v! v! $'  dBase III p!@ v!  B@ko  PB@V ( ( (oH` ( (1C:\Program Files\QuickQuote\Common Files\CompZips !P(~o ( (3C:\Program Files\QuickQuote\Common Files\GACompZips !P(~oX ( (3C:\Program Files\QuickQuote\Common Files\TXCompZips !P(~o ,Text1.Text = Application.CurrentProject.PathP C:\Quick95\COMPZIPS !P(~pCITYKT COUNTYKT Ck kk 0!T 0!l  0!T 0!l  0!T 0!l 1ap B@BSQLName Size Type Field B@CI   0!T 0!T  $\  0!l 0!l  $\ CITY B@ DBF files with issues  B@ssueHd kUNION  B@   0!T 0!T  $\  0K[!l 0!l  $\ COUNTY B@H P!d   A8A   0!T 0!T  $\  0!l 0!l  $\ ZIPCODE B@ A~------------------------------- B@ A~ AGN2 23 10 CITY B@ Name Size Type Field B@** **** Correct Sample **** B@ C------------------------------- B@AGN2 14 10 COUNTY B@   B@itAGN2 5 10 ZIPCODE B@ WScript.Shell$6.l.n.l issues.txt'' notepad  lB@Z  n%.k  k    d8  d(  d k k k Del C:\Quick95\COMPZIPS\ .DBF B@Del C:\Quick95\COMPZIPS\ .DBF B@Del C:\Quick95\COMPZIPS\ .DBF B@P ok' @o  ' k]' ' ' ' k k issues.bat'WHERE CITY <> "$"$ OR COUNTY <> "$"$  B@SELECT ZIPCODE, CITY, COUNTY, " " AS NAME FROM "C:\Quick95\COMPZIPS\ .DBF"  B@ '2 k   %.xk !* k !* SELECT CITY FROM  GROUP BY CITY;  %.SELECT COUNTY FROM  GROUP BY COUNTY;  %.] ( '2 '4 '4  Check if the table contains Cityit  2 4  "Check if the table contains CountyConstrained: False  B@ True"*/  B@  B@RunMode: Default  B@AuxTables: True  B@ Type: DBASE  B@ode:  B@/*  B@ALSE"  B@Answer:: PRIV: Answer.DBF  B@e.Writ Alias: WORK  B@AnswLiveAnswer: FALSE  B@0]@ X p ALL1.SQL'4 4  n%. Gnotepad 4  lB@ZjhٶAttribute VB_Name = "Form_Test TX DBF"  Bas0{5ACF7018-9C12-405E-851F-BB20DE4C3F45} |GlobalSpacAIFalse dCreatablTru PredeclaId"Expose_Templat@eDerivCustomizD$Option Comp@ DTi P'+ Sub chkDoBatch_Click()  If Then SQLj7 End If ,43&2L@ "" $C A$ A Me.R= GA F $Q83.En_glEu!aP)'DoCmd.TransferSp|dsheC, , acNC(FExitlI:OC!krrM sgBoxR.D`escriBvResu 0 llDim myTBAs VariantC astrFields, dFiler!J Sngis" OKBooHlea m3#C;P4Kepai` FSOKu#)ng.Sys@gcyw K.k@,sts(GM-qCall Del_Link_"fK( , R1[Or bGAdD!Get.%Gls 5@issues.bat!_aa!<'"t~xd!A ALLQL 2out3+(K! pAf) O(d9, | .Writee (8"/* _inQ?L1Answer:: PRIV: .! Type:ASECon: 0ed:cV__AuxS+://@RunMod e`fault??Alias: WOlRKL  FALo("*/__9ytJ7sQ5.J! "s with #6 " & v`bCrLf!/("A0Size"qrZ("-g'Loop throuxgh NP@ PEacheIPurrentDb.'DefA fH'xD@In g(mk.P/n da") > 0_B, 'Tb fl in   b@t=e VUqMyR ecn`ords>es/aJ = BCVOpen(vbaDyn`tReadOnly!w=2<f @`p}/_Q& -,1SelK[ C ("ZIPCxODE?er!(".1`5) uDR2@10m|Zu/7("P@ C:\Qu9@5\COMPP S\?&& "a/{3&A8& (3 - Len)@6 6` Q6.,IW 3 isTableOK = Fa`lse  E`nd If:Case "CITY"BIf (field.Size <> 23) OrTyp10) ThenMQchkDo`Batch$3outFile.WriteLine ("Del C:\Quick95\COMPZIPS\" & tName".DBF")LECE6?& String(3 - Len), " "))& CVTMra9"4 `OUN014???%REpcRR GYRKYC9_R __R SR!Select8NexŜSQLDim cCity,ounty Asąo #@Tru4cC = ws 'Check if the t contains Set str MyRec CurrentDb.Open`ordset("SELECT ! FR OMTGROUP BY;", dbDyntReadOnlytJ@.."!@1̅*I&1s?'ec"5" "2c 'F__8 ?A`k(c/77f-D(`CODE,&Pbx"O6)AS NAMED"//F"*F ("WHERER AChr$(30n& " OR VodUNION3S.3T7Call _`tk_bs!N8ot p(vbCrLf0|A(" * CoLct Sapmple2 (~" pspFqo-//AGN2  5A010t///%23% o("146c!CloiЇ Command3.tEnAjdSn!iFSOp#h@objshe@'= CreateO bj~7Scrippt.S) .Run "notepadldF F0*)=Bg 0 c{Tl1.Q" @ Exit__4Cl:d Sub PrrOaMsgBox Err.DesioT_Resvuk\Priv Funlctm@(:myAVarian 'Dete 1Ds logic here ...sFor EaIn '1DefGInStr(.Conn"bdB> 0 DoC4md`l` & ac, N@ame E nd IfxNe@xt LFunction<Private Sub Link_Tables(strFolder, OnlySym)\Dim FSO, FldB\LH(?%H+[}x$>ڍE|rX:x$>ڍE|rX:>B\LH(MELK[[LS S<0,< <<<< <$<(<,<0<4<8<<<@<<<<<<<<<<<<<<<<<<<<<N0{FD833F8C-25E2-48E6-8992-152B5B7D78A8} X:(% x`lkHC:\temp\`'C:\Program Files\Excel Compare\xlsc.exeC:\Quick |`.f@vH 8%\\mainnt2\QQData\Testers 4 `xlk<ee t `kL`x %%   `)k  ` dI @I() `i  BpH  `& k( \ H`h `x %  ( `x+kd **y  `X/Hkl  `p0Hkp `1Hkt i' (@l %%   ` 5Hk `@!kPP2(P6@ll `h  `2Hkx `4Hk|i  0`x el`>  BPHBF@ Hb(4 @`   (@  BBH0XxP` 0 @ X   P`"kT$ 0`kDI I I @H @L8 `8 BH@( @x\ x 0 (`7Lk `8Lk X`hDkh @++i  `X bn (@  `  X P0x@  0>i    (@  `  X P0xK[( ( x0 X`P@  @P @8 @ @  @` @( , ( `XkP8&&y`$L  `@6lkL `8lk   ( x@   0( X (` P`h`d Bh  ( x@   0( X (` P@8 @0 ) pi  ( x@   0( X (` PX  N xx H `  H8` H@0 @O @` @x h @ P8@ x@ @ ` @| @@:*(@l h ` xx4 @X$ @ T x@D `@`0@`( 8h h `%k8 X <i  @p (@ @ @ @ @ @ @ @0 @H @`t @xd @T @D @4 @$ @ @ @ @ @P @ @ @ @ @_ 8P@X @ @ H  @p @ @ @6@@ @ @ X@l `2j ( !xh Hh ( 8H@ P @` x8@ `@o p$(@ @ @@ `b @(t @d @XT @D 2*' 6$("NpK[`xHP@T @D @@4 @$ @ @ @ @( @X @ @p @ @ @ @t @d @T @`D (@04 @H$ @ @x @ @ @ (x`@l  H ` 0 6P:*(@ h @x X @ H @ 8 @4 @0 @! @ @ p$$(0!"h"" "!P) 6:*(@P"h @8"X H@"H @"8 @4 @0 @" @ @ H$####6N:*( @#h @#X @@$H @($8 @4 @0 @X$ @ (@ (&$XH h$@$l (  @$X @T @8&P 0d#P%X%`%h%p%x%)$$`&&%$$ !P&%@L_ &8&@x&< @&, @& @ &@ 8& ((('('''H @'l ''' )' (l@(\ @L :` ` -o`( h ++I" (i  @(< @(, @ @ (H @)l '`)() )!) @+X 9())))  )`f\ ) @*+*p)*())@)H)*@*H @D @B @0 @, @0+ @H+ @`+ @ K[ %,,,0,`,,-PN@H,P @x,@ @0 @ @ @ @ @ ,(4,* h3-`(@.(.p.-.-H: @:-l .-- 6P2*N@X.X @.T @.D @.4 @.$ @@/ @. @/ @ @/ @ &0/@ (0@00/BP:@l @h @X0X @H @1X1(11BP:@l @h @p1X @H X2p2@2(2BP:@l @h @2X +222222@H 33332F: @l @h @3X 33@H 4444F:@l @h @5X @H 5655F: @l @h 1@(6X @H 66@l 777:@l @7\ (@L 88@l 999:l @l @9\ @L 8:X@l (\ @L 1  `8K[ ,I*\R2*#26$*\Rffff*07491d8b37*\R1*#4*\R0*#f*\R1*#8*\R1*#a*\R0*#2*\R0*#1*\R0*#e*\R2*#0*\R0*#17*\R0*#19*\R0*#13*\R1*#25*\R2*#2e:*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#..\..\..\..\..\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*#f*\R2*#27*\R2*#24*\R1*#98*\R1*#99*\R0*#14*\R1*#c1*\R1*#48*\R1*#5b8<x@|DtHpLrPTX\`dhlvptx| h V Rx 08 (    d8 $ <"P8(@ @ ` p x *$[ (c P    h <8 *n0     (  /$B "+0 &&xp  "8&&    *$ $X%$$  : hiX``JpX # ! ! !! !!!p  h  `  4# H X`   #  )"  P pHX   *$ $8%%0%` <  $ $B @(8(  >(,HH( Fh& & & ,&& & !& 0' 8' H'X'`'h'  p' x' '$1' ' ' $'' 3(((0( ) `& " H @!X# 0# * -!' #! %P! p!4R"'" !*8" (#  " ## ## ($ # @$)`$ "*$#8#`"  0!X      x p P " Px  4) 0 ~2 ch `   *  "    (  8 $ `  0 p  X "  " (0 *80h K[ "      <  " *"  H X h"x    p  < "   * "P  x   $     <( B  "- $? -X hp B X 5p H    X    ( @  H p P X  0 h  8  @8  @  0 xB x <3<[@ 3<[ 3 <[ 3<[  P  N (x"(( $H 0 (J >;;H;@ 0      ( 8 X$H  0X    B * $ 8 H F 6(@8`#@ h@ 6 ` x#X x 6` h` h  xX " p   &p  8 "@ X H  &h "p x   & "   *&  "    *&80 "8 @  P(&` "% % % %% " "% % % %% ")x0Ao8x(]UserAccounts.CommonDialog$6.#State MDE File|tx.mde;fl.mde;tx.mde ( ( B@h ! ! P(~ ( (( (erSprekH (@0Both Textboxes must have info> 6k 2(fScripting.FileSystemObject$6.nA]  !<p thro B@d ]C:\temp\ kA:K[k !$$MSYS CaddA:z@ !PB@VA:File1 2(f~j 2(fk@6|08 *!,A@( 2(f8o]) f !<i S'FLKT = ""k.n`iX !$' Microsoft Access !@  2 B@cessi oH` ( ( B TX\TX.MDE !P(~o ( (oX ( (o  ( ( B GA\GA.MDE !P(~o  ( (oP  ( (o $$Mid(dS].&8|0( *!,A@( &o]UserAccounts.CommonDialog$6.State MDE File|??.mde (  ( B@ ! ! (~ (erSpre (, acNe (k A:A:( A:A:A:A: P!~ n% !~ n% Microsoft Access !@  1 B@ Loop through all tables ( f! B@&(m f!$$MSYS ) < !P!~ %FloridaCompanies'n P!~ n% !~ n%A`A:>.|` *!,A@(FiokPH !.CSV'@ L B@^P TXKT$'  TexasCompanies'GAKT`GeorgiaCompanies' !$' k   n%   nB@ WScript.Shell$6.lWi h d *Default Compare utility not found ask User  . "!Nk Locate Compare utility.lP ] UserAccounts.CommonDialog$6.Compare Utility|*.exe ( ($ B@  !@ Delete old Tables Import the tables P!~ !~ the4Export tables to a CSV file in the CSVDirPath folderSaUaUaScripting.FileSystemObject$6.aaa P!~$ !~$ 2(fid( B FL\FL.MDE !P(~]C:\QuickP F\Florida\Beta\FL.MDE !(~a"oR]H  !N(~UserAccounts.CommonDialog$6.Compare Utility|*.exe ( ( B@ ! ! !N(~k0A: !P(Blacke UtkT.|R *!,A@(T0]'C:\Program Files\Excel Compare\xlsc.exeA) "C:\Program Files\WinMerge\WinMerge.exe"`PU ! !N(~utilOpen Compare utility ]\\mainnt2\QQData\Testers F\Texas\Beta\TX.MDE !(~ F\georgia\Beta\GA.MDE !(~ (X (  (F (eta\GA (!( (p'xxFile2ll k] %kd@HXo8!"$ !"$ "$ "$ "$ "$ lB@Z l"$ "$ "$ "$ "$ "$ lB@Z 6Default compare utility Not Found K[    #Do you want to open compare utility  $  Program Not found$('.8P.]`] N!~'%d  n% ]]pIf an error disable buttonBrowse For File1f ( ( ( ( ( (Read Arguments on load" Expects File1 |File2 |CompareUtil]|@ H Arguments should be separated by a char not allowed in file names ex: |  $'()]0Split the arguments.Value$$ !(~Import the given tablesDiferent tables per StateDelete tables logic here ...|    !N(~] dk  'A4dkBrowse For File2le6 Do the Validation & error handling on the Click eventBrowse For Compare utility6The name of the file MUST have the state ex: FL123.MDE 6The name of the file MUST have the state ex: FL123.MDE !P(!Red8The name of the files MUST have the state ex: FL_123.MDE?If one of the required files is not found change the font color !!~ % !(Black !(!RedCompare Utility !N!~ % oA: o !N(%Black fil !N('Red font @ "G B@Vjb "G PB@VjbtnCA: "C:\Program Files\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\hsepulveda\My Documents\stuff\vbs\Tools.mdb" /cmd "CompareMDE |File1 |File2 |CompareUtil"  B@,H *!`kx *(` *(` *(`]'(d'( (G B@Pjbt$$ !P(~$$ !N(~* "C:\Program Files\Excel Compare\xlsc.exe" Usage:e K The compare utility is not required by default it looks for Excel compare:ogram P /cmd " | | |[CompareUtility]" Keep in mind that Quotes are requierd if path to any of the files contains spaces, I will recomend you using it all the time. ex:} "C:\Program Files\OFFICE11\MSACCESS.EXE" "C:\Tools.mdb" /cmd "CompareMDE |C:\QuickFL\FL.MDE |H:\Testers\Florida\Beta\FL.MDe"8]H x D ?k $ '7Columns to be excluded of the CSV files (USE UPPERCASE)NE]`]](@QUALClean the Columns from a tableORTE takes a table as a parameterNGON 0  $SELECT  INTO [text;HDR=Yes;Database= ].  FROM  ! ORDER BY CompanyID'L8 H  ]H  . ! Companies ' Fkd $%SELECT * INTO [text;HDR=Yes;Database= ].  FROM  !'Lx !! 0" k@"d8"GeorgiaFinance'  d"k"d!k!FloridaFinance' TexasFinance'! !$' Microsoft Access !@  1 B@ !$' Microsoft Access !@  2 B@0"( o.x A, CSVD. kk##k0 B@B v!$' t 'kScripting.FileSystemObject$6.: v  %r!x( xB@B ]K[( mp v! Companies'$  kk 'd8 '    $.CSV6NOpen File for readingn%Open File for appendingCount the Linesz v!@ %z. ! x! B@$P%     A%%   % v!  $Finance '%k& N!~ n%','Finance B@X%]h  &   G d 'j& !aFile  ' B@~Do UntxP&    B@ S' v!@ %z. B@B'Open File for reading   %z.x&#If old Schema file exists delete itld She  schema.ini nB@k&#If old Schema file exists delete it&  schema.ini nB@kx&  schema.ini n%  schema.ini n%`& o@( ( ( ((o( ( ( (' (Clean the Columns NamesIF old file exists delete iti@( !  %.' !%Loop through all Columns in the table  !>' !$' )Loop through all items that should not be    'y@'k8'0' Add it if is OK  [ !], ' k&&Delete the last 2 chars (", ")    $' kx&kp&]0]`$EMAILEMAIL2FREENEWRENEWALVERSIONSTATUS PROGRAMMERQUALITYCONTROL INFORECEIVEDREADYFORTESTINGBY DISTRIBUTION WHATSGOINGON BRIDGECONTACTBRIDGECONTACTPHONE BRIDGEEMAILBRIDGECONFIDENTIALITY BRIDGENOTESD'' ' )-Open default Compare ut ility If it exists)Attribute VB_Name = "Form_CompareMDE" Bas0{FD833F8C-25E2-48E6-8992-152B5B7D78A8} |GlobalSpacI False dCr@eatablTru PredecldId"Expose_Template DerivCustomizD$' Usage: ' |*< 1 [Ut@ility]'@ The c u is not requi} by default it looks for ExcelP"C:\Program ?s\<\xlsc.exeKeep in mind that Quo0tes Zerd if path to any of e f@=sntains sws, I will4e@you usinjg.a@t;N. exT,OFFICE11\MSACCESS.EXE" 6Tools.mdb" \5 |>QuickFL\FL.H:\Testers\Florida\BetaA Op tion  Da@licit Const CSVDirPׁE@t\UDke '9 WinMerge\DpfldLocal@F"ARemot\\m`5nt2\QQaE#dSepa!|@DimP Load_Z As B/ean aDo"AVal*A"(& errRhpandl>*>C'k even`(P@p@q Sub (btn$_b() myTp*/F O,!01&2, strQuery" m, dCF Sng# FSOAObjec(On EPGoToA_ Me.Text1.Set`FocusG.En!If 2N4is-n R`2i& ` R = ec( "Scri@YngR.A#Sy_mc"* (6ue <> "") And 2.aCb ExistsI D )@G e'Deleold <%C`_'ImpportBPBnj' na( MUST have stQ FL123a" (G; Pj,1>.).+ SVA5an@n`Y%XA'Looprough aL "x Each mE5I Ourr@9D|b.`6L)UCP(Left(.Qn, 4))B$MSYS"/ 2is5= In @8L"aniebs(> 0 5'ClGr=umPg1 @ 4K,uA4p! D3-E2IfO q_Q'IF A.Aspo3}/Qe!=N  & "."@8j& &8!9 (?le2'0 SchemabV "s.iniP%O mar/ QO'ѪKb:2s'ferP.<qDSELEC8T "$/P% I@NTO [tk;HDR=Yes;M=K].1_?  u'+ FR OMm- ORD ER BYsnyID_.EÏ * g2" pb21 g?O# DoCmBdWarn`s< (OK[72RunSQL (a_$Np1$_o/U$2/ N01; BAppΑ sSL{G1txtpaZc ?@n{W If FSO.FileExists(DefaultCompare) Then ,strJUtil = nbEnd If . !Call O(pen(t, CSVDirPath & 12) X h bt6.Enabled!nTrueEls%SchangeStatus(9 u  ?$ t_R_Click:'old Schema f e delete itO~JS"sB`.ini" AD?B\Ka 0SetTNothingxit Sub @7rr7MsgBox Err.Descr`iptio\mResume N'Clean the Columns fro m a t "'kes aam@Wr Func% "N@(dTA A,s )StrADim MyRecordlsekd#AV arianmys, dIte8m,  Ok toAddABoo!0 to:6(V#' to be`IcludI@bofc$SVLs (USE UPPERCASE` =Array("EMAIL", 2!FREENEWREAbVERSION_#)v "S TATUSaPROGRAMMERQUALITY@CONTRO INFORECEIVED  READYTESTINGBYA DIS@TRIBUT"WHATSGOBRIDGEACT PHO>N!RFI`DENTI' N:O`"J5kH= CurrentDb.IP.aREbDynaMD #I`6"".`u#S.EOF 'Loop@Aroughv Fihf7For Each YInd Fieldsk=U= \= UC( "DEOidsat shouxnot[Gj EZ $bpgFae / ɩNex%'|if is OK U}! sP & "["0vY"]< 'cce l@ast 2 @srC-x Len() > 3cNQ Mid, -  ZV aU]jPrivatSub Apdaps(dFwerwW Umy@s, in, o utObje>c\"^dPo^inunt!tMax, JIntegePhA0 300 qqBCre 3("S3ungSysp2F61 1.GetE)< = Right(DH5[C, 4) "j." InPn"nie>sU Q1P%B> 0Be %H @%- 1)q/Finance"1aD<"& b'Y  fSPdW%=@1TPAQ1y$?"&;Li neZDo UFn .Atp6Of eamouq+ 1ReadiClo1Q >=7$=Co 79CS%|%_LaK7%%O҄%, N8%ReWr0wBlank# (0=I- ("7//#."Allz/!AtKZ6`Tij$ =?w" Sub Private OpenCom@pare(d Util, dFile12)  Dim ob jshelDObjFSO As ectFResp.Intege"r0Setx =0 Cre9("WScript.ZSZ"n7' default  utility If it exists3 <> "" Thenb.Run Chr(34) & & " " _  *25Else 'D}{not found aspk UsM= MsgBox("!cCzONF3= vbCrLf, MM "Do you want t(o o '", vbExclamation +#YesNo,kProgram~ A7HE6Gvb@ A'LocaǚK@A# AbAccUts.monDialog!.ter"E@|*.exe" A Index@3ShowA !' eNamefaMe.txta.ValueLK xu`r-saiGr#Gm tLurErIfkERhing')i%",aPbtnDelete_Click(ĨCall _Table 'BrowဌFor 5 mand0 On ErrGoToA_k 5A B$ !kf eSttMDEb|tx.mde;flgJfde3c>Text1a`gRTX9Fa?GA|FLa7KB;c hangea!us(B ? Exit3:SOA c.DesypVSupBko00*-&2/& &14?& =&EO&jD& /&e ("/&ϜY Y,&??%O%erO%aXO%Wp A%2O%l2ZC%2#S% FLu%!%%AE%No'm' 'd'! /'D|ɯK27''E''oeroh' q 1&*''S''0"o~=HX(###%#=Gr##/Ks#dJ!FuncstnPt!nVariO0n1x tv ic here0 ...vEa,chQycIPurrentDb."z/UCase(Left(., 4))abMSYSDoCmdp\ P&P acb,6}YNmSeGet2(dStropo,B@ooleanĉ'Dif!pkBWSc`ߐ Mid, 2) "FLZ!1dk PT"Florida7nies?1WFinancݻi TX  p bas   GetTable = "TexasFinan`ce"  E nd IfLCa@se "GA LIf doComp Then  ڀGeorgia- anies qlse"@(ES H@u@Select?  Functioi 'Import the given ts Privahte  s(str1, 2)0Dim tName As String ' n of6fiMUST have st8ex: FL12`3.MDE(= q@.5, TrueE oCmd.TransferDa3xacC:, "Microsoft Access"11.Path, ,1` & "1T$$Fag$le~$2HH2H2HG#G]#]Read Arguments on loada "C:\Program FSs\OFFICE11\MSACCESS.EXDE"DocDa!Sett@]s\hsepulvK[e@da\My \stuff\vbs\Tools.mdb" /cmFd `are] |12 |@reUtil@+'should be arfy a char not allowed in S"mAos ak|EtxpsSub Form_ L%(`ZOn Error GoT:oA_?IntPos, I!egerArray0s()c hasAB9%ea= Len(Open) > 0%+'SpliCaACF& , dSepazas _ʚAMe.`t1.ValuATridm(#0) 2ŕ1txtaHH=U2E Defaul @V&AlxitA:Cq RTX*~gGAoFLoTX2ɏGAFLL_ Q0is, d s C3 btn8_Click00.Numbe:r0/?ahQu)&acaSPnAllWy 8* 9 @rr?$e.=  ResL EP9Mub΀pFngeS{us(doOFQs*AA1>myFSO>O,bjp = CrepM("SPcrip1V.1RSystem"@c'Both 4boxes mustӅinfo3QW.End((R78) <> ""I@7"y/Nexd'$one requirCZZs is\fou3ont colotT'>2S bpsts(@7 & KP[ eCQ,'Bla.A 255 'Resq1 r12.%" :41s.tS)L81.1qSGB 'E Zity#< ?oodi/ );N8濱E%K 31an edis: butt;P(RLL5M0T RFLC^a 0a3!Ol.ROl}fl@dLocalaFL\FLqf}y ( Ea] GA ?s.ve  != GA\GA= ag_ F2TX {??5"TX\TX.M@DE" Call changeStatus(False) End Sub Private@ RFL2_Click(LMe.( = 0True&TXN2&(GAText2.Value0fldRemot & "\Florida\Beta\FL- z\ R\ q\g eorgi\GA?:\G*\ ì4as[[G1_COTXGAHLostFocb*P'X+2_q+ˁHoA:iOwd]!aPF}LkgV]hI*xgV]hI*oA:iOwd]!aME  @SLS S)L NI Hh    xp]C:\temp\0RDH]  (^M  (@ Loop through all tables  !< !  B@. k( CmbTable.SelStarto  !@  $ !@  $ !@ ;  !@  $ (@ d  !@ $ (@ k  (@  (~kho` $ !@   !@   !@ ; $ !@   (@ d $ !@  (@ k $ (@ $ (~ko ]`]x  !@   B@V  !~ ' 2  !  2  %^ ' y(k   !~ $ B@.   !~  B@\   (~ 2 $ !   G 2 '2j 2  ,^ d  ,^ kpdh  ! G  ,^ jk8k0o(]] $ !@  $ B@Vx $ !~ ' 2 $ !  2 $ %^ ' yk $K[ !~  B@.  $ !~ $ B@\  $ (~ 2 $ !   G 2 '2j 2 $ ,^ d $ ,^ kd $ ! G $ ,^ jkko]@]X  !@   !~ ' 2  !  2  %^ ' yk 2   B@V  !~  B@\   !~ 2  B@.   (~ 2  ,^ khk`kXoPp]]  !@   !~ ' 2  !  2  %^ ' yk 2  !     B@V  !~  B@\   !~ 2  B@.   (~ 2  ,^ k kko x. x>AT ko@ x, x<AV kox]] $ (@  (@  !~  %. !  !> ! $ B@.  $ B@V $ ,^ koRead Arguments on load x  (@ $ (@  (@ $ (~  (~  A,   (^AB k|   (~A, oX  !@ Scripting.FileSystemObject$6.n  !~'' _ IF old File exists delete it  .CSV n%  .CSV nB@k #If old Schema file exists delete it  schema.ini n%  schema.ini nB@k   !@ NAME  $ !@ NAME ' @ ' Right([NAME],2) AS [YEAR], [  !@ ;], [$Z]'[  !@ ;], [$Z]'' kk B@d Symbol1 erySymbol2'' d' k .nkho`X@dP !$$MSYS !$$~  ] [VIN]$[VIN], [VIN] & "&" & Left([NAME], 1)$Z' ] 8 HAVING (([  !   %4 ])<>"$"$) ORDER BY Right([NAME],2), [  !@ ;], [$Z]' ' hxH0P Symbol1  !@ Symbol2  k0  SELECT  INTO [text;HDR=Yes;Database= ]. .CSV FROM    ;'L  GROUP BY Right([NAME],2), [  !@ ;], [$Z]' ] $ !@ VIN;   (h.l]Phk]&C:\Program Files\WinMerge\WinMerge.exelesp  n%'xb0 WScript.Shell$6.lp"$ "$']S InputBox "", "", strQuery [VIN]([VIN] & "&" & Left([NAME], 1) AS [VIN10]$Z'    \Symbol1.CSV   \Symbol2.CSV lB@Zbo L B@^   (~GAttribute VB_Name = "Form_Export@All" Bas0{62AA3329-5E6E-4919-AB24-ED6BEC6B711F} |GlobaBlSpacFalse dCre atablTru PredeclaId" se_TemplateDerivCustom izD$Option Comp@ DT  <licit Const CSVDirPathC:\t>\Default'Program Files\WinMerge!.exe P_c Sub doInit() Dim myT]As V`arianI Cmb .LockI? RowSourh"@'Loop through all Bis EachIIurrentDb.@;  If UCN(LPeft(+.K[, 4)) <> "MSYS" And _C1~" The n >AddI]b JNAEIfNexDN'SelStarA _ cBtn@6_Ckf 0wy= D I[#o]A Ct - 1c)`yected(I)?EI eExit  \?@ oA1.{2?h Remove7l& I1. !Is= H(0) M cQ &D# ? q_ 26K O6 O6O6 @oc 4?O6qD6BO6 g.O6-F6L /1.y-5O6SqO6 O6%q"J6EPL6[q O6nBLO6O6 1O61L߿ cQO6t O6O6PO6"btnGoUP+6q 663iz6 4Wj4bCjT&T24444 4 e(a+=a %j#U:, J`8mb3lf)/qa R+DOWN++++p o 0 Then  isFound = False pFor Iho List2. Cbt -L 1 ZIfNSelected(I)}Tru |#Exit %lEIf Ne\xt fA(I < (f)TSetFocus .RRemo@veItem.V alue)Add,+"") #~) MSub Private Bv1_KeyPress(Ascii As IntpegerD;\G= 46) Or &_- 62]Call BtnToRight_ClXick (21(4E(0(Lef'CmbTable_Change(KDim MyRecARordseDdColumnAVarian1.RowSourceQXd = CurrentDb.OpTen(.RdbDynaG<NotC .EOF|!Each eIndFieldh%b(d.NamgG{+reĎ6= _GHuseVin10.Vi si1 '(InS trH*, "VIN;") > 0$A~  `bAd'Read Argum)s on` loadkg"m _L>On ErrGoToA~_&0;>B19D<odoI niLyLen(@s!=KF a&FLocke!΋$d7$/{%:D1rrnRes`9> !ϧj>ɢ@Expor$z&Bg8`<> "",'|strQuery,es„S GroupStpringc!FSO, objsheObj` dog, hasa5, CompareBooleag5 1Cre0`c("@Script`.FileSys0o"(2d" DO'd lI ' Do'IF old q exs dj+a1  `sts(CSVDirP@ath & & ".p>Q!D"?le4 E, f Schema f  "s.in>i_ ! 0\ ma і[q`%-5'(hV2k`VNAME aVXn{& Q (("Symbol10_ 81*I([Q ],AS [YEAR], [" Repplacet? ;"@b)!]ϛd>= " GROUP BY <?ฟa v7 HAmG (&(" t2.1DaChr(3p& ")wX" ORDER) "iENQs(7"M` mW ++U*+/+fe) (:[](("&h& 1- 1) -10]\i 6+NA>P1) 7Us1SELEC.T3\вs1 I@NTO [t;HDR=Yes;5-b`=",`"].+TaFROMn3<md;!; DoCmdB.uWarn ts (rLcRun`SQL (L'InputBox@Q CPoable = "Symbol1") And (InStr(CmbT.RowSource,2> 0) Then dn2"FoNext!#TrueOpenComparFSO.FileExists(Default) =ElsOdnFaEyIf  #Loop W:h8  Se t LaNothingIf e"objshell%CreateObject("WScript.S" tDim d As @= Chr(34) & G. #.Ru"nD& "@& CSVDirPath"\č."2>NQ?e$CESub t TXT/&H00000000 Module=Module1 DocClass=Form_Schema & Link/&H00000000 DocClass=Form_Import all XLS/&H00000000 DocClass=Form_Check SYM files/&H00000000 DocClass=Form_Join All into One/&H00000000 DocClass=Form_Import all DBF/&H00000000 DocClass=Form_CompareMDE/&H00000000 Module=dAutoExec DocClass=Form_CompareSym/&H00000000 DocClass=Form_ExportAll/&H00000000 DocClass=Form_Test TX DBF/&H00000000 DocClass=Form_Check TX ZIP/&H00000000 Name="Access9db" HelpContextID="0" VersionCompatible32="393222000" CMG="383A89EF8DEF8DEF8DEF8D" DPB="0D0FBC1544EB45EBK[45EB" GC="E2E0534429452945D6" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_Import TXT=57, 32, 643, 579, C Module1=44, 44, 741, 591, Form_Schema & Link=66, 66, 763, 613, C Form_Import all XLS=10, 29, 751, 483, C Form_Check SYM files=278, 303, 983, 853, C Form_Join All into One=88, 88, 837, 534, Form_Import all DBF=-76, 158, 967, 774, Form_CompareMDE=-177, 4, 794, 545, dAutoExec=9, 103, 814, 708, C Form_CompareSym=229, 16, 1044, 645, Form_ExportAll=66, 66, 1188, 406, Form_Test TX DBF=88, 88, 722, 717, Z Form_Check TX ZIP=132, 132, 766, 761, Form_Import TXTForm_Import TXTModule1Module1Form_Schema & LinkForm_Schema & LinkForm_Import all XLSForm_Import all XLSForm_Check SYM filesForm_Check SYM filesForm_Join All into OneForm_Join All into OnePROJECTwmAcessVBAData Forms nB`^$+0A,mi05f\ql < BForm_Import all DBFForm_Import all DBFForm_CompareMDEForm_CompareMDEdAutoExecdAutoExecForm_CompareSymForm_CompareSymForm_ExportAllForm_ExportAllForm_Test TX DBFForm_Test TX DBFForm_Check TX ZIPForm_Check TX ZIP  0289=Babce ghi.j%kBBlob PropData46TypeInfo7BlobDeltag϶n@I(>*zAO*'. U Lucida Console"[Event Procedure]d2 Tahomahgh Tahomam45 Tahoma` Details>ȠCŠZІh1U`a8bcPL2..."[Event Procedure]HNext Record PNmIm7UF`a8bc,kT2Ti2%I)eP! h1U`4aTiCommand3 IMPORT"[Event Procedure] 72Ck$x2h1U`abcPiL1..."[Event Procedure]Next RecordB a HBGXm7UF`abc,kT1Ӓ'pP"MLNjd5U` abc Label6Text FilewCC d5U` aHbc Label7Excel FileBl'E%Z:ͬU}MEtHvDetailh L2mT2h Command3h L1mT1d Label6d Label7dhmhmhhmdd 0289=Babc e gh!ij,kp"@&rHlQK). U Lucida Consolehgh Tahoma`pߞK[ DetailfXڈL@p| h1U`habc13=:s8;‚ݕXBlob PropData9;TypeInfo<TCommand0"Create Schema.ini"[Event Procedure]KI0.lh1U`hatbciCommand1Create Link"[Event Procedure]daI1NoͬPF}LkטDetailh Command0h Command1hhhBlobDelta*2?YkWP_6Blob PropData>@ 0289=Babce ghij /k%϶n@eOvU$D. U Lucida Console"[Event Procedure]d2 Tahomahgh Tahomam45 Tahoma` Detail9knAiDmrih1U`abcPCommand0..."[Event Procedure]HNext Recordn%MMmm7UF`ab c,i k Text196EbwlOfh1U`DaiCommand3 IMPORT"[Event Procedure]wS=C{qFͬdqq!BQs~ΘDetailh Command0mText1h Command3dhmhmhTypeInfoAcBlobDeltaO38VD0|o,Blob      "#$%&')*+-./01234569;=>?@ABCDEFGHIJKLMNORSTVWZ[\]^_`bcdfghijklmnopqrstuvwxyz{|}~ 0289=Babce g.hij.k\϶n@oGڰ0(J| ӂ. U "[Event Procedure]Lucida Console"[Event Procedure]d2 Tahomahgh Tahomai1ghk1m45 Tahoma`l  Detail^4K[ACi6Սth1]`abcPiL2..."[Event Procedure]HNext Record̅-Detailh Command0mText1d Label2mText3d Label4dhmhmdmd 0289=Babce ghG"i%j7k !϶n@`@eH(Jfg. U Lucida Console"[Event Procedure]d2 Tahomahgh Tahomai5GQN] 1i_Blob <PropDataMOPTypeInfoPQ1ghk1m45 Tahoma` DetailˇώEJ8h1]`atbcPCommand0..."[Event Procedure]HNext RecordsE@+m7WF`atbc,k Text1'rsNYNUh1U`DaDiCommand3 IMPORT"[Event Procedure]J¡[DAӒ+Zi2]`aiRFL"[Event Procedure]h` #GD#bd5`abcLabel29Floridan!Kɹi2]`aiRTX"[Event Procedure]%|di2` ai RGA2"[Event Procedure]]!G71d5`abcLabel11Georgia[Ba|GUC1uk5`ab8ctiFrame12fǰF<7*Vd25`abcLabel13 Folder 2λgGTK[Bj2`a" iChkdoExportTrueFF }=d5`a bcLabel15$Open Export Wizardj K6B'm^ґj2`aN ichkSymOnly =True!i:_Eo d5`a0 bcLabel17"Symbol files only0*L`S$ͬzOX A֙^9Detailh Command0mText1iRFLd Label29iRTXd PropDataWYTypeInfoZBlobDelta8] ;D`YVvcLabel31iRGAd  Label33k Ctl__State Stated  Label35d Label7d Label9d Label11kFrame12d Label13iRFL2iRTX2iRGA2m Text2h  Command1h btnComparemTxtOutputd Label15jChkdoExportd Label17jchkSymOnlydhijkmrmhmhidididkdhmidididkdjdjd 02389=Babce gh*i j-kJ.hQw&=@z͍͠Lc$. U Lucida Console"[Event Procedure]d2 Tahomahgh Tahomaj1ghn2 Tahomao2 Tahoma` Detail;u3;A(X n03UAabc dl List1Blob bPropData\^TypeInfo_<BlobDeltaValue ListZIP;TERR"[Event Procedure]BJֵ50Cn03UAaxbc dl List2Value List"[Event Procedure]A"[Event Procedure]zM H+r_uJh1U` abc,iBtnAllRight>>"[Event Procedure]$ A%gHh1U` abc,iBtnToLeft<"[Event Procedure]mHiC+h1U` a bc,iBtnAllLeft<<"[Event Procedure]O6*7M:4 Ljod5U`abcLabel10$ Available Fields:~8CuR3d5U`xabcLabel11" Selected Fields:>Um'H;76@h1U`ahiBtnExportExport to CSV"[Event Procedure]8A +CeVh1U5`|a(bg hibtnGoUP!"[Event Procedure]Lucida Brightzy̆M7h1U5`|a bg hi btnGoDOWN!"[Event Procedure]Lucida Bright7RO4Wj2U`K[ ai useVin10TrueNEEEht3 Sd5` abcLabel17Convert VIN6OpJV-ͬ)3bn^I$kkqDetailnList1nList2oCmbTabled Label5h BtnToRighth BtnAllRighth BtnToLefth BtnAllLeftd  Label10d  Label11h  BtnExporth  btnGoUPh  btnGoDOWNd Label17juseVin10dhjno nnodhhhhddhhhjd 0289=Babce ghi0 j\+k϶n@scOr P䠊. U Lucida Console"[Event Procedure]d2 Tahomahgh Tahomai1ghj1ghk1m45 Tahoma``  DetailgAdu h1]`atbcPCommand0     10[jbїvQNMiBlob dPropDataacTypeInfod/..."[Event Procedure]HNext Recordͻ K{)m7WF`atbc,k Text1^AN'ϬCh1U`0 aDiCommand3Test"[Event Procedure] wO<>$i2]`aiRFL"[Event Procedure]B7d~H=Qd5`abcLabel29Florida58,[N/j>xi2]`aiRTX"[Event Procedure]fz?Nv@4 d5` abcLabel31 Texas:e4RMNzi2]` aiRGA"[Event Procedure] IM02KZ)d5`abcLabel33Georgia_ Kq3x^k5`abhcXi StateCtl__StateLj2U`HaichkDoBatch False"[Event Procedure]Irxhd5`)abc Label5"Create batch filexniC""^jj2U`HaichkDoSQL False"[Event Procedure]DDClC%d5`)abc Label7Create SQL file=N44ÃͬpZ^@ L?EDetailh Command0mText1h Command3iRFLd Label29iRTXd Label31iRGAd  Label33k Ctl__State Stated  Label35d  Label5j chkDoBatchd Label7jchkDoSQLdhijkm hmhididK[idkdjdjd 0289=Babce gh8i jP(k/϶n@sO8]*~. U Lucida Console"[Event ProceBlobDelta11gR.tTp2P7\Blob PropDatafhdure]d2 Tahomahgh Tahomai1ghj1ghk1m45 Tahoman2 Tahoma`h Detaileþȁ.G* h1]`a bcPiCommand0..."[Event Procedure]HNext RecordG8ٍBxK(jm7_F`Xa bLc,k Text17&AFQuh1U`aiCommand3Check File"[Event Procedure]ҔJumi2]`aiRFL"[Event Procedure]{iMNјBd5`abcLabel29FloridaCN Ty i2]`aiRTX"[Event Procedure]ƄG Jd5` abcLabel31 Texas<A> i2]` aiRGA"[Event Procedure]mOCqxUd5`abcLabel33GeorgiabU]Hj,ݜk5`abc8i StateCtl__State4TDC-4d25`a<bcLabel35 State*TH`dn03U71Aahbcd` lListFilesValue ListLucida Console"[Event Procedure] 3p7Hg~m 27U<1F`ab cTextLogLucida ConsoleuDȕG}j2U`ai chkDoAll False"[Event Procedure]T2~ױC@d5` abHcLabel14Do All Files8HG &g1    "%&'()*+,-.0135789<=>@BCDͬa1NF<#Detailh Command0mText1h Command3iRFLd Label29iRTXd Label31iRGAd  Label33k Ctl__State Stated  Label35n ListFilesm TextLogd Label14jchkDoAlldhijkmn hmhididiTypeInfoi0BlobDeltaDirDatael TPropDatadkdnmjdTest TX DBF CompareSym&Join All iK[nto One"Check SYM files Import all XLSImport TXTSchema & Link Import all DBFCompareMDEExportAllCheck TX ZIP  10CB0 7CB0 4CB0 3CB0 2CB0 0CB0 1CB0 5CB0 6CB0 8CB0 11CB0Test TX DBF CompareSym&Join All into One"Check SYM files Import all XLSImport TXTSchema & Link Import all DBFCompareMDE~Test ExportAllCheck TX ZIP DirDataCopykmdPropDataCopyCmdbars`^$+`^$+Modules2yr`^$+0A,mi 10CB0 7CB0 4CB0 3CB0 2CB0 0CB0 1CB0 5CB0 6CB0 9CB0 8CB0 11CB0Module1dAutoExec 0CB0 1CB0Module10qn'‚n'‚PropData 1pus e PropData DirData0PropDatatvDirDataCopywPropDataCopy  0CB033!4TablesToCSV ("C:\temp\") 33!t'Run the function that Checks the command line Arguments CheckCommandLine () Reports`^$+`^$+Scriptsx`^$+0A,mi0|`Ax tR!Blob !PropDataK[{}# BlobDelta1z *K Blob $'Sample below:<' "C:\Program Files\Microsoft Access Runtime\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\hsepulveda\My Documents\stuff\vbs\Tools.mdb" /cmd Compare MDE33!BlobDelta2J "p "Blob /BlobDelta6QueriesToCSV ("C:\temp\") 33!0RecoverDeletedTable () 33!"RunSQLFile ("") 33!8RDelete all tables & Queries3~HD0<DBlob 2|BlobDelta4ϑS [SBlob 4nBlobDelta5 i_\H_Blob 6DeleteAll ()!$<Compact the tableCompactDB()RunSQLFile4Export all Tables to CSVAutoExec6Export all Queries to CSV*RecoverDeletedTable,Delete All & Compact 4CB0 0CB0 1CB0 2CB0 3CB0 5PropData: BlobDeltaDirData;PropDataK[?FCB0RunSQLFile4Export all Tables to CSVAutoExec6Export all Queries to CSV*RecoverDeletedTableDelete All 2CB0 1CB0 0CB0 3CB1ijMSysDbDirDataCopyAPropDataCopyE0PropDataFDatabases`^$+0A,mi0`^$+ &+Blob DirDataGCustomGroups`^$+`^$+DataAccessPages `^$+`^$+˩LVALʾxxxxCreate table in Design viewCreate query in Design viewCompareSymCreate report in Design viewCreate data access page in Design viewDelete All & CompactModule19Z^3& @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @      !"#$%&'()*+,-./0 1!2"3#4$5%6&7'8(9):*;+<,=->.?/@0A1B2C3D4E5F6G7H8I9J:K;L<M=N>O?P@QARBSCTDUEVFWGXHYIZJ[K\L]M^N_O`PaQbRcSdTeUfVgWhXiYjZk[l\m]n^o_p`qarbsctduevfwgxhyizj{k|l}m~nopqrstuvwxyz{|}~S YNY Э Y Y   Y  Y  Y Id LValueObjectGuidObjectNameProperty Value         YYYId$ObjectGuidProperty$ObjectNamePropertyHv1b     qYNY Y  Y Y Y Y Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Width      YY Index1PrimaryKeyv1   YN   Y Y Y Y  Y  Y Y Y   Y Y  Y    Y    Y  DateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelim   YPrimaryKeyv1 QQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'  &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp  &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp     &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp      &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp      &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp      &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp      &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp     &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp     &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp     &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp     &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   LVALʾxxxxCreate table in Design viewCreate query in Design viewTest TX DBF Create report in Design viewCreate data access page in Design viewDelete All & CompactModule19Z^3LVAL l + / 37;?MR2 GUIDNameMapZ scOr P䠊6 . U MR2 GUIDNameMapZ &rHlQK)6 . U MR2 GUIDNameMapZ d)ގH3b6 . U MR2 GUIDNameMapZ I(>*zAO*'6 . U MR2 GUIDNameMapZ eOvU$D6 . U MR2 GUIDNameMapZ `@eH(Jfg6 . U MR2 GUIDNameMapZ z͍͠Lc$6 . U MR2 GUIDNameMapZ h5"HCA G6 . U MR2 GUIDNameMapZ U.Gq'xܕ 6 . U MR2 GUIDNameMapZ sO8]*~6 . U MR2 GUIDNameMapZ oGڰ0(J| ӂ6 . U MR2( ReplicateProject MR2vAccessVersion BuildAuto Compact6Remove Personal Information"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in Remote.Show Values in Snapshot*Show Values in Server(Themed Form Controls.Use Default Page Folder&Default Page Folder6Use Default Connection File.Default Connection FileRow LimitANSI Query ModeProjVerAppTitleStartUpForm&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt 08.50 .                '  #        )vcO<)   x e d Q P = < ) (xdQ &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   T&ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   ˇ8S˜&C%}.y֕iEE~jIX)J Me tO!$6c3J]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp    ˇ8S˜&C%}.y֕iEE~jIX)J Me tO!$6c3J]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   T&ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp  ˇ8S˜&C%}.y֕iEE~jIX)J Me tO!$6c3J]j> ee}2F?.uQݭp  &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp  ˇ8S˜&C%}.y֕iEE~jIX)J Me tO!$6c3J]j> ee}2F?.uQݭp  &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp   &ۜ|&C%}+}*;oW(/v*~jIX)J Me t7@,YJٝ@HJ]j> ee}2F?.uQݭp