Standard Jet DBnb` Ugr@?~1y0̝cßFN c7ܜL(.` {6߱lCE73y[-|*|,+8/f_Љ$g'DeFx -bT4.0 dv  YaDDS aa Y   Y Y  Y Y  Y  vY  Y  4 Y 4v Y v Y  Y 4 Y 24vY  Y   Y  4Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypev4v44vv4v44vYYIdParentIdName        OY<P|S`Y Y Y  Y 2ACMFInheritableObjectIdSIDL YObjectId YBBSY  Y dY Y  Y d Y dY  Y  AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order  Y"ObjectIdAttribute -Y S  Y Y Y  Y P Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @@   0 AA@@     @ @ @ @ @@ @  @@ @Si`MdbmJMmkSi`MdbmJMmk+UQbQiJmdikSi`SY^mQiSi`UQbQiJmdikSi`fQi`YmkkoLSi`SdUkoLSi`UQbQiJmdikMdbmJMmkkoLSi`UiQJkQmiJfkkoLSi`bQs`JboSJMmoiQikoLSi`kQsQiOYkmiYMmkkoLkoLSi`OYkfdkJ^`dOo^Q8ifmUQbQiJmdikLvfQi`YmkifmUQbQiJmdikLvkQsQiOYkmiYMmifm`JY^YbUUQbQiJmdikifmkoiqQv mJL^QiQ^JmYdbkWYfkSdiSdU`JbJUQi!JO`Yb"OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`MdbmJMmk+UQbQiJmdik+kh+MmvfQ#+kh+MSi`MdbmJMmk+kh+MmvfQ$+kh+MSi`SY^mQi+kh+M^kmkQsQiOYkmiYMmk%+kh+MSi`SY^mQi+kh+M^kmmdsbk&+kh+MSi`UQbQiJmdik+Mdfv+kh+MbL`QJ^k'+kh+MSi`UQbQiJmdik+Mdfv+kh+MkoLSi`SdU(+kh+MSi`UQbQiJmdik+Mdfv+kh+MkoLSi`UQbQiJmdikMdbmJMmk)+kh+MSi`UQbQiJmdik+Mdfv+kh+MkoLSi`UiQJkQmiJfk+kh+MSi`UQbQiJmdik+Mdfv+kh+MkoLSi`kQsQiOYkmiYMmk+kh+MSi`UQbQiJmdik+Mdfv+kh+MmvfQ+kh+MSi`UQbQiJmdik+kh+MMd`LdF<+kh+MSi`UQbQiJmdik+kh+MMd`LdH<+kh+MSi`UQbQiJmdik+kh+MbL`QJ^k+kh+MSi`UQbQiJmdik+kh+MkoLSi`SdU+kh+MSi`UQbQiJmdik+kh+MkoLSi`UQbQiJmdikMdbmJMmk+kh+MSi`UQbQiJmdik+kh+MkoLSi`UiQJkQmiJfk+kh+MSi`UQbQiJmdik+kh+MkoLSi`kQsQiOYkmiYMmk +kh+MSi`UQbQiJmdik+kh+MmvfQ +kh+MSi`bQsUQbQiJmdi+kh+MMLdMdbmJMmYO +kh+MkoLSi`SdU+kh+MkoLkoLSi`OYkfdkJ^ +kh+SSi`MdbmJMmk +kh+SSi`MdbmJMmk+UQbQiJmdik+kh+SSi`fQi`Ymk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivUQbQiJmdikhivUQbQiJmdikSY^mQihivUQbQiJmdikYbSdhivUQbQiJmdikYbSdfQi`Ymkhiv`JY^YbUUQbQiJmdikhivkQiqYMQfidqYOQikhivkQsQiOYkmiYMmkhivmdsbkmL^MdbmJMmkmL^MdbmJMmmvfQkmL^OYkfdkJ^mL^OYkfdkJ^`QmWdOkmL^QhoYf`Qbmk mL^SdU!mL^SsUmvfQk"mL^UQbQiJmdik#mL^UiQJkQmiJfk$mL^`JboSJMmoiQik3mL^bL`QJ^k3mL^fQi`Ymk3mL^kQsQiOYkmiYMmk3mL^koiqQv`QmWdOk3JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOiQSQiQbMQ3mL^MdbmJMmkmL^UQbQiJmdik3mL^MdbmJMmmvfQkmL^MdbmJMmk3mL^OYkfdkJ^`QmWdOkmL^OYkfdkJ^3mL^QhoYf`QbmkmL^SdU3 mL^SdUmL^OYkfdkJ^3 mL^SsUmvfQkmL^UQbQiJmdik3 mL^UQbQiJmdikmL^SdU3 mL^UQbQiJmdikmL^UiQJkQmiJfk3 mL^`JboSJMmoiQikmL^UiQJkQmiJfk3mL^bL`QJ^kmL^UQbQiJmdik3mL^fQi`YmkmL^UQbQiJmdik3mL^kQsQiOYkmiYMmkmL^UQbQiJmdik3  @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"#$%&'()*+ , - . / 0123456789:3;3<3=3>3 ?3 @3 A3 B3 C3D3E3F3 !" #+$1383<3A3F3 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @TTTTTTTTT T T T TTTTTTTTTTTTT$T% T& T' T( T) T* T+ T, T- T. T/ T0 T1 T2 T3 T4T5T6T7T8T9T:T;T<T=T>T?T@TATBTCTDTETFTGTHTI[ [!["[#[$[%[&['[([)[*[+[,[-[.[/[0[1[2[3[4[5[6[7[8[9[:[;[<[=[>[?[@[A[B[C[D^ ^ ^ ^ ^!^!^!^!^"^ "^ "^ "^ #^ #^#^#^$^$^$^$^%^%^%^%^&^&^&^&^'^'^'^'^ (^!(^"(^#(^$)^%)^&)^')^(*^)*^**^+*^,+^-+^.+^/+^0,^1,^2,^3,^4-^5-^6-^7-_._._._._/_/_/_/_0_ 0_ 0_ 0_ 1_ 1_1_1_2_,2_-2_.3_/3_03_14_24_34_45_55_65_76_86_96_:7_;7_<7_=8_>8e8e9e9e9e:TJ:TK:TL;TM;TN;TO<TP<[<[=[=[=[>[>[>[?[?[ ?[ @[ @[ @[ A[A[A[B[B[B[C[C[C[D[D[D[E[E[E[F[F[F[_#_$_%___&_'_(_)_*_+____ee e __________ _!_"eeee e e eeeeeeeeeeee e e e+e+e+e1e 1e!1e"8e#8e$8e%<e&<e'<e(Ae)Ae*Ae+Fe,Fe-Fe.TTTT TT TTTT!T"T#-             !!!#!$!%!&!""'")"*"+","(#-#/#0#1#2#.$3$5$6$4%7%9%:%;% <%8&=&?&@& A&>'B'D'E'C(F(H(I(J(K(G)L)N)O)P)Q)M*R*****S+++++ +, , , , ------- -......////0 0"0#0!1$1&1'1%2(2*2+2,2-2.2/20212 22)3335363738393:3;3<3=3>3?3 @3 A3 B3 C3 D3E3F3G3H3I3J33334444444 4 4 4 4 4444 4 44444555555555 5!5"5#5$5 %5 &5 '5 (5)5*5+5,5 -5 .56/6162636460 @@ @iQSQiQbMQKmL^MdbmJMmkmL^UQbQiJmdikKmL^MdbmJMmmvfQkmL^MdbmJMmkKmL^OYkfdkJ^`QmWdOkmL^OYkfdkJ^KmL^QhoYf`QbmkmL^SdUKmL^SdUmL^OYkfdkJ^KmL^SsUmvfQkmL^UQbQiJmdikKmL^UQbQiJmdikmL^SdUKmL^UQbQiJmdikmL^UiQJkQmiJfkKmL^`JboSJMmoiQikmL^UiQJkQmiJfkK mL^bL`QJ^kmL^UQbQiJmdikK mL^fQi`YmkmL^UQbQiJmdikK mL^kQsQiOYkmiYMmkmL^UQbQiJmdikK . @ mL^MdbmJMmkKmL^OYkfdkJ^KmL^OYkfdkJ^KmL^SdUKmL^SdUKmL^UQbQiJmdikKmL^UQbQiJmdikKmL^UQbQiJmdikKmL^UQbQiJmdikK mL^UQbQiJmdikK mL^UQbQiJmdikK mL^UiQJkQmiJfkKmL^UiQJkQmiJfkK    mL^MdbmJMmkKmL^MdbmJMmmvfQkKmL^OYkfdkJ^`QmWdOkKmL^QhoYf`QbmkKmL^SdUKmL^SsUmvfQkKmL^UQbQiJmdikKmL^UQbQiJmdikKmL^`JboSJMmoiQikK mL^bL`QJ^kK mL^fQi`YmkK mL^kQsQiOYkmiYMmkK mL^koiqQv`QmWdOkK *d _ Z L _  $ b  - i G8t~zDCBO@!!Ƿ,T@Ƿ3 *-@*-@~sq_cfrmGenerators_copy~sq_csubfrmFOG94MR2KeepLocal Tlllllllj @N-@q-@~sq_cfrmGenerators_copy~sq_cNBMEALS94MR2KeepLocal Thhhhhhhf @3p4@p4@~sq_cfrmFilter~sq_clstSewerDistricts94MR2KeepLocal Tjjjjjjjh @#-S@.S@~sq_cfrmContacts~sq_cType94MR2KeepLocal TTTTTTTTR @3 @#H@Admin9\ 8,,,,,,,,,* ]@]@Table Relationships for FOG Manager9~@Vttthhhhhhhf @3{G@{G@rptMailingGenerators9@ZVVVJJJJJJJH @ٍ@ٍ@rptGeneratorsBySewerDistrict9@ZfffZZZZZZZX @V @@MSysRelationships8 DDDDDDDDDDB @@MSysQueries8 88888888886 @@MSysACEs8 22222222220 @@MSysObjects8 88888888886 @ω}S@MSysDb9@V:::......., @@@Relationships8 <<<<<<<<<<: @@Databases8 44444444442 @@Tables8 ..........,  T?7 t 4 g 7  b D &  t V  d F yS5i9mO1>{;q?!i>*> *> G)>([__GeneratorID] = ID)5 ')>tblContactsfrmGeneratorsAA' ) > G)>__GeneratorID+++ O)> )> G(>!([__GeneratorID] = GeneratorID)> '(>frmGenerators@7+ 7( > G(>__GeneratorID+++ O(> (> G'>tblNBMeals%%% ' > G'> '> G& >[ID]# '&>tblSewerDistricts.ID3 g&>tblSewerDistricts333 &> &> G% >[Survey Method]. '%>"tblSurveyMethods.[Survey Method]? g%>tblSurveyMethods.SurveyID8 g%>tblSurveyMethods111 %> %> G$>tblFWGTypes''' $ > G$> $> G#>([__SewerID] = SSA_ID)5 '#>frmGenerators_copy@A5 7# > G#>__SewerID### O#> #> G">([__ID] = GeneratorID)5 '">frmGenerators_copy@A5 7" > G">__ID O"> "> G!>([__ID] = ID), '!>tblContactsfrmGenerators_copyKK' ! > G!>__ID O!> !> G >([__ID] = GeneratorID)5 ' >frmGenerators_copy@A5 7  > G >__ID O >  > G>tblNBMeals%%%  > G> > G >[Town]% '>qryTowns.Town, g>qryTowns!!! > > G >[ID]# '>qrySewerDistricts.AreaServed; g>qrySewerDistricts.Owner6 g>qrySewerDistricts.WWTF5 g>qrySewerDistricts.ID3 g>qrySewerDistricts333 > > G>tblContactTypes.ContactType: g>tblContactTypes.ContactTypeID< g>tblContactTypes/// > > G>tblContactTypes.ContactType: g>tblContactTypes.ContactTypeID< g>tblContactTypes/// > > GLVAL4~ FB@IIf(qryGeneratorsFilter!SewerID Is Null,"Outside Sewer District",[tblSewerDistricts]!WWTF)(((qryGeneratorsFilter.Status)="M"))qryGeneratorsFilter.SewerID=tblSewerDistricts.IDqryGeneratorsFilter.GeneratorID=tblContacts.IDtblNBMeals.NBMeals=qryGeneratorsFilter.NBMEALSIIf(qryGeneratorsFilter!SewerID Is Null,"Outside Sewer District",tblSewerDistricts!WWTF)tblSewerDistricts.ID = tblGenerators.SewerIDtblContacts.ID = tblGenerators.ID(((tblContacts.Type)=1) AND ((tblGenerators.ID) Is Null))SELECT tblDisposal.ID, tblDisposal.FOG_ID, tblDisposal.DisposalMethod, tblDisposal.Provider, tblDisposal.PickupFrequency FROM tblDisposal; SELECT tblSewerDistricts.ID, tblSewerDistricts.WWTF, tblSewerDistricts.Owner, tblSewerDistricts.AreaServed, tblSewerDistricts.Status, tblSewerDistricts.PlantEngineer FROM tblSewerDistricts; SELECT tblGreaseTraps.GreaseTrapID, tblGreaseTraps.GeneratorID, tblGreaseTraps.Manufacturer, tblGreaseTraps.[Size (Gallons)], tblGreaseTraps.Functioning, tblGreaseTraps.Location1, tblGreaseTraps.Location2, tblGreaseTraps.CleaningInterval, tblGreaseTraps.WasteDisposal, tblGreaseTraps.ServiceProvider, tblGreaseTraps.Additives FROM tblGreaseTraps; SELECT tblFOG.FOGID, tblFOG.GeneratorID, tblFOG.FOGType, tblFOG.Volume, tblFOG.Equipment FROM tblFOG; SELECT tblSewerDistricts.SSA_ID, tblSewerDistricts.WWTF, tblSewerDistricts.Owner, tblSewerDistricts.AreaServed, tblSewerDistricts.Status, tblSewerDistricts.Acres, tblSewerDistricts.PlantEngineer FROM tblSewerDistricts; SELECT tblGreaseTraps.GreaseTrapID, tblGreaseTraps.GeneratorID, tblGreaseTraps.Manufacturer, tblGreaseTraps.[Size (Gallons)], tblGreaseTraps.Functioning, tblGreaseTraps.Location1, tblGreaseTraps.Location2, tblGreaseTraps.CleaningInterval, tblGreaseTraps.WasteDisposal, tblGreaseTraps.ServiceProvider, tblGreaseTraps.Additives FROM tblGreaseTraps; SELECT tblFOG.FOGID, tblFOG.GeneratorID, tblFOG.FOGType, tblFOG.Volume, tblFOG.Equipment FROM tblFOG; %'#Od M + 'LX J H62H8E C5kA2f+++@$[@2 @tblGreaseTraps9m JJJ>>>>>>>< @ 2@lRG@tblGenerators9(k HHH<<<<<<<: @$1@>@tblFWGTypes9U@jDDD88888886 @`f/2@@tblEquipments9@fHHH<<<<<<<: @G2@❐@tblDisposalMethods9b@iRRRFFFFFFFD @R@❐@tblDisposal9 @iDDD88888886 @΂R@@tblContactTypes9\@fLLL@@@@@@@> @s- S@Wh^@tblContacts9g DDD88888886 @9a-@a-@qryTowns9@f@dJ>>22222220 @`7@u@V%Bu@qryServiceProviders9 @S@v|@dl``THHHHHHF `6Ŗ@;ה.@qryMailingGenerators9@c@dbVVJJJJJJJH @5dę@H.@qryGeneratorsInfoPermits9O@c@aj^^RRRRRRRP @`3L$T@#$T@qryGeneratorsFilter9!qw |@V```THHHHHHF `2l@@qryGenerators9W@b@aTHH<<<<<<<: @bV@bV@MSysIMEXSpecs9<<<<<<<<<<: UbV@xcV@MSysIMEXColumns9@@@@@@@@@@>  @ @MSysAccessXML94MR2KeepLocal  T|||<<<<<<<: @,T@,T@MSysAccessObjects9DDDDDDDDDDB `0&Z@&Z@~sq_ffrmContacts_Generators94MR2KeepLocal TXXXXXXXV @3.$R@$R@~sq_csubfrmFOG~sq_csubsubfrmDisposal94MR2KeepLocal Tjjjjjjjh @-eqN@N@~sq_cfrmNewGenerator~sq_cCboContactID94MR2KeepLocal Tlllllllj @3+ S@ S@~sq_cfrmGenerators~sq_csubfrmSewerDistricts94MR2KeepLocal Txxxxxxxv @*3 S@3 S@~sq_cfrmGenerators~sq_csubfrmGreaseTraps94MR2KeepLocal Trrrrrrrp @3(3 S@3 S@~sq_cfrmGenerators~sq_csubfrmFOG94MR2KeepLocal Tbbbbbbb` @' S@ S@~sq_cfrmGenerators~sq_cNBMEALS94MR2KeepLocal T^^^^^^^\ @3% S@ S@~sq_cfrmGenerators~sq_cCombo8394MR2KeepLocal T^^^^^^^\ @$q-@q-@~sq_cfrmGenerators_copy~sq_cTYPE94MR2KeepLocal Tbbbbbbb` @3"#-@b-@~sq_cfrmGenerators_copy~sq_csubfrmGreaseTraps94MR2KeepLocal T|||||||z @?KfM c E R  z \ R 4  j 8  V$BFAy3m+_#3totblSewerDistricts.ID3 g3totblContacts.Town/ g3totblGenerators.GreaseTrap7 g3totblGenerators.SewerID4 g3totblGenerators.Participation: g3totblGenerators.DaysofOp5 g3to tblGenerators.HoursofOp6 g3to tblGenerators.Organic4 g3to tblGenerators.VHD_Type5 g3to tblGenerators.SurveyMethod9 g3to tblGenerators.[Surveyed date]< g3totblGenerators.SCORE2 g3totblGenerators.Status3 g3totblGenerators.PermitDate7 g3totblGenerators.PermitNb5 g3totblGenerators.NBMEALS4 g3totblGenerators.TYPE1 g3totblGenerators.Name1 g3toGeneratorIDtblGenerators.IDE'' o3stotblGenerators+++ 3stotblContacts''' 3stotblSewerDistricts333 3sto 3to G2 stotblContacts.Name/ '2stor@ '2totblContactstblGenerators!tblContacts.ID=tblGenerators.IDnA' 2totblContacts.Town/ g2totblContacts.Address2 g2totblContacts.Name/ g2totblContacts.ID- g2stotblGenerators+++ 2stotblContacts''' 2sto 2to G1>tblPermits%%% 1 > G1> 1> G0>tblContacts''' 0 > G0> 0> G/>tblContacts''' / > G/> /> G.>([__FOGID] = FOG_ID)3 '.>subfrmFOG@/# 7. > G.>__FOGID O.> .> G- >[Name]% '->qryGenerators.Town1 g->qryGenerators.Address4 g->qryGenerators.Name1 g->qryGenerators.ID/ g->qryGenerators+++ -> -> G,>tblFWGTypes''' , > G,> ,> G+>([__SewerID] = ID)1 '+>frmGenerators|@7+ 7+ > G+>__SewerID### O+> +> G*>!([__GeneratorID] = GeneratorID)> '*>frmGenerators@7+ 7* > G*>__GeneratorID+++ O YANY Y DataIDYAOIndexv1K[ "Tw9|x||SysAccessObjectsLLLLLLLLLLJ eTraps.AdditivesZH,,ceProviderrT88ddenDescription FormatCaptionSmartTagsDecimalPlacesInputMaskDefaultValueRequiredDisplayControlAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList  J B UjmL4{(ga(R@tblFOGJ 8 E]{7jmL4{(FOGID+|^KϿOjmL4{(GeneratorID=BNA'jmL4{(FOGTypeK2rNDjmL4{(Volume~ea(L3$ 2@tblEquipmentsUIFeIX~ea(L3$EquipmentIDDHEGLoa~ea(L3$Equipment@7og&B%ްjmL4{(Equipment   jmL4{(O FOGID       J 8 E]{7FOGType         m    =BNA' Volume         m    K2rNDGeneratorID         0  m +|^KϿOEquipment         0  o Table/Query SELECT tblEquipments.EquipmentID, tblEquipments.Equipment FROM tblEquipments;     0;1440  1440twip ! R$ZX=JR"r8WK[ࡱ>  K O}QTNML9E1  !"#$%&'()*+,-./02345678Fe;<=>?@ABCDGHIJKLNOPQRSTUVWYZ[\]^_`abcdghijklmnoprstuvwxyz{|Root Entryd@z %VBA`^$+@z VBAProject&$`w*+@z VBA `w*+`w4dir__SRP_0Q__SRP_1#__SRP_2 %B  !"#$&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^`abcdefghijklmnopqrstuvwxyz{|}~0* pHd Access9dDb0@ = p WF 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_frmContactsG A@(rm_f*Cn@.ac@s@ ZCZBYJ_LUEVVQDPRBBTQFUIPDZK_28ACZiYJLUEVE@QpPR@B@TQF@IP@ZK@ AH@1`B,Q0J"B(B+1BM5_Generator868_GhnraXXWI8>D@KU6P /6e! e5e5I4$L42AFIZLRDXDGPMSDSGZAJOKPKREBPJA IL-(DXLG MS SA5O2jP`R4B"R72hPPermikPLmiHkSRNHSPHVDMRPMDEFODXOEQTQAXHU5S@N1SH[B3!NP3aLFXUE9Q5XBwKkAOQJ5terG FL5F`lefCNUFHEHNIVLLOIEWZRJMTGYMBEBXEC4NMF E`NeVNLI1W@7R4MGeME`fX`O4_40Fdsub`FOGshba*GiSQHCSHGEHXJWWDJEIQMKGIPKDNS.HSGHNJ W@NJIM&G@(H (OK0 &0=@}%] Grea@seTrapPO,Wvy GPePNsp(TapNK[CFJXKMHZMBBAIECO@QFZLBDPItC5J K'HpB&qCU]ZBpApE7*ʰr}%0xNe@wManufkuZr1)44N0wѐ anfPm urGUNMYRDZDGRTVDTYIHEKEPXBFEFdmZG*NPq[D0DUR)V0T)I0EXp*F&FomP  *E ?*:SewerDistriR{2/$S"8D`9 rpy|YIYNKJBMXEGpSZZZCVN nPTPJK9YYl*B78RSZ0C@HN@IAoT@JOЧMrU~~~~~~~~~~~i     ) i( K*m rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ yۚ.GO}տ   a  18Y88889v!wj >A ikI q $)=8Y8188IyxY~Qy!>Qa 1\ \za{Ya _I_\ `ɃForm_frmContactsForm_frmNewGeneratorForm_frmGeneratorsForm_frmFilter Access9dbForm_frmGenerators_copyForm_frmGenerators1F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  )J_N?4C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLBAccess  !^F=C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dllDAO 1m.4C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\msado21.tlbADODB !I0FC:\WINDOWS\system32\stdole2.tlbstdole 1Y}F$OjH/D{UM1Gr 8PxDLeP7`hA&@C7? SurveyMethod HoursofOp31?FormSC7? FormHeaderDetailIDAC7?subfrmGeneratorsContacts_LabelDaysofOpPC7?subfrmGeneratorsContactsLC7?TypeNBMEALSsubfrmSewerDistrictssubfrmSewerDistricts_Label subfrmFOGsubfrmFOG_LabelLabel76GC7?Check51Label53subfrmGreaseTrapssubfrmGreaseTraps_LabelDC7? ImagePath OLEUnbound62 OLEUnbound64Label75EC7? cmdFiltercmdOpen FormFooterStatus Surveyed_dateName cmdOpen_ClickcmdFilter_Click  frmFilterɤs h)aN? K[`GXGPfĤIx8< VBE6.DLL  S GhpM#y1tNP6s>Af:4t$mEC=# # AND Date<=# # AND ((Town = ' ') AND ((Hauler = ' B OR (tblSewerDistricts.SSA_ID = ' )  WHERE  ;qm.. SELECT tblGenerators.ID, tblGenerators.Name, tblGenerators.TYPE, tblGenerators.NBMEALS, 5 tblGenerators.Status , tblGenerators.SCORE, tblGenerators.[Surveyed date], tblGenerators.SurveyMethod,  2 OR (tblContacts.Town = ' &qryGeneratorsFilter2 tblGenerators.VHD_Type, tblGenerators.Organic, tblGenerators.HoursofOp, tblGenerators.DaysofOp, 2 tblGenerators.Participation, tblGenerators.SewerID, tblGenerators.GreaseTrap, tblContacts.Town,  0tblSewerDistricts.SSA_IDm.PostCodeFax8 FROM tblSewerDistricts INNER JOIN (tblContacts INNER JOIN tblGenerators ON tblContacts.ID = tblGenerators.ID) hON tblSewerDistricts.SSA_ID = tblGenerators.SewerID  WHERE  4AND ((tblContacts.Town = ' DAND ((tblSewerDistricts.SSA_ID = ' 0 0ނg@@Эeo!p]JvyIcmdFilterRemovecmdFilterRemove_Click 1T#B 1X?~Nm dd83 T3 ,((tblContacts.Town = ' 2tblSewerDistricts.SSA_ID  frmGeneratorsMailAdd1MailAdd2MailTown5 tblGenerators.STATUS, tblGenerators.SCORE, tblGenerators.[Surveyed date], tblGenerators.SurveyMethod, ( tblGenerators.Participation, tblGenerators.SewerID, tblGenerators.GreaseTrap  j ON tblSewerDistricts.SSA_ID = tblGenerators.SewerID;Town9 FROM tblSewerDistricts RIGHT JOIN (tblContacts RIGHT JOIN tblGenerators ON tblContacts.ID = tblGenerators.ID)  hON tblSewerDistricts.SSA_ID = tblGenerators.SewerID;E{u@DߗrIdK[IN  UH[x(K dd8 8L3 Ts03 8 FROM tblSewerDistricts RIGHT JOIN (tblContacts RIGHT JOIN tblGenerators ON tblContacts.ID = tblGenerators.ID)c[LQ<[keJO @u_N EG} *tblSewerDistricts.ID  : OR (tblSewerDistricts.ID = '  <((tblSewerDistricts.SSA_ID = 'Address F AND ((tblSewerDistricts.SSA_ID = 'BZI"\xlj<@^:~'"A.KП frmNewGenerator[fOkv 'έL`}APicture 4Image found and displayed.{\>&(BEvS{F=ws j NCan't find image in the specified name.   FAn error occurred displaying image.  H i heFKkZ%mgFEC9" PNo permit was ebtered for this generator:}I knw=5>nlb*FNY5MohOyeg%(pGq! 4((tblSewerDistricts.ID = ' > AND ((tblSewerDistricts.ID = 'G SELECT tblGenerators.ID, tblGenerators.Name, tblGenerators.TYPE, tblGenerators.NBMEALS, tblGenerators.PermitNb, tblGenerators.PermitDate, :eBKkozNU@ Mll@DEew)page X&0J!tYv[TVE&oEtwB,‡5Combo83Ϗ\B|; yq (I6 H|v>eNҍ 9cmdFirst cmdPreviouscmdNextcmdLast L $tblGenerators.VHD_Type, tblGenerators.Organic, tblGenerators.HoursofOp, tblGeneratK[ors.DaysofOp, tblGenerators.PermitNb, tblGenerators.PermitDate, xKD-OG{m. ܝ}KLʙQaD|xwI{ dd8 3 Ts03 *7:Byx4YQ 8SELECT tblGenerators.ID as tblGeneratorID, tblGenerators.Name, tblGenerators.TYPE, tblGenerators.NBMEALS, tblGenerators.PermitNb, tblGenerators.PermitDate, N 2SELECT tblGenerators.ID as GeneratorID, tblGenerators.Name, tblGenerators.TYPE, tblGenerators.NBMEALS, tblGenerators.PermitNb, tblGenerators.PermitDate, [(dEc`"naIqDNJG^MT[7LB `ON tblSewerDistricts.ID = tblGenerators.SewerID  GeneratorID PNo permit was entered for this generator0ie|MGb}_]Gݼ.w>He8f6/BwtF{I: ImagePath_AfterUpdateForm_subfrmFOGDdTdJ\-UJ&E5H$]b^AvS;c {k:KAUBVolumesubsubfrmDisposalsubsubfrmDisposal_Label EquipmentFOGType cmdAddNew FOGType_Label Volume_LabelEquipment_LabelFOGIDcmdAddNew_Click xIua@.}T|6jJ .nj%gNBD Form_subfrmGreaseTrapsŠw8FzB59H (O.kz1 _@v_).oHSI<ServiceProvider Functioning Additives ManufacturercmdAddManufacturer GreaseTrapIDSize__Gallons_ Location1CleaningInterval WasteDisposal Location2cmdAddManufacturer_Click | tblManufacturersForm_subfrmNewManufacturerN?B}'a{[z+JFDEgZ#؈oUKOszښ`Ȍ5BhlT^E)txtManufacturerLabel2txtManufacturer_Enter L1m.F;|? Manufacturer.%L|Ge7]lJ6Z@3&OKjlDfk(aN?9C~)AsAz^CL;m5}Z3O5#M a|:J,G1fӓK\O¢NG$RA7C`T+›D3 R dd83 T3 *subfrmNewManufacturerRH,Cy37)j@o2ז~Command3Command3_ClicktxtManufacturer_Exit PЂ!Bz`zGF)b^wIԓA͓[=bMG@?K8G'פw;ChaSWȹCK\ %^ƣE_&Vh\krHv`.'o INWy#лuj{0Hf6Q)AI}M?x@M ׆ڙr}qJ]]]%9  VNo Permit ID was entered for this generator ^No Permit number was entered for this generatorY+wC&Dg^ As9lForm_frmContacts_GeneratorsForm_frmContacts1NMA R ҽBgx% cmdNewGencmdNewGen_Click nM+$)O5BMZ C~@URю`s hEnter Path and Image name below to View Permit Image OH6wi OGu>B)gBKNzIJ)@CDkhؿCrQ/͛DUJ ƴL<+fR$EF} Form_Activate Command14" Enter Permit # and Path and Image name below to View Permit ImageѧK knO]ZF%!$oԚRGRgFWǺ9X-loGGdb[`XMm9E F6vKE'lf4*V49L5+9][rFuũ4FNfLN Form_OpenP;|?aSCt \FGNQ~MName_AfterUpdateOyuBHM4 yD?ńH^OGVF-uj xJc}qYIKSJ$J>F@ ti<} Form_Enter -PO)隻A~@$=BY5`ŠE INVsubfrmFOG_EnterEnabledKGQ@>4 . ( xDx@K*3ng!.CU?}P cmdAddNew׍-C"_d^_\F!D Equipment_AfterUpdate-DfEquipment_Enter¿Nwʉ ȺpKp2cmGY]m& J!ם Form_Loado6`D8AyJ)sیK@G~ page$by1A@oAc SFkN8CE]ohp4F&H9ѼnG| DzWacf@:Q"Yؗ$DwM,ĥ!* 㸺@gr.2cmdOpenContactcmdOpenContact_Click frmContacts [Name]=>r+ELYT}Y¶2M-\C ws=63zEK cmdDeletecmdDelete_Click  zpҶC?R3b"5͉I G( Command91Command91_Click>܀A(oz'zE@WhJZ{xmMsKi.ʜF Vn+N%D?(q^cmdOpenAllContactsCombo93cmdOpenAllContacts_Click 9A.Y@E_D7SnuDwAbj,VAr7~0StOS(NǥÏ2UA)oȡbYcM42|TxRBLBVD{fJo:D_ZGT_I7 Combo93_ExitRequeryForm_subfrmSewerDistricts9,uyLuĂ)UTJ0=^OM#C/iyHkuAi1:ղ AreaServed PlantEngineerSewerIDWWTFOwner d~,KSvsjKE T*%ۉ[BwPEb)bKP66{VI urlu{IFp/2kE!;s5+p,DQ- >)9L06OL-C 9`2i7nOL*^m@6}C6gۊb*@U\G遵MK8RK'~p$Dz{};IN)W:&C%X Detail_ClickCommand14_Click `BD{D|AW['K2 Enter Permit # and Copy and Paste from Windows Explorer Path and Image name to View Permit Image* Enter Permit # then Copy and Paste from Windows Explorer the Path and Image name PwAޔIC*[MIˊ5 &L_ vL8 i H  X  h  x q   ActlImageControl strImagePathCancel;;;rU H19ZYy@4aZ@8i Z@<Z@@  [I@D )[@ Hq aA[ @:L)Q@Pippp@Ta[rrr@X[ttt@\[vvv@`ixxx@di @ha[zzz@laW~~~W0 0  0   0   H@@H$TxD4$HX8@  C0,:X 8:H `168@ ,:XT:H `16T@  CK[T@  C,:XT:H `16(8h(H2hlh"8@ V3l*Fh"8:X \`16\h"T@ 3l*Fh"T:X \`16\ h~l 8@  l*1T@  l*1l 2l 2$ l*1XP*l*#l*#l*#*1X2$ l=TT H , lXFH%:X%T QP)'X%$ ` ,<'@%'8%'H%:X%$ ` `<d L(|lhXTP0 \tX@Y @ :WKRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O, tx$,p 0 0  T)'h%x$ `x ,x<*#`*#\*#X*#T*#P*1d2 `\XTPx$ lx= Lx xL H x , x xldF8%:h %L QxH<'%'(%'8%:h %x$ `x `xd0 dLH$`\XTPx`<HrU x __SRP_3:*__SRP_4 _N __SRP_5MV__SRP_6XrU x$` $A`$`n@8 !) @ <q a1M@@ qI@Di  @HA @L  @ Pq aMI@Ta1 xxx@ Xq aiM @\ L@ `q a$@:d)Q@hippp@lirrr@patK[tt@ tq a = @ xq aIk @|a<@a<@i Y @ @a |||@ q a @a @ A @Y @ @a @aI @ q a1~Q@i  @i @ q aQM@ q aY@ @i ) @a @ q aA@  pWWW_0   0   0 0  0   0   0   0   0 H  0   0   0 8  0   0   0 H  0   0 P  d0+:h%x$ `x hx0$  xx`tP<X @ @ @ D Wˁ K[QA7y@4a@8a@<a@@a 8@ Dq a7 @H  @La7@Pa@Ta7@Xa7@\i @ `q aI@:d)Q@hippp@lirrr@pattt@ta1 xxx@ xq ay @|a3|||@a+@a'@a'@a' WWW0 0  0 p  0   0   0 0  0 p  8$  0   0 @  0