Standard Jet DBnb` Ugr@?~1y0̝cßFN/h7לo(%`{6\߱gCf<3y[;&|*j|?SKf_Љ$g'DeFx -bT4.0"PbMx Y;S  Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYSY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YeSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipn)Z { 6 ? H  y 4 Q =n) 7@@  (@(@@((@@ @(h`@q4 @@K@@   @ @@@ @ @  @ @ M^YQbm+MdbmJMmk+hoQiv#M^YQbm+MdbmJMmk+hoQivkoLSdi`$M^YQbm+Sdi`%M^YQbm+Sdi`<6MdbmJMm+Uidof+hoQiv'Si`M^YQbmZSi`[dLk(Si`bQsM^YQbmISi`bQs[dLfksLkobLdobO+dfmYdbUidofLJkJOdiQMdiOkQmk:LJkQuJ`f^Qk#`dOo^Q8 OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^Qk+kh+MM^YQbm+Sdi`+kh+MMd`fJbvMd`Ld`+kh+MM^YQbm+Sdi`<+kh+MMd`fJbvMd`Lda+kh+SM^YQbm+MdbmJMmk+hoQivkoLSdi` +kh+SSi`bQsM^YQbmi+kh+SSi`bQs[dLnMJ^^k)MJ^^k+hoQivM^YQbm0M^YQbm+Md`Ld+hoQivM^YQbm+MdbmJMmk+M^YQbm+MdbmJMmk+hoQivM^YQbm+hoQiv+Sid`+mumMmi^M^YQbm+hoQiv:MdbmJMm+Uidof+hoQiv MdbmJMmmvfQk,[dL+MdbmJMm+iQMdiOM[dLkM^YQbmm[dLk`dOQ^k$`dOQ^N`dOQ^+k\Y^^P`kvkJMMQkkdL[QMmk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfk`v+JOdQhO^mM^YQbm/hiv[dLk3hivbQsM^YQbmKk\Y^^RksYmMWLdJiO+M^YQbm;JMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO okQiOQSYbQO  okQiOQSYbQO [+;K[+ QLS>BM@O<>S6HO<<<>+ +;K[ +;K[QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[ +;K[LS>BM@O<>S6HO<<<>+ +;K[<<>+ +;K[  @ @ @ @ @ @ @           #$%'( !# &#'6*:+;-I/K2Z5/6`7a:3;f=i?k@nd)+,MNPQR0m$ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ !"#$%&'()*+,-./0123MMM M M M M M  M  M  M  M  M M M M M MMMMMMMM M!M"M&M'M(M)M*M+M,M-M.MGMHMI#Z!#Z"#Z#&Z*&Z+&Z,'Zc'Zd'Ze*Zo*Zp*Zq+Zr+Zs+Zt-Z-Z-Z/Z/Z/Z2Z2Z2Z5Mj5Mk5Ml6My6Mz6M{7M|7M}7M~:M:M:M;M;Z;Z=Z=Z=Z?Z?Z?Z@M@M@M  dMNdMOdMPMTMUMVMWMXMYM]M^M_M`MaMbMfZZZZZZZZMmMnMoZZZZZZ             @ @ @ @ @ @ @ @ @ @ @ @ QQQQQQQQQ Q Q Q Q  f- f% f& f' f( f) f* f+ f, f. Q  Q Q Q Q Q Q  Q! Q Q" f f f f Q# Q( W W W W W Q) Q1 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q2#W<#WC#W>#W?#W@#WA#WB#W=+W+W+W+W+W/f6/f8/f75f5f5f5f5f5f6f6f6f6f6f6f7f7f7f7f7f:6 ::: : :6=6g=6i=6j=6h@@@@@@@@@>6l>6l>6l>6l:6:6:6:6 + <8JJD8DSMLLS>B>BJM6:@F@>FLDQF>:H+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[+ QLS>BM@O<>S6HO<<<>+ +;K[ `dOQ^+k\Y^^`dOQ^+k\Y^^dOQ^+k\Y^^dOQ^+k\Y^^`dOQ^+k\Y^^\Y^^`dOQ^+k\Y^^k\Y^^ k\Y^^k\Y^^k\Y^^\Y^^^k\Y^^k\Y^^k\Y^^`dOQ^k\Y^^5d _ Z 7 T  _ __________ w miHkågg4٭ku@:3ku@jobs)@xjobs''4.``0   2 2 2   @3>6**( h:Y;u@㥛̭u@qryJobs)&t@|@THH<000000. `^gvu@axu@client)@ xclient''4.``B@}m!Y.f @F:.., ~5jAxu@u@ qdltClient)@|@NBB66666664 @mu@T0xmu@ContactTypes)@xContactTypes''4.``  2U@^F::8 ^'Sޤmu@/᳌u@client_contacts)@xclient_contacts''4.``x@}@jL@@> ^dY)ܣmu@SZmu@calls)@xcalls''4.``$    2 2l@B8,,* ^\*?u@\*?u@frmJobs)@<<<0000000. @e]*?u@e]*?u@contact_group_query)T@TTTHHHHHHHF @R*?u@R*?u@client_form) @3DDD88888886 @,*?u@,*?u@client_contacts_Query subform)^@>chhh\\\\\\\Z @(r*?u@(r*?u@client_contacts_Query)T@0XXXLLLLLLLJ @ o*?u@7p*?u@contact_group_query)?@|@Sl``THHHHHHF ` o*?u@x u@client_query2) 9@|@`TTH<<<<<<: ` v}o*?u@0k?u@client_contacts_Query)e@`@SpddXLLLLLLJ ` S?o*?u@W!Ru@client_combo_query)*@*e|@ {^RRFFFFFFFD @ n*?u@0o*?u@calls_query):@F@SPDD88888886 @b|$?u@b|$?u@DataAccessPages)@@@@@@@@@@> b|$?u@b|$?u@SysRel).........., b|$?u@b|$?u@Modules)0000000000. b|$?u@b|$?u@Scripts)0000000000. b|$?u@b|$?u@Reports)0000000000. b|$?u@b|$?u@Forms),,,,,,,,,,*  f$|$?u@f$|$?u@UserDefined)A@DDD88888886 @ f$|$?u@f$|$?u@SummaryInfo)r@DDD88888886 @w$?u@x$?u@MSysAccessObjects)DDDDDDDDDDB u$?u@u$?u@MSysRelationships(DDDDDDDDDDB u$?u@u$?u@MSysQueries(88888888886 u$?u@u$?u@MSysACEs(22222222220 u$?u@u$?u@MSysObjects(88888888886 u$?u@}gau@MSysDb)-@-:::......., @u$?u@u$?u@Relationships(<<<<<<<<<<: u$?u@u$?u@Databases(44444444442 u$?u@u$?u@Tables(.........., P{hUB/A S @ ,  |  B /   l Y 2 o\IƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬƬK) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) K) G( G+@ J=)+LP]=w1]G$.7)?04"@)tН"5QK) K) ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ) +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( ( ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ) ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p T+@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p T+@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ) ) ) ( ) ( ) ) ) )  Yv NvY Y DataIDDD𣪉YAOIndexOJmJLJkQkiQ^JmYdbkWYfkmJL^Qk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkOL +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p +@ J=)+LP]=w1]G$.7)?04"@)tН"5Qk3= 2'-k+tRQֹΪ(p ( ) ) ) ( ) ( ) ) ) )  f! @ @ @      7? @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @VWXYZ [ \ ] ^ _`abcdefghijklmnopq r!s"t#u$v%w&x'y(z){*|+},~-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~!"#$%&FGi '(),-./     012*+6789:<=@ABHIJhjklmnopqrstuvw      !"%&'()*/1234#$ !-"#C$D%E&K'L(M)N*O+,-./0123456789:;<=>?@ABCDEFGHIJKLMNO P Q R S TUVWXYZ0[1\8]9^:_;`<a=b>c?dPeQfRgShTiUjVkWlXmYnZo[p\q]r^s_t`uaK[d k f R 0ĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐĐ0PMSysAccountsxxxxДxx xxMR2K[ @ࡱ> -/ G/ }Root Entryp-APropData Forms '`>;-AReports`>`>08=Babce ghi=jr$klLF X EMFD  XFXLGDIC)4 ji    &_FMRIB_# iC (f3f3̙f3fffff3ff333f3333f3f3f3̙f3fffff3ff333f3333f3f3̙̙̙f̙3̙̙̙f3fffff3ff333f3333f3fffff3fffffff3fff̙ffff3fffffffffff3ffff3f3f3ff3f33f3ffffff3ff333f3333333f33333̙33f3333f3f3f3ff33f3f3333333f3333333333f3333f3f3̙f3fffff3ff333f3333f3,,,+&+++++,+,,,,,+,+++,+,++,%+,+++%,+,,,+,,%,,+++,%,+++++++,,+%+,+,,+%,,%,,%+,+,,++ k !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~DataAccessPages `>`>Databases `> Gc>0 `> Gc>Blob %+,,+,&%,%,&++&+,+,,+%,,+,,,,+++,++&++++,+++,+,+%+,,%+,,,,,+,+,+++%++,,+++,,,%,,+,,,,,,&+&++%,,+,,+%,,,,,&,&,+,,%%+,%%,+%%+,,++,+&+++,+++&+,+++,+,,,+,,+,,%,+&+,,,&%++,,&&,&+,+%+&,+%,+,++%,+,,,,+,,+%,+,+,,%+,%,+,++%+%++%,+,+,+%&,+,+%+,,K[v1 @+,+%++,%,+,,++,,+,++%,%,,,,+,,,,,+&%,++&+,,,%%%+&,+,++,+,Root Entry<%APropData Forms '`>И%AReports`>`> !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Blob nTypeInfoVVPropData()M5/.#>` A__SRP_bi__SRP_aSu11er;@p-ABlob T E> %l  __SRP_12k]__SRP_137g}xAAHKABlob <0mnРs@Рs@DirData\.Blob ]dPropDataCopy     !*1#";+&0<6,BEE P 2347 =89FDwJ5W CpHMGIOK L LVALЎMMMMM΍΍΍΍΍΍΍΍΍΍΍8888  _P.'WGt@client`P.'W_P.'Wclient_id_h"EK~_P.'Wcompany_nameaP.'W_P.'WstreetbP.'W_P.'WcitycP.'W_P.'WstatedP.'W_P.'Wzip$9OWN_P.'Wbill_attn_toeP.'W_P.'Wbill_streetfP.'W_P.'Wbill_citygP.'W_P.'Wbill_statehP.'W_P.'Wbill_zipiP.'W_P.'Wbill_phone=HnMM#ȥjvj_P.'Wdescription?client_id   ^ street      m  Zcity      m  \ state      m  Y zip e      0  mhbill_street      m  MR2lODBCTimeoutLogMessagesMaxRecordsOrientationDOL4 <  MR2lODBCTimeoutLogMessagesMaxRecordsOrientationDOL4 <    UMR2 GUIDNameMapr q$تeN5v,u`N F Uf(dM$Ez|lu@MR2vODBCTimeoutLogMessagesMaxRecordsOrientationDOLGUIDL <    U e%=iCq*-2FMR2vODBCTimeoutLogMessagesMaxRecordsOrientatioMR2 GUIDNameMapr q$تeN5v,u`N F Ue%=iCq*-2F+9nu@qryNewClientMR2 GUIDNameMapr q$تeN5MR2 GUIDNameMap0  ghFxtoP  UMR2 GUIDNameMap0  ghFxtoP  UMR2&AllowZeroLength skill MR28RequMR2&AllowZeroLength skill MR28RequiredAllowZeroLMR2&AllowZeroLength skill MR28MR2&AllowZeroLength skill MR28RequiredAllowZeroLength id name  txt  ts MR2&AllowZeroLength1"contact_method memo MR2&AllowZeroLength+ContactType MR2&AllowZeroLength#subject  notes MR2 GUIDNameMap0 WIAȃ  UMR2( ReplicateProject MR20 Title AuthorCompany> access4 joe joeK[NTPRQUSW]XajZ[\f?mVo qxrstu|yz{}~TypeInfo5PropDatacd4TypeInfoPropData_fModules:`> Gc>Scripts`>`>VBA`><%ACmdbars`>`>CustomGroups l>>DirDataVBAProject><%AAcessVBADataBlobCopyTypeInfoCopy,%++,,,%,%,%+,+%,,,,++++,,%%+,+%%+%+,+++,,%+,,+,,+,+,%,+,,+%,&,+,+++,++,,+++,++,++++,&,,+,+,+,+++,,+&+,+,+,+,%+++,&+&++,,+&+,,++%,%,+,++&+&,+,%,,+,,%,++,,+,,+,,%,,%,,%++++,+%,+%,%,++,+,+,,+,,+%+,,+%,,,%,,+,+%,&,+,++&+,,++%,,,%%%,,%+,,%,+%,%++,,++,%+,&%,+,,+%,,,,,,%,++%+,,+,+,,+,+,,%%+,+,%,,++,%,++,+++,,,,%,,+%,,++,,%+,%,%,,+++%%,++,%,+%++,++&+%++&,+++,++,,,+,+,+,%,,,,%+,%,,+++,,%+,%,+,,,,+++,&+,,%%%,,%,+,,,+%,,++%+%,%,,%,,+,,+%,%,+,,,++%,+&,++,,,%+,++,,,&%&,+,,,%%,%,+%,++,%,+,%+,%,,+,+,,++,%%,+%+%,,+,,+&,,+,+&,++,+%,+,,+,,,++,+,,%+&++&,++,%,++&%&+,+++%,%+,+,+++,+,+,+,+,++&,,+%,+++,%+%,,,,,,&+++%,,+,+,&+,,,,+,+,,+&&%,%&+,%++%++,++,%,+%,,,+++,,,,+++&+%%,,+%+,++%,+,+,+,,+&++,++++,,&+,,+,,+&+,%++,,&++,+,+,,+,+%,%,,,&+,,%,++,%%+,+%&+++,,,+,+,%,+,,+,,+%%,+,+,,,%,+,+,,,+,+,++,,,%,%,+,+,++,+,+++&++,,++%,,+&%+&+++%&,++&+,+++,++,,%,,%+%++,++,&++%,,%++++,,++,%+,++,,,%,,+,,+%&+,&+,+%,+%+,%,+,%+&,&+%,,++++%,+&,,,,+,%&+++,+&,,++&%,+,+++,+++,%+,+,++++%,++,,+,,++,+++%%+%%,,,+%+++%%,,,+,,+,%,+,+LVAL2ǏD| 4HF 4j  <?HF8$HFHFHF(HF@HF <HFFHFnHFHFHFHFHFHFFHFnHFHFHFHF8HF`HFHFHFHFHFHF8HF`HFHFHFHFHFHFHFHFHFHFHAFHFHFHFHF HFFHFnHFHFHFHFHFHFFHFnHFHFHF d  d ȇ ( d d d  d    client.client_id clientclient_id%client.company_name#client.descriptionclient.streetclient.lineTwoclient.mainPhoneclient.country%client.bill_attn_to#client.bill_street%client.bill_lineTwo!client.bill_phoneclient.client_idclient_idHF  HF HFxHFHFx u@HFHFh! `HFP0 FHFP0hnHFP0h!!HFP0h!!HFP0h!!HFP0h!!HFP0Xh!HFP0h8FHFP0!-nHFP0h! hHFP0h Pclientx HF    HFh HFPHFHFaxu@client_idclient_query2HF HF HF 8HF HF `HF HF HF( HF HF0 HF HF8 HF HF@ HF HFH HF 8HFP HF  `HFX HF  HF` HF h HF HFHF8HF`HFHFHFHFHFHF8HF`HFHF'[client].[client_id]h HFP HFP0h! FHFP0!hnHFP0HFP0hHFP0h!hHFP0!HFP0hHFP0h!BFHFP0!hnHFP0 HFP0h client_id client HF HF@ FHF HF nHF HF HF HF HF HF HF HF HFHF HFHF FHFHF nHFHF HF HFHFh HFclient_id8HF`HFHFHFHFHFHF8HF`HFHFXHFHFHFHFXHFXHF9[forms]![frmClient].client_idXHF HFHFXHFHF"client_id"\HF XHF:9[forms]![frmClient].client_idHFHF`HFHFHFHF HFHF(HF HF8HFhHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFHFH$HF HF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF hHFPHF  hHFPHF  hHFPHF HFx (HFP$HFP$HF#HFHF2HFHFHFHFhHF HFxHFXHFHFHFHFHFHFHFHF8HFHFpHFHFHFHFHFHFHFHFHF dHF  HF dXHF ȃHF (HF dHF d8HF dpHF dHFHFHFX0xHFHFHFHFHFHFHFHFHFHFHFHFHFHF HFXHFHFHFHF8HFpHFHFHFHFPHFHF PRIMARYHFHFHFHqFHFHFHFHFHFHFHFHFHFHFHFHFHLVAL+FHFHFHFHFHFHFHFHFHFHFHFHFHFHFHF#HF HF#HF#HF0$HF HFHFyp#HFHFHFHFDSN=avant2;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=avant;SERVER=www.sirfsup.com;PASSWORD=joeofclew;PORT=3306;OPTION=1048579;STMT=;"HFHFHF*X#HF HF85SELECT `client`.`client_id`liSELECT `client`.`client_id` FROM `client` WHERE NOT(( "HF HF"HF"HF"HFHFSELECT `client`.`client_id` FROM `client` WHERE NOT(( ? = 0 ) ) @N`b"HFh HFHFp#HF"HF p#HF   HFHF #HF#HF #HF$HFPHF +HFE *HF )HF+HF H-HFP-HFh-HF-HF x1HFx/HF`x-HFDSN=avant2;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=avant;SERVER=www.sirfsup.com;PASSWORD=joeofclew;PORT=3306;OPTION=1048579;STMT=; d  d ȋ ( d d d d$)HF *HF| 2*HF" | (*HF0| 28*HF9 | dH*HFC | X*HFO | 2h*HFY| 2x*HFh | 2*HFv| 2*HF   pSELECT `client_id`,`company_name`,`description`,`street`,`lineTwo`,`mainPhone`,`country`,`bill_attn_to`,`bill_street`,`bill_linemTwo`,`bill_phone` FROM `client` WHERE `client_id` = ?$)HF b_SELECT `client`.`client_id` FROM `client` WHERE INSERT INTO `client` (`client_id`,`company_name`,`description`,`street`,`lineTwo`,`mainPhone`,`country`,`bill_attn_to`,`bill_street`,`bill_lineTwo`,`bill_phone`) VALUES(?,?,?,?,?,?,?,?,?,?,?) DELETE FROM `client` WHERE `client_id` = ? AND `company_name` = ? AND `description` = ? AND `street` = ? AND `lineTwo` = ? AND `mainPhone` = ? AND `country` = ? AND `bill_attn_to` = ? AND `bilql_street` = ? AND `bill_lineTwo` = ? AND `bill_phone` = ?4UPDATE `client` SET `client_id`=?,`company_name`=?,`description`=?,`street`=?,`lineTwo`=?,`mainPhone`=?,`country`=?,`bill_attn_to`=?,`bill_street`=?,`bill_lineTwo`=?,`bill_phone`=? WHERE `client_id` = ? AND `company_name` = ? AND `description` = ? AND `street` = ? AND `lineTwo` = ? AND `main LVALЬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬϬMR20AllowZeroLengthGUID title +description %location $ Mm(XߤMR20AllowZeroLengthGUID title +description %location $ Mm(Xߤ. jobId 5&Jŋ_MR2ODBCTimeoutMaxRecordsRecorMR2&AllowZeroLength title MR2&AllowZeroLength title +description MR2 GUIDNameMap0 M5JV>  UMR2 GUIDNameMap0 f kK`Sw  U* LVALM& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& MR20AllowZeroLengthGUID title +description %location $ a֜5@M\۠MR20AllowZeroLengthGUIMR2 GUIDNameMaph MkD < U-&ͪBAQQu@qryJobsMR2 GUIDNameMaph MR2 GUIDNameMap0 hz~<(B2s  UMR2 GUIDNameMap0 hz~<(B2s  UMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDOLGUIDReplicable  <     U`N!Bg9"6#ft@hu client_contactsV ZGP)`N!Bg9"6contact_idvECuHQmm`N!Bg9"6client_idT Ї@C}@`N!Bg9"6first_nameENFZ!`N!Bg9"6last_name*vF{G Ox`N!Bg9"6middleN#Z3@)Z%r9`G`N!Bg9"6titleLVALٺD.a. `?   <>v6V~0h(HpXXXXaXXXXXXXXXX>v6V~ d  d d d  d d  d  d  d     client.client_id client%client.company_name#client.descriptionclient.streetclient.cityclient.stateclient.zipclient.country%client.bill_attn_to#client.bill_streetclient.bill_city!client.bill_stateclient.bill_zip!client.bill_phone08Vʂu@ >8B v8B 8B 8B 8B 8B 8B 68B V8B ~8B 8B 8B 8B 8B client`0vmu@dlt_client_query>8B v8B 8B 8B 8B 8B 8B 68B V8B ~8B 8B 8B 8B 8B client 8 X=[Forms]![frmClient].[client_id]  X 08p                              xh` h` `$h` h` h` h` h` h` h`  h`  h`  h`  h`  x h#pPDPx x 0hH((8P d  d d0 dh d d dH d d(`8 (08@P0hH(`h__uniqueindexq` pH hyDSN=avant2;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=avant;SERVERy=www.sirfsup.com;PASSWORD=joeofclew;PORT=3306;OPTION=3;STMT=;X * 85SELECT `client`.`client_id`}SELECT `client`.`client_id` FRsLVALOM `client` WHERE (`client_id` =    4HSELECT `client`.`client_id` FROM `client` WHERE (`client_id` = ? ) 0h h@     p8 p` &eh%$&x((() 8+*`(DSN=avant2;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=avant;SERVERy=www.sirfsup.com;PASSWORD=joeofclew;PORT=3306;OPTION=3;STMT=; d  d d d d d d d dP$$  $| 2$" |$0| 2$9| 2$@| 2$H $N | 2%X| 2%g | 2 %u | 20% | 2@%  P%   SELECT `client_id`,`company_name`,`description`,`street`,`city`,`state`,`zip`,`country`,`bill_attn_to`,`bill_street`,`bill_city`,`bill_state`,`bill_zip`,`bill_phone` FROM `client` WHERE `client_id` = ?$$  b_SELECT `client`.`client_id` FROM `client` WHERE INSERT INTO `client` (`client_id`,`company_name`,`description`,`street`,`city`,`state`,`zip`,`country`,`bill_attn_to`,`bill_street`,`bill_city`,`bill_state`,`bill_zip`,`bill_phone`) VALUES(?,5?,?,?,?,?,?,?,?,?,?,?,?,?) VSDELETE FROM `client` WHERE `client_id` = ?UPDATE `client` SET `client_id`=?,`company_name`=?,`description`=?,`street`=?,`city`=?,`state`=?,`zip`=?,`country`=?,`bill_attn_to`=?,`bill_street`=?,`bill_city`=?,`bill_state`=?,`bill_zip`=?,`bill_phone`=? WHERE `client_id` = ? AND `company_name` = ? AND `street` = ? AND `city` = ? AND `state` = ? AND `zip` = ? AND `country` = ? AND `bill_attn_to` = ? AND `bill_street` = ? AND `bill_city` = ? AND `bill_state` = ? AND `bill_zip` = ? AND `bill_phone` = ?LVAL?HD+ + 0<?(  h   <`0    0 `  h    @ H H H H H H 0    0 `   d d d d 3client_contacts.contact_idclient_contacts1client_contacts.client_id3client_contacts.first_name1client_contacts.last_name+client_contacts.middle)client_contacts.title  @  p 7p*?u@  0 @  @  @  @ 0 @ ` @!client_contacts(    p mu@%contact_group_query   H  P         ( `  h  ;[client_contacts].[contact_id] 9[client_contacts].[client_id]P ;[client_contacts].[first_name] 9[client_contacts].[last_name] 3[client_contacts].[middle]( 1[client_contacts].[title]h 0 @  @  @  @ 0 @ ` @!client_contacts 0 8 @  @   H   P  0 X  ` `  P   ( h      p 8 P h   h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h    x h   h   h   h   h   h    x (#   0  C 0 h        H  0 h  d  d  d  dH @      0 h    H   __uniqueindex0   q                                h 0     y      DSN=avant2;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=avant;SERVERy=www.sirfsup.com;PASSWORD=joeofclew;PORT=3306;OPTION=3;STMT=;@   %  LISELECT `client_contacts`.`contact_id`|ySELECT `client_contacts`.`contact_id` FROM `client_contacts` h             0   0 h  p% E$ @$ K[e Respond$"'  KT'2 frmNewClient HF LJ 8 B@R KT'2n client_form HF LJ 8 B@R{Attribute VB_Name = "Form_clientD_f," Bas0{C9297F4A-89A8-4D99-98FA-CFC17A6F5856} |GlobaBlSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT Sub Get nyInfo(search_field As Sng) Dim rst ADODB.Recordset9cm,maDndonnCecNSet c= New2 !nn !my&C=(B1.@d  OpenC_&>I&L?. p"Sel@,\ny_nfrom C where " & _CW" LIKE "L"%A e& "", n'' Me.H..c{n@JmbjSouBrBsqlsl'% o If Not.EOF8 ThI2AMo0veFi@7DoCmdHA' "+3dmode:=acAdd, windowDialog, a,Args:="= E"saAEintAnswerDInteger= MsgBox("inserXt n PD(?vbYesNo, "Ple!Respond"dc >C& Abb acancelGAi (frmdC??(+?( NoEnd # CIfcaBCl ub !fP S Uo_KInList(`!|, C/D:0S8Do you want to add t'" n&B @j'athe items in thisaltrol@HuvbOKC5A UI?")7lb'`m`bJa] ombo box soe @ be requ e,' af.t YC 'gohry !,d.C.FRunDh acpUjis %col"i"ne`d `"e"r |Sh' }lsL@T"G A^tinueDt@hout ding default error message78 &="ErrIa.pK!9 Irr ? 5!4833_Currm 0IsNull(M@e![txtBId]):)# GoTo!0.YcjP ׁ A{v(xOn a_ %?Exit[6: `@Brr?=.descriuG g`~tac僣_ck 0  fstDocb LinkCrFriaL0 s_Q@fy4#st0[Eid]=m  x,  r[ 3? Oms ?e)$ run_subr?ineC$"cPAit !6e_Dbl"${{h_ 'I89_A\UpQesa ' `Ե onaferslof"Yunder|lyAMY.oM+0zTeֽ߽$2of'aA.IsorLocaaqadUseJ?3`Cebo~_pa/(s fQ_SBruF I`^sIccaB_C9cb#% rstTest.CursorLocation = adUseClientclient_combo_query (bo` fh] l!n'j].p t!r pB@]]'Select * from client where client_id = j'x' CurConn.Open CurrentProject.Connection x p vB@ v!z populate list box here( make the list box a dialog box pop-up+ put list box results back into main form v"< |( v"~ |(~ v"& |(& v" |( v" |( v" |( v" |(d Error is $!& forget itA@"'2kP vB@B.v|0h(  Error is $!& entering  company nameA@"o`]] ]@]X&Select company_name from client where  company_name =" "'x t!r pB@ x p  vB@ v!zKthis company name has already been used. Please use search feature to findA@"'2k8 vB@B.v|  Error is $!& entering  company nameA@"|oU compare to old_delete_record_Click which though it deleted still left fields in form call delete queryo] Dim client_id_value As Integer client_id_value = 11T SQLStmt = "select * from client where client.client_id = '" & client_id_value & "'" MsgBox SQLStmt] .]@ .]`  GA record should only be deleted if completely erroneous information was[ just entered ab