Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6p߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{wVCS ''          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`amfvbmjblifufgruvw`wvov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvwamjosruwjpgruo`wjrpwamrggfpvfwamsjsd`w` `bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdufgfufpbf5wamrggfpvfwamsjsd`w`5sjsd`w`5w`5rggfpvfwamsjsd`w`55wamrggfpvfwamsjsd`w`55wamrggfpvfwamsjsd`w`5ggfpvfwamsjsd`w`5wamrggfpvfwamsjsd`w`5fufpbf5wamrggfpvfwamsjsd`w`5gfpvfwamsjsd`w`5amrggfpvfwamsjsd`w`5mrggfpvfwamsjsd`w`5rggfpvfwamsjsd`w`5`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  @ @ @      55MPU 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       @@@@@  @ @ @ @ @ @ @ @ @ @777777777 777777777777 7! B  B  B BBBBD D D D BBBBBBB!B"B#BBDDDB$DDBBBBBBBBBBBB MDMDMDPDPDPDUDUDUD777777 7 7 7 777777777777777777777777777777777777777777777 @ @ GGAGBGCGDGEGFGGGHGIGJGKGL GMGNGOGGGGGGGGGGGGGGGG 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  wamrggfpvf6wamrggfpvf6<!QM FwsE,o######C?==9BJJU/1UUx̢@KP@tbl PIP Dataf p):Ns(G@=eIII=======+ @UUx̢@KP@tbl PIP Dataf p):Ns(G@=eIIIUx̢@KP@tbl PIP Dataf p):Ns(G@=eIII=======+ @P%g̢@|W̢@Ux̢@KP@tbl PIP Dataf p):Ns(G@=eIII=======+ @P%g̢@|W̢@tbl Offensef p):Ns(@EHHH<<<<<<<* @ 5hϢ@қ:P@Click Here for Stats @$E@@>CYMMA5555553 `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<<<<<<<* @  -5dH> -5-5-5-5(-5-5-5-5x-5-5tbl PIP Data  /p-5tbl PIP DataOffense Codebl Offetbl Offense  -5 -5PrimaryKeyense Offense Code-5-5v 0-5 -5-5v -5-5-5-5s-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-LVAL5-5-5-5-5-5-5-5-5-5-5-5-5-5 -5 -5!-5 -5 -5-5h-5-5PIP tbl PIP Datap-5h-5 @-5h-5 0-5-5X-5`-5-5U0X -5-5s-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5-5t-5tbl Offensep-5t-5 @-5t-5 -5-5@-5 H-5x-5 -5 -5-5 -5-5H-5  @ @ p-5-5 p-5-5 @-5-5 -5-50-5 8-5-5`-5h-5-5     -5-5` -5x -5 -5 0-5 0-5 -5 -5 -5 -5 -5-5-5 `-5-5h-5@-5-5@-5-5 !-5 -50!-5 8!-5h!-5!-5 !-5x!-50!-58!-5!-5LVAL $ @ @ gh pt v|@ @ @( @@ @X @p t @ d @ T @ D @ 4 @ $ @  @  @0 @H @` @x @ @ @ @ @ t @ d @ T @8 D @P 4 @ $ @  @ 0 P8ME "  < BX8   " : Y8X ` "h 6p *    6 4@ @x.A"A (  48 0p *DJ& (+P  :h D <2@H OX &Ox ,b  ,  0 @ B H 8P 2 8    ( 8 H X h &x  LVAL %  4 8 8*.HFex  B  B+  `  p      "   <5  0  Y8 X p  Yx    I "  4 00  `  h  2O     8  Y  8 @ `  h p   D     *   + 0 ,8  h  x    2 4 ($8HP8+X  xp06 Minimize the database window and initialize the form.< Move to the switchboard page that is marked as the default.,[ItemNumber] = 0 AND [Argument] = 'Default' ( (l4 Update the caption and fill in the list of options. "$ (A@ l/ Fill in the options for this switchboard page.# The number of buttons on the form.ZZ(ZHZhZ/ Set the focus to the first button on the form,- and then hide all of the buttons on the form9 but the first. You can't hide the field with the focus. ".B@0 , "Option ,$(2 OptionLabel ,$(2 ,. Open the table of Switchboard Items, and find* the first item for this Switchboard Page.$4.$!SELECT * FROM [SwitchLVAL &board Items]'* *, WHERE [ItemNumber] > 0 AND [SwitchboardID]= "6'* * ORDER BY [ItemNumber];'* * $%8.&3 If there are no options for this Switchboard Page,= display a message. Otherwise, fill the page with the items. &!:,There are no items for this switchboard page "<(a &!:Option &">$(2 OptionLabel &">$(2 &" OptionLabel &">$( &B@@h& Close the recordset and the database. &B@B $B@Bl2 This function is called when a button is clicked.+ intBtn indicates which button was clicked.1 Constants for the commands that can be executed.ZZ0ZHZ`ZxZZZ An error that is special cased.Z ZZX8- Find the item in the Switchboard Items table1 that corresponds to the button that was clicked.$4.$Switchboard Items Z $%8.&[SwitchboardID]= "6 AND [ItemNumber]= D &B@\< If no item matches, report the error and exit the function. &!^7There was an error reading the Switchboard Items table.A@` &B@B $B@Bsxhp &"b Go to another switchboard. FHQ%[ItemNumber] = 0 AND [SwitchboardID]= &"d ( Open a form in Add mode. HHQ &"d f hB@j Open a form. JHQ &"d hB@j Open a report. LHQ &"d l hB@n Customize the Switchboard. NHQ . Handle the case where the Switchboard Manager ) is not installed (e.g. Minimal Install).WZMAIN80.sbm_Entry pB@r tFCommand not available.A@`gLVAL '8  Update the form.,[ItemNumber] = 0 AND [Argument] = 'Default' ( "$ (A@  Exit the application. PHQA@v Run a macro. RHQ &"d hB@x Run code. THQ &"d pB@r# Any other command is unrecognized.PUnknown option.A@`k& Close the recordset and the database. &B@B $B@BzpshX`, If the action was cancelled by the user for- some reason, don't display an error message." Instead, resume on the next line. t Va)There was an error executing the command. |A@`zhh`fXPAttribute VB_Name = "Form_Switchboard"  Bas0{F3154121-7F85-11D2-BFC2-006008B0535B} |Cre atablTrue ]PredeclaId"@ExposeFals @TemplateDeriv%Custom izD$Option Comp@ DTv  <licit P/3 Sub Open(Cancel As Integer) ' Mini6e the d* windo@w and tializf.2 ov os pagat is mHarkwas2e`fault"!Me.Filter[ItemNu mber]0 AND [Arg ument'DC' oOn@ d E/@@DPCurr@(@Up=A+e caYa>fill@?,list of o-s@@/C = @Nz(Me!0Text], ""A#8ljs '@D C'! a%@V\&' TsnR.@tons zDqA"C t con]BubtB = 8)Dim dbsǝ r@FReco0rdseEstPrSQLA Sngint8D ' Set/0focuFLfiׁ C),c'Un hide a7`6e@# @. You@n 'tfield`bthg ->C1].FC  o6= 2 TNo,("" &).Visi䀡+Label NRg ' !&Ȭ rs,+f wc#a2ivRIPOd%a:H= oDbA\DE@SELECT * FROM []~&& " WHERE >  ID]=%a7Q ORDER BY ;d =dv.A)a( Ā'Ifa-r@T`noŊ#7(&\dis@y @a messa+  O0rwise, b2#V3A-`(.EOF)nAYbJ Z" ͐"EB! aWhi (Not "EMe`P Ta0^14^G.Mq7WendiIfWtClP!! reTL6yD4w4.oF(uncH mle%^Ck(@XBtnXac`efUc`LVAL (T{whenP'KTA}cAed` ''AEAics @which ws 'nst0antsd$wommP Qpcan be execPqjCmdGoto;1I8i1AdQ2Bhrowң3?1Report@4%e5ExiPtAppab= 6ORunMahcro7ComBz' An error@$3spec`l#vErrDo#li503O!P(#Hnf p Gon&_/F"/D#"g h5tha!ospondfd&& _gVg[w[2"",] DyntK9 F‰"kfR`@~"íqEBiS9# [@bmaexr(^32id<15_NoM~_sgBox "#^!7Sding1.^I!J1A0 ICQSelect C `![A]' GPo to@Sor i$QC7q?9UB aQOm/Im< np &K;, acE7 POdObc*SU_dX.OpenReport rst![Argument], acPreview  ' Customize the Switchboard.JCase conxCmd\RP'@ HandlOc!9wher^ M@anager 0) Then MsgBox "CommrTavaila0ble.IGoTo 0 .' Updatform hMe.Filter = "[ItemNumber]0 AN D 'Default' !CapA=@ Nz(hMe!BTH"L")%lO sˉExitaRA H[Clo@seCurrDpatab ga macroDMA Do@AvLOcode>CKM ׋Any or̃unrecognNElseřUnknown oBd End SelecC+4 rdset~ TA{M- .#1cdbs axButt~ gk_::A FuncKrr,' i!a was cance{byus@]` ' some reason, don't di splay eb}mess@ a`ead,o nB n@] link=z=3n|"GC#}!5%5`Aanexe@cutingcC.", vbCritl .>Ifc )0__SRP_2rU (' i 1 q I  9 a 9 I  QyiI9 qia@4a)@ 8LVAL )Qy@<a@ @Q@Da@ HQ@La@ PQ9@TaQ@Xy@\a@`@d)@ hQAvvv@laYxxx@p1@tppp@xy rrr@|a9ttt@ QQzzz@ai|||@ Q~~~@a@ Q{?P   0  8 $ hYd:h%x x $4:D%QdoT%"$ ,4`#0 X/0x6T4LVAL *Lh$ 0xdT4H.T:X %h h $T )hTncPAfX%T kn#L*F<%h h $T /L)hT5<AfX%T kn#L*F<%h h $T /L)hT5< ndP?h"$ QhxCpJlp*F,T:X%h h $Ta<`1p)hT6,< lp*1p+h'%',%'<%lpx Qht6<,t 4k2:%T:X%h h $T)hTt 4kOc%T: <:X%t $<,%h h $T )hT6<,Oc%T: <:X%t $<,%h h $T )hT6<,b:%t $%T: <:X%t $<,%h h $T)hT6<, t  t  x X0 xpt$LhT<,TKp"$ Qpx.p'@%'P%`%x Qpt6P@e:,<:`%p p $tdTD4$P@ tdTD4$$ "pp #l p+'' '@:`$NPP 6P@ K  0Y<:`%p p $@:,%Q abc OptionLabel1=HandleButtonClick(1)h1U` abcg iOption2=HandleButtonClick(2)Systemd5U`> abc OptionLabel2=HandleButtonClick(2)h1U` aabcg iOption3=HandleButtonClick(3)Systemd5U`> aabc OptionLabel3=HandleButtonClick(3)h1U` a bcg iOption4=HandleButtonClick(4)Systemd5U`> a bc OptionLabel4=HandleButtonClick(4)h1U` a bcg iOption5=HandleButtonClick(5)Systemd5U`> a bc OptionLabel5=HandleButtonClick(5)h1U` aM bcg iOption6=HandleButtonClick(6)Systemd5U`> aM bc OptionLabel6=HandleButtonClick(6)h1U` abcg iOption7=HandleButtonClick(7)Systemd5U`> abc OptionLabel7=HandleButtonClick(7)h1U` abcg iOption8=HandleButtonClick(8)Systemd5U`> abc OptionLabel8=HandleButtonClick(8)e125bcHorizontalHeaderBoxd58` ab:cdLabel1HP807 PIP DataTimes New Romanf3_5`} abZHorizontalDividingLineg26b} cPictureg6`<a<b cImage23(Cz+^  ;&~ & &$TNPPMicrosoft PowerPoint & TNPPP & &TNPP ~  ;45&-- &LVAL - TNPP.  --&  & &$TNPPMicrosoft PowerPoint & TNPPN & &TNPP&0y& -- & &y9&y9&m--0-qc--' & &y9&0 z- & &o?jAp & &*c,:$E{7\b ,Ex VJI+.Am & &2  & &y-   &  &  & &}- =oN  &  & &"&I&!-( & &D/pF & &D F((F & & ))E &  & &|> &  & &F9F&F'9F&V-[ & &0;b> & &D [:[ & LVAL .&9F \;=\ &  & &Ir &  & &F&'F&%5V-7[% & &0vbx & &.D [)v[ & &&uF \,vw\ &  & &<Ir< &  & &0"}&i-j> & &0I}&v!(v & &0/p0 & &0 0(z(0 & &w )|)0 &  &  & &- $.JEJ. & &-&.&dq-se & &]&E.(F & & & &.P Ly & &0 |. &  &  & &-&W c-eX & &\&8'!9 & &  & &'B ?r & &z'LVAL r# &  &  &  &  & &TNPP & --' & TNPP--' & &TNPP & --'X'C:\MSOFFICE\CLIPART\POPULAR\MEETING.WMF!MSysDb#!MSysDb#aKlForm_!MSysDb#+H7Program Modules!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'p> uAT#e4g3m=qA u |pL@I 1A20250ALLENPKWY031100($"" ̽ N@ 1A2013RHAWTHORNE030020($""" `| M@  1A2013RRUTHVEN030240&"  ZL@ 1A2013RRICHMONDAVE032030*&$$! J@ 1A2013RDREWST030105%! J@ 1A2013RFAIRVIEWST030430)%##! z N@ 1A1013RLA BRANCH030000($""" O`L@@ 1A1013RPOLK031230# HՍ`M@y 1A1013BST JOSEPHPKWY031052,(&&" > `K@ 1A1013RMAINST031100%! #N@ 1A10140FANNIN030000%! Ҏ M@ 1A1018NFRANKLINST030030)%##! J@ 1A1013RSMITH030100$  =J@a 1A1018PCHENEVERT030930($""" @fdL@, 1A1013RHAMILTONST030530)%##! TX1L@& 1A3013RWESTHEIMERRD020130+'%%# lN} M@ 1A3020RALABAMASTW020000)%#"  K@ 1A2020AAVONDALEST020300)%##! N N@, 1A1018PMILAM020300$   N@l 13RKATYFWY SERN210220&"  `K@X13RWEST LP SSERE211815'#!  <+K@250OUTSIDE211630! K@250WEBSTER TEXAS210837'#!!!  K@m)20RWIGGINSST181310# 9%K@J)140AIRPORTBLVDW181710&"  A@N@ 18CWINDFERN181420" @N@20RHOVEDENDR181700# M@13RSOUTHMOREAVEE181715'#!  J@250HUMBLE TEXAS181100&"  M@>!20RLEAFDALEDR071200$  0VL@18GALDINE BENDERRD071210)%##! L8K@18ASOUTH HOUSTON TEXAS072130-)''' K7@18OOUTSIDE070000! ;@N@!18UNORTHWEST FWY061305'#!!! @K@18PNORTH LP WSERN060930($"! <_ @K@520ROXHAM FALLSCT051800'#!! x K@,070VETERANS MEMORIALDR050510-)''% ӻN@13ROUTSIDE042000! ИyM@20ROUTSIDE041730!U&rC o> wAqAT"['Lm wL@& 1A3003BWESTHEIMERRD040000+'%%# Խ N@H 1A2013RMONTROSEBLVD040015+'%%! M@` 1A2018RMONTROSEBLVD040110+'%%! dJ@9 1A2020ABLUEBONNET PLACECIR0419302.,,) \ `K@P 1A2013RCLEVELANDST041510*&$$" 0À M@ 1A2018CHYDE PARKBLVD041625,(&&" P9 L@( 1A2018APARK TRAIL VISTA040035/+))) wM@ 1A20070RICHMONDAVE041550*&$$! xv]L@ 1A2020AALABAMASTW040830)%#"  M@ 1A1020RLA BRANCH040800($""" yM@@ 1A1013BMAINST041945%! ,`L@ 1A1013RTRAVIS040000%! !K`L@ 1A1020AFRANKLINST040045)%##! 0`K@ 1A1013RCONGRESS042230'#!!! OiL@  1A1013RHARDY040000$  ȅ@M@ 1A1013RMAINST040200%! J@X 1A1013RMAINST040205%! $¿ N@ 1A1011RMCKEE040710$  N@M@ 1A1003BTEXAS040205$  ^@M@ 1A1013RMAINST040200%! wM@ 1A5018BKIRBYDR031100&"  u,K@ 1A5005CPOST OAKPKWY031612+'%%! J@B 1A4020RPIPING ROCKLN031140,(&&$ ,(`M@ 1A3013RSANDMANS032300'#!  hG@L@ 1A3013RCOMMONWEALTH031640+'%%% L;J@ 1A3013RYUPON032250$  J@( 1A3013RMANDELL030225&"  ē N@ 1A3018NCOMMONWEALTH031100+'%%%  N@ 1A3013RDUNLAVY030013&"  1L@ 1A3013RMAINSTW030100&"   M@n 1A3018ACOLQUITT032120'#!!! HQJ@ 1A2018NMONTROSEBLVD030215+'%%! XkL@ 1A20080MONTROSEBLVD030050+'%%! K@ 1A20080MONTROSEBLVD030115+'%%! ЪD@L@ 1A2013RMASON030940$  J@ 1A2013RWHITNEY030230&"  hM@ 1A2013RTAFT030100# K`L@ 1A2018ASMITH030140$ (U%d3^(d3_.ZS$I| D`C@^ 1A3020RHAROLDST051500'#!! 5 N@ 1A3020PVERMONT052105&"  ԛM@ 1A3020ACALIFORNIA050800)%### `PE@ 1A20250WESTHEIMERRD051700+'%%# J@H 1A2005OMONTROSEBLVD051700+'%%! (K@ 1A20070STANFORD050537'#!!! lL@ 1A2024ESOUTHWEST FREEWAY SMITH05025062000 VJ@^ 1A2020RALBANYST051730'#!! @K@* 1A2024CWAUGH051830$  JF@ 1A20250WESTHEIMERRD051200+'%%# (K@ 1A20070WAUGH050000$  ̵J@l 1A2020CGENESEE051900&"  lr^L@ 1A2020RWEBSTERSTW051110)%#"  bK@ 1A2020ABLUEBONNET PLACECIR0500182.,,) ,mL@ 1A2005EFAIRVIEWST052000)%##! lm1K@ 1A20210MONTROSEBLVD052200+'%%! |N@ 1A20250RHODE PLACE051600*&$$$ tM@ 1A20060RHODE PLACE051700*&$$$ _@M@# 1A2020RKIPLING051826&"  )=L@& 1A2020ABLUEBONNET PLACECIR0519002.,,) $M@ 1A2020AHAWTHORNE052300($""" @"K@ 1A20080WESTHEIMERRD051830+'%%# M@ 1A2003BTUAM052200# L@d 1A2018AWILLARD051200&"  lW@L@n 1A2005VAVONDALEST051600)%##! PPK@ 1A2020PBUELCT051130%! pmU`L@ 1A10210PRAIRIE051000&"  M@% 1A1005VHARDY051120$  R`L@ 1A5020APIN OAK PARK042220+'%%% p>@N@ 1A5013RWILD INDIGO041530*&$$$ p>@N@ 1A5013RWILD INDIGO041530*&$$$ Ԝ0L@ 1A4018RWESTHEIMERRD040030+'%%# <K@ 1A3018NSHEPHERDDRS040320*&$#! 4 N@ 1A3018ADUNLAVY040630&"  J@ 1A3018ARICHMONDAVE040210*&$$! ܉ N@z 1A3020AMAINSTW041640&"  <J@@ 1A3013HSOUTHWESTFWY042245+'%%"LVAL 5<   s%?  H P A 2 j      X x   @ @ @ @ @ 2 j              2 1Switchboard Items.SwitchboardIDSwitchboard ItemsSwitchboard Items.ItemNumberSwitchboard Items.ItemTextSwitchboard Items.CommandSwitchboard Items.Argument      G7@   2 P% j P%  P%  P%  P%Switchboard ItemsX  @ x  JMˢ@~sq_fSwitchboard     X   x          X x   2 P% j P%  P%  P%  P%Switchboard Items 2    j (   0   8   @   X x     `    @ X 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      @ x  @ x  p x  @ x  p x  |   @  X%        H        H <` h p x      H x Switchboard Items PrimaryKey  vLVAL     ` `s ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` 0  H @    P Switchboard Items PrimaryKey@ P    @ ` @  @ p x  LVALKKDJFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden 2 Error   2 Field S  0 Row   KKDJFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden 2 Error   2 Field S  0 Row   KKD AccessVersionBuildShow Values LimitShow Values in IndexedShow Values in Non-IndexedShow Values in RemoteAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIconStartupShortcutMenuBarpubwiz_SpecNamepubwiz_PIP Export HTML  07.53       Switchboard             PIP Export HTML ;;;;;C:\Access;;1;;LVAL 8i_VBA_MODULEHxIe@( @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`