Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6p߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{@VCS ''          2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni g Id ParentIdName        Ω=^V#jKV#jKV    [;  [;V#jKxZ#?iD@:%18G5020CWINDSWEPTLN062315*&$$"  ŗ@~$18G5018ORICHMONDAVE062000*&$$!  @$18G5018PPAGEWOODLN062245)%##!  J@@18G5018UBELLAIRE061800'#!!!  j@18G5018ABELLERIVE062345($"""  @@L18G5018OBELLAIRE061355'#!!!   @L18G50250BELLAIRE061800'#!!!  b@L18G5018UBELLAIRE061545'#!!!  5@r@L18G5023SBELLAIRE061000'#!!!  0(@18G5018OBELLAIRE061500'#!!!  vu@@18G5018OBELLAIRE061400'#!!!  `@18G5018OBELLAIRE061800'#!!!  =@@18G5018UBELLAIRE061300'#!!!   @X18G5018OSOUTHWESTFWY062130+'%%"  @18G5018RSOUTHWESTFWY061230+'%%"  F@@,18G5018OSOUTHWESTFWY060030+'%%"  ^T4@118G5018RFONDREN061430&"   U@|18G5018MSOUTHWESTFWY062030+'%%"  ֣@18G5018OHARWIN061800%!  "`@18G5018OHARWIN061900%!  bt`@(18G5018OSOUTHWESTFWY062030+'%%"   @18G5018AFONDREN062150&"   &@818G5018OSOUTHWESTFWY060100+'%%"  d`@:18G5018AREIMS062000$   U @@18G5018AREIMS060215$   0`@18G5018OHILLCROFT060000($"""  |  @ 18G50250HILLCROFT061730($"""  r@18G5018OHARTSDALE061100($"""  b:@[18G50250ANN ARBOR060900($"""  v@18G5018NGESSNERS062300'#!   6U@18G5018PGESSNERS062300'#!    @18G5018ATANGLEWILDE060935*&$$$tbl Offensetbl PIP Dat @@@ `dojpo{jmm`udd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvdrxamfbmjblifufgru`xhxvwvw`wvov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvwamrggfpvfwamsjsd`w` `bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdufgfufpbf5wamrggfpvfwamsjsd`w`55ggfpvfwamsjsd`w`5wamrggfpvfwamsjsd`w`5fufpbf5wamrggfpvfwamsjsd`w`5wamrggfpvfwamsjsd`w`55wamrggfpvfwamsjsd`w`5rggfpvfwamsjsd`w`5`w`5rggfpvfwamsjsd`w`5d`w`5rggfpvfwamsjsd`w`55rggfpvfwamsjsd`w`5w`5gfpvfwamsjsd`w`5amrggfpvfwamsjsd`w`5@ D ` D  h D D  D D [tbl PIP Data].[Offense Date]D [tbl PIP Data].[Offense Time]D [tbl Offense].OffenseD [tbl PIP Data].BeatD [tbl PIP Data].Premise D xD [tbl PIP Data].[Street Name]@ D [tbl PIP Data].Typeh D [tbl PIP Data].Suffix D D PED PmD PɅ D PɅ D PɅ D PɅ D PɅtbl PIP Data D D   D D  ' D D  D D  w D D  D D  D D D D  D @ D h D  D D D PɅtbl Offense D ` D D tbl PIP Data Street# D xD  D D @D hD D D D D D D D D D D D D D D D D D D D D Do{<YHmHb>? H   'O 8  'O 2   2   2  tbl Import Information.Host Filetbl Import Information!tbl Import Information.Table Name+tbl Import Information.Import Specificationxp0P hݬ70@p c 'c Octbl Import InformationP8 h^Mˢ@~sq_ffrm Import Information   88c 'c Octbl Import Information  ' O8 (  h@P`p                             X        | x  e P       P   4 X ` h  P   tbl Import Information v ((s @ @ @      55PU R R8R=R<R:R;R9R>R@RAR?RBRDRC]"]#^^]]]]]]]]]]]]D^D^D^H^H^H^K^K^ K^ P^ P^ P^ BBBBBB B B B BBB     '&%$#"! bbbbbbbbbbbbbbbb b b b b bbbbbbbbbb&a%a$a#a`&%$#"! @ tbl Import Information  ((  {qg]SI?  m$b?       % = U u        0 H h                ! % = U u       @@@ 8 @ @ @ @ @ @ @ @ @ @777777777 777777777777 7! B  B  B BBBBD D D D BBBBBBB!B"B#BBDDDB$DDBBBBBBBBBBBB PDPDPDUDUDUD777777 7 7 7 777777777777777777777777777777777777777777777777 @ @ GGGGGGGGG G G G G  GGGGGGGGGGGGGGGGGGG G G G     x  @  p     0  @ 0 P ` `  p    @  p        0 `     P(p x          @ p    0 `    tbl PIP Data  tbl PIP DataOffense Code  v (     s                             x   h   tbl PIP Datatbl PIP DataOffense Code  (  (    X    ufgfufpbf6wamrggfpvfwamsjsd`w`6SON TERRY L JRSPANISHREAD AND SPEAKBCOMM SERVICES13002100071POLICE OFFICEReWTPL?>0)  Jffff@HERRERA JOSESPANISHREAD, WRITE, SPEAKHSOUTHWEST15002300045POLICE OFFICER]OLHD;:(!  әffff@HERRADA PETE ANTHONYSPANISHREAD, WRITE, SPEAKHSOUTHWEST18000400123POLICE OFFICEReWTPLCB0)  ffff@HERNANDEZ URBINA PSPANISHREAD, WRITE, SPEAKHMAJOR OFFENDERS08001600071POLICE OFFICERi[XTPA@.'  uffff@HERNANDEZ TORIBIO RSPANISHREAD AND SPEAKHHOMICIDE08001600071SERGEANT OF POLICEcQNJF>=/(  ffff@HERNANDEZ ROVERTOSPANISHREAD, WRITE, SPEAKHEASTSIDE22000600067POLICE OFFICERaSPLH@?-&  ffff@HERNANDEZ ROBERTOSPANISHREAD, WRITE, SPEAKHTRAFFIC/ACCIDENT14002200034POLICE OFFICERi[XTP@?-&  fffff@HERNANDEZ REYNALDOSPANISHSPEAK ONLYHCLEAR LAKE14002200034POLICE OFFICER\NKGC98.'  3ffff@HERNANDEZ NOE JSPANISHREAD, WRITE, SPEAKHNORTHEASTPOLICE OFFICERUGGGG>=+$  Vffff@HERNANDEZ LUIS ESPANISHREAD, WRITE, SPEAKHSPCL OPERATIONS14002200071POLICE OFFICERgYVRN?>,%  yffff@HERNANDEZ LUIS ASPANISHREAD, WRITE, SPEAKHNORTHWEST22000600034POLICE OFFICERaSPLH?>,%  ffff@HERNANDEZ ISRAELSPANISHREAD ONLYHNORTHWEST14002200045POLICE OFFICERXJGC?65,%  ffff@HERNANDEZ HENRY VSPANISHREAD, WRITE, SPEAKHAUTO DEALERS07001500071SERGEANT OF POLICEiWTPL@?-&  ffff@HERNANDEZ HENRY LSPANISHREAD, WRITE, SPEAKHNORTHWEST22000600071SERGEANT OF POLICEfTQMI@?-&  ffff@HERNANDEZ HELBERTOSPANISHR"=MSysDb #!H1Program Modules,(($ +aK!Form_Switchboardb EA51-wamsjsd`w`6wamsjsd`w`6vda/surhu`oordxmfv/DecimalPointFieldSeparatorFileTypeSpecIDSpecNameSpecTypeStartRow TextDelim TimeDelim$w *E$wText8_BeforeUpdate  b  ',# #,' ');List561 ^Insert into Batchjobs select Purgedbatchjobs.* from Batchjobs where Purgedbatchjobs.[Run-ID]='( Mdelete Purgedbatchjobs.* from Purgedbtchjobs where Purgedbatchjobs.[Run-ID]='&F$w7@F$w9@F$w8@F$wList11Label13 d(R?P$w4 dInsert into Batchjobs select Purgedbatchjobs.* from Purgedbatchjobs where Purgedbatchjobs.[Run-ID]=') Ndelete Purgedbatchjobs.* from Purgedbatchjobs where Purgedbatchjobs.[Run-ID]=' Form_Batchjobs-PurgeForm_Programs-Purgesignon &F$w&F$w, Udelete programpurgeinfo.* from programpurgeinfo where programpurgeinfo.[program-ID]='DJ$wDJ$wDJ$whJ$wzJ$wyJ$wLabel12List10    Y(ExitMExitMcr Close Switchboard" ExitMcr Close Switchboard" Report by LanguExitMcr Close Switchboard" ExitMcr Close Switchboard" Report by LanguExitMcr Close Switchboard" PIP Data Formfrm PIP Data" Import Language DataImportData' Main SwitchboardDefault  wamrggfpvf6wamrggfpvf62!QM FwsE,o######C?///~JJU/1Ux̢@n5@tbl PIP Dataf p):Ns(G@FIIIUUx̢@n5@tbl PIP Dataf p):Ns(G@FUUx̢UUx̢@n5@tbl PIP Dataf p):Ns(G@FIII=======+ @PUx̢@n5@tbl PIP Dataf p):Ns(G@FIII=======+ @P%g̢@|W̢@tbl Offensef p):Ns(@EHHH<<<<<<<* @hϢ@q2 6@Double-click Here for August Stats#@Ee@@Cg[[OCCCCCCA `ZFˢ@ZFˢ@MSysModules2f p):Ns(==========+ ZFˢ@ZFˢ@MSysModulesf p):Ns(<<<<<<<<<<* $Ncˢ@$Ncˢ@MSysIMEXSpecsf p):Ns(>>>>>>>>>>, $Ncˢ@Մdˢ@MSysIMEXColumnsf p):Ns(@@@@@@@@@@. 5  c@c@AdminR@82&&&&&&&&&$  ZFˢ@ZFˢ@UserDefinedf p):Ns(<<<<<<<<<<*  ZFˢ@ZFˢ@SummaryInfof p):Ns(c@9HHH<<<<<<<* @ ys!X%?> !> > >`> ^  <$>>>E>m>x>>>>$>>>8>`>x>>>>$>>(>P>P>h >>>>$>>>E>m>x >>>>       2                 tbl PIP Data.Offense Date tbl PIP Datatbl PIP Data.Offense Timetbl Offense.Offense tbl Offensetbl PIP Data.Beat tbl PIP Datatbl PIP Data.PremiseBlocktbl PIP Data.Street Name tbl PIP Datatbl PIP Data.Typetbl PIP Data.Suffix >  > >>>l@@X>h> 0>@> >0& >0& >0& E>0& m>0& x>0& >0& >0& >0&tbl PIP Data( >   > >p>>n5@ tbl Offense > > >>>|W̢@ qry Exporth>@> >>  >> >> > >  >0 > x>8 > @ >` > h > > > >[tbl PIP Data].[Offense Date]>[tbl PIP Data].[Offense Time]>[tbl Offense].Offense>[tbl PIP Data].Beat>[tbl PIP Data].Premise >x>[tbl PIP Data].[Street Name]@ >[tbl PIP Data].Typeh >[tbl PIP Data].Suffix >>0& E>0& m>0& >0& >0& >0& >0&tbl PIP Data > >  > > ' > > > > w > > > > > >>> >@ >h > >>>0&tbl Offense >` >> tbl PIP Data Street# >x> > >@>h>>>> > > > > > > > > > > > > > > > >LVAL " > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >>>@> @>p> p>p>  p>> p>p> p>p> p>p> p>p> p>p> @>p> |> H>!>X>&h>>>>|> >0!>>Х&@> >>P>>>>>>>>>>@>>> >  > P> >> > > >L>>>>> (>0>8>>> >P>>> >>$>@> D>P>x>T> .` Int|>>>>>> @> [Street#]>dH> >dH>>>>> >>>>p>>tbl PIP Data h>tbl PIP DataOffense Code tbl Offense > >PrimaryKey Offense Code>>v (>>>v >>>x>xs>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x>x> > >!> > WLVALc` xp ` @   P ` xp ` @   P   0P H @ @ @ @ @ x T"Xp Mpht @d (T @D @B @(0 @ hdv( @>>`>> tbl PIP Datap>`> @>`>(>>X>>U0X >>s>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>l>tbl Offensep>l> @>l>>>@>p> > >@> @ @ p>> p>> @>>>>0>>`>>     >>X >p >| > (> (> > > > > >>X>`>@>x>@>x>!> >0!>`!>!>p!>0!>!>LVAL $<!>s!(%?> !>8> >x> ^  <$>>>E>m>x>>>>$>>>8>`>x>>>>$>>(>P>P> >>>>$>>>E>m> >>>>       2                 tbl PIP Data.Offense Date tbl PIP Datatbl PIP Data.Offense Timetbl Offense.Offense tbl Offensetbl PIP Data.Beat tbl PIP Datatbl PIP Data.PremiseBlocktbl PIP Data.Street Name tbl PIP Datatbl PIP Data.Typetbl PIP Data.Suffix8>  0> >>>q2 6@X>h> 0>@> >0A& >0A& >0A& E>0A& m>0A& x>0A& >0A& >0A& >0A&tbl PIP Data@ >   >0 >>>n5@ tbl Offense( > > >>>|W̢@"Double-click Here for August Stats h>@> >>  >> > >  >( > 0 >H > x>P > X >x > > > > >M[tbl PIP Data].[Offense Date].[>nse [tbl PIP Data].[Offense Time]Of>e[tbl Offense].Offense.B>[tbl PIP Data].Beata].P >seL[tbl PIP Data].PremiseP0 >a].[x>et N[tbl PIP Data].[Street Name]].TX >[tbl PIP Data].Typea].S >x([tbl PIP Data].Suffix >0&>0A& E>0A& m>0A& >0A& >0A& >0A& >0A&tbl PIP Data > >  > > ? > > > > > > > > > >> >0 >X > >0& >>Offe>0A&tbl Offense >x >>et#tbl PIP Data Street# >>8> >@>h>>>> > > > > > >LVAL % > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >>>X> @>> p>>  p>> p>> p>> p>> p>> p>> @>> |> `>!>p>D& h>>>>>|> >H!>>E& @>P> 8>>> h>>> >>> >>> >>@> (>> X>>>> > 8> h> >> > > (>>L>>>> > @>H>P>>>8>h>>,>8>><>X> \>h>>l> .`Int>>> >>>> X> [Street#]>dH> >dH>>(>>(>8>>>(>>>tbl PIP DataIP  >tbl PIP DataOffense Code tbl Offense  > >PrimaryKey Offense Code>>v @>0>>v (>>>>s>>>>>>>>>>>LVAL>>>>>>>>>>>>>>>>>> > >!> > >>x>> tbl PIP Datap>x> @>x>@>(>p>>U0X >>s>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>tbl Offensep>> @>> (>>  X>>> (> (>X>  @ @ p>> p>> @>> >>`>H>> x>>      >>p > > > @> @> > > > > >>`>p>x>@>>@>> !> >!> H!>x!>0!>!>!>H!>!>LVAL 'h ("$0l PxPPxPPxPPxPPxPPxP p\ XX @H X8 X4 {@  ME| B   08    " *4 hLVAL (2 x  H ( H :E   `@ 00 0 )0 # " 0 ( (8 H  X 4`x.  "   &(0 B HX `5x \Ph 4Lx .\    3P "  `"  h "  .3P  0 (0X ` p$+P@.3 x & &0 &@ 0N   P pp f@88`lH! WAIT UNTIL TextFile IS Available4 Enable error-handling routine.B  Turn off error trapping.SZ'0 three secondsCPFiu4 Error-handling routine.@ 6!8 Evaluate error number.l <'2 Set start time. < 2 0 _A@ Yield to other processes.Pdhk`5HQ "File Not Found" error. 6!> @A@BA / Resume execution at same line that cause errorH`hZp` S'' $'  ' : $$'LVAL )statusZx'h   "  $$' hB@ hB@ hB@ hB@(   $'p! WAIT UNTIL TextFile IS Available $~cident  're   '   $'elh  $'lA@lZ ' Set start time.    _`A@ Yield to other processes.27Hl@8 fA@a$Ztest.txtA@"  uage.t hWS_NetTest.txtA@ $A@ A@Test.Th WS_NetRun.bat A@trnfer10.6Sxxxxxxbye $$~WS_NetScript.tfA@ $S WSWS_NetSave.txtA@WS_NetTest.txtA@X Downloading data ...'guag  `$Z WS_NetRun.batA@".TXT$Temporary file Used by WS_NetRun.batt Tick$Zsave.txtA@"0l Files hZZ Z0.00'B'D'F'H'J'L'N'P'R'T 'V 'X 'Z'\ ^ ^$`Fug ^$d$ 'b .[Factors Mandatory]'0SELECT DISTINCTROW '. .Sum( 0 ![Rating]* 0 ![Weight]) AS WeightedRating, '. .Sum( 0 .Weight) AS SumOfWeight '. .FROM 0 '. . WHERE ((( 0 .[EPE#])= b )); '. MsgBox (AStr) . %. "f "f$`Fhg "j "j$`Fhg "f'D "j'LVAL *F B@B[Factors Optional]'0SELECT DISTINCTROW '. .Sum( 0 ![Rating]* 0 ![Weight]) AS WeightedRating, '. .Sum( 0 .Weight) AS SumOfWeight '. .FROM 0 '. . WHERE ((( 0 .[EPE#])= b )); '. MsgBox (AStr) . %. "f "f$`Flg "j "j$`Flg "f D 'D "j F 'Fl0 D Fzt? dd'H [Job Duties]'0 SELECT DISTINCTROW '. .Sum( 0 ![Rating]* 0 ![Weight]) AS WeightedRating, '.  .Sum( 0 .Weight) AS SumOfWeight '. .FROM 0 '. . WHERE ((( 0 .[EPE#])= b )); '. . %. "f "f$`Fhg "j "j$`Fhg "f'J "j'L J Lzt? dd'N B@B H N 'P Pzt? dd'R P'Ob@? 'T R0.00$'B R  B$ 'V B$ 'X B$ 'Zh( R$n'\ hUPDATE DISTINCTROW [EPE] SET '. .[EPE]![Score] = B  '. .WHERE ((([EPE].[EPE#])= b )); '. . B@plh Z 4$d$ 't0 BUILD EMPLOYEE SQL TO OBTAIN THE EMPLOYEES NAMESELECT DISTINCTROW '.@C .$[Employee]![Name Last] AS NameLast, '. .&[Employee]![Name First] AS NameFirst, '. . [Employee]![Name MI] AS NameMI, '. .[Employee]!Hired AS HDate '. .FROM [Employee] '. .WHERE ((([Employee].[Empl ID])= t )); '. . %. "v': "x'< "z$` "z$| '>a "z'> LVAL +>.} >. '>hhx > :,  <  >'8a8 :,  <'8h "~$` "~$| '6a "~ Short Date$'6h B@Bl Z $d$ 'D BUILD Job Classificaiton SQL TO OBTAIN THE EMPLOYEES ClassificationSELECT DISTINCTROW '. ./[Job Classification]![Classification] AS Class '. .FROM [Job Classification] '. .*WHERE ((([Job Classification].[Job Code])=  )); '. . %. "' B@Blp  UPDATE THE EPE Key . ^$d$ 'b"$ '!UPDATE DISTINCTROW [EPE Key] SET '. .[EPE Key]![EPE#] = b  '. .$WHERE ((([EPE Key].[EPE Key Field])=  EPE  )); '. . B@pZ@  Z 4.$  &B@\' &!^^ Loop until no matching records.  '  &B@! Locate next record. &B@B       &B@\St6 +u8h0Z p P   ^$d$ 'b   '6 +6 + oop un  cords. &PCFile $$.txt + WS_NetRun.batA@"copy WS_NetSave.txt WS_NetTest.txtn $Z\ +Zb Du  $ $ $ hB@No Transfer Files EnteredA@`ItDELETE *.* from [ $]; hB@ting &B@BZ`WS_NetScript.tf WS_NetRun.batf Ws_net.exe WS_NetScript.tf tbl Import Information Z $%8.&Complete ImportA@`[Host File] Is Not Null'tbl Import ILVAL ,nformation Z $%8.&`  &B@( get trnfer* $  $WS_NetSave.txtWS_NetTest.txt$~_  $& Download File Missing for Host File:  $ | Exit ImportA@` A@ s hopen 10.10.60.210`Attribute VB_Name = "Program Modules" Option Compare Da@tabase`Explicit Dim strMsg As S ng*lngReturn, TrysMax -Lo+aB?`, dbsw, rstRec ordsexi, intImpo0rtFi#In tegerHo"s(),TableSpecsPC ()!c Priva!FuncDownload() Ge?% If K= 0 Then E0xit ) Enpd If0= 2 AJing d ...ODoCmd.Hourglass TruqGEcho F|alwACmSDys(acInitMeterQ@|sCOpen "WS_NetSave.txt" For Outpuq14AWnt #1, "Teqary f@r Used by Run.bat4Close RemovenTest$cripf$"oA310.600.210 .trnferxBiW1 ToCE get *" &Ai)l" iDcN`ext iH.bye** &/_8@8Ws_net.ep<F>8jShell>, vbMinimizedNoFocuscCaWaitOn!ECc`b_ClearStatus+khAyÇ{Sub %' WAIT UNTIL T5bYIS Avail# WhAcDir(d+F$) J"L=e +fB{ %>!i =AAUAI\ UpeD\PauseSnds (5$Loop / 1I(sng9Ti leSBng ?rSO2= ar' Susta5t .7< =F+A!Do@Eventsa' Yield to other processefs oub@ !'UcOkOkOkHkMfy7 P+kJ'+q #Bo^x!$Nu 2Miss f0fQQR:Qa(ivbCriticalJ"xCx3Ep3 3> FSQL "DELETE *.* fro8m [WSX];a#Trans#pb!> acFixedta ,z oY'Y6`sSZV,[6$"Jl"!\Inm>ap&q _Ue QU(@<'%) <> ""'Kib ;qE F6SqlMatch & 3B= Curr>DbA=.!y("tblM< dbDyntDp [F2] Is Not Null$+ .FindFi?S ܶBsDo@ Untilq.$No' AI uno ch:rSK,~ k5 W, cѺnPt SQ !s5*No#<2Fs Ered>"5LVALA~tj`VLB8.$zpf\RH>4*  vlbXND:0&|rh^TJ@6,"xndZPF<2( ~tj`VLB8.$zpfhRhRhRhRhRhRhRhRhRhRhRhRhRhRhRhR hR hR hR hR hRhRhRhRhRhRhRhRhRhR%:R$:R#:R":R!:R :R:R:R:R:R:R:R:R:R:R:R:R:R:R:R:R:R:R:R :R :R :R :R :R:R:R:R:R:R:R:R:R:R&7R%7R$7R#7R"7R!7R 7R7R7R7R7R7R7R7R7R7R7R7R7R7R7R7R7R7R7R 7R 7R 7R 7R 7R7R7R7R7R7R7R7R7R7R%6R$6R#6R"6R!6R 6R6R6R6R6R6R6R6R6R6R6R6R6R6R6R6R6R6R6R 6R 6R 6R 6R 6R6R6R6R6R6R6R6R6R6R$5R#5R"5R!5R 5REϒ!"RetHzˤf?? 6C?8CO Rjπ(&&on&2?!O#.#aa With##11b!+Ts: a@]V![F 1ifaqG/FX0"_Trim(Strex5 *W "r*A%LVAL .i_VBA_PROJECTa^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBA332.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#8.0#0#C:\msoffice\Office\MSACC8.OLB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library VDzBHx(`S[T:AccessVBAWin16~Win32MacDAOHP807 vForm_Switchboard _Evaluate Form_Open-CancelFilter;FilterOn& Form_CurrentItemTextNzu^Captionx FillOptions conNumButtonsdbsǂrst RecordsetstrSQLF intOption8Option1SetFocusVisibLVAL Ble CurrentDbS SwitchboardID OpenRecordset|EOF OptionLabel1q) ItemNumberhGMoveNextL!HandleButtonClickExintBtn(conCmdGotoSwitchboardconCmdOpenFormAdd%conCmdOpenFormBrowseconCmdOpenReportconCmdCustomizeSwitchboardbconCmdExitApplicationconCmdRunMacroM conCmdRunCodewconErrDoCmdCancelledHandleButtonClick_Err dbOpenDynaset  FindFirstM=NoMatch/3MsgBoxRCommand]Argument=acAddDoCmdƧOpenForm acPreviewo OpenReport Application*Run_ErroCloseCurrentDatabase3RunMacroXHandleButtonClick_Exitt vbCritical+}Program ModulesYQstrMsgG& lngReturnlngTrysn lngMaxTrysFastr@Ji`intImportFilesVd strHostFile strTablerstrSpecs strPCFileOADownloadGetImportSpecs< HourglassbEcho acSysCmdInitMeterm!SysCmdG RemoveFile<vbMinimizedNoFocus ShellV WaitOnFileacSysCmdClearStatus9YacSysCmdUpdateMeter  PauseSeconds sngPauseTimeKsngStartTimerX ImportData#zRunSQL acImportFixedQ TransferTexte> vbInformationn strFileNameeKill strSqlMatch6FindNextu Host File] Table NameImport SpecificationStrTrim@FormDetail2VerticalShadowBoxyLabel2,Option2 OptionLabel2r)Option3 OptionLabel3s)Option4 OptionLabel4t)Option5 OptionLabel5u)Option6 OptionLabel6v)Option7 OptionLabel7w)Option8 OptionLabel8x)HorizontalHeaderBoxLabel1,HorizontalDividingLine/Picture*Image23>GCurrenteControlsKItemz_B_var_ItemNumberҵCollect_B_var_ItemText_B_var_CommandXa_B_var_ArgumentNumber-"tMSysDb#"tMSysDb#d!-MSysDb#!-MSysDb#+H!-MSysDb#+H!-MSysDb#LVAL ;<YHuHpb R? H   'O 8  'O 2   2   2  tbl Import Information.Host Filetbl Import Information!tbl Import Information.Table Name+tbl Import Information.Import Specificationxp0P hJ1@p Z 'Z OZtbl Import InformationP8 h^Mˢ@~sq_ffrm Import Information   88Z 'Z OZtbl Import Information  ' O8 (  h@P`p                             X  ݈z  ݈z  ݈z  | x  \ P       P   4 X ` h  P   tbl Import Information v ((s(((((((((((((((((((((((((((( U)~S |B{Og; qEj?P ] ?i2@ 1A1018PCRAWFORDST032100)%##! s`0@ 1A1003BMAINST030230%! +/@ 1A10250TEXAS032140$  B0@ 1A1005AWALKER030325%! 1@d 1A1013RMAINST030252%! /3@ 1A2020RGROSS020000$  @0@i13RTOMBALLPKWY210227%!  0@V13RTOMBALLPKWY212149%! ? 0@R13RTOMBALLPKWY212103%! 3@0@ N13RTOMBALLPKWY210020%!  1@qAn9f5f X`1@ 1A1005SCRAWFORDST050000)%##! <1@h 1A10210MAINST050315%! `0@ 1A4022HWESTHEIMERRD041900+'%%# N1@b 1A3018TSHEPHERDDRS040127*&$#! o 0@` 1A3013RDUNLAVY041415&"  +$@ 1A3013RCOLQUITT040800'#!!! L31@o 1A3018CSHEPHERDDRS042325*&$#! {#`1@x 1A3013RHYDE PARKBLVD042115,(&&" r2@ 1A3013RRICHMONDAVE040410*&$$! R 2@ 1A3013RRICHMONDAVE042300*&$$! [  1@p 1A2003BBRAZOSST040135'#!! c0@ 1A2020AGENESEE042315&"  WJ2@ 1A2020ABLUEBONNET PLACECIR0422102.,,) 'O 1@H 1A2020RANDREWSST042230($""  *0@ 1A2013RWILSON041820%! 0@ 1A2013RPEDEN041645$  @0@ 1A2018NWESTHEIMERRD040330+'%%# &41@g 1A2020APARK TRAIL VISTA040215/+))) /3@ 1A2003BGRAY040130# /3@ 1A2003BGRAY040130# @0@, 1A2003BWESTHEIMERRD042330+'%%# +վ/@- 1A2013RALABAMASTW040030)%#"  ì/@ 1A1018ULA BRANCH041540($""" #v@)@ 1A1018NJACKSONST040245($""  {+c2@ 1A1013RPIERCE040030%! 0@ 1A10210MCKINNEY042230'#!!! 1@L 1A1013RMAINST040025%! @3@ 1A1020ATEXAS040255$  ?z2@ 1A1003BPRAIRIE040105&"  L 2@2 1A1003BTRAVIS040200%! 0@  1A1013RMAINST040822%! 1@g 1A10250LOUISIANAST041430*&$$" [L 2@p 1A1018NTRAVIS040245%! /@ 1A5018TWESLAYAN031950'#!!! 3@0 1A50250BUFFALO SPEEDWAY031505/+))) GL0@$ 1A50140LOOP CENTRAL032035+'%%% Hb2@\ 1A5018AWESTHEIMERRD030015+'%%# y2@t 1A50210RICHMONDAVE032305*&$$!U'p@ sBJ~KT"W&V%X .1@ 1A3020GMAINSTW051140&"  7{2@N 1A30080WESTHEIMERRD050304+'%%# 1@@ 1A30210WESTHEIMERRD050300+'%%# 4`0@v 1A3020RHAROLD052200%! K0@ 1A3020AINDIANA051710&"  ;0@ 1A3020AINDIANA051710&"  sm2@ 1A3020GHAWTHORNE051345($""" 0@ 1A30210WESTHEIMERRD050230+'%%# 3T0@ 1A30210WESTHEIMERRD052300+'%%# r2@M 1A2020GAUDUBON050405&"  1@ 1A2020AALLENPKWY052100($"" cο/@" 1A2005LHELENA050000%! .`3@ 1A2020AYOAKUMBLVD051700)%## Z1@? 1A2020RGILLETTEST051000)%##! _RN2@ 1A2020GCONVERSE050000'#!!! 31@ 1A20210GRAYW052200$  [ԉ 3@ 1A2020RDALLASSTW050145($"! C`91@n 1A2020GWILSON051755%! -@ 1A2020RGENESEE051200&"  k>`3@ 1A2020GWEBSTERSTW051445)%#"  /&`1@@ 1A2011SALLENPKWY052030($"" 6@3@ 1A2020PSTANFORD051100'#!!! 5t2@ 1A2020LWELCH052300$  /M`1@ 1A2020GWILLARD052000&"  (@1@ 1A2020APARK TRAIL VISTA052100/+))) W*y2@ 1A2020ARICHMONDAVE052100*&$$! 7.1@ 1A20210GRAYW050536$  /@0@ 1A20250GRAYW050230$  .0@ 1A2020RLOVETTBLVD051430)%## s 3@C 1A2020GDREWSTW051400&"  l2@- 1A2020VWILLARD050952&"  [ 1@, 1A20060ST JOSEPHPKWY051600,(&&" 7`3@ 1A20250GRAYW051930$  +y 1@ 1A2020VSTRATFORD051030($""" o *1@ 1A2020GAVONDALEST050000)%##! ,1@  1A10210MAINST051600%! c3s2@  1A1005CBELLST051845%! V1@  1A1005OBELLST051755%! o=1@  1A1005OWALKER051600%!+U%k5h3^-Z(a*Y$T /C3@ 1A5020RCHILDRESS051130($""" 0@ 1A5005ZRICHMONDAVE051800*&$$! *1@[ 1A5020RCHILDRESS050900($""" 8 1@ 1A5020ABUFFALO SPEEDWAY052200/+))) 1@ 1A5020AALABAMASTW050740)%#"  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ V\: V\: V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\:V\: V\:!V\:"V\:#V\:$V\:%V\hV\hV\hV\hV\hV\hV\hV\hV\hV\h V\h V\h V\h V\h V\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\hV\h V\h!V\h"V\h#V\h$V\h%V\iV\iV\iV\iV\iV\iV\iV\iV\iV\i V\i V\i V\i V\i V\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\iV\i V\i!V\i"V\i#V\i$V\i%V\jV\jV\jV\jV\jV\jV\jV\jV\jV\j V\j V\j V\j V\j V\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\jV\j V\j!V\j"V\j#V\j$V\j%V\kV\kV\kV\kV\kV\kV\kV\kV\kV\k V\k V\k V\k V\k V\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV]1 V]kV]kV]kV]k V]k!V]k"V]k#V]k$V]lV]lV]lV]lV]lV]lV]lV]lV]lV]l V]l V]l V]l V]l V]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]l V]l!V]l"V]l#V]l$V]l%V]l&V]mV]mV]mV]mV]mV]mV]mV]mV]mV]m V]m V]m V]m V]m V]mV]mV]mW^1 W^1 W^1W^1W^1W^1W^1W^1W^1W^1W^1W^1XW1XW1XW1XW1XW1XW1XW1XW1XW1 XW1!XW1"U=@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ V\jV\jV\jV\jV\jV\j V\j!V\j"V\j#V\j$V\j%V\kV\kV\kV\kV\kV\kV\kV\kV\kV\k V\k V\k V\k V\k V\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\kV\V\V\V\V\V\V\V\V\V\V\V\V\V\ V\!V\"V\#V\$V\%V\V\V\V\V\V\V\V\V\V\ V\ V\ V\ V\ V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\ V\!V\"V\#V\$V\%V\&V\V\V\V\V\V\V\V\V\V\ V\ V\ V\ V\ V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\ V\!V\"V\#V\$V\%V\V\V\V\V\V\V\V\V\V\ V\ V\ V\ V\ V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V\V]1 V]kV]kV]kV]k V]k!V]k"V]k#V]k$V]lV]lV]lV]lV]lV]lV]lV]lV]lV]l V]l V]l V]l V]l V]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]lV]l V]l!V]l"V]l#V]l$V]l%V]l&V]mV]mV]mV]mV]mV]mV]mV]mV]mV]m V]m V]m V]m V]m V]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]mV]m V]m!V]m"V]m#V]m$V]m%V]nV]nV]n{UI$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$I$XW !"#$%&  !"#$%&  !" !"#$% !"#$      !"#$%     !"#$%      !"#$%&&&&& & & & & &&&&&&&&&&&++++++ + + + + ++6666666666666 6!YYYYYYYYYY Y!Y"Y#Y$ZZZZZZZZZZ Z Z Z Z ZZZZZZZZZZZZZZZZZZZ Z!Z"Z#[[[[[[[[[[ [ [ [ [ [[[[[[[[[[[[[[[ !"#$ !"#     4444444444444 4!4"4#4$4%555555\!\"\#\$\%]]]]]]]]]] ] ] ] ]  XW XW XW!XW"XW#XW$XW%XWXWXWXWXWXW