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`amfvdrxamfbmjblifufgrukxm}bujofvw`wvov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvwamrggfpvfwamsjsd`w` `bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdufgfufpbf5wamrggfpvfwamsjsd`w`5gfpvfwamsjsd`w`5`w`5gfpvfwamsjsd`w`5amrggfpvfwamsjsd`w`5ggfpvfwamsjsd`w`5wamrggfpvfwamsjsd`w`5fufpbf5wamrggfpvfwamsjsd`w`5wamrggfpvfwamsjsd`w`55wamrggfpvfwamsjsd`w`5rggfpvfwamsjsd`w`5d`w`5rggfpvfwamsjsd`w`55rggfpvfwamsjsd`w`5w`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  GGGGG G G G G G G G G G G G G G G 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?+++zJJU/1UUx̢@N2@tbl PIP Dataf p):Ns(G@FUUx̢@N2@tbl PIP Dataf p):Ns(G@FIII=======+ @UUx̢@N2@tbl PIP Dataf p):Ns(G@FIII=======+ @PUx̢@N2@tbl PIP Dataf p):Ns(G@FIII=======+ @P%g̢@|W̢@tbl Offensef p):Ns(@EHHH<<<<<<<* @hϢ@̒2@Double-click Here for July Crime Stats @Fe@@Ck__SGGGGGGE `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<<<<<<<* @ LVAL !<!ps!x%?p !p8p pxp ^  <$pppEpmpxpppp$ppp8p`pxpppp$pp(pPpPp pppp$pppEpmp pppp       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.Suffix8p  0p ppp̒2@Xphp 0p@p p0A& p0A& p0A& Ep0A& mp0A& xp0A& p0A& p0A& p0A&tbl PIP Data@ p   p0 pppN2@ tbl Offense( p p ppp|W̢@&Double-click Here for July Crime Statshp@p pp  pp p p  p( p 0 pH p xpP p X px p p p p pM[tbl PIP Data].[Offense Date].[pnse [tbl PIP Data].[Offense Time]Ofpe[tbl Offense].Offense.Bp[tbl PIP Data].Beata].P pseL[tbl PIP Data].PremiseP0 pa].[xpet N[tbl PIP Data].[Street Name]].TX p[tbl PIP Data].Typea].S px([tbl PIP Data].Suffix p q+p0A& Ep0A& mp0A& p0A& p0A& p0A& p0A&tbl PIP Data p p  p p ? p p p p p p p p p pp p0 pX p p q+ ppOffep0A&tbl Offense px ppet#tbl PIP Data Street# pp8p p@phpppp p p p p p pLVAL " p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p pppXp @pp ppp  ppp ppp ppp ppp ppp ppp @pp |p `p!pppD& hppppp|p pH!ppE& @pPp 8ppp hppp ppp ppp pp@p (pp Xpppp p 8p hp pp p p (ppLpppp p @pHpPppp8phpp,p8pp<pXp \phpplp .`Intppp pppp Xp [Street#]pdH> pdH>p(pp(p8ppp(ppptbl PIP DataIP  ptbl PIP DataOffense Code tbl Offense  p pPrimaryKey Offense Codeppv @p0ppv (ppppspppppppppppLVALpppppppppppppppppp p p!p p ppxpp tbl PIP Datappxp @pxp@p(ppppU0X ppspppppppppppppppppppppppppppppppppptbl Offenseppp @pp (pp  Xppp (p (pXp  @ @ ppp ppp @pp pp`pHpp xpp      ppp p p p @p @p p p p p pp`pppxp@pp@pp !p p!p H!px!p0!p!p!pH!p!pLVAL $ @ @ 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#+HProgram Modules!MSysDb#+HProgram 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(((((((((((((((((((((((((((( LVAL 2<  s%?HPA 2j Xx@@@@@2j          2 1Switchboard Items.SwitchboardIDSwitchboard ItemsSwitchboard Items.ItemNumberSwitchboard Items.ItemTextSwitchboard Items.CommandSwitchboard Items.Argument G7@ 20% j0% 0% 0% 0%Switchboard ItemsX@x JMˢ@~sq_fSwitchboard  X x   Xx20% j0% 0% 0% 0%Switchboard Items 2  j( 0 8 @ Xx `  @XpH 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  px  @x  px  | @8%       H        H <`hpx    H x Switchboard ItemsPrimaryKeyvLVAL ``s````````````````````````````0 H@ PSwitchboard Items PrimaryKey@P @`@@px LVAL 4<` ` s&?`` `` ``%`=`U`u````````0`H`h`````````````````!%`=`U`u`````                           tbl PIP Data.Incident# tbl PIP Datatbl PIP Data.Offense Datetbl PIP Data.Beattbl PIP Data.Premisetbl PIP Data.Street Nametbl PIP Data.Typetbl PIP Data.Suffixtbl PIP Data.Street#tbl PIP Data.Offense Codetbl PIP Data.Offense Time``  X` `@` `@h`x` `) `) %`) =`) U`) u`) `) `) `) `) tbl PIP Data`   @````N2@~sq_ffrm PIP Datax` `` `` `` 0`` H`` h`` ` ` `(` `0`  `8````0`H`h``````) `) %`) =`) U`) u`) `) `) `) `) tbl PIP Data ` ` ` ` %` ` =` ` U` ` u` ` ` ` ` ` ` ` ` ````0`H`h````` ``` `@`h```` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `DLVALP ` ` ` ```` ` @`` @`` p`` p`` p`` p`` p`` @`` p`` p``  |` ``` )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````LVAL 9<HsH$? H       2 tbl Offense.Offense Code tbl Offensetbl Offense.Offense @ () ()tbl Offensep |W̢@"~sq_cfrm PIP Data~sq_cOffense Code (H Ph[tbl Offense].[Offense Code]([tbl Offense].[Offense]P() ()tbl Offense  (P    @HPX`                             X  p  p  | 8 H )@ p   @  p 0 ( @ p   tbl Offense h  x PrimaryKey Offense Code v x  s                             @ tbl Offense PrimaryKey@  @ (LVAL 7i_VBA_MODULEs54A`S[!A`S[3A`S[xZ83A`S[4A`S[v*48<@DHLPTX\`dvhxlpptrxt|z|~H @[LS S(LX(L(>LLLLL @ @ 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 LVAL <<m!ps!$?p !p p p`p ^  <$pppEpmpxpppp$ppp8p`pxpppp$pp(pPpPph pppp$pppEpmpx pppp       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 p  p pppl@@,Xphp  0p@p  p q+ p q+ p q+ Ep q+mp q+ xp q+ bp q+epp q+ p q+  tbl PIP Data( p   p ppppN2@ tbl Offense p p ppp|W̢@ qry Exporthp@p pp  pp pp p p  p0 p xp8 p @ p` p h p p p p[tbl PIP Data].[Offense Date]p[tbl PIP Data].[Offense Time]p[tbl Offense].Offensep[tbl PIP Data].Beatp[tbl PIP Data].Premise pxp[tbl PIP Data].[Street Name]@ p[tbl PIP Data].Typeh p[tbl PIP Data].Suffix p p q+nEp q+mp q+p q+p q+p q+p q+ xtbl PIP Data p p  p p ' p p p p w p p p p p ppp p@ ph p ppp q+tbl Offense p` pp tbl PIP Data Street# pxp p p@phpppp p p p p p p p pKLVALW @ tbl Import Information݈z  ݈z(( LVAL = p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p ppp@p @ppp pppp  ppp pppp pppp pppp pppp pppp @ppp |p Hp!pXpt+hpppp|p p0!ppu+@p ppPpppppppppp@ppp p  p Pp pp p p pLppppp (p0p8ppp pPppp pp$p@p DpPpxpTp .` Int|pppppp @p [Street#]pdH> pdH>pppp ppppppptbl PIP Data hptbl PIP DataOffense Code tbl Offense p pPrimaryKey Offense Codeppv (pppv pppxpxspxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpxpx'LVAL3pxpxpxp p p!p p pp`pp tbl PIP Datapp`p @p`p(ppXppU0X ppsppppppppppppppppppppppppppppppppplptbl Offensepplp @plppp@ppp p p@p @ @ ppp ppp @pppp0pp`pp     ppX pp p| p (p (p p p p p ppXp`p@pxp@pxp!p p0!p`!p!pp!p0!p!pLVAL ?  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.