Standard Jet DBnb` Ugr@?~1y0̝cßFNm7cҜ(- `j{6߱IbC93 y[#|*|Kadf_Љ$g'DeFx -bT4.0`r YSI QueS  Y   Y Y  Y Y  Y  Y  Y   Y u Y o Y n Y z Y 2lY  Y  z Y  pY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypenis deSwesYYIdParentIdName        OYSY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YH H SY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute -YSI QueS Y Y Y  Y t Y r Y o Y t Y rccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationshiputTlr loraeAo ciAIntt orYYYszObject$szReferencedObjectszRelationshipEr-^ J  s . _  C t / `  @A*)0 qc@ B`m OJmJLJkQk+kh+OifmYbkfQMmYdbkkmv^Q8L+kh+OYbkfQMmYdbkmJmok+kh+OifmfQi`Ymkkmv^Q:L+kh+OfQi`YmkmJmokYO iQSQiQbMQFvSi`YbkfQMmdikSi`YbkfQMmdik^YkmSi`[oiYkOYMmYdbkSi`^JLQ^Si`^QmmQiSi`fQi`YmOQkMiYfmYdbkSi`fQi`YmkSi`fQi`YmkYbkfQMmYdbkkoLSi`fQi`YmkmJmok Si`fQi`YmkmJmokkoL!Si`fQi`YmmvfQk"Si`iQfdimk#Si`koiqQv$`dOfQi`Ymk%ifmMdbmiJMmdik&ifmWQ^f'ifmYbkfQMmYdbkkmv^Q8(ifmYbkfQMmYdbkkmv^Q8L)ifmYbkfQMmYdbkkmv^Q:*ifmYbkfQMmYdbkkmv^Q:L+ifmYbkfQMmYdbkkmv^Q<,ifmYbkfQMmYdbkkmv^QifmYbkfQMmYdbkkmv^Q>LifmYbkfQMmYdbkkmv^Q>MifmYbkfQMmdikifm^JLQ^kMdbmiJMmdikJqQ@8B6ifm^JLQ^kYbkfQMmdikJqQ@8B6ifm^JLQ^kmdSid`@:B>ifm^JLQ^kmdSid`@:B>L^Jb\mdifm^QmmQi ifmfQi`YmOQmJY^k ifmfQi`YmOQmJY^kJ^^fQi`Ymk ifmfQi`YmOQmJY^kYbkfQMmYdbkkoL ifmfQi`YmkQufYiYbU ifmfQi`Ymkkmv^Q8ifmfQi`Ymkkmv^Q:ifmfQi`Ymkkmv^Q:LifmiQfdimkifmkmJmYkmYMkifmkmJmYkmYMkYbkfQMmYdbkLvYbkfQMmdikoLifmkmJmYkmYMkYbkfQMmYdbkLv`dbmWkoLifmkmJmYkmYMkfQi`YmOQkMiYfmYdbkoLifmkmJmYkmYMkfQi`Ym[oiYkOYMmYdbkoLifmkmJmYkmYMkfQi`YmkLvMdbmiJMmdikoLifmkmJmYkmYMkfQi`YmkYkkoQOLv`dbmWkoLifmkmJmYkmYMkfQi`YmkmJmokkoLifmkmJmYkmYMkfQi`YmmvfQOQkMiYfmYdbkoLifmkmJmYkmYMkfQi`YmmvfQkoLifmkoUUQkmYdbkifmkoiqQvJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`MdbSYU+kh+MOQSJo^mfQi`Ym[oiYkOYMmYdbYO+kh+MSi`MdbSYU+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`MdbSYU+kh+MfQi`YmkmJmokYO!+kh+MSi`MdbSYU+kh+MfQi`YmmvfQYO"+kh+MSi`OQ^QmQiQMdiOk+kh+M[oiYkOYMmYdb#+kh+MSi`OQ^QmQiQMdiOk+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWJOOiQkk+kh+MSi`fQi`Ymk+kh+MMLdkQJiMW[oiYkOYMmYdb+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWdsbQibJ`Q+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWfQi`Ymbo`LQi+kh+MSi`fQi`Ymk+kh+MMLdkQ^QMmiQfdim+kh+MSi`fQi`Ymk+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymk+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymk+kh+MfQi`YmOQkMiYfmYdbYO+kh+MSi`fQi`Ymk+kh+MfQi`Ym[oiYkOYMmYdbYO +kh+MSi`fQi`Ymk+kh+MfQi`YmkmJmokYO +kh+MSi`fQi`Ymk+kh+MfQi`YmmvfQYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbkmJmokYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbmvfQYO+kh+MSi`fQi`Ymkd^O+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmOQkMiYfmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`Ym[oiYkOYMmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmmvfQ+kh+MSi`fQi`YmkmJmok+kh+MSi`fQi`YmkmJmokkoL`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$,%&'()*+,-. / 0 1 2 3456789:;<=>?@ABCDE F!G"H#IJKLMNOPQR S T U V WXYZ[\]^_`abcdefghijklm n o p q rstuvwxyz{|}~                               tttttttttt t t t t ttttttttttttttttttt  !"#$%&'$ o       K9:    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP     GHIJ   !!!"" " # # # $$$%%%&&&'''((()))* *!*"+#+$+%,&,',(-)-*-+.,.-..///0/102030415161728292:3;3<3=4>4?4@5A5B5C6D6E6F7G7H7I8J88999:::;; ; < < < ===>>>???@@@AAABBBC C!C"D#D$D%E&E'E(F)F*F+G,G-G.H/H0H1I2I3I4J5J6J7K8K9K:L;L<L=M>M?M@NANBNCODOEOFPGPHPIQJQQRRRSSSTT T U U U VVVWWWXXXYYYZZZ[[[\ \!\"]#]$]%^&^'^(_)_*_+`,`-`.a/a0a1b2b3b4c5c6c7d8d9d:e;e<e=f>f?f@gAgBgChDhEhFiGiHiIjJjjkkklllmm m n n n ooopppqqqrrrssstttu u!u"v#v$v%w&w'w(x)x*x+y,y-y.z/z0z1{2{3{4|5|6|7}8}9}:~;~<~=>?@ABCDE !"#$%&'()*+,-./0123456789:;<=>?@ABCDEF  !"# ~e0!uA"|/wEEE E E  E  EF FFFFF FGGGGG GHHHHH HI I"I#I$I %I!J&J(J)J*J+J ,J'K-K/K0K1K 2K.L3L5L6L7L8L 9L4M:MM?M @M;NANCNDNENFNGNHNINJN KN LNBOMOOOOOONPPPPPP  P  PQ Q QQQ Q RRRRR RSSSSSSS STT!T"T#T $T U%U'U(U)U*U +U ,U&V-V/V0V1V 2V.W3W5W6W7W 8W4X9X;XX:Y?YAYBYCY DY@ZEZGZHZ IZF[J[L[M[ N[K\O\Q\R\\ \P]]]] ]^^ ^ ^ ^_ ____ _ ````` `aaaaa abb b!b"b #bc$c&c'c(c )c%d*d,d-d.d /d+e0a  @@@@ iQSQiQbMQiQSQiQbMQ8iQSQiQbMQ:iQSQiQbMQ<iQSQiQbMQ@iQSQiQbMQBiQSQiQbMQFmL^YbkfQMmYdbkmJmokmL^MdbSYUmL^YbkfQMmdikmL^MdbSYUmL^[oiYkOYMmYdbkmL^MdbSYU mL^[oiYkOYMmYdbkmL^fQi`Ymk mL^[oiYkOYMmYdbkmL^fQi`Ymk8 mL^fQi`YmOQkMiYfmYdbkmL^fQi`Ymk mL^fQi`YmkmJmokmL^MdbSYU mL^fQi`YmkmL^YbkfQMmYdbkmL^fQi`YmmvfQkmL^MdbSYUmL^iQfdimkmL^iQfdimkokQibJ`Qk   @ mL^MdbSYUmL^MdbSYUmL^MdbSYU mL^MdbSYU mL^MdbSYUmL^YbkfQMmYdbkmL^YbkfQMmYdbkmL^YbkfQMmYdbkmL^YbkfQMmYdbkmL^fQi`YmkmL^fQi`YmkmL^fQi`YmkmL^fQi`YmkmL^fQi`Ymk mL^fQi`Ymk mL^fQi`Ymk mL^iQfdimkokQibJ`Qk  @@mL^MdbmiJMmdikmL^YbkfQMmYdbkmJmokmL^YbkfQMmYdbkmJmokmL^YbkfQMmYdbmvfQkmL^YbkfQMmdikmL^YbkfQMmdikmL^[oiYkOYMmYdbkmL^[oiYkOYMmYdbk mL^[oiYkOYMmYdbk mL^[oiYkOYMmYdbk mL^fQi`YmOQkMiYfmYdbk mL^fQi`YmkmL^fQi`YmkmJmokmL^fQi`YmkmJmok mL^fQi`YmmvfQkmL^fQi`YmmvfQkmL^iQfdimkZ-d _ Z g  ~K k  N bEF[\ C!95A$$}l@}l@rptInspectionsStyle3HHHHHHH$i4ҽ@tx@rptInspectionsStyle3kJ@VVVJJJJJJJH @" ѽ@Ͼh@rptInspectionsStyle2kJ@VVVJJJJJJJH @!G h:@m@rptInspectionsStyle1bkL@XXXLLLLLLLJ @ tj@tj@rptInspectionsStyle1kJJJJJJJJJJH #I^@#I^@rptHelpk$MR2 GUIDNameMap```0000000. @@@modPermitsk66666666664 jR@jR@frmSurveyk44444444442  01@ 01@frmReportsk66666666664 ,@,@frmPermitTypesk>>>>>>>>>>< Wr@Wr@frmPermitStatusSubkFFFFFFFFFFD @'@@'@frmPermitStatusk@@@@@@@@@@> 6l@6l@frmPermitsInspectionsSubkRRRRRRRRRRP (c@(c@frmPermitsk66666666664 1@1@frmPermitDescriptionskLLLLLLLLLLJ E>s@E>s@frmLetterk44444444442 qp@qp@frmLabelk22222222220 -@-@frmJurisdictionskBBBBBBBBBB@ Tfs@Tfs@frmInspectorsListkDDDDDDDDDDB Bi@Bi@frmInspectorsk<<<<<<<<<<: m@m@frmInspectionTypeskFFFFFFFFFFD HW@HW@frmInspectionStatuskHHHHHHHHHHF  c^^@c^^@frmHelpEntryk$MR2 GUIDNameMapjjj:::::::8 @ q&0@q&0@frmDeleteRecordskBBBBBBBBBB@  bqNr@bqNr@frmContractorsListkFFFFFFFFFFD  9@9@frmContractorsk>>>>>>>>>><  7m@7m@frmConfigk44444444442  E]@E]@UserDefinedkA@DDD88888886 @ E]@E]@SummaryInfok@DDD88888886 @]@]@SysRelk.........., ]@]@Scriptsk0000000000. ]@]@Reportsk0000000000. ]@]@Modulesk0000000000. ]@]@Formsk,,,,,,,,,,* ]@]@DataAccessPagesk@@@@@@@@@@> ~]@~]@MSysRelationshipsjDDDDDDDDDDB ~]@~]@MSysQueriesj88888888886 ~]@~]@MSysACEsj22222222220 ~]@~]@MSysObjectsj88888888886 ~]@@MSysDbk0@:::......., @~]@~]@Relationshipsj<<<<<<<<<<: ~]@~]@Databasesj44444444442 ~]@~]@Tablesj.........., $NF ^ 5 c & f  /+#%)MICnjB@HH@@~sq_cfrmDeleteRecords~sq_cJurisdictionlllllllllll G% +@% +@~sq_cfrmConfig~sq_cPermitTypeIDk4MR2KeepLocal T```````^ @F*@*@~sq_cfrmConfig~sq_cPermitStatusIDk4MR2KeepLocal Tdddddddb @D*@% +@~sq_cfrmConfig~sq_cDefaultPermitJurisdictionIDk4MR2KeepLocal T~~~~~~~| @BŎ@Ŏ@rptSurveyk44444444442 A좙M^@좙M^@rptSuggestionsk$MR2 GUIDNameMapnnn>>>>>>>< @@)hs@)hs@rptStatisticsPermitTypeSubkVVVVVVVVVVT ?,~?@,~?@rptStatisticsPermitTypeDescriptionSubkllllllllllj >@ `@@ `@rptStatisticsPermitStatusSubkZZZZZZZZZZX =@@rptStatisticsPermitsIssuedByMonthSubkjjjjjjjjjjh <4I@4I@rptStatisticsPermitsByContractorSubkhhhhhhhhhhf ;jv@jv@rptStatisticsPermitJurisdictionSubkffffffffffd :Ou@Ou@rptStatisticsPermitDescriptionSubkddddddddddb 9Rh@Rh@rptStatisticsInspectionsByMonthSubkffffffffffd 8K /@K /@rptStatisticsInspectionsByInspectorSubknnnnnnnnnnl 7I?@I?@rptStatisticsk<<<<<<<<<<: 60Խ@0Խ@rptReportsk66666666664 5~ ;@~ ;@rptPermitsStyle2bkDDDDDDDDDDB 4.6@.6@rptPermitsStyle2kBBBBBBBBBB@ 3̴1@̴1@rptPermitsStyle1kBBBBBBBBBB@ 2ӽ@ӽ@rptPermitsExpiringkFFFFFFFFFFD 1@@rptPermitDetailsInspectionsSubk^^^^^^^^^^\ 0ӽ@ӽ@rptPermitDetailsAllPermitskVVVVVVVVVVT /@%@@%@rptPermitDetailskBBBBBBBBBB@ .] @] @rptLetterk44444444442 -,q@,q@rptLabelsToFrom5264BlankTokVVVVVVVVVVT ,Dp@Dp@rptLabelsToFrom5264kHHHHHHHHHHF +F4Ɨ@F4Ɨ@rptLabelsInspectorsAVE5160kVVVVVVVVVVT *s]@s]@rptLabelsContractorsAVE5160kXXXXXXXXXXV )=p@=p@rptInspectorsk<<<<<<<<<<: ' @-:;@G~t@rptInspectionsStyle4bkL@ XXXLLLLLLLJ @&;ս@~@rptInspectionsStyle4kJ@VVVJJJJJJJH @%C"G;@[^@rptInspectionsStyle3bkL@XXXLLLLLLLJ @P\2O d ( l $  g " c 9  m # uW%rH* zP2qGp-R^M#OY__PermitID%%% OOY OY GN YJ@ 'N YtblReports.ReportOrder5 'NYR@ 'NYtblReportstblReportsUserNamesd@WK% NYtblReports.ReportFlag4 gNYtblReports.ReportNameActual: gNYJ@ gNYtblReports.ReportID2 gNYtblReportsUserNames777 NYtblReports%%% NY NY GM YtblPermits.PermitNumber6 'MY@ 'MYtblPermits.PermitNumber6 gMYtblPermits.PermitID2 gMYtblPermits%%% MY MY GL Y@ 'LY@ 'LYName@% oLYtblPermits.PermitID2 gLYtblPermits%%% LY LY GK YF@ 'KYF@  gKYJ@  gKYtblJurisdictions111 KY KY GJ YZ@  'JY(@  'JYAddressAndPermitZ@ =11 oJYtblPermits.PermitID2 gJYtblPermits%%% JY JY GI YtblPermitStatus.PermitStatus; 'IYtblPermitStatus.PermitStatus; gIY tblPermitStatus.PermitStatusID= gIYtblPermitStatus/// IY IY GH YF@ 'HYF@ gHYJ@ gHYtblJurisdictions111 HY HY GG YtblPermitTypes.PermitType8 'GYtblPermitTypes.PermitType8 gGYtblPermitTypes.PermitTypeID: gGYtblPermitTypes--- GY GY GF YtblPermitStatus.PermitStatus; 'FYB@ gFYtblPermitStatus.PermitStatus; gFY tblPermitStatus.PermitStatusID= gFYtblPermitStatus/// FY FY GE Y@ 'E YtblInspectors.InspectorActive< 'EYInspector@/## oEYtblInspectors.InspectorID8 gEYtblInspectors+++ EY EY GD YF@ 'DYF@ gDYJ@ gDYtblJurisdictions111 DY DY GLVALp*j h  8  l & R4TrBtblContractors.ContractorLicenseExpirationDateIIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)")([__PermitID] = InspectionPermitID)tblReportsUserNames.ReportDisplayName(((tblReportsUserNames.ShowReport)=True))tblReports.ReportID = tblReportsUserNames.ReportIDtblReportsUserNames.ReportDisplayName(((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]))IIf(IsNull([PermitOwnerLastName]),[PermitOwnerFirstName],IIf(IsNull([PermitOwnerFirstName]),[PermitOwnerLastName],[PermitOwnerLastName] & ", " & [PermitOwnerFirstName])) & " (" & [PermitNumber] & ")"(((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]) AND ((tblPermits.PermitOwnerLastName) Is Not Null)) OR (((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]) AND ((tblPermits.PermitOwnerFirstName) Is Not Null))IIf(IsNull([PermitOwnerLastName]),[PermitOwnerFirstName],IIf(IsNull([PermitOwnerFirstName]),[PermitOwnerLastName],[PermitOwnerLastName] & ", " & [PermitOwnerFirstName])) & " (" & [PermitNumber] & ")"tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionID[PermitAddress] & " (" & [PermitNumber] & ")"((([PermitAddress] & " (" & [PermitNumber] & ")") Is Not Null) AND ((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]))[PermitAddress] & " (" & [PermitNumber] & ")"tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionIDtblPermitStatus.PermitStatusColor[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionID5njN L  KI z vIGEVRD}B@c e@ c c e@ e@~sq_drptInspectionsStyle2~sq_dInspectionStatus|b9:@9:@~sq_drptInspectionsStyle1b~sq_dInspectionTypek4MR2KeepLocal T|||||||z @a9:@9:@~sq_drptInspectionsStyle1b~sq_dInspectionStatusk4MR2KeepLocal T~ @_n@n@~sq_drptInspectionsStyle1~sq_dInspectionStatusk4MR2KeepLocal T~~~~~~~| @^n使@n使@~sq_cfrmPermitStatus~sq_cfrmPermitStatusSubk4MR2KeepLocal Txxxxxxxv @ \yF@yF@~sq_cfrmPermitsOLD~sq_cPermitStatusk4MR2KeepLocal Thhhhhhhf @[F@F@~sq_cfrmPermitsOLD~sq_cPermitJurisdictionk4MR2KeepLocal Ttttttttr @ YyF@yF@~sq_cfrmPermitsOLD~sq_cPermitContractorIDk4MR2KeepLocal Ttttttttr @XyF@yF@~sq_cfrmPermitsOLD~sq_cfrmPermitsInspectionsSubk4MR2KeepLocal T~ @ VEPY@hY@~sq_cfrmPermitsInspectionsSub~sq_cInspectionStatusIDk4MR2KeepLocal T @UEPY@EPY@~sq_cfrmPermitsInspectionsSub~sq_cInspectionInspectorIDk4MR2KeepLocal T @ SX@j^^@~sq_cfrmPermits~sq_cPermitStatusIDk @4MR2KeepLocal Trffffffd `RHa@Ha@~sq_cfrmPermits~sq_cPermitJurisdictionIDk4MR2KeepLocal Trrrrrrrp @ PHa@Ha@~sq_cfrmPermits~sq_cPermitContractorIDkH4MR2KeepLocal Tznnnnnnl `O_@_@~sq_cfrmPermits~sq_cfrmPermitsInspectionsSubk4MR2KeepLocal Tzzzzzzzx @M a@ a@~sq_cfrmPermits~sq_ccboSearchPermitNumberk4MR2KeepLocal Ttttttttr @L`@`@~sq_cfrmPermits~sq_ccboSearchOwnerNamek4MR2KeepLocal Tnnnnnnnl @J a@ a@~sq_cfrmPermits~sq_ccboSearchAddressk4MR2KeepLocal Tjjjjjjjh @IY^Fn@Y^Fn@~sq_cfrmDeleteRecords~sq_cPermitStatusk4MR2KeepLocal Tnnnnnnnl @#SjL.{Q X .  ` 6 j <   : <cE'eG)iK-oQ3V8iK-}_#\Y"[tblPermitStatus].[PermitStatus]? g\YtblPermitStatus/// \Y \Y G[ YF@ '[YF@ g[YtblJurisdictions111 [Y [Y GZ Y[PermitDescription]2 'ZYV@ gZYtblPermitDescriptions;;; ZY ZY GY Y@ 'YYCont@% oYYtblContractors.ContractorID: gYYtblContractors--- YY YY GXYF@ 'XYfrmPermitsOLD@7+ 7X Y GXY__PermitID%%% OXY XY GW YB@ 'WYB@ gWYF@ gWYtblInspectionTypes555 WY WY GV YH@ 'VYH@  gVYL@  gVYtblInspectionStatus777 VY VY GU Y@  'U YtblInspectors.InspectorActive< 'UYX@  gUYInspector@ /## oUYtblInspectors.InspectorID8 gUYtblInspectors+++ UY UY GT YtblPermitTypes.PermitType8 'TYtblPermitTypes.PermitType8 gTYtblPermitTypes.PermitTypeID: gTYtblPermitTypes--- TY TY GS YtblPermitStatus.PermitStatus; 'SYB@ gSYB@ gSYtblPermitStatus.PermitStatus; gSY tblPermitStatus.PermitStatusID= gSYtblPermitStatus/// SY SY GR YF@ 'RYF@ gRYJ@ gRYtblJurisdictions111 RY RY GQ YN@ 'QYN@ gQYR@ gQYtblPermitDescriptions;;; QY QY GP Y0@ 'P Y!tblContractors.ContractorActive> 'PY\@ gPYCont0@% oPYtblContractors.ContractorID: gPYtblContractors--- PY PY GOYF@ 'OYtblInspectionsfrmPermitsAA- O Y GLVAL(~0 R p d  L ZDtHVDh"RtblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusID(((tblPermitStatus.PermitStatusID) Not Like 1))[tblPermitStatus].[PermitStatusColor]tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdiction[tblPermitDescriptions].[PermitDescription]IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName])IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName])([__PermitID] = InspectionPermitID)SELECT tblInspections.* FROM tblInspections ORDER BY tblInspections.InspectionDate DESC;tblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusID[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")tblInspectors.InspectorLicenseExpirationDate[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")tblPermitStatus.PermitStatusFinaltblPermitStatus.PermitStatusColortblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionIDtblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptionIDIIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)") [~`&i- F  J L " P & R ( V,X.\2^4 b8d:h>j@lY Gk YH@ 'kYH@ gkYL@ gkYtblInspectionStatus777 kY kY Gj YB@ 'jYB@ gjYF@ gjYtblInspectionTypes555 jY jY Gi YH@ 'iYH@ giYL@ giYtblInspectionStatus777 iY iY Gh YB@ 'hYB@ ghYF@ ghYtblInspectionTypes555 hY hY Gg YH@  'gYH@  ggYL@  ggYtblInspectionStatus777 gY gY Gf YB@  'fYB@  gfYF@ gfYtblInspectionTypes555 fY fY Ge YH@ 'eYH@ geYL@ geYtblInspectionStatus777 eY eY Gd YB@ 'dYB@ gdYF@ gdYtblInspectionTypes555 dY dY Gc YH@ 'cYH@ gcYL@' gcYtblInspectionStatus777 cY cY Gb YB@& 'bYB@% gbYF@$ gbYtblInspectionTypes555 bY bY Ga YH@# 'aYH@" gaYL@! gaYtblInspectionStatus777 aY aY G` YB@  '`YB@ g`YF@ g`YtblInspectionTypes555 `Y `Y G_ YH@ '_YH@ g_YL@ g_YtblInspectionStatus777 _Y _Y G^Y^@ '^YtblPermitStatus.*0 g^YtblPermitStatus/// ^Y ^Y G] Y[PermitType]+ ']Y[tblPermitTypes].[PermitType]< g]YtblPermitTypes--- ]Y ]Y G\ Y[PermitStatus]- '\YJ@ g  @@ @@@ @ @@ @  @@ @  Si`MdbSYUSi`MdbmiJMmdikSi`MdbmiJMmdik^YkmSi`OQ^QmQiQMdiOkSi`WQ^fQbmivSi`YbkfQMmYdbkmJmokSi`YbkfQMmYdbmvfQkSi`YbkfQMmdikSi`YbkfQMmdik^YkmSi`[oiYkOYMmYdbkSi`^JLQ^Si`^QmmQiSi`fQi`YmOQkMiYfmYdbkSi`fQi`YmkSi`fQi`YmkYbkfQMmYdbkkoLSi`fQi`YmkmJmok Si`fQi`YmkmJmokkoL!Si`fQi`YmmvfQk"Si`iQfdimk#Si`koiqQv$`dOfQi`Ymk%ifmMdbmiJMmdik&ifmWQ^f'ifmYbkfQMmYdbkkmv^Q8(ifmYbkfQMmYdbkkmv^Q8L)ifmYbkfQMmYdbkkmv^Q:*ifmYbkfQMmYdbkkmv^Q:L+ifmYbkfQMmYdbkkmv^Q<,ifmYbkfQMmYdbkkmv^QifmYbkfQMmYdbkkmv^Q>LifmYbkfQMmYdbkkmv^Q>MifmYbkfQMmdikifm^JLQ^kMdbmiJMmdikJqQ@8B6ifm^JLQ^kYbkfQMmdikJqQ@8B6ifm^JLQ^kmdSid`@:B>ifm^JLQ^kmdSid`@:B>L^Jb\mdifm^QmmQi ifmfQi`YmOQmJY^k ifmfQi`YmOQmJY^kJ^^fQi`Ymk ifmfQi`YmOQmJY^kYbkfQMmYdbkkoL ifmfQi`YmkQufYiYbU ifmfQi`Ymkkmv^Q8ifmfQi`Ymkkmv^Q:ifmfQi`Ymkkmv^Q:LifmiQfdimkifmkmJmYkmYMkifmkmJmYkmYMkYbkfQMmYdbkLvYbkfQMmdikoLifmkmJmYkmYMkYbkfQMmYdbkLv`dbmWkoLifmkmJmYkmYMkfQi`YmOQkMiYfmYdbkoLifmkmJmYkmYMkfQi`Ym[oiYkOYMmYdbkoLifmkmJmYkmYMkfQi`YmkLvMdbmiJMmdikoLifmkmJmYkmYMkfQi`YmkYkkoQOLv`dbmWkoLifmkmJmYkmYMkfQi`YmkmJmokkoLifmkmJmYkmYMkfQi`YmmvfQOQkMiYfmYdbkoLifmkmJmYkmYMkfQi`YmmvfQkoLifmkoUUQkmYdbkifmkoiqQvJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`MdbSYU+kh+MOQSJo^mfQi`Ym[oiYkOYMmYdbYO+kh+MSi`MdbSYU+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`MdbSYU+kh+MfQi`YmkmJmokYO!+kh+MSi`MdbSYU+kh+MfQi`YmmvfQYO"+kh+MSi`OQ^QmQiQMdiOk+kh+M[oiYkOYMmYdb#+kh+MSi`OQ^QmQiQMdiOk+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWJOOiQkk+kh+MSi`fQi`Ymk+kh+MMLdkQJiMW[oiYkOYMmYdb+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWdsbQibJ`Q+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWfQi`Ymbo`LQi+kh+MSi`fQi`Ymk+kh+MMLdkQ^QMmiQfdim+kh+MSi`fQi`Ymk+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymk+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymk+kh+MfQi`YmOQkMiYfmYdbYO+kh+MSi`fQi`Ymk+kh+MfQi`Ym[oiYkOYMmYdbYO +kh+MSi`fQi`Ymk+kh+MfQi`YmkmJmokYO +kh+MSi`fQi`Ymk+kh+MfQi`YmmvfQYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbkmJmokYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbmvfQYO+kh+MSi`fQi`Ymkd^O+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmOQkMiYfmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`Ym[oiYkOYMmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmmvfQ+kh+MSi`fQi`YmkmJmok+kh+MSi`fQi`YmkmJmokkoL`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @      @  Sdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`MdbSYU+kh+MOQSJo^mfQi`Ym[oiYkOYMmYdbYO+kh+MSi`MdbSYU+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`MdbSYU+kh+MfQi`YmkmJmokYO!+kh+MSi`MdbSYU+kh+MfQi`YmmvfQYO"+kh+MSi`OQ^QmQiQMdiOk+kh+M[oiYkOYMmYdb#+kh+MSi`OQ^QmQiQMdiOk+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWJOOiQkk+kh+MSi`fQi`Ymk+kh+MMLdkQJiMW[oiYkOYMmYdb+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWdsbQibJ`Q+kh+MSi`fQi`Ymk+kh+MMLdkQJiMWfQi`Ymbo`LQi+kh+MSi`fQi`Ymk+kh+MMLdkQ^QMmiQfdim+kh+MSi`fQi`Ymk+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymk+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymk+kh+MfQi`YmOQkMiYfmYdbYO+kh+MSi`fQi`Ymk+kh+MfQi`Ym[oiYkOYMmYdbYO +kh+MSi`fQi`Ymk+kh+MfQi`YmkmJmokYO +kh+MSi`fQi`Ymk+kh+MfQi`YmmvfQYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbYbkfQMmdiYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbkmJmokYO +kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MYbkfQMmYdbmvfQYO+kh+MSi`fQi`Ymkd^O+kh+MSi`fQi`YmkYbkfQMmYdbkkoL+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmMdbmiJMmdiYO+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmOQkMiYfmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`Ym[oiYkOYMmYdb+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmkmJmok+kh+MSi`fQi`Ymkd^O+kh+MfQi`YmmvfQ+kh+MSi`fQi`YmkmJmok+kh+MSi`fQi`YmkmJmokkoL+kh+OifmYbkfQMmYdbkkmv^Q8+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q8+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q8L+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q8L+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q:+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q:+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q:L+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q:L+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q<+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q<+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q>+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q>L+kh+OYbkfQMmYdbkmJmok +kh+OifmYbkfQMmYdbkkmv^Q>L+kh+OYbkfQMmYdbmvfQ +kh+OifmYbkfQMmYdbkkmv^Q>M+kh+OYbkfQMmYdbkmJmok +kh+OifmYbkfQMmYdbkkmv^Q>M+kh+OYbkfQMmYdbmvfQ +kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmOQkMiYfmYdb +kh+OifmfQi`YmOQmJY^k+kh+OfQi`Ym[oiYkOYMmYdb+kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmkmJmok+kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmmvfQ+kh+OifmfQi`YmOQmJY^k+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmOQkMiYfmYdb+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`Ym[oiYkOYMmYdb+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmkmJmok+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmmvfQ+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OYbkfQMmYdbYbkfQMmdiYO+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OYbkfQMmYdbkmJmok`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOHLVAL5p*Z B l $ Z  ~ 8 h Pz2hFp"D^[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionIDtblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptionID([__PermitID] = InspectionPermitID)tblJurisdictions.PermitJurisdictiontblJurisdictions.PermitJurisdictionIDtblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptiontblPermitDescriptions.PermitDescriptionIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusIDtblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusOFBNk L J  EAHjFDC'X}}t}x@x@~sq_drptPermitsStyle1~sq_dPermitStatusIDk4MR2KeepLocal Trrrrrrrp @|Dw-z@Dw-z@~sq_drptPermitDetailsInspectionsSub~sq_dInspectionTypek4MR2KeepLocal T @{g-z@g-z@~sq_drptPermitDetailsInspectionsSub~sq_dInspectionStatusk4MR2KeepLocal T @y$ӽ@$ӽ@~sq_drptPermitDetailsAllPermits~sq_dPermitTypek4MR2KeepLocal T~~~~~~~| @xjӽ@$ӽ@~sq_drptPermitDetailsAllPermits~sq_dPermitStatusk4MR2KeepLocal T @v$ӽ@$ӽ@~sq_drptPermitDetailsAllPermits~sq_dPermitDescriptionk4MR2KeepLocal T @uȩ&'z@ȩ&'z@~sq_drptPermitDetails~sq_drptPermitDetailsInspectionsSubk4MR2KeepLocal T @s&'z@&'z@~sq_drptPermitDetails~sq_dPermitStatusk4MR2KeepLocal Tnnnnnnnl @rȩ&'z@&'z@~sq_drptPermitDetails~sq_dPermitJurisdictionk4MR2KeepLocal Tzzzzzzzx @pN;@<\N;@~sq_drptInspectionsStyle4c~sq_dInspectionTypek4MR2KeepLocal T|||||||z @o<\N;@<\N;@~sq_drptInspectionsStyle4c~sq_dInspectionStatusk4MR2KeepLocal T~ @nv-:;@v-:;@~sq_drptInspectionsStyle4b~sq_dInspectionTypek4MR2KeepLocal T|||||||z @lxܽ@xܽ@~sq_drptInspectionsStyle4~sq_dInspectionTypek4MR2KeepLocal Tzzzzzzzx @kKyܽ@1yܽ@~sq_drptInspectionsStyle4~sq_dInspectionStatusk4MR2KeepLocal T~~~~~~~| @iǹs@ǹs@~sq_drptInspectionsStyle3b~sq_dInspectionStatusk4MR2KeepLocal T~ @h=ҽ@`ҽ@~sq_drptInspectionsStyle3~sq_dInspectionTypek4MR2KeepLocal Tzzzzzzzx @fN{`@){`@~sq_drptInspectionsStyle2b~sq_dInspectionTypek4MR2KeepLocal T|||||||z @e){`@){`@~sq_drptInspectionsStyle2b~sq_dInspectionStatusk4MR2KeepLocal T~ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @DDDDD DEEE E E  E  EF FFFFF FGGGGG GHHHHH HI I"I#I$I %I!J&J(J)J*J+J ,J'K-K/K0K1K 2K.L3L5L6L7L8L 9L4M:MM?M @M;NANCNDNENFNGNHNINJN KN LNBOMOOOOOONPPPPPP  P  PQ Q QQQ Q RRRRR RSSSSSSS STT!T"T#T $T U%U'U(U)U*U +U ,U&V-V/V0V1V 2V.W3W5W6W7W 8W4X9X;XX:Y?YAYBYCY DY@ZEZGZHZ IZF[J[L[M[ N[K\O\Q\R\\ \P]]]] ]^^ ^ ^ ^_ ____ _ ````` `aaaaa abb b!b"b #bc$c&c'c(c )c%d*d,d-d.d /d+e0" @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @e2e3e4e 5e1f6f8f9f:f ;f7gg?g@g Ag=hBhDhEhFh GhCiHiJiKiLi MiIjNjPjQjRj SjOkTkVkWkXk YkUlZllll lmmmm m  mn n nnn n ooooo oppppp pqqq q!q "qr#r%r&r'r$s(s*s+s,s -s)t.t0t1t2t 3t/u4u6u7u8u9u5v:vv ?v;w@wBwCwDwAxExGxHxIx JxFyKyMyNyOy PyLzQzSzzz z zR{{{{{  {| | | || | }}}}} }~~~~~ ~  !"$%& '#(*+, -).012 3/4678 95:<=> ?;@BCD EAFHIGJLMKNPQOR!!!)"TvL"xN$ | R ( ~ T * X .  V ,  ^ @ " T O W9y1w9m#uWL.zYtblInspectors+++ zY zY Gy YtblPermitTypes.PermitType8 'yYtblPermitTypes.PermitType8 gyYtblPermitTypes.PermitTypeID: gyYtblPermitTypes--- yY yY Gx YtblPermitStatus.PermitStatus; 'xYtblPermitStatus.PermitStatus; gxY tblPermitStatus.PermitStatusID= gxYtblPermitStatus/// xY xY GwYF@3 gwYJ@2 gwYtblJurisdictions111 wY wY Gv YN@1 'vYN@0 gvYR@/ gvYtblPermitDescriptions;;; vY vY GuYF@. 'uYtblInspectionsrptPermitDetailsMM- u Y GuY__PermitID%%% OuY uY Gt YtblPermitTypes.PermitType8 'tYtblPermitTypes.PermitType8 gtYtblPermitTypes.PermitTypeID: gtYtblPermitTypes--- tY tY Gs YtblPermitStatus.PermitStatus; 'sYtblPermitStatus.PermitStatus; gsY tblPermitStatus.PermitStatusID= gsYtblPermitStatus/// sY sY GrYF@- grYJ@, grYtblJurisdictions111 rY rY Gq YN@+ 'qYN@* gqYR@) gqYtblPermitDescriptions;;; qY qY Gp YB@( 'pYB@' gpYF@& gpYtblInspectionTypes555 pY pY Go YH@% 'oYH@$ goYL@# goYtblInspectionStatus777 oY oY Gn YB@" 'nYB@! gnYF@  gnYtblInspectionTypes555 nY nY Gm YH@ 'mYH@ gmYL@ gmYtblInspectionStatus777 mY mY Gl YB@ 'lYB@ glYF@ glYtblInspectionTypes555 lY S6 b8 f <  p $ r H J | ^  eG uW9M/C JSiK-iK-Y GYtblHelp  Y GY Y GYtblContractors---  Y GY Y GYtblConfig###  Y GY Y G Y[PermitType]+ 'Y[tblPermitTypes].[PermitType]< gY![tblPermitTypes].[PermitTypeID]> gYtblPermitTypes--- Y Y G Y[PermitType]+ 'Y[tblPermitTypes].[PermitType]< gY![tblPermitTypes].[PermitTypeID]> gYtblPermitTypes--- Y Y G Y[PermitType]+ 'Y[tblPermitTypes].[PermitType]< gY![tblPermitTypes].[PermitTypeID]> gYtblPermitTypes--- Y Y G Y[PermitStatus]- 'Y"[tblPermitStatus].[PermitStatus]? gYD@ gYtblPermitStatus/// Y Y G Y[PermitJurisdiction]3 'YN@  gYR@  gYtblJurisdictions111 Y Y G Y[PermitDescription]2 'YV@  gYZ@  gYtblPermitDescriptions;;; Y Y G Y[PermitStatus]- 'Y"[tblPermitStatus].[PermitStatus]? gYD@  gYtblPermitStatus/// Y Y G~ Y[PermitStatus]- '~Y"[tblPermitStatus].[PermitStatus]? g~YD@ g~YtblPermitStatus/// ~Y ~Y G} Y[PermitStatus]- '}Y"[tblPermitStatus].[PermitStatus]? g}YD@ g}YtblPermitStatus/// }Y }Y G| YB@ '|YB@ g|YF@ g|YtblInspectionTypes555 |Y |Y G{ YH@ '{YH@ g{YL@ g{YtblInspectionStatus777 {Y {Y Gz Y@ 'z YtblInspectors.InspectorActive< 'zYInspector@4/## ozYtblInspectors.InspectorID8 gLVAL&@d V  t  ~ : B t 0 \hD: IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName])IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName])(((tblPermits.PermitStatusID)=[Forms]![frmDeleteRecords]![Status]))(((tblPermits.PermitIssueDate)<[Forms]![frmDeleteRecords]![IssueDate]))(((tblPermits.PermitExpirationDate)<[Forms]![frmDeleteRecords]![ExpirationDate]))(((tblPermits.PermitJurisdictionID)=[Forms]![frmDeleteRecords]![Jurisdiction]))[qryStatisticsPermitTypeDescription].[CountOfPermitID][qryStatisticsPermitTypeDescription].[PermitDescriptionID][qryStatisticsPermitTypeDescription].[PermitTypeID]tblReportsUserNames.ReportDisplayNametblReports.ReportID = tblReportsUserNames.ReportIDtblReportsUserNames.ReportDisplayName(((tblCountNumbers.CountNumber)<7))(((tblInspectors.InspectorActive)=True))(((tblContractors.ContractorActive)=True))IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)")tblContractors.ContractorFileUndertblContractors.ContractorCompanyNametblContractors.ContractorFirstNametblContractors.ContractorLastName(((tblPermitStatus.PermitStatusID) Not Like 1))(((tblPermitStatus.PermitStatus)="expired"))tblPermitStatus.PermitStatusColor[tblPermitStatus].[PermitStatusID][tblJurisdictions].[PermitJurisdiction][tblJurisdictions].[PermitJurisdictionID][tblPermitDescriptions].[PermitDescription][tblPermitDescriptions].[PermitDescriptionID][tblPermitStatus].[PermitStatusID][tblPermitStatus].[PermitStatusID][tblPermitStatus].[PermitStatusID]tblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypetblInspectionTypes.InspectionTypeIDtblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatustblInspectionStatus.InspectionStatusID[InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)")v   @  @@ +kh+OifmYbkfQMmYdbkkmv^Q8L+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q:+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q:+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q:L+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q:L+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q<+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q<+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q+kh+OYbkfQMmYdbkmJmok+kh+OifmYbkfQMmYdbkkmv^Q>+kh+OYbkfQMmYdbmvfQ+kh+OifmYbkfQMmYdbkkmv^Q>L+kh+OYbkfQMmYdbkmJmok +kh+OifmYbkfQMmYdbkkmv^Q>L+kh+OYbkfQMmYdbmvfQ +kh+OifmYbkfQMmYdbkkmv^Q>M+kh+OYbkfQMmYdbkmJmok +kh+OifmYbkfQMmYdbkkmv^Q>M+kh+OYbkfQMmYdbmvfQ +kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmOQkMiYfmYdb +kh+OifmfQi`YmOQmJY^k+kh+OfQi`Ym[oiYkOYMmYdb+kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmkmJmok+kh+OifmfQi`YmOQmJY^k+kh+OfQi`YmmvfQ+kh+OifmfQi`YmOQmJY^k+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmOQkMiYfmYdb+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`Ym[oiYkOYMmYdb+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmkmJmok+kh+OifmfQi`YmOQmJY^kJ^^fQi`Ymk+kh+OfQi`YmmvfQ+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OYbkfQMmYdbYbkfQMmdiYO+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OYbkfQMmYdbkmJmok+kh+OifmfQi`YmOQmJY^kYbkfQMmYdbkkoL+kh+OYbkfQMmYdbmvfQ+kh+OifmfQi`Ymkkmv^Q8+kh+OfQi`YmkmJmokYO+kh+OifmfQi`Ymkkmv^Q:+kh+OfQi`YmkmJmokYO +kh+OifmfQi`Ymkkmv^Q:L+kh+OfQi`YmkmJmokYO +kh+OifmkmJmYkmYMkfQi`YmOQkMiYfmYdbkoL+kh+OfQi`YmOQkMiYfmYdbYO +kh+OifmkmJmYkmYMkfQi`Ym[oiYkOYMmYdbkoL+kh+OfQi`Ym[oiYkOYMmYdbYO +kh+OifmkmJmYkmYMkfQi`YmkmJmokkoL+kh+OfQi`YmkmJmokYO +kh+OifmkmJmYkmYMkfQi`YmkmJmokkoL+kh+OfQi`YmmvfQYO +kh+OifmkmJmYkmYMkfQi`YmmvfQOQkMiYfmYdbkoL+kh+OfQi`YmmvfQYO +kh+OifmkmJmYkmYMkfQi`YmmvfQkoL+kh+OfQi`YmmvfQYO +kh+SSi`MdbSYU +kh+SSi`MdbmiJMmdik +kh+SSi`WQ^fQbmiv +kh+SSi`YbkfQMmYdbkmJmok +kh+SSi`YbkfQMmYdbmvfQk +kh+SSi`YbkfQMmdik +kh+SSi`[oiYkOYMmYdbk +kh+SSi`fQi`YmOQkMiYfmYdbk +kh+SSi`fQi`Ymk +kh+SSi`fQi`YmkYbkfQMmYdbkkoL +kh+SSi`fQi`YmkmJmok +kh+SSi`fQi`YmkmJmokkoL +kh+SSi`fQi`YmmvfQk +kh+iifmWQ^f +kh+iifm^JLQ^kMdbmiJMmdikJqQ@8B6 +kh+iifm^JLQ^kYbkfQMmdikJqQ@8B6 +kh+iifm^JLQ^kmdSid`@:B>L^Jb\md +kh+iifmfQi`YmOQmJY^kYbkfQMmYdbkkoL +kh+iifmiQfdimk +kh+iifmkmJmYkmYMkfQi`YmmvfQOQkMiYfmYdbkoL +kh+iifmkoUUQkmYdbk `kvkJMMQkkkmdiJUQ `kvkJMMQkku`^ `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivOQ^QmQJ^^MdbSYUkQmmYbUk hivOQ^QmQJ^^MdbmiJMmdik hivOQ^QmQJ^^YbkfQMmYdbkmJmokthivOQ^QmQJ^^YbkfQMmYdbmvfQkthivOQ^QmQJ^^YbkfQMmdikthivOQ^QmQJ^^[oiYkOYMmYdbkthivOQ^QmQJ^^fQi`YmOQkMiYfmYdbkthivOQ^QmQJ^^fQi`YmkthivOQ^QmQJ^^fQi`YmmvfQkthivOQ^QmQJ^^okQiiQfdimktJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO}!O+0,NE b m iK ) %Jv HH{F FvD1-CZVB\@k@kk@k@(qryDeleteAllContractorsNNNNNNNNNNN A@Ё:n@8qryDeleteAllConfigSettingsk@ |@nbbVVVVVVVT @oZ]@]@MSysAccessXMLk4MR2KeepLocal  T|||<<<<<<<: @$%ӓ@ӓ@ MSysAccessStoragekDDDDDDDDDDB Z>VY@Z>VY@~sq_rrptStatisticsPermitTypeDescriptionSubk4MR2KeepLocal Tvvvvvvvt @ g-z@g-z@~sq_rrptPermitDetailsInspectionsSubk4MR2KeepLocal Thhhhhhhf @b'Uq@b'Uq@~sq_rrptLabelsToFrom5264BlankTok4MR2KeepLocal T```````^ @ tzp@p@~sq_rrptLabelsContractorsAVE5160k4MR2KeepLocal Tbbbbbbb` @ޮ@ޮ@~sq_rrptHelpk4MR2KeepLocal Tzzz:::::::8 @ y@5"z@~sq_ffrmPermitStatusSubk4MR2KeepLocal TPPPPPPPN @ hY@̘Y@~sq_ffrmPermitsInspectionsSubk4MR2KeepLocal T\\\\\\\Z @5a@Xa@~sq_ffrmPermitsk4MR2KeepLocal T@@@@@@@> @cEnս@cEnս@~sq_ffrmJurisdictionsk4MR2KeepLocal TLLLLLLLJ @uw@uw@~sq_ffrmInspectionTypesk4MR2KeepLocal TPPPPPPPN @ep@vip@~sq_ffrmInspectionStatusk4MR2KeepLocal TRRRRRRRP @7y@7y@~sq_ffrmContractorsk4MR2KeepLocal THHHHHHHF @% +@IJ+@~sq_ffrmConfigk4MR2KeepLocal T~~~>>>>>>>< @Z>VY@Z>VY@~sq_drptStatisticsPermitTypeDescriptionSub~sq_dPermitTypeIDk4MR2KeepLocal T @)hs@)hs@~sq_drptStatisticsPermitStatusSub~sq_dPermitTypeIDk4MR2KeepLocal T @'@'@~sq_drptStatisticsPermitStatusSub~sq_dPermitStatusIDk4MR2KeepLocal T @w@%w@~sq_drptStatisticsPermitDescriptionSub~sq_dPermitDescriptionIDk4MR2KeepLocal T @x@x@~sq_drptPermitsStyle2b~sq_dPermitStatusIDk4MR2KeepLocal Ttttttttr @ VbD&R4 ~ `  n P 2 V ,  w M /  } _ 3  i?`tVMt.EiKs)YtblReportstblReportsUserNamesd@WK% Y tblReportsUserNames.ShowReport= gYJ@ gYtblReports.*+ gYtblReportsUserNames777 YtblReports%%% Y Y GYtblInspections---  Y GY Y GYF@ 'YtblCountNumbers.CountNumber: gYtblCountNumbers/// Y Y GYP@ 'YtblInspectors.InspectorZip9 gYtblInspectors.InspectorState; gYtblInspectors.InspectorCity: gY tblInspectors.InspectorAddress= gY"tblInspectors.InspectorFirstName? gY!tblInspectors.InspectorLastName> gYtblInspectors+++ YtblContractors--- Y Y GYT@ 'Y Cont0@% oYD@ gYtblContractors.ContractorZip; gY tblContractors.ContractorState= gYtblContractors.ContractorCity< gY"tblContractors.ContractorAddress? gYH@ gYD@ gYB@ gYtblContractors--- Y Y GYtblHelp  Y GY Y GYtblPermitTypes---  Y GY Y GY^@ 'YtblPermitStatus.*0 gYtblPermitStatus/// Y Y GYX@ 'YB@ gYtblPermitStatus/// Y Y GYtblInspections---  Y GY Y GYtblPermits%%%  Y GY Y GYtblPermitDescriptions;;;  Y GY Y GYtblJurisdictions111  Y GY Y GYtblInspectors+++  Y GY Y GYtblInspectionTypes555  Y GY Y GYtblInspectionStatus777  Y GY w @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @!!!!!! ! !! ! !! !!!!!!!!!!!!!!!!!! !"!#!$!!!%!'!(!&!)!+!,!*!-!/!0!1!2!3!4!5!6!7 !8!9!.!:!<!=!>!?!@!A!B!C!D!;!E!G!H!I!F!J!L!M!K!N!P!Q!R!S!T!U # #!O######## # # # ########### # # # # #### #!#"###$#%#&#'#(# #)#+#,#-#.#*#/#1#2#3#4#0#5#7uuu#6uuuuuuu u u u uu uuuuuuuuuuuuuuuuu uu!u#u$u%u&u"u'u)u*u+u,u-u.u/u(u0u2u3u4u5u6u7u1u8u:u;u<u=u>u?u9u@uBuCuDuEuFuGuHuAu8rTtV8 h 8 r  X x   >|Lf,x4k Gk k GktblInspectionStatus.*4 gktblInspectionStatus777 k Gk Gk k GktblContractors.*/ gktblContractors--- k Gk Gk k GtblConfig.DefaultCompanyNameFrom""aQ wtblConfig.DefaultLastNameFrom""[K wtblConfig.DefaultFirstNameFrom""]M wtblConfig.DefaultZipFrom""QA wtblConfig.DefaultStateFrom""UE wtblConfig.DefaultCityFrom""SC wtblConfig.DefaultAddressFrom""YI wtblConfig.PermitStatusExpired""[K wtblConfig.DefaultPermitExtraFieldUser20Label""yi wtblConfig.DefaultPermitExtraFieldUser10Label""yi wtblConfig.DefaultShowPermitExtraFieldUser200ug w tblConfig.DefaultShowPermitExtraFieldUser100ug w tblConfig.DefaultShowPermitFeePaymentDate0qc w tblConfig.DefaultShowPermitFee-1]M w tblConfig.DefaultExpirationTimeType""gW w tblConfig.DefaultExpirationTimeNumber""k[ wtblConfig.DefaultPermitNumber""[K wtblConfig.DefaultPermitFee0SE wtblConfig.DefaultInspectorID""YI wtblConfig.DefaultInspectionStatusID""gW wtblConfig.DefaultPermitJurisdictionID""k[ wtblConfig.DefaultPermitTypeID""[K wtblConfig.DefaultPermitStatusID""_O wtblConfig.DefaultState""M= wtblConfig###  G G  GYtblSuggestions---  Y GY Y GYl@ gYt@ gYf@ gYqryStatisticsPermitTypeDescriptionUUU Y Y G YJ@ ' YdtblReports.ArchiveReport9 /V Y3N%%Y  sY Y 8 Y L Y L6Y 68Y 8DateCreateDateUpdateIdLvNameParentIdType6L86L86%g8L6L86L86%h8L6L86L86%k8L6YYYIdParentIdIdParentIdName%%v1bx0@ @$7@ V a  E  O \ ) 4 Wr?Z Fv1G?m E>s@;lj@| PropDataxGC?/ E>s@;lj@{BlobDeltax0,( wE>s@;lj@z@NTypeInfox:62" E>s@;lj@y&K HBlobx2.*" E>s@;lj@x4   w-@tx@t PropDatapGC?/ -@tx@sBlobDeltap0,( w-@tx@r$@>TypeInfop:62"  @tx@qI HBlobp2.*"  @tx@p3   ww@8}@3 PropData/GC?/ w@8}@2BlobDelta/0,( w9@8}@15@>TypeInfo/:62" 9@8}@0g<E HBlob/2.*" 9@8}@/2   w)7m@I+@. PropData*GC?/ 7m@I+@-BlobDelta*0,( w7m@I+@,J@>TypeInfo*:62" 7m@I+@+u[? HBlob*2.*" 7m@I+@*1   wӓ@ӓ@)DataAccessPages<84 wӓ@ӓ@(CustomGroups62. wvӓ@ӓ@'MSysDbDirData$PLH8 vӓ@ӓ@&Blob%&" wvӓ@ӓ@%0$  wvӓ@ӓ@$Databases0,( wvӓ@ӓ@#ijPropDataPLH8 vӓ@{@"Scripts,($ wvӓ@F;@!@>PropData:62" vӓ@k ;@ :@)DirData:62" vӓ@6[?Խ@BlobDelta0,( wvӓ@6[?Խ@v@)TypeInfo:62" vӓ@f {@PropDataPLH8 vӓ@6[?Խ@#< HBlob2.*" vӓ@f {@1  wvӓ@3ᗪn@BlobDelta0,( wvӓ@3ᗪn@@)TypeInfo:62" vӓ@ҁ{@PropDataPLH8 vӓ@3ᗪn@t* HBlob2.*" vӓ@ҁ{@0  wvӓ@F;@Reports,($ wvӓ@U@Modules,($ wvӓ@vӓ@Cmdbars,($ wvӓ@ ~%:@@)PropData :62" vӓ@ ~%:@@)DirData :62" vӓ@Ջ@BlobDelta 0,( wvӓ@Ջ@D@)TypeInfo :62" vӓ@x@PropData PLH8 vӓ@x@ *' HBlob 2.*" vӓ@x@ 0   wvӓ@ ~%:@ Forms($  wvӓ@a@VBAProject2.* w ӓ@'b@VBA$  wӓ@ӓ@MSysAccessStorage_SCRATCHPLH wdӓ@ӓ@MSysAccessStorage_ROOTJFB wLVAL H(Pu08=5B>a)b*cH!de g h6ij1k ?K NtblHelp.HelpOrder, tblHelp.HelpSubOrderlc^^@ tblHelp tblHelp @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx  aIp`,m  Detailx 'pnD2Sٗm7UF{`6axbc,e HelpTitle HelpTitlex EeRҒHL0?Qkd5U`6<axbc, HelpTitle_Label HelpTitlex  o9 NMTm7UF{`6abc,e k HelpSubtitle HelpSubtitlex 5-pC-|d5U`6<abc, $HelpSubtitle_Label HelpSubtitlex uGXyjm7UF{`6aHbXc,eXk HelpOrder HelpOrderx *X$z%C !d5U`6<aHbc, HelpOrder_Label HelpOrderx  N*!BjR5pm7UF{`6abXc,eXk HelpSubOrder HelpSubOrderx &s'JFAvfzd5U`6<abc, $HelpSubOrder_Label HelpSubOrderx U1$ID#q@m J27UF{`6abc,Ue k HelpContent HelpContentx !pϯ@fğd5U`6LVAL<abc, "HelpContent_Label HelpContentx >D>eN"1`, FormFooterx rD9ɁLVAL  .rptInspectionsStyle4b"8rptLabelsInspectorsAVE5160:rptLabelsContractorsAVE5160,rptInspectionsStyle4rptStatistics NrptStatisticsPermitTypeDescriptionSub  rptContractors @rptPermitDetailsInspectionsSub$rptPermitDetailsrptLetterrptHelp rptSuggestions$rptPermitsStyle1$rptPermitsStyle2,rptInspectionsStyle2 ,rptInspectionsStyle38rptPermitDetailsAllPermits(rptPermitsExpiringrptReportsrptSurveya)b*cB'e gh6xij(k I ?l#I^@ tblHelp Program Help @ Arial 8888B'h DC odXXLetterDINU"4 },KMXL Y)SLPT1: d28" @ Arialg3I75mf5I<" @ Arial0K HelpOrder0K HelpSubOrderK`, ReportHeaderx :C]`, "PageHeaderSectionx 8⿲G|΋ d!78"`6abDc,  Label9 Version 1.0 " @ Tahomax m-{I'ӭ%f2 abB'333  Line14x PyDĦFȚ$?f2 afbB'333  Line48x A|- C:G9m !;<"CF{ab,c,  Text35 H="Page " & [Page] & " of " & [Pages]& Short Date" @ Tahomax 9ʕ'ZsHۉg`6o abDc, Image19 F:lAF' EMF@F܁GDIC/ā @@ |  | @C ||(|$!!LVAL,Ÿ(6x$w$U`ɣԫr{GSx%u%y&S_Ŵ%2u&u%R^Ȣаu$y&|%v&t$4AT`U_T_}%3'6ĠӲ|$t$LVAL-w${#u%z%ӜT`u$v&u"m#~&4FRo$s$ܼ{'x%ְR_y#x%w$w$ڿLVAL.ɠá޾ϯ}&4đ&y&໒R]x$y%x$|'5š&5&o"U_ʤĵq|o%|'n%Ɖ4B5Cx#DRT^t&w${%ɠx%Q]ES&5Ӳ5Au$y$'T_q{x&{%q$6Bã̐7Cw$u%w%4BƑŠcmx&u%v&R]ˢERu#v&5Bfny&$4Үs{z$s$o$4Bˢ(6{#r#T_СƏ2A(x%}%3s{r!'t&z(5Ŕ#4s%y&}&4 w"0'y%u"y&|%}&u%z%3R_Ƥ|(4{#p#v'{$y&z%v$~%5BT^⼒R^z&u$x&}"1|%3v&p!&4ҠT`q#4AQ^~'5q{ŕ$2y&s"x%%r%y#z&t%EP'5w$w%~&4FQv#y$7Eܾclx'~(4ղģbkz&%(5“7Cu$v$T_ɣŪs|r$|'n$໒R]x$y%x$|'5šɠz(5u#&r&R^‘r|x&v%y#%3đȢGSt$t&%4Ɠp#n#Цv#S^EQ'5S]t%x% q"w*ERw"ݿn%T_w%uy#v"FRҀ%4s|ˣs$y%w&|$y%w%%4ERx#v&p%u!x%u%u&3'~&4CO}&S_gpo%{&q|3By%s"U`doFSx%u$w$y%{#v#ѯ{%v%Vax%$3ALv%'u"p&w"}&԰v&n$q%t%s{Īu~&5x&U`r%w&qzҿ$1v%v$0ϣS]%n$ѯy%y%ц%3w$r|w'4y&|"t%s&v#q$EPT^S]Ȳo$%cnq"q'r|6DÐ{%x"T^dm7B~#Ϯ%x%ERz%S]t%x%q%z%s|FRw%~%z$s$r%o&r&x%԰w$t%COӃ&5t|Ȕr!z&u$r#S^q(Ŋ5CQ]&z&q$ȟw't#x"z'ÏTavp$~'EPϱȟ4BU`s%T`Tas%z'u%q|Òv%p%ܾs}o"v#EQ˳ϣ4Aپz'y#y&t"еrzy(s"GRΰدFR%x&t&z%EQ|%(6šs"v%DPy(t x%v%u$u$'4t%dl"1DR"1grw$v%t#%rzŒo$x%R]x(v#u$S]u$ǔȔr!z&}&y&v~y$w%FPϯҰGSq#x%Ā%x$П|)|'u#y#y%S_y$ƓѢ'5p&r#s$r"'6r|}&x&šx%u$4A᷂LVAL/S_x&S_T]s&ď~&3y%u"x%w#y&7D乂q$x$׮}%r%ƒw$s$EPs|w#{'x%w$FRs#'6v%z$Ѱz$u&eov#w#|$z$Îm"}'eow$̣՗R]z'n#(6x%߿}&s$ܾU`v$w$r#V`x%|'u#y&t%đp&s$ISuw$}%u"x'v#(6w%x&y&s$T_v&CPr&t$|$&S_v$5Cu%s|ǣв|#|&ēS_z%R_T^s"x%y%y#аz&v#ƢÒv#{%%4x$cl¢x%}%ʡw&m"s%v&y&w%CPq%y$Òt#u$w%’q$v%t%o$FSx%4@x&cmձ5B5CS_6Cblx%x%o%ēy&s%Q]x&Œ%x%R\v%w%x&{#x$ɠx%y%ɠy%z$y&z"S_u%x%w$t&u%R]u'Őr{}&u%x%ǡv&z%S^x&u$v#‘x%m#T^x$U^S^&ɐs|&5ְo$y%Ɠ}%s"y%w&FP%5Bx$T]w%u&|$w$szz$u$ڲz$x$w&v#x&|$u%x%s$w%x$s{s$}%2~&4&5Òu$Ŧֿ}%s%v}#2γ|$p#T^w$ēq%x&T_u$s%v%w#r%Œu'R^v$x%p#%T^{&x%w$z%x%Uaw%񸄋o$w'&4Aвu%u%T`y&đx$x%y'U`T^x$S]R_u%خ6CS^ٰw$z$Òu!Xap##t|t#|'5Òv#ŕt&z$w$w$ֱ{%u$rzx"y%t#{%dn|&{$v$}%u%s$Ĕĕs${'5Cw%Ģ&3x"q"v&Ͳ5CT`ӯw$y&U^{&ÐLVAL0|'{$R\w#ď|'%|$w$˒u%˒v#w$v%u$S^x%x%w$y&x%S]y&R]y%u"7Dǡy&w$t$w$'4x$ÒŒt$S_T^x$T^T_y&Ұco~&4o%{#z'R\|$w&ˢu%Òy%U^Î×s%$x%w$y%s"7Cy&u$Үz'%r#v%r&z%y&ERv#dmv"}'3&x#T_r%Կv'z%ױdn&5z&z$T]y&ڿv&s%Wav#p"v%o%s$w$R^Ŕđ|)u$x%z"y%t$x%w$q#v"Vb&x&}%v#w&ӱv&x%ֲcmv%ďđr|x$y'z(BOʯēT^x$V`T`v$S^ͤx"z'ֿy%DOӯƑx%w#ͣ%4u$R]ďď4Bx%&5t$v%x$w$x$v%x$w#v#Òвr{t&|"5AĔp#u#fq4A}&r")7do߽|%u"~$&3z&dnv&t&U^x$|!y&S^ɠu$v%V`u%s"x(T^w$ǒ(q$ݿu&y#đu'P]ÎƓ“6Cw${&4w$s"w#w'ϴv"|'ձx%w$ݿ{%y&|%3x%x%t{}%v%ɠCOw'z'̣z$͡u$u%R]y'}(v#ƓT^x$T^U^v%'6Őy&Q]w&{&R^~&o&z'Őr#u$҃4A6Aen4Aw%dn|'p#Œw$w$w#w&x"n#$w%s'}&o%t$u%{&q'Œx"y)׾՚R^v$|%ֿv#w$z&EPɠz$u$t!|'%3s$ʡŁ&{$‘v#Vay&p#߿S]x&eoʢ{%{$3>y&x&{%T^R^UaS_U`R]VaS_T_~!{'6Ccm4A{%cmw%y&޽t&j%ǣEOt%s%x%w$𼒙x%v#s|‘{&p$}%3'6㾒w${#fpұGP'v!U`ckT^v%S_Ԁ#2t}ӱn"v&T^x$S]&3x$qzT_Ҳ}&4v&{$FR԰q"&}'3s}ӳ|'s#{%y%LVAL1$3ʡ{$x$w%㾏v&y%q{w's}y&w$x$t#})5}'x"t|ır|u#x't{’{%w%S_p&t"в㾏y&y%q|t$q{đm#Ю7Cn#u}t$دǡt#'4Òt#t%đr}y$u~u&BNӳ}%|$%2t&cmVb։5An#DPw|&}#v$v#t'z"őy's"s&x&r#ɐw%z#alѴCN$~$x%w$6C{#z&j%p$v&y&S^Ģv%őП6Dq!Ɠ2?|&r#S_x&q$w$v#GTV_R_ҲҰU`z$DO~'5cnԮCPt(r|T^x$V`Ӥent#z$Ƣy"y'x%s}s%“ʡ|%3y%r|҅&5cmԲERz#s|r#w$t~w%“Ӡ3B‘~&3o$ǣȑ3Aw%u$DOz'}$dmx$w$z&w$W_u$r#Ðx$r#x$v#x#u)S_6Dw#x%EPu%|'fp&5Ƣ5C}#t}T`DQڿÁ&55AU^T_T`Œ3As&u$FPz%r$cns{x%Ȥ"2w$u|ԥbkx%q%ӈ6Cx%m#}%|&Ӱr|t&t${&w#U_w$&v#v%Ȣ3A‘ļ&3u$ɠ{&q$5Cu%v(T^v%w#r%t%BLx%w$ˣckŲs}R^ÒĪt{T_u}ʡͰdmƢU^R^˲r|R_T_đblVbqzT^x$T^㶃̠ԲS^żS_U`s|ʡÒeoS^r|z%|$ǿƑᷓT_S_s{ˡfor|dnw$w$x$w$|$|&y#u&3@۾䋋y%t&v&o#}&̠gou~bmᾔS_U_ţs}S_cnɡdmq{foǸU`P]u~ģཁƢV_akʡcnS^v&u$z$p%⾒T`U`s{x#x$ͯeoǢS^T^’Óy#z(S_u$T_r#v%y&w%&6s%|'5z&r#}%n#}%۝Ðp#w&y$x&z%Ðu$x%x${%tLVAL2#w$’w&w"S]{%S`ϱ%t%s%{&uq#w'z"{'’q"u&4A丸ǔr%r#Юz'u#FS’w(u#x%v%y%u&ܿŐt(%EPU^z$Q]s}z&u$v$w#–pz|'v&q{y&w$ǒfq|"~&ݷ{%w#fpt$t(ӯŒp ~)x$u${%o"m#y'EPV`z$T_ɣs%կ|$p#q%w&̢FRs#z%v#u$eow$y'u|׎u||$z's~%w$y'|%y'v#x%t%‘{&4~'{"FR۱T^t%3@U`UaS^'4v#%4S]UaR^7Dq%y'GTx$y%دWax%m#w$%3T_T]T`r$z'CPޯEOz&w#y&ERS^LVAL3T_4Bu%|%dnϱ盛ޞÒ'4q$t"y'4VaT`t&p$dnƑ~&4x#{$U_԰ױS]s%y%~(4ҡdns#}%ܾپݿ׾͡2@z%߽ܾ߿ؿؿڿݿ԰U`w#  B B |  LVAL4|   QA|P(x$ |(|$!!Ÿ(6x$w$U`ɣԫr{GSx%u%y&S_Ŵ%2u&u%R^Ȣаu$y&LVAL5|%v&t$4AT`U_T_}%3'6ĠӲ|$t$w${#u%z%ӜT`u$v&u"m#~&4FRo$s$ܼ{'x%ְR_y#x%LVAL6w$w$ڿɠá޾ϯ}&4đ&y&໒R]x$y%x$|'5š&5&o"U_ʤĵq|o%|'n%Ɖ4B5Cx#DRT^t&w${%ɠx%Q]ES&5Ӳ5Au$y$'T_q{x&{%q$6Bã̐7Cw$u%w%4BƑŠcmx&u%v&R]ˢERu#v&5Bfny&$4Үs{z$s$o$4Bˢ(6{#r#T_СƏ2A(x%}%3s{r!'t&z(5Ŕ#4s%y&}&4 w"0'y%u"y&|%}&u%z%3R_Ƥ|(4{#p#v'{$y&z%v$~%5BT^⼒R^z&u$x&}"1|%3v&p!&4ҠT`q#4AQ^~'5q{ŕ$2y&s"x%%r%y#z&t%EP'5w$w%~&4FQv#y$7Eܾclx'~(4ղģbkz&%(5“7Cu$v$T_ɣŪs|r$|'n$໒R]x$y%x$|'5šɠz(5u#&r&R^‘r|x&v%y#%3đȢGSt$t&%4Ɠp#n#Цv#S^EQ'5S]t%x% q"w*ERw"ݿn%T_w%uy#v"FRҀ%4s|ˣs$y%w&|$y%w%%4ERx#v&p%u!x%u%u&3'~&4CO}&S_gpo%{&q|3By%s"U`doFSx%u$w$y%{#v#ѯ{%v%Vax%$3ALv%'u"p&w"}&԰v&n$q%t%s{Īu~&5x&U`r%w&qzҿ$1v%v$0ϣS]%n$ѯy%y%ц%3w$r|w'4y&|"t%s&v#q$EPT^S]Ȳo$%cnq"q'r|6DÐ{%x"T^dm7B~#Ϯ%x%ERz%S]t%x%q%z%s|FRw%~%z$s$r%o&r&x%԰w$t%COӃ&5t|Ȕr!z&u$r#S^q(Ŋ5CQ]&z&q$ȟw't#x"z'ÏTavp$~'EPϱȟ4BU`s%T`Tas%z'u%q|Òv%p%ܾs}o"v#EQ˳ϣ4Aپz'y#y&t"еrzy(s"GRΰدFR%x&t&z%EQ|%(6šs"v%DPy(t LVAL7x%v%u$u$'4t%dl"1DR"1grw$v%t#%rzŒo$x%R]x(v#u$S]u$ǔȔr!z&}&y&v~y$w%FPϯҰGSq#x%Ā%x$П|)|'u#y#y%S_y$ƓѢ'5p&r#s$r"'6r|}&x&šx%u$4A᷂S_x&S_T]s&ď~&3y%u"x%w#y&7D乂q$x$׮}%r%ƒw$s$EPs|w#{'x%w$FRs#'6v%z$Ѱz$u&eov#w#|$z$Îm"}'eow$̣՗R]z'n#(6x%߿}&s$ܾU`v$w$r#V`x%|'u#y&t%đp&s$ISuw$}%u"x'v#(6w%x&y&s$T_v&CPr&t$|$&S_v$5Cu%s|ǣв|#|&ēS_z%R_T^s"x%y%y#аz&v#ƢÒv#{%%4x$cl¢x%}%ʡw&m"s%v&y&w%CPq%y$Òt#u$w%’q$v%t%o$FSx%4@x&cmձ5B5CS_6Cblx%x%o%ēy&s%Q]x&Œ%x%R\v%w%x&{#x$ɠx%y%ɠy%z$y&z"S_u%x%w$t&u%R]u'Őr{}&u%x%ǡv&z%S^x&u$v#‘x%m#T^x$U^S^&ɐs|&5ְo$y%Ɠ}%s"y%w&FP%5Bx$T]w%u&|$w$szz$u$ڲz$x$w&v#x&|$u%x%s$w%x$s{s$}%2~&4&5Òu$Ŧֿ}%s%v}#2γ|$p#T^w$ēq%x&T_u$s%v%w#r%Œu'R^v$x%p#%T^{&x%w$z%x%Uaw%񸄋o$w'&4Aвu%u%T`y&đLVAL8x$x%y'U`T^x$S]R_u%خ6CS^ٰw$z$Òu!Xap##t|t#|'5Òv#ŕt&z$w$w$ֱ{%u$rzx"y%t#{%dn|&{$v$}%u%s$Ĕĕs${'5Cw%Ģ&3x"q"v&Ͳ5CT`ӯw$y&U^{&Ð|'{$R\w#ď|'%|$w$˒u%˒v#w$v%u$S^x%x%w$y&x%S]y&R]y%u"7Dǡy&w$t$w$'4x$ÒŒt$S_T^x$T^T_y&Ұco~&4o%{#z'R\|$w&ˢu%Òy%U^Î×s%$x%w$y%s"7Cy&u$Үz'%r#v%r&z%y&ERv#dmv"}'3&x#T_r%Կv'z%ױdn&5z&z$T]y&ڿv&s%Wav#p"v%o%s$w$R^Ŕđ|)u$x%z"y%t$x%w$q#v"Vb&x&}%v#w&ӱv&x%ֲcmv%ďđr|x$y'z(BOʯēT^x$V`T`v$S^ͤx"z'ֿy%DOӯƑx%w#ͣ%4u$R]ďď4Bx%&5t$v%x$w$x$v%x$w#v#Òвr{t&|"5AĔp#u#fq4A}&r")7do߽|%u"~$&3z&dnv&t&U^x$|!y&S^ɠu$v%V`u%s"x(T^w$ǒ(q$ݿu&y#đu'P]ÎƓ“6Cw${&4w$s"w#w'ϴv"|'ձx%w$ݿ{%y&|%3x%x%t{}%v%ɠCOw'z'̣z$͡u$u%R]y'}(v#ƓT^x$T^U^v%'6Őy&Q]w&{&R^~&o&z'Őr#u$҃4A6Aen4Aw%dn|'p#Œw$w$w#w&x"n#$w%s'}&o%t$u%{&q'Œx"y)׾՚R^v$|%ֿv#w$z&EPɠz$u$t!|'%3s$ʡŁLVAL9&{$‘v#Vay&p#߿S]x&eoʢ{%{$3>y&x&{%T^R^UaS_U`R]VaS_T_~!{'6Ccm4A{%cmw%y&޽t&j%ǣEOt%s%x%w$𼒙x%v#s|‘{&p$}%3'6㾒w${#fpұGP'v!U`ckT^v%S_Ԁ#2t}ӱn"v&T^x$S]&3x$qzT_Ҳ}&4v&{$FR԰q"&}'3s}ӳ|'s#{%y%$3ʡ{$x$w%㾏v&y%q{w's}y&w$x$t#})5}'x"t|ır|u#x't{’{%w%S_p&t"в㾏y&y%q|t$q{đm#Ю7Cn#u}t$دǡt#'4Òt#t%đr}y$u~u&BNӳ}%|$%2t&cmVb։5An#DPw|&}#v$v#t'z"őy's"s&x&r#ɐw%z#alѴCN$~$x%w$6C{#z&j%p$v&y&S^Ģv%őП6Dq!Ɠ2?|&r#S_x&q$w$v#GTV_R_ҲҰU`z$DO~'5cnԮCPt(r|T^x$V`Ӥent#z$Ƣy"y'x%s}s%“ʡ|%3y%r|҅&5cmԲERz#s|r#w$t~w%“Ӡ3B‘~&3o$ǣȑ3Aw%u$DOz'}$dmx$w$z&w$W_u$r#Ðx$r#x$v#x#u)S_6Dw#x%EPu%|'fp&5Ƣ5C}#t}T`DQڿÁ&55AU^T_T`Œ3As&u$FPz%r$cns{x%Ȥ"2w$u|ԥbkx%q%ӈ6Cx%m#}%|&Ӱr|t&t${&w#U_w$&v#v%Ȣ3A‘ļ&3u$ɠ{&q$5Cu%v(T^v%w#r%t%BLx%w$ˣckŲs}R^ÒĪt{T_u}ʡͰdmƢU^R^˲r|R_T_đblVbqzT^x$T^㶃̠ԲS^żS_U`s|ʡÒeoS^r|z%|$ǿƑᷓT_S_s{ˡfor|dnw$w$x$w$|$|&y#u&3@۾䋋y%t&v&o#}&̠gou~bmᾔS_U_ţs}S_cnɡdmq{foǸU`P]u~ģཁƢV_akʡcnS^v&u$z$p%⾒T`U`s{x#x$ͯeoǢS^T^’Óy#z(S_u$T_LVAL:r#v%y&w%&6s%|'5z&r#}%n#}%۝Ðp#w&y$x&z%Ðu$x%x${%t#w$’w&w"S]{%S`ϱ%t%s%{&uq#w'z"{'’q"u&4A丸ǔr%r#Юz'u#FS’w(u#x%v%y%u&ܿŐt(%EPU^z$Q]s}z&u$v$w#–pz|'v&q{y&w$ǒfq|"~&ݷ{%w#fpt$t(ӯŒp ~)x$u${%o"m#y'EPV`z$T_ɣs%կ|$p#q%w&̢FRs#z%v#u$eow$y'u|׎u||$z's~%w$y'|%LVAL;y'v#x%t%‘{&4~'{"FR۱T^t%3@U`UaS^'4v#%4S]UaR^7Dq%y'GTx$y%دWax%m#w$%3T_T]T`r$z'CPޯEOz&w#y&ERS^T_4Bu%|%dnϱ盛ޞÒ'4q$t"y'4VaT`t&p$dnƑ~&4x#{$U_԰ױS]s%y%~(4ҡdns#}%ܾپݿ׾͡2@z%߽ܾ߿ؿؿڿݿ԰U`w#LVAL% % 0 K C:\Documents and Settings\sun\My Documents\Business\SolaraSoft\Programs\Inspections\HelpTitle.jpgx |:P@Ƌ=:K`, GroupHeader3x OM_c)Ft'm<"F{axbB'c,i# j% HelpTitle HelpTitle" @ Tahomax *f?IsJPzE>K`,a GroupHeader0x Wۄ%MCfhؗ[m<"F{b$'j% HelpSubtitle HelpSubtitle" @ Tahomax goUGB;K`,  Detailx  /\XCbZBm J2<"F{b$'c, HelpContent HelpContent" @ Tahomax ZdC@`, "PageFooterSectionx pxhM|Id7ab$'c, Label10 VCopyright SolaraSoft. All rights reserved. x ݭ@Vߜ^cK`, ReportFooterx ~xK<$LVAL H=u08:<=5B>a)b*c`'e g ij.k : ?y "[Event Procedure]l좙M^@ tblSuggestions tblSuggestions @ Arial 88888`'h DC odXXLetterDINU"4 },KMXL Y)SLPT1:d!278d# e%" @Times New Romane24 fg3I75jg4h5mf5IC" @ Arialn=I" @ Arialo3IA" @ Arialp4IK`, ReportHeaderx LϻcàI.ASbd2`6<a<b c,d#  Label6 Suggestionsx {ĥAI!<۞y`, "PageHeaderSectionx ȩPf@PCPd7`6!a<bc,, $SuggestionID_Label SuggestionID  DetachedLabelx B&G J#]d7`6-a<bVc,, (SuggestionDate_Label Date  DetachedLabelx Xboux$BssQ[~d`6Ua<bc,,  Suggestion_Label Suggestion  DetachedLabelx `XDK !f2 awb'  Line11x ]!mHRC^K`,  Detailx ܊s[A|m;F{`6!a<bc, SuggestionID SuggestionIDx }br3He٠Mm;F{`6Ka<b8c,k Suggestio LVAL nDate SuggestionDatex t$E#azmF{`6Ua<bc,k Suggestion Suggestionx р̐Bpz`, "PageFooterSectionx /0z`C'd^m !;<F{`6<abc,,i# j%  Text7  =Now()& Long Date" @Times New Romanx Ү82LFC2Cm !;<F{`6&abc,,i# j%k  Text8 H="Page " & [Page] & " of " & [Pages]" @Times New Romanx TOwdMu6X2f2 `6<ab'  Line10x ݓ[koAM@4K`, ReportFooterx QG6'QLVAL/Qͬ/  N7@FormHeaderDetailFormFootermInspectionStatusd Label34ͬ^c^]KB__\љFormHeaderDetailmPermitJurisdicationFormFooterPermitTyped Label34ͬ`6@Tzz-FormHeaderDetailmPermitJurisdicationFormFooterPermitDescriptiond Label34ͬ 6^֒D h?2ՙFormHeaderDetailmPermitJurisdicationFormFooterPermitJurisdictiond Label2mPermitJurisdictionAddressmPermitJurisdictionCitym PermitJurisdictionStatem PermitJurisdictionZipͬ6S\6B-JDetaild Label1mContractorFirstNamed Label2mContractorLastNamemContractorAddressd Label4mContractorCityd Label5m ContractorStatem ContractorZipd Label8d Label9d Label10mContractorEmaild Label11mContractorLicenseNumberd Label12mContractorLicenseExpirationDated Label15mContractorMasterLicenseNumberd Label16mContractorMasterLicenseExpirationDated Label17mContractorMasterNamed Label18m ContractorFederalEmployerIDd !Label19m"ContractorWorkersCompInsuranceCarrierd #Label20m$ContractorMESCEmployerNumberd %Label21m'ContractorOtherPhoneNumberLabelm(ContractorCommentsd )Label24k*Frame27d +Label28i,Option30i-Option322ContractorFileUnder3FormHeader4FormFootermContractorCompanyNamem ContractorPhonemContractorFaxmContractorCell7ContractorOtherPhoneNumberm&ContractorOtherPhonej8ContractorActived 9Label36m;ReferringFormm<ContractorIDm=ContractorContactd >Label40ͬ5R l9DCݍ3FormHeaderDetailmDefaultStated DefaultState_LabeloInspectionInspectorIDd Label11oPermitTypeIDd Label12oDefaultPermitJurisdictionIDd Label13o PermitStatusIDd Label28m DefaultPermitFeed Label15mDefaultPermitNumberd Label16mDefaultExpirationTimeNumberd Label18oDefaultExpirationTimeTypejDefaultShowPermitFeePaymentDated Label23jDefaultShowPermitFeed Label24FormFooterd Label19DefaultPermitStatusIDDefaultPermitTypeIDDefaultInspectionStatusIDDefaultInspectorIDjDefaultShowPermitExtraFieldUser10d Label25jDefaultShowPermitExtraFieldUser20d Label26d "Label27d $Label29d %Label30d &Label31m#DefaultPermitExtraFieldUser10Labelm!DefaultPermitExtraFieldUser20Labeld 'Label33m(DefaultCompanyNameFromm)DefaultAddressFromm*DefaultCityFromm+DefaultStateFromm,DefaultZipFromm-DefaultFirstNameFromm.DefaultLastNameFromd /Label36d 0Label37d 1Label38d 2Label39d 4Inspections_Labelo3DefaultMileageHours 34CB0 32CB0 7CB0 29CB0 9CB0 4CB8 11CB8 17CB0 16CB0 15CB0 14CB0 13CB0 8CB0 6CB0 3CB0 10CB0 12CB0 18CB0 5CB0 20CB0 24CB8 22CB8 27CB8 23CB8 25CB8 28CB8 21CB8 19CB8 1CB8 26CB8 31CB8 30CB8 2CB8 0CB8 33CB0 35CB0 36CB0LVAL H@Z ^ _$F02389 =5B>CJa)b*cNe g+h6ijj,k !?l7m@ tblConfig (Set Program DefaultsM "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx v@0NA[IUb`,  Detailx 8hM5Frm47UF{`6abc,e DefaultState DefaultStateV "[Event Procedure]" @ Tahomax Y;ބOP}md5U7`6vabc, $DefaultState_Label  State" @ Tahomax 7x NA|oC25UD{`Fb@ c6de nZ ("";"";"";"";"10";"0"x TuɒGsx{l} *InspectionInspectorID $DefaultInspectorID] Table/Query[ XSELECT tblInspectors.InspectorID, [InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)") AS Inspector FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)");  0;2880V "[Event Procedure]" @ TahomaY Z"SELECT tblInspectors.InspectorID, [InspectorLastName] & "", "" & [InspeLVALActorFirstName] & IIf([InspectorActive]=True,"""","" (Inactive)"") AS Inspector FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & "", "" & [InspectorFirstName] & IIf([InspectorActive]=True,"""","" (Inactive)"");";"tblInspectors";"";"InspectorID";"[InspectorLastName] & "", "" & [InspectorFirstName] & IIf([Inspect";"PrimaryKey"d5U7abTc, Label11 Inspector" @ Tahomax JB/ oC25UD{`Fbc6de nZ *"";"";"";"";"10";"40"x LONu PermitTypeID &DefaultPermitTypeID] Table/Query[ SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;  0;1440V "[Event Procedure]" @ TahomaY h"SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;";"tblPermitTypes";"";"PermitTypeID";"PermitType";"PrimaryKey"d5U7`6abc, Label12 Permit Type" @ Tahomax H.AsoC25UD{`Fbc6dMe nZ ,"";"";"";"";"10";"100"x ~ԻS)Jb߷&Gw 6DefaultPermitJurisdictionID 6DefaultPermitJurisdictionID] Table/Query[ *SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;  0;1440V "[Event Procedure]" @ TahomaY "SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;";"tblJurisdictions";"";"PermitJurisdictionID";"PermitJurisdiction";"PermitJurisdictionID"d5U7`6IaMb LVALBc, Label13 Jurisdiction" @ Tahomax BoLi|b6oC25UD{`Fbc6de nZ 6"";"";"";"";"";"";"10";"40"x \ͰGep PermitStatusID *DefaultPermitStatusID] Table/Query[ DSELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus, tblPermitStatus.PermitStatusColor FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus; 0;1440;0V "[Event Procedure] "Active"" @ TahomaY "SELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus, tblPermitStatus.PermitStatusColor FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus;";"tblPermitStatus";"";"PermitStatusID";"PermitStatus";"PrimaryKey"d5U7`6ab7c, Label28 Permit Status" @ Tahomax q@"! ;Zm47UF{`6a2 b8k   DefaultPermitFee  DefaultPermitFee& *$#,##0.00;($#,##0.00)V "[Event Procedure]" @ Tahomax =\9E6+Knd5U7`6a2 b7c, Label15 Permit Fee" @ Tahomax VA@ 3m47UF{`6ak &DefaultPermitNumber &DefaultPermitNumberV "[Event Procedure]" @ Tahomax (>H0Xd5U7`6abc, Label16 Permit Number" @ Tahomax &k %OPgm47UF{`6a bk 6DefaultExpirationTimeNumber 6DefaultExpirationTimeNumberV "[Event Procedure]" @ Tahomax  J"]Qd5U7a bTc, Label18 Expiration TiLVALCme" @ Tahomax @; PlG > oC0\25U9D{c6Ld ebnx c_` TN1qF 2DefaultExpirationTimeType 2DefaultExpirationTimeType] Value List[ "Days";"Months"V "[Event Procedure]  "Days"" @ Tahomaj2U`6a i  >DefaultShowPermitFeePaymentDate >DefaultShowPermitFeePaymentDateV "[Event Procedure] True~ "[Event Procedure]x w4yR J47Hd5`6ac bc, Label23 .Show paid date on form?" @ Tahomax uvEܯk,Hnj2U`6as i  (DefaultShowPermitFee (DefaultShowPermitFeeV "[Event Procedure] True~ "[Event Procedure]x y;@#ud5`6aU bc, Label24 "Show fee on form?" @ Tahomax N&L\C i3j2U`6aui BDefaultShowPermitExtraFieldUser10 BDefaultShowPermitExtraFieldUser10V "[Event Procedure]~ "[Event Procedure]x *\JZhLFXd5`6aWb c, Label25 >Show extra field 10 characters?" @ Tahomax d`$AP_xjj2U`6ai BDefaultShowPermitExtraFieldUser20 BDefaultShowPermitExtraFieldUser20V "[Event Procedure]~ "[Event Procedure]x s]B/s嵈d5`6ab c, Label26 >Show extra field 20 characters?" @ Tahomax `ׅIڈ[m47wF{`6arb8k DDefaultPermitExtraFieldUser20Label DDefaultPermitExtraFieldUser20LabelV "[Event Procedure]" @ Tahomax ?>14ӁoBё!cd5w7`6 arbGc, Label27 (label)" @ Tahomax ^ Em47LVALDwF{`6aGb8k DDefaultPermitExtraFieldUser10Label DDefaultPermitExtraFieldUser10LabelV "[Event Procedure]" @ Tahomax px F vSud5w7`6 aGbc, Label29 (label)" @ Tahomax rR,M%b'd5]7aWbTc, Label30 &User-Defined Fields" @ Tahomax 7(U=HAROd!57`6ia8bc,8d# Label31 These fields are to be used instead of the fee fields above as they would cover them. A combination of fee and extra 20 would work." @ Tahomax KZYL^RM ~d5]7`6a bc, Label33 Sender Address:" @ Tahomax MCL m47]F{`6ab j%k  ,DefaultCompanyNameFrom ,DefaultCompanyNameFrom" @ Tahomax ފ\&E¿"<m47]F{`6ab k $DefaultAddressFrom $DefaultAddressFrom" @ Tahoma= Addressx XA,MXj: m47_F{`6ab8k DefaultCityFrom DefaultCityFrom" @ Tahoma= Cityx +ŊBIbENm47_F{`6 abk  DefaultStateFrom  DefaultStateFrom H=DLookUp("DefaultState","tblConfig")" @ Tahoma=  Statex װGj~h]m47WF{`6 abk DefaultZipFrom DefaultZipFrom" @ Tahoma= Zipx Nk'KNcF@rm47_F{`6ab8k LVAL (DefaultFirstNameFrom (DefaultFirstNameFrom" @ Tahoma= Addressx  yEÔ̔m47WF{`6 abk &DefaultLastNameFrom &DefaultLastNameFrom" @ Tahoma= Addressx WlLBmTd5]7abTc, Label36 Address" @ Tahomax >Dn@@E8mrNd5W7abTc, Label37 City/St/Zip" @ Tahomax sR?CL(td5_7abTc, Label38 First/Last" @ Tahomax _ Eѱd5W7abTc, Label39 Company" @ Tahomax fՅYi@٧^[o0\25UD{bc6de nx SC*f~INRD  &DefaultMileageHours &DefaultMileageHours] Value List[ ""Hours";"Mileage" 1440V "[Event Procedure]" @ Tahomad5U7abTc, "Inspections_Label Mileage/Hours" @ Tahomax vGvd݅`, FormFooterx d;Gd5U`6aKbc,9 Label19 Use this form to set default field values upon creating a new record and to show or hide fields. " @ Tahomax 5cG@֛_s3+LVAL HF> ^ _F02389 =5B>CJa)b*cPe g)h6pihjk k? "[ContractorID]=34lw@ tblContractors $Contractor DetailsN "[Event Procedure] @ Arial d2" @ Tahomai1g4h5j1g4h5k1mf45I" @ Tahomao2" @ Tahoma`, FormHeaderx My֖f]G.`,  Detailx PIG!B/Fm45I7UF{`6iabk *ContractorCompanyName *ContractorCompanyNamex !/Lz1 ld5]7ab'c,  Label1 Company Namex idA[m45I7UF{`6ia bk &ContractorFirstName &ContractorFirstNamex $pEҧI\d5U7a b'c,  Label2 First/Lastx VԚlSGDBrm45I7UF{`6 a bx k $ContractorLastName $ContractorLastNamex : "ĶMr;d$m45I7UF{`6ia*bk "ContractorAddress "ContractorAddressx ,aRzI:E2Čd5U7a*b'c,  Label4 Addressx 2ur+Cbvm45I7UF{`6iaGbPk ContractorCity ContractorCityx DK6֧I1+)d5U7aGb'c,  Label5 City/St/Zipx `:[NHm45I7UF{`6 aGbkLVALG ContractorState ContractorState H=DLookUp("DefaultState","tblConfig")x `DGA 'K5m45I7UF{`6aGbk ContractorZip ContractorZipx -@nCGXm45I7UF{`6iabk ContractorPhone ContractorPhoneH .!\(999") "000\-0000;0;_x )Fqo7d5U7ab'c,  Label8  Phonex ?T|iJ<<92m45I7UF{`6ia bk  ContractorFax ContractorFaxH .!\(999") "000\-0000;0;_x <7CЅJGd5U7ab'c,  Label9 Faxx .,@#>#m45I7UF{`6abk  ContractorCell ContractorCellH .!\(999") "000\-0000;0;_x !*PӧA+[}Ed5U7`6 abXc, Label10 Cellx  _N{zm45I7UF{`6ia%bk  ContractorEmail ContractorEmailx eFM-In;:d5U7a%b'c, Label11  Emailx JӍ!Ei.m45I7UF{`6iam bk .ContractorLicenseNumber .ContractorLicenseNumberx ,SF‰ContractorLicenseExpirationDate >ContractorLicenseExpirationDatex >M:Gd5U7`6 am bc, Label15 Expiresx *M9ӳXm45I7UF{`6ia bkLVALH :ContractorMasterLicenseNumber :ContractorMasterLicenseNumberx mg!E2|d5U7a b'c, Label16 Master License#x x(7+DOK06m45I7UF{`6a bk JContractorMasterLicenseExpirationDate JContractorMasterLicenseExpirationDatex [RcG 8̎d5U7`6 a b*c, Label17 Expiresx Y.HlNinm45I7UF{`6ia bk (ContractorMasterName (ContractorMasterNamex ks0)dCS EY*{d5U7a b'c, Label18 Master Namex =LG>"4m45I7UF{`6 aKb k 6ContractorFederalEmployerID 6ContractorFederalEmployerIDx c|nuOØud5U7aPb1 c, Label19 &Federal Employer IDx i Ia:m45I7UF{`6 ahb k JContractorWorkersCompInsuranceCarrier JContractorWorkersCompInsuranceCarrierx yA_ڀ5d5U7ahb1 c, Label20 <Workers Comp Insurance Carrierx ՆmDH[m45I7UF{`6 ab k 8ContractorMESCEmployerNumber 8ContractorMESCEmployerNumberx r$Mm$?d5U7ab1 c, Label21 (MESC Employer Numberx &*jH<tm45I7UF{`6a bk  (ContractorOtherPhone 4ContractorOtherPhoneNumberH .!\(999") "000\-0000;0;_x hNt=u{m47U;F{`6| a bnk  >Contractor=LVALMOtherPhoneNumberLabel >ContractorOtherPhoneNumberLabel "Other"x v. C{m J245I7UF{`6ia.bc,sk $ContractorComments $ContractorCommentsx FyRu`IDxjRd5U7a)b'c, Label24 Commentsx c0|M뽧-k15U`6'axbAc, Frame27 &ContractorFileUnder 1x  ;QC>>#D)d257`6a-bc,d# Label28 File Underx nOXҏ<i2W`6Ea: Option30x 1HI1i2W`6Ea: Option32x 'S5|Ghdj2U`6ia2c,i  ContractorActive  ContractorActivex r``4+D9C`d5U7`6a#bc, Label36  Activex  (D@臐Um7UF{`6 abk ReferringFormx @;Bտ@BHjm7WF{k ContractorID ContractorIDx UW7|GKɿ[m45I7UF{`6ia bk "ContractorContact "ContractorContactx P lJGl{d5U7a b'c, Label40 Contact Personx `ꩥAQ}3}8l`, FormFooterx m5|KEt{LVAL HJ ^ _289 =5B>a)b*c e gh6Vij#k ?l-@  tblJurisdictions $Edit JurisdictionsN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx WT,-D T`,  Detailx #nAN͂9~[m47]F{`6<bej% &PermitJurisdication $PermitJurisdiction" @ Tahomax OB ]DM7 ٻm47_F{`6<abk 2PermitJurisdictionAddress 2PermitJurisdictionAddress" @ Tahoma= Addressx eB}m47_F{`6<abk ,PermitJurisdictionCity ,PermitJurisdictionCity" @ Tahoma= Cityx Ebm=@=Sm47_F{`6abk .PermitJurisdictionState .PermitJurisdictionState H=DLookUp("DefaultState","tblConfig")" @ Tahoma=  Statex @NCJa)b*e g'h6iwj/k z?lT|i'@ Letter DetailsM "[Event Procedure] @ Ariald2" @ Tahomahg#h%" @ Tahomai1g4h5j1g4h5k1mf45I" @ Tahoma`,  Detailx mrݫMI$d5]`6abc,I Label35 If you wish to print on letterhead, press the Start Letter button and then change the top margin by selecting File -> Page Setup.x ;VAT8m J45I7]F{`6a bc, k  LetterContentx G`B#4d5_`6wa bc,e%  Label2 Letter Contentx  @>uMה*h1`6ac,i  cmdStartLetter Start Letter~ "[Event Procedure]x -OJHk15]`6abc, fraAddressToV "[Event Procedure] 1x Ӹ\[J*ed257`6waibec,e%  Label7 Address Tox Jc@BzW` i2W`6Xa: Option9x tknLYyťi2W`6a: Option11x []z(A'Wi2W`6da: Option13x ٕKE/i2W`6a: Option15x FnuFHx$SOm45I7UF{`6aAbk Addressx !s[MxFߡd5U7`6aAbc,LVALM Label17 Addressx  4~CUoڋm45I7UF{`6ajbPk Cityx K]!l.Gh;}%d5U7`6akbc,  Label8 City/St/Zipx pCKr،m45I7UF{`6 ajbk  Statex 4 :mC޾ȁNm45I7UF{`6ajbk  Zipx 4C AB_B|+d!5U`6abc,9 Label19 Edit these fields as needed; they will only be used for this letter.x E>HF!KVkϘ m45I7UF{`6abk FirstNamex 1zIhD✋d5U7`6,abc,  Label6 First/Lastx n~ C 92m45I7UF{`6# abx k LastNamex YH4OY0Ñ0j2]`6a(i chkShowName Truex ϯIgJ#j2]`6ai chkShowCompany Truex <*C2d!5U`6atbc,w Label23 Include?x ~`K f3`6 ab  Line24x 3s;MR)olf3`6 aVb  Line25x y1rOJ5tgf73w`6aVbc,=  Line27x )fHCu%--?fm45I7UF{`6abk Companyx \+.VH"d5U7abc, Label29 Companyx ˱ZBjm45I7UF{`6a bk  Salutationx IƂNK.շ LVAL d5U7`6a bc, Label31 Salutationx ~N^BHI4+h1`6ac,i  cmdCancel  Cancel~ "[Event Procedure]x #' wM١;}d5`6Habc, Label10  Ownerx :}CsHu)1d5`6 abc, Label12 Contractorx v0#J˲Z_s3Ad5`6Jabc, Label14 Inspectorx @iOEu$d5`6abc, Label16  Otherx -!3Cd5`6a bc, Label38 XRemember to include closing signature lines!x FqBIts^LVALT [Vvͬ {Z2QO"?ѧPageHeaderSectionDetailmText0mText2mText3mText4mText5mText6mText7 PageFooterSectiond Label54ͬ![}M&Z7FormHeaderDetaild Label2d Label4d Label5d Label8d Label9d Label10d Label11d Label12d Label15d *Label24/FormFooter2InspectorID@InspectorCategorymInspectorFirstNamemInspectorLastNamemInspectorAddressm InspectorCitym InspectorStatem InspectorZipm InspectorPhonemInspectorFaxmInspectorCellm'InspectorOtherNumberm(InspectorOtherNumberLabelmInspectorEmailmInspectorLicenseNumberm)InspectorCommentsmInspectorLicenseExpirationDatejAInspectorActived BLabel36mCReferringFormͬHpt@y刹FormHeadermPermitNumberd Label0mPermitIssueDated Label1mPermitExpirationDated Label2d Label28 Detailm PermitOwnerFirstNamed Label6m PermitOwnerLastNamem PermitAddressd Label7mPermitCityd Label8mPermitStatemPermitZipd Label10mPermitCommentd Label11d Label12d Label13mPermitFeed Label14oPermitContractorIDd Label17p frmPermitsInspectionsSubf!Line32"FormFooterh #cmdExito$cboSearchJurisdictiono&cboSearchPermitNumbero(cboSearchAddresso*cboSearchOwnerNameo,cboSelectReportf.Line31e/Box33e8Box42d <Label47d =Label48?PermitIDd @Label50d ALabel19d BLabel51d CLabel52d DLabel53d ELabel54d FLabel55fGLine14m;StartingDatem>EndingDateh KcmdDeletePermith JcmdAddPermitoPermitTypeIDoPermitDescriptionIDoPermitJurisdictionIDoPermitStatusIDd MLabel62h OcmdMaximizeh PcmdRestoreh QcmdHelpmLPermitFeePaymentDatemRPermitExtraFieldUser10mSPermitExtraFieldUser20mTExtraUser10LabelmUExtraUser20LabelmVPermitOwnerPhoned WlblLicenseExpiredd lblContractorh XcmdContractorListd YlblLicenseExpiredInspectorͬhMP&C\s_FormHeaderd lblLicenseExpiredd Label0d Label1d Label2d Label3fLine14h cmdInspectorList Detailm InspectionDatem InspectionMileageo InspectionStatusIDo InspectionInspectorIDfLine11mInspectionCommentsd Label13oInspectionTypeIDFormFooterfLine16h cmdDeleteInspectionh cmdAddInspectionInspectionIDInspectionPermitIDInspectionFeeInspectionExtraField10InspectionExtraField20InspectionExtraField30InspectionExtraFieldNumbermText22ͬ%TVK?QЌ DetailmLetterContentd Label2h cmdStartLetterkfraAddressTod Label7iOption9iOption11iOption13i Option15m Addressd Label17m Cityd Label8mStatemZipd Label19mFirstNamed Label6mLastNamejchkShowNamejchkShowCompanyd Label23fLine24fLine25fLine27mCompanyd Label29mSalutationd Label31h cmdCanceld Label10d Label12d !Label14d "Label16d #Label35d $Label38 $7;k& 3 n + Y o : e Dr-C|9RB4[@%@ -z@SBlobDeltaP0,( w@%@ -z@R@qTypeInfoP:62" @%@ -z@QXHl HBlobP2.*" @%@˂-z@P3  w@{@PropDataPLH8 @@BlobDelta0,( w] @@@NTypeInfo:62" ] @@:j HBlob2.*" ] @{@2  w@@DirDataCopy62. w@tA;@modPermitsDirDataXTP@ @@PropDataCopy62. w@U@ 0CB8PropDataIEA1 @U@ PropDataGC?/ @U@0  wO@5 q@ PropDataGC?/ HW@5 q@BlobDelta0,( wHW@5 q@@>TypeInfo:62" HW@5 q@ @iBlob2.*" HW@Qq@13 " w 01@e@% PropData!GC?/  01@e@$BlobDelta!0,( w 01@e@#@fTypeInfo!:62"  01@e@"g HBlob!2.*" /1@e@!12 " wM,@G@~@ PropDataGC?/ M,@G@~@BlobDelta0,( w,@G@~@@>TypeInfo:62" ,@G@~@ @fBlob2.*" ,@G@~@11 " wcO'@؎@ PropDataGC?/ @'@؎@BlobDelta0,( w@'@؎@@bTypeInfo:62" @'@؎@"c HBlob2.*" @'@؎@10 " wo@y@  PropData GC?/ 1@y@ BlobDelta 0,( w1@y@ @>TypeInfo :62" 1@y@  @bBlob 2.*" 1@y@ 9   w@@ PropDataGC?/ @@BlobDelta0,( wBi@@@NTypeInfo:62" Bi@@u%_ HBlob2.*" خ@@8   w\t@+@PropDataPLH8 c@+@BlobDelta0,( wua@+@3@NTypeInfo:62" ua@+@T HBlob2.*" ua@+@7   wtl@HY@  PropData GC?/ 6l@HY@ BlobDelta 0,( w6l@HY@ @NTypeInfo :62" 6l@HY@ G3P HBlob 2.*" 6l@HY@ 6   wLVAL HQ:FP28=5B>a)b*c$e gh6+ijr$k ?K &InspectionDate DESCl)Y:O<@ tblInspectionsW "[Event Procedure] @ Arial d2" @ Tahomae12hg#h%" @ Tahomamf45I" @ Tahomao2" @ Tahomaw2`, FormHeaderx vsIG8d25]7`68bc, "lblLicenseExpired License Expiredx c;L@@T=vkd5]`6Ubc,  Label0 Inspection Typex 1Z̍Ky wd5]`6Zbuc,  Label1 Datex ?D<5d5]`6> bc,  Label2  Statusx s9OH74$d5]`62bc,  Label3 Inspectorx d5#Lf2 3_ab$333  Line14x 扡ZlnL0Y=3h 1`6Qbhc,  cmdInspectorList Command77~ "[Event Procedure] (   c  @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`@ @@@`@@@@@ @ @@ @` @ @ @ @ @@@ @@@@@`@@@@@@@@@@`@ `@@`@``@`@`@`@`@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@ @` @ ` @ @@@`@@@@@` `@``````` @` @`ࠀ @` @` @` @ ` @ @@@`@@@@@` `@``````` @`LVALR @` @` @`= 2Open Contractor List Form C:\Documents and Settings\sun\My Documents\Business\SolaraSoft\Programs\Inspections\ListImage.bmpx HpsbC >XQ m847;CF{`6bk  Text22 V=DLookUp("DefaultMileageHours","tblConfig")x YBy޼`,[  Detailx 0~S$-Ol3\K]m45I7UF{`6ya-b InspectionDate InspectionDatex ~+HE:m45I7U;F{`6a-b:k "InspectionMileage "InspectionMileagex XAUݰoT25UD{`Fbc6P d-enZ *"";"";"";"";"10";"40"x (uOdDm"c $InspectionStatusID $InspectionStatusID] Table/Query[ 6SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;  0;1440 "[Event Procedure]Y "SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;";"tblInspectionStatus";"";"InspectionStatusID";"InspectionStatus";"PrimaryKey"oCT25UD{`Fb@ c6Cd-e# nZ 4"";"";"";"";"";"";"10";"0"x zU @Aڪ|" *InspectionInspectorID *InspectionInspectorID] Table/Query[ SELECT tblInspectors.InspectorID, [InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)") AS Inspector, tblInspectors.InspectorLicenseExpirationDate FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & ", " & [InspectorFirstName] & ILVALSIf([InspectorActive]=True,""," (Inactive)"); 0;2880;0 "[Event Procedure] T=DLookUp("DefaultInspectorID","tblConfig")Y "SELECT tblInspectors.InspectorID, [InspectorLastName] & "", "" & [InspectorFirstName] & IIf([InspectorActive]=True,"""","" (Inactive)"") AS Inspector, tblInspectors.InspectorLicenseExpirationDate FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & "", "" & [InspectorFirstName] & IIf([InspectorActive]=True,"""","" (Inactive)"");";"tblInspectors";"";"InspectorID";"[InspectorLastName] & "", "" & [InspectorFirstName] & IIf([Inspect";"PrimaryKey"f2 3UaIb$  Line11x b OaFzԦ?m J245I7UF{`6eaKbyc,k $InspectionComments $InspectionCommentsx E'CJa)b*cCe gPh6<iJj,k N? V((tblPermits.PermitDescription="New Home"))K 4tblPermits.PermitIssueDatel|4P@ tblPermits InspecTrackerDB v1.0, Copyright SolaraSoft ***DEMO, five permit limit***W "[Event Procedure]M "[Event Procedure] @ Arial d2" @ Tahomae12f333hg#h%" @ Tahomaj1g4h5mf45I" @ Tahomao2" @ Tahomap5w2`, FormHeaderx BJyfXsC^a( mT45I7UF{`6=aKj% PermitNumber PermitNumber "[Event Procedure] V=DLookUp("DefaultPermitNumber","tblConfig")x n?7;J0#_d5U7`6aKbc,  Label0 Permit Numberx +_b HN-Rnm45I7UF{`6aKb8k PermitIssueDate PermitIssueDateV "[Event Procedure]x 8D;6ޯd5U7`6] aKb c,  Label1 Issue Datex _D MgIQe0ة[2m45I7UF{`6aKb8k (PermitExpirationDate (PermitExpirationDateV "[Event Procedure]x EknF%)d5U7`6TaKb)c,  Label2 Expirationx yD%dFfoT25UD{`Fbc6 dKenZ J"";"";"";"";"";"";"";"""""";"10";"40"x cvLEbw PermitStatusID LVALVPermitStatusID] Table/Query[ SELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus, tblPermitStatus.PermitStatusColor, tblPermitStatus.PermitStatusFinal FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus; 0;1440;0;0V "[Event Procedure] "[Event Procedure] Z=DLookUp("DefaultPermitStatusID","tblConfig")Y "SELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus, tblPermitStatus.PermitStatusColor, tblPermitStatus.PermitStatusFinal FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus;";"tblPermitStatus";"";"PermitStatusID";"PermitStatus";"PrimaryKey"d5U7`6aKbgc, Label28  Statusx  !BLߋqh 1U`6o'abhi cmdDeletePermit Command57~ "[Event Procedure] (ڭڭzwwq}}wqzwwqzwڭc H= Delete Permitx m˼GP#-|h 1U`6&abhi cmdAddPermit Command56~ "[Event Procedure] (ڭڭڬͭڬͭDMDDDJͭDMڬͭڭڭc H= Add Permitx q̜|Gz5Fh 1U`6(abhi cmdMaximize Command67~ "[Event Procedure] (   6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%mnmnmnmnmnmnmnmnmnmn6%%mnmnmnmnmnmnmnmnmnmn6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%6%%c  @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`@ @@@`@@@@@ @ @@ @` @ @ @ @ @@@ @@@@@`@@@@@@@@@@`@ `@@`@``@`@`@`@`@@ @@@`@@@@@@ @@@`@@@@@@ @@@LVALW`@@@@@@ @@@`@@@@@ @` @ ` @ @@@`@@@@@` `@``````` @` @`ࠀ @` @` @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`= Maximize C:\Documents and Settings\sun\My Documents\Business\SolaraSoft\Maximize.bmpx k^uH 2h 1U`6?*abhi cmdRestore Command68~ "[Event Procedure] (   c  @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`@ @@@`@@@@@ @ @@ @` @ @ @ @ @@@ @@@@@`@@@@@@@@@@`@ `@@`@``@`@`@`@`@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@ @` @ ` @ @@@`@@@@@` `@``````` @` @`ࠀ @` @` @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`= Restore Size C:\Documents and Settings\sun\My Documents\Business\SolaraSoft\Restore.bmpx FDӧ_o`,  Detailx HBQ,mT45I7]F{`6 abk  (PermitFeePaymentDate (PermitFeePaymentDate= *Date payment receivedx XJkKUOd5]7`6Kab+c, Label62 Paidx  γ̾GăTm 47;CF{`6jab k  ExtraUser20Labelx X`ayA !mT45I7UF{`6=abk (PermitOwnerFirstName (PermitOwnerFirstName= First Namex Sqv=Ho:LVALXd5U7abc,  Label6 Owner F/L/Phx {r` JA5mT45I7UF{`6=ab PermitAddress PermitAddressx ,ʐKlhd5U7`6xabsc,  Label7 Addressx w͢8$IgK͙mT45I7UF{`6=abPk PermitCity PermitCityx  {ӫMx d5U7`6xabsc,  Label8 City/St/Zipx ZcۘL!{tmT45I7UF{`6 abk PermitState PermitState H=DLookUp("DefaultState","tblConfig")x *K;āmT45I7UF{`6abk PermitZip PermitZipx $^wW\J5w{$oT25UD{`Fbc6dem n Z *"";"";"";"";"10";"50"x PNm U &PermitDescriptionID &PermitDescriptionID] Table/Query[ LSELECT tblPermitDescriptions.PermitDescriptionID, tblPermitDescriptions.PermitDescription FROM tblPermitDescriptions ORDER BY tblPermitDescriptions.PermitDescription;  0;1440 "[Event Procedure]Y "SELECT tblPermitDescriptions.PermitDescriptionID, tblPermitDescriptions.PermitDescription FROM tblPermitDescriptions ORDER BY tblPermitDescriptions.PermitDescription;";"tblPermitDescriptions";"";"PermitDescriptionID";"PermitDescription";"PrimaryKey"d5U7`6Tab)c, Label10 Descriptionx EoGA$IZh\m J2LVALY45I7UF{`6=abc,k PermitComment PermitCommentx M[ZWCi:HLWad5U7`6ab9c, Label11 Commentsx _;Jh5725oT25UD{`Fbc6dem n Z *"";"";"";"";"10";"40"x SAC{W PermitTypeID PermitTypeID] Table/Query[ SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;  0;1440 "[Event Procedure] V=DLookUp("DefaultPermitTypeID","tblConfig")Y h"SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;";"tblPermitTypes";"";"PermitTypeID";"PermitType";"PrimaryKey"d5U7`6abvc, Label12 Typex A!OXϵ&oT25UD{`Fbc6dem n Z ,"";"";"";"";"10";"100"x SA|aF=V (PermitJurisdictionID (PermitJurisdictionID] Table/Query[ *SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;  0;1440 "[Event Procedure] f=DLookUp("DefaultPermitJurisdictionID","tblConfig")Y "SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;";"tblJurisdictions";"";"PermitJurisdictionID";"PermitJurisdiction";"PermitJurisdictionID"d5U7`6Tab)c, Label13 Jurisdictionx z+'iJ'XmT45I7F{`6ab8k  PermitFee PLVALZermitFee& *$#,##0.00;($#,##0.00) P=DLookUp("DefaultPermitFee","tblConfig")x GkM*ӗd5]7`6&abWc, Label14 Feex { 4HDfp;,oT25UD{`Fb@ c6=de f,nZ 4"";"";"";"";"";"";"10";"0"x /mm`Ig4Hj $PermitContractorID $PermitContractorID] Table/Query[ SELECT tblContractors.ContractorID, IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)") AS Cont, tblContractors.ContractorLicenseExpirationDate FROM tblContractors ORDER BY tblContractors.ContractorActive, IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)"); 0;2880;0U "[Event Procedure] "[Event Procedure]Y "SELECT tblContractors.ContractorID, IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & "", "" & [ContractorFirstName]) & IIf([ContractorActive]=True,"""","" (Inactive)"") AS Cont, tblContractors.ContractorLicenseExpirationDate FROM tblContractors ORDER BY tblContractors.ContractorActive, IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & "", "" & [ContractorFirstName]) & IIf([ContractorActive]=True,"""","" (Inactive)"");";"tblContractors";"";"ContractorID";"IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorL";"PrimaryKey"d25U7`6abUc, lblContractor Contractorx oIGuBDvJ&dc5]`6abc, e% Label17 Inspectionsx %v kD1 p35`6abT#c,cd333 0frmPermitsInspectionsSub :Form.frmPermitsInspectionsSubLVAL[1 $InspectionPermitID2 PermitIDx PJB f2 3Ub=  Line32x 埶3Kfh6We5]`6&abdc,#   Box33x G).܌te24 5]`6&a^ bdc,C  Box42x VBJfL=]m T45I7F{`6p&a bk StartingDate& Short Datex *4_La!Wd5`6a&a bc, Label47 Starting Datex  n =:Hujd5`6a&abec, Label48 Ending Datex EHjI8zgm T45I7F{`6p&abk EndingDate& Short Datex ޅI.Lh1U`6%ac,i cmdExit Exit~ "[Event Procedure]x ℅Gb@4eMo T259D{`Fb@ c6p&denZ ,"";"";"";"";"10";"100"x UVVM 2 *cboSearchJurisdiction] Table/Query[ *SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;  0;2880V "[Event Procedure]Y "SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;";"tblJurisdictions";"";"PermitJurisdictionID";"PermitJurisdiction";"PermitJurisdictionID"o T259D{`Fc6p&denZ *"";"";"";"";"10";"40"x N ۛXDN%1 *cboSearchPermitNumber] Table/Query[ |SELECT tblPermits.PermitID, tblPermits.PermitNumber FROLVAL\M tblPermits WHERE (((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction])) ORDER BY tblPermits.PermitNumber;  0;1440V "[Event Procedure]o T25D{`Fb@ c6p&d&enZ ("";"";"";"";"10";"0"x A5FǤ)LH FN8d  cboSearchAddress] Table/Query[ SELECT tblPermits.PermitID, [PermitAddress] & " (" & [PermitNumber] & ")" AS AddressAndPermit FROM tblPermits WHERE ((([PermitAddress] & " (" & [PermitNumber] & ")") Is Not Null) AND ((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction])) ORDER BY [PermitAddress] & " (" & [PermitNumber] & ")";  0;1440V "[Event Procedure]o T25D{`Fb@ c6p&dQ enZ ("";"";"";"";"10";"0"x $t65Hc $cboSearchOwnerName] Table/Query[ SELECT tblPermits.PermitID, IIf(IsNull([PermitOwnerLastName]),[PermitOwnerFirstName],IIf(IsNull([PermitOwnerFirstName]),[PermitOwnerLastName],[PermitOwnerLastName] & ", " & [PermitOwnerFirstName])) & " (" & [PermitNumber] & ")" AS Name FROM tblPermits WHERE (((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]) AND ((tblPermits.PermitOwnerLastName) Is Not Null)) OR (((tblPermits.PermitJurisdictionID)=[Forms]![frmPermits]![cboSearchJurisdiction]) AND ((tblPermits.PermitOwnerFirstName) Is Not Null)) ORDER BY IIf(IsNull([PermitOwnerLastName]),[PermitOwnerFirstName],IIf(IsNull([PermitOwnerFirstName]),[PermitOwnerLastName],[PermitOwnerLastName] & ", " & [PermitOwnerFirstName])) & " (" & [PermitNumber] & ")";  0;1440V "[Event Procedure]o T25D{`Fb@ c6p&d*enZ D"";"";"";"";"";"";"";"";"10";"100"x  >En  cboSelectReport] Table/Query[ SELECT tblLVAL]Reports.ReportID, tblReportsUserNames.ReportDisplayName, tblReports.ReportNameActual, tblReports.ReportFlag FROM tblReports INNER JOIN tblReportsUserNames ON tblReports.ReportID = tblReportsUserNames.ReportID WHERE (((tblReportsUserNames.ShowReport)=True)) ORDER BY tblReports.ReportOrder, tblReportsUserNames.ReportDisplayName; 0;2880;0;0V "[Event Procedure] "[Event Procedure]Y "SELECT tblReports.ReportID, tblReportsUserNames.ReportDisplayName, tblReports.ReportNameActual, tblReports.ReportFlag FROM tblReports INNER JOIN tblReportsUserNames ON tblReports.ReportID = tblReportsUserNames.ReportID WHERE (((tblReportsUserNames.ShowReport)=True)) ORDER BY tblReports.ReportOrder, tblReportsUserNames.ReportDisplayName;";"tblReports";"tblReportsUserNames";""d57`64&ab7c,e% Label50 Find Recordsx I4EBQ(d57`6a&abEc, Label19 &Filter Jurisdictionx ]#FI d57`6a&abEc, Label51 Select Permit#x JșJ ]D6d57`6a&aEbEc, Label52 Select Addressx &MS Q1d57`6a&apbEc, Label53 Select Ownerx #8i{D1 jd57`6%&a| bFc,e% Label54 View Reportsx QBF^O+d5`6a&a:bec, Label55 Select Reportx fIlMA h1U`6%a(c,i cmdHelp Help~ "[Event Procedure]x IE;.f]QmT45I7F{`6ab8k ,PermitExtraFieldUser10 ,PermitExtraFieldUser10x ޒ!o HNّc4mT4LVAL^5I7F{`6 abk ,PermitExtraFieldUser20 ,PermitExtraFieldUser20x ULzM=F)glam 47;CF{`6'abVk  ExtraUser10Labelx *^LW>TmT45I7UF{`6abk  PermitOwnerPhone  PermitOwnerPhoneH .!\(999") "000\-0000;0;_= Phone Numberx {+8M!C#d25]7`6abUc, "lblLicenseExpired License Expiredx n.ԴAuE nh 1U`6abhc,i "cmdContractorList Command77~ "[Event Procedure] (   c  @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`@ @@@`@@@@@ @ @@ @` @ @ @ @ @@@ @@@@@`@@@@@@@@@@`@ `@@`@``@`@`@`@`@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@ @` @ ` @ @@@`@@@@@` `@``````` @` @`ࠀ @` @` @` @ ` @ @@@`@@@@@` `@``````` @` @` @` @`= 2Open Contractor List Form C:\Documents and Settings\sun\My Documents\Business\SolaraSoft\Programs\Inspections\ListImage.bmpx  rFBU|>{d257`6abUc, 4lblLicenseExpiredInspector License Expiredx #pnI/ q`, FormFooterx 2wI[HKJ(f2 3UbLVAL=  Line31x ވ_=ME!Ii]f2 3Uab=  Line14x -]2EC=ҟ>ݾLVAL H`> ^ _F02389 =5B>CJa)b*cPe g'h6,ijQ'k  ? [InspectorID]=1l@ tblInspectors InspectorsN "[Event Procedure] @ Arial d2" @ Tahomai1g4h5j1g4h5k1mf45I" @ Tahomao2" @ Tahoma`, FormHeaderx 4/-KƜȉ`,  Detailx Sߕf*H]\%]Im45I7UF{`6iab $InspectorFirstName $InspectorFirstNamex >(; MEw3L d5U7ab'c,  Label2 First/Lastx i":B5&m45I7UF{`6 abx k "InspectorLastName "InspectorLastNamex xߴfG1?X$m45I7UF{`6ia bk  InspectorAddress  InspectorAddressx |EzN Xjd5U7a b'c,  Label4 Addressx l#K-m45I7UF{`6ia*bPk InspectorCity InspectorCityx |;IJH3~d5U7a*b'c,  Label5 City/St/Zipx Q0@~0iI\8ؒ@-m45I7UF{`6 a*bk InspectorState InspectorState H=DLookUp("DefaultState","tblConfig")x pYxHucm45I7UF{`6a*bk InspectorZip InspectorZipx SGXJݱSrD/m45I7UF{`6LVALaiabk InspectorPhone InspectorPhoneH .!\(999") "000\-0000;0;_x m$G:b=d5U7ab'c,  Label8  Phonex y!W@Dm45I7UF{`6iabk InspectorFax InspectorFaxH .!\(999") "000\-0000;0;_x ?<:U´B&d5U7ab'c,  Label9 Faxx ^ ODB7+5m45I7UF{`6abk InspectorCell InspectorCellH .!\(999") "000\-0000;0;_x HSLwZP4Xd5U7`6 abXc, Label10 Cellx t9G$j޳m45I7UF{`6iabk  InspectorEmail InspectorEmailx q=Gn2Qd5U7ab'c, Label11  Emailx ¢Ap{F$m'm45I7UF{`6iaQ bk  ,InspectorLicenseNumber ,InspectorLicenseNumberx bT9Jk|(d5U7aQ b'c, Label12 License Numberx ¼GL5-9m45I7UF{`6aQ bk  <InspectorLicenseExpirationDate <InspectorLicenseExpirationDatex Guk7G- ɒd5U7`6 aQ bc, Label15 Expiresx EXe@}zm45I7UF{`6abk  (InspectorOtherNumber &InspectorOtherPhoneH .!\(999") "000\-0000;0;_x yƵ9K m47U;F{`6 ab#k  2InspectorOtherNumberLabel 0InspectorOtherPhoneLabel "Other"x ׃^iD7p`mG LVALW J245I7U;F{`6ia bc, k "InspectorComments "InspectorComments& \Ins"pe"c"tor"sx _v)EL%}̂#d5U7a b'c,  Label24 Commentsx MK6Uj2U`6ia2i InspectorActive InspectorActivex 7:F| id5U7`6habc,J Label36  Activex 6TFs+4m7UF{`6aAb k ReferringFormx ]1Nq9`, FormFooterx eI<^LVAL %rU >d$>`x<nrU $`@ (A`D 0&$`H $`L nͬ LCDAiFormHeaderd Label1d Label37DetailjContractorActivemContFormFooterd Label2h cmdAddContractorm ContractorIDͬvo G /|FormHeaderDetailmPermitJurisdicationFormFooterInspectionTyped Label34ͬ3S JB*/>kFormHeaderDetaild Label7d Label9d Label10d Label11d Label12d Label13d Label14d Label15d Label16d Label17d Label18d Label19d Label28d Label35pfrmPermitStatusSuboPermitStatusColord Label46FormFooterd Label34 ^ _289 =5B>a)b*cie gh6iijV"k O?l/ @ *tblPermitDescriptions 0Edit Permit DescriptionsN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx !=s@“`,  Detailx lmFCTݧm47UF{`6<be 333 &PermitJurisdication "PermitDescriptionx 9m[nE K7`,u FormFooterx v|ucA`[zd5U`6<b-c,u Label34 Do not type over an existing entry unless you wish to rename it and keep the same meaning and associations. If you want to get rid of an old one you must delete it. See Help-FAQ for more details.x Ls͏H0j'xLVAL Hd ^ _$F02389 =5B>CJa)b*ce g/h6\ iZjk 0?lP@ SELECT tblPermitStatus.PermitStatusColor FROM tblPermitStatus WHERE (((tblPermitStatus.PermitStatus)="expired")); $Edit Permit StatusN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx 7u8KcF`,a  Detailx O4B-g_d23I5U`6aGbc,@@@  Label7  52377" @ Tahomax %+*BEs d23I5U`6abc,yw@@@  Label9 7829960" @ Tahomax ċ1:j@-d23I5U`6abc,@@@ Label10 9868950" @ Tahomax TxnE<{fvWd23I5U`6a*bc,@@@ Label11  39423" @ Tahomax O`}F": d23I5U`6abc,@@@ Label12 16777164" @ Tahomax >uoJl"W%d23I5U`6aGbc,@@@ Label13 10092543" @ Tahomax >\D5E5Lb8d2LVALe3I5U`6abc,@@@ Label14 16764057" @ Tahomax ذrNva#d23I5U`6abc, @@@ Label15  593614" @ Tahomax U+/OXC븨kd23I5U`6adbc,@@@ Label16 10272933" @ Tahomax [ vaClTSd23I5U`6abc,3f@@@ Label17 6723891" @ Tahomax 6I O*|d23I5U`6a*bc,@@@ Label18 13434828" @ Tahomax +n&ATd23I5U`6adbc,@@@ Label19  65535" @ Tahomax TۮOC]Ju d5]`6aN bc,W Label28 Check at least one record as Final. This is for the status you use to indicate the permit is finalized, and marking it Final will not allow it to be automatically changed to Expired if the expiration date is passed.x ?E=D+d5U`6a b c, Label35 L"Expired" is a required status. Color:x ?UDiJLp3U56 `6abxc, 333 $frmPermitStatusSub .Form.frmPermitStatusSubx ֙MAv~oC0\25UD{c6 d en333x /HzJF "PermitStatusColor "PermitStatusColor] Value List[ 39423;52377;65535;593614;6723891;7829960;9868950;10092543;10272933;13434828;16764057;16777164" @ Tahomad25`6a] b$ c, Label46 If there are no records in table, get invalid use of null upon opening permits form.x LVAL"  FD[ZN`, FormFooterx u5*ѹM:8V@d5U`6bc, Label34 Do not type over an existing entry unless you wish to rename it and keep the same meaning and associations. If you want to get rid of an old one you must delete it. See Help-FAQ for more details.x g3NK4qLVALJ2J|rU HT$H`0<nrU FT$F`0<nrU DT$D`0<nrU Bh(B`l,&$AB`p<$B`t (B`x$&nrU @d$@`,<nͬx F"aqAFormHeaderd Label3d Label5d Label10DetailmReportDescriptionmReportDisplayNamejShowReportmReportNameActualh cmdPreviewReportj ArchiveReport FormFooterd Label4z togArchivesh cmdReportsListReportFlagReportIDReportOrderReportInitialName ^ _289 =5B>a)b*cie gh6iijV"k O?l.@ tblPermitTypes "Edit Permit TypesN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx uGD~(o~`,  Detailx Kӧ&rKm47UF{`6<be 333 &PermitJurisdication PermitTypex bQAmRn`,u FormFooterx >GFd5U`6<b-c,u Label34 Do not type over an existing entry unless you wish to rename it and keep the same meaning and associations. If you want to get rid of an old one you must delete it. See Help-FAQ for more details.x ШvJbLVAL Hh$F289 =5B>a)b*ce gh6ijW!k >?lO@ 2qryRecordSourceFrmReports Edit ReportsN "[Event Procedure] @ Arial/d2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx  _uGqd5U7`6`b c, Label10 Archive?x Nb`$Ku<4`,W  Detailx D;O?NQYm8 247]F{`6abEc,gk@@@ "ReportDescription "ReportDescription" @ Tahomax v1nFNAs4m47WF{`6b e j%333 "ReportDisplayName "ReportDisplayName" @ Tahomax G*=Bf'j2`6ai ShowReport ShowReportx :H1:}Dɫc#km8 45I7W;CF{`6 bk333333  ReportNameActual  ReportNameActual" @ Tahomax  uMSȉph 1U`6nabhiLVAL  cmdPreviewReport Command8~ "[Event Procedure] (p xp臀px   c H= Openx ACJ|$;g%j2`6`ai ArchiveReport ArchiveReportx R(iIP?:``, FormFooterx zIBbfd5U`6ab7c,  Label4 Uncheck the Show Report box to hide it from the drop-down list if you don't need it on a routine basis. Edit the report's title as desired. The Archive box is to drop reports off this list if you will never use them.x ?JfXz1U`66abc,h togArchives Show All~ "[Event Procedure]x £$LDA&h1U`66awi cmdReportsList Reports List~ "[Event Procedure]x 9N}O2@fLVAL 0Yy3SrU `(` &nrU T(` &nrU L(`X &nrU T( ` &nrU L|$L` $AL`<$L` $L` nrU \( `  &nrU d(` &nrU d(` &nrU JT$J`$<n ^ _289 =5B>a)b*cZe gh6iijV"k O?laN@ &tblInspectionStatus ,Edit Inspection StatusN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx ՑP0,HjC`,  Detailx l/KCI]Ջm47UF{`6<be 333  InspectionStatus  InspectionStatusx ~#2Bi(cs6`,u FormFooterx /BO-%K0NBd5U`6-b-c,u Label34 Do not type over an existing entry unless you wish to rename it and keep the same meaning and associations. If you want to get rid of an old one you must delete it. See Help-FAQ for more details.x soHJwLVAL Hku08:<=5B>a)b*cc$e gh6Fjyk h?y "[Event Procedure]l@  Letter @ Arial 8c$h DC odXXLetterDINU"4 },KMXL Y)SLPT1:d28" @ Arialmf5I<" @ Arial`, "PageHeaderSectionx c8 vH3K`,  Detailx &:Kͷgm<"F{ab $c,Ji#   Text0 =IIf([Forms]![frmLetter]![chkShowCompany]=True,[Forms]![frmLetter]![Company],"")" @ Tahomax B\pTm<"F{a(b $c,Ji# k  Text2 =IIf([Forms]![frmLetter]![chkShowName]=True,[Forms]![frmLetter]![FirstName] & " " & [Forms]![frmLetter]![LastName],"")" @ Tahomax  E5`sm<"F{arb $c,Ji# k  Text3 <=[Forms]![frmLetter]![Address]" @ Tahomax 'H}2B"+m<"F{ab $c,Ji# k  Text4  =IIf(([Forms]![frmLetter]![Address]="")," ",([Forms]![frmLetter]![City] & ", " & [Forms]![frmLetter]![State] & " " & [Forms]![frmLetter]![Zip]))" @ Tahomax 㴯IK`m<"F{a.bc$c,Ji# k  Text5 B=[Forms]![frmLetter]![Salutation]" @ Tahomax 1%ɔI'Dm LVAL <"F{abc$c,Fi# k  Text6 H=[Forms]![frmLetter]![LetterContent]" @ Tahomax L}c1Gb=m;<"F{bc$c,Ji# k  Text7 =Date()& Long Date" @ Tahomax OCz`d278"`6tbc,d# e% Label54 (Letter Sample Report" @ Tahomax O`MK^`, "PageFooterSectionx i4ӊ@D LVAL Hmu08:<=5B>a)b*c3'e gCh6ija5k v ?y "[Event Procedure]lA+0lm@ >qryRecordSourceRptPermitDetails DPermit Details for Selected Permit @ Arial 88883'$h hp psc 2400 series!@d߀dBeRLdMSACCESSArialHBeںں\\SOLARIS\hp psc 2400 series,LocalOnly,DrvConvertVWK*XX >&winspool2hp psc 2400 seriesoUSB001inter (Copy 1)oL d278d# e%" @Times New Romane2g3I75jg4h5mf5I<C" @Times New Romann7=I" @Times New Romano3I:A" @Times New Romanp4IK`, ReportHeaderx NHQd278"`6bbc,d#  Label54 8Permit Details Sample Report" @ Tahomax r>A@8_' "PageHeaderSectionx YGcؼLVALnF(]m;CF{ab'c,Xi#33  Text46 D="Permit Number " & [PermitNumber]x >?(HʌPf2 ab$'333  Line14x $#ENB>f2 aub$'333  Line48x YrDkzMkm !;<"F{`6absc,k  Text35  =Now()& Short Date" @ Tahomax Lz&K`,$  Detailx ӽ.O4x! o9:"D{`Fbc6<dWef,l# Z *"";"";"";"";"10";"40"x N:gFfRB PermitType PermitTypeID] Table/Query[ SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;  0;1440" @ TahomaY h"SELECT tblPermitTypes.PermitTypeID, tblPermitTypes.PermitType FROM tblPermitTypes ORDER BY tblPermitTypes.PermitType;";"tblPermitTypes";"";"PermitTypeID";"PermitType";"PrimaryKey"o9:"D{`Fbc6<dtef,l# nZ *"";"";"";"";"10";"50"x zEvQEDrB+ "PermitDescription &PermitDescriptionID] Table/Query[ LSELECT tblPermitDescriptions.PermitDescriptionID, tblPermitDescriptions.PermitDescription FROM tblPermitDescriptions ORDER BY tblPermitDescriptions.PermitDescription;  0;1440" @ TahomaY "SELECT tblPermitDescriptions.PermitDescriptionID, tblPermitDescriptions.PermitDescription FROM tblPermitDescriptions ORDER BY tblPermitDescriptions.PermitDescription;";"tblPermitDescriptions";"";"PermitDescriptionID";"PermitDescription";"PrimaryKey"m;<"F{`6<bc,i# k PermitIssueDate PermitIssueDate" @ Tahomax u]1UNb5\m;<"F{`6<abac,LVALoi# k (PermitExpirationDate (PermitExpirationDate" @ Tahomax jYu@~0tDBo9:"D{`Fb@ c6<d:ef,l# nZ *"";"";"";"";"10";"40"x X_YGS PermitStatus PermitStatusID] Table/Query[ SELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus;  0;1440" @ TahomaY "SELECT tblPermitStatus.PermitStatusID, tblPermitStatus.PermitStatus FROM tblPermitStatus ORDER BY tblPermitStatus.PermitStatus;";"tblPermitStatus";"";"PermitStatusID";"PermitStatus";"PrimaryKey"m<"F{ab'c,i# k PermitComment PermitComment" @ Tahomax Yw󧧸L9gMWo9:"D{`Fbc6<def,l# nZ ,"";"";"";"";"10";"100"x '!5BfOIYZ'1 $PermitJurisdiction (PermitJurisdictionID] Table/Query[ SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions;  0;1440" @ TahomaY "SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions;";"tblJurisdictions";"";"PermitJurisdictionID";"PermitJurisdiction";"PermitJurisdictionID"m<"F{`6abc,i# k  Text42 =[PermitOwnerFirstName] & " " & [PermitOwnerLastName] & IIf(IsNull([PermitOwnerPhone]),"",(", Ph " & [PermitOwnerPhone]))" @ Tahomax  (}QDCrpaM b'c,d <rptPermitDetailsInspectionsSub JReport.rptPermitDetailsInspectionsSub1 $InspectionPermitID2 PermitIDx NHFavbCd78"`6abc,d#33 .PermitDescription_Label LVALpDescription" @ Tahomax /OE'D,d78"`6a&bc,d#33 *PermitIssueDate_Label Issue Date" @ Tahomax \'ԡpHzd78"`6aCbc,d#33 4PermitExpirationDate_Label Expiration Date" @ Tahomax %rt7FMD`d78"`6a`bc,d#33 $PermitStatus_Label  Status" @ Tahomax }ĎrU T( `L &nrU T(`P &nrU \(` &(A` &nrU N$N` <nrU L(`H &nrU h$` $A`<(`$&(`,&nrU L(` &nrU \(` &nͬޔrCLA}PageHeaderSectionDetailmText3mText4PageFooterSectionContractorLastNameContractorFirstNameContractorCompanyName ContractorAddress ContractorCity ContractorState ContractorZip ContractorFileUndermContdLabel54dLabel6ͬ-@ÃReportHeaderdLabel0dLabel1dLabel2dLabel3dLabel4fLine14PageHeaderSectionfLine18 Detailm InspectionDatem InspectionMileageo InspectionStatuso InspectionInspectorIDfLine11mInspectionCommentsoInspectionTypePageFooterSectionfLine19ReportFooterfLine27InspectionIDInspectionPermitIDInspectionFeeInspectionTypeIDInspectionStatusIDInspectionExtraField10InspectionExtraField20InspectionExtraField30InspectionExtraFieldNumberͬE`OVUi3ReportHeaderdLabel54PageHeaderSectionmText46fLine14fLine48mText35Detailo PermitTypeo PermitDescriptionm PermitIssueDatem PermitExpirationDateo PermitStatusmPermitCommentoPermitJurisdictionmText42prptPermitDetailsInspectionsSubdPermitDescription_LabeldPermitIssueDate_LabeldPermitExpirationDate_LabeldPermitStatus_LabeldPermitJurisdiction_LabeldLabel43dLabel49dLabel50dPermitContractorID_LabelmText51m Text55!PageFooterSectionm"Text36#ReportFooterm$Text58%PermitID&PermitNumber'PermitCity(PermitState)PermitZip*PermitOwnerFirstName+PermitOwnerLastName,PermitOwnerPhone-PermitTypeID.PermitDescriptionID/PermitStatusID0PermitContractorID1PermitJurisdictionID2PermitFeePaymentDate3PermitExtraFieldUser104PermitExtraFieldUser205PermitExtraFieldDeveloper106PermitExtraFieldDeveloper207PermitExtraFieldDeveloper308ContractorCity9ContractorState:ContractorZip;ContractorLastName<ContractorFirstName=ContractorCompanyName>ContractorFileUnder?ContractorPhone@ContractorLicenseNumberAContractorFaxBContractorCellmCText59DContEPermitAddressFContractorAddressmGText60mHText63IPermitFee$7s.; v 3 X e 0 [  : j%2m*V l7b8f! ѽ@T|@yBlobDeltav0,( w ѽ@S|@x#@TypeInfov:62"  ѽ@T|@w< HBlobv2.*"  ѽ@S|@v13" wI?@ekʻ@ PropData GC?/ I?@ekʻ@ BlobDelta 0,( wI?@ekʻ@ @TypeInfo :62" I?@ekʻ@ ) HBlob 2.*" I?@ekʻ@ 12" wj~?@Z׻@ PropData PLH8 ,~?@ ׻@ BlobDelta 0,( w,~?@ ׻@ i@TypeInfo :62" ,~?@ ׻@ $ HBlob 2.*" ,~?@Z׻@ 11" w* >@]@q PropDatam GC?/ k) >@F@p BlobDeltam 0,( wk) >@]@o @TypeInfom :62" k) >@F@n B HBlobm 2.*" k) >@󞕿@m 10" w/6@.;@ PropData GC?/ .6@.;@ BlobDelta 0,( w.6@.;@ @TypeInfo :62" .6@.;@ 6 HBlob 2.*" .6@.;@ 8  w 1@p;g@PropDataPLH8  1@p;g@BlobDelta0,( w̴1@p;g@@TypeInfo:62" ̴1@p;g@b8 HBlob2.*" ̴1@p;g@6  wv30@^K@> PropData:GC?/ q&0@^K@=BlobDelta:0,( wq&0@^K@< @}TypeInfo::62" q&0@^K@;%~ HBlob:2.*" q&0@^K@:15 " wiv@ss@ PropDataGC?/ m@ss@BlobDelta0,( wm@ss@@bTypeInfo:62" m@ss@ @}Blob2.*" m@ss@14 " w%j@To@PropDataPLH8 tj@To@BlobDelta0,( wtj@To@.@|TypeInfo:62" tj@To@<x HBlob2.*" tj@To@7  ws]@p@PropDataPLH8 s]@/p@BlobDelta0,( ws]@p@@qTypeInfo:62" s]@p@ v HBlob2.*" s]@p@5  w\=@1-z@ePropDataaPLH8 @1-z@dBlobDeltaa0,( w@1-z@c@qTypeInfoa:62" @1-z@b**s HBloba2.*" @1-z@a4  w~%@ -z@T PropDataPGC?/ LVAL Htu08:<=5B>a)b*c`'e gh6i]j*k  2?lE2r@ tblInspections <rptPermitDetailsInspectionsSub @ Arial 8`'h DC odXXLetterDINU"4 },KMXL Y)SLPT1:d278d# e%" @Times New Romane2g3I75jg4h5mf5I<C" @Times New Romann7=I" @Times New Romano3I:A" @Times New Romanp4I InspectionDateK`,K ReportHeaderx e{bBOed78"`6abDc,d#33  Label0 Inspection Type" @ Tahomax  _Y,JUL}d78"abc,d#33  Label1 Date" @ Tahomax dc@6:d78"`6abc,d#33  Label2  Status" @ Tahomax m{0W]C# \d78"`6abc,d#33  Label3 Inspector" @ Tahomax ʍCM"ed78"`6 $ab9c,d#33  Label4 Mileage" @ Tahomax B(7K`f2 ab`'333  Line14x AABEIJC(`, "PageHeaderSectionx  _a Ia(f2 b  LLVALuine18x g"8eCdV-*YK`,  Detailx 8jӌEl<m<"CF{`6ya-bc,i# j% InspectionDate InspectionDate" @ Tahomax BLR- 2m<"CF{`6)$a-bc,i# k "InspectionMileage "InspectionMileage" @ Tahomax OZH]L5&wVo:"D{`Fbc6d-ef,l# nZ *"";"";"";"";"10";"40"x e}_H#{-o  InspectionStatus $InspectionStatusID] Table/Query[ 6SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;  0;1440" @ TahomaY "SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;";"tblInspectionStatus";"";"InspectionStatusID";"InspectionStatus";"PrimaryKey"oC:"D{`Fb@ c6d-e f,l# nZ ("";"";"";"";"10";"0"x  ;Bb !  *InspectionInspectorID *InspectionInspectorID] Table/Query[ XSELECT tblInspectors.InspectorID, [InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)") AS Inspector FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & ", " & [InspectorFirstName] & IIf([InspectorActive]=True,""," (Inactive)");  0;2880" @ TahomaY Z"SELECT tblInspectors.InspectorID, [InspectorLastName] & "", "" & [InspectorFirstName] & IIf([InspectorActive]=True,"""","" (Inactive)"") AS Inspector FROM tblInspectors ORDER BY tblInspectors.InspectorActive, [InspectorLastName] & "", "" & [InspectorFirstName] & IIf([InspectorActive]=True,""""LVAL,"" (Inactive)"");";"tblInspectors";"";"InspectorID";"[InspectorLastName] & "", "" & [InspectorFirstName] & IIf([Inspect";"PrimaryKey"faIb$  Line11x |'J ?m J2<"CF{`6aKb*!c,i# k33 $InspectionComments $InspectionComments" @ Tahomax =e.lOF/:Zo:"D{`Fbc6d-ef,l# nZ *"";"";"";"";"10";"50"x V$R?D N InspectionType  InspectionTypeID] Table/Query[ "SELECT tblInspectionTypes.InspectionTypeID, tblInspectionTypes.InspectionType FROM tblInspectionTypes ORDER BY tblInspectionTypes.InspectionType;  0;1440" @ TahomaY "SELECT tblInspectionTypes.InspectionTypeID, tblInspectionTypes.InspectionType FROM tblInspectionTypes ORDER BY tblInspectionTypes.InspectionType;";"tblInspectionTypes";"";"InspectionTypeID";"InspectionType";"PrimaryKey"`, "PageFooterSectionx nTOp^2fb  Line19x  ]Q=Ow\`$R K`,Z ReportFooterx F9Z(@%Gof2 ab$333  Line27x M켽H*2ƅLVAL Hwu08:<=5B>a)b*c`'e gh6ij~6k f?y "[Event Procedure]lČ[0@ SELECT tblContractors.ContractorLastName, tblContractors.ContractorFirstName, tblContractors.ContractorCompanyName, tblContractors.ContractorAddress, tblContractors.ContractorCity, tblContractors.ContractorState, tblContractors.ContractorZip, tblContractors.ContractorFileUnder, IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName]) & IIf([ContractorActive]=True,""," (Inactive)") AS Cont FROM tblContractors WHERE (((tblContractors.ContractorActive)=True)); Mailing Labels @ Arial 8h hp psc 2400 series!@d߀dBeRLdMSACCESSArialHBeںں\\SOLARIS\hp psc 2400 series,LocalOnly,DrvConvertVWK*XX >&winspool2hp psc 2400 seriesoUSB001inter (Copy 1)oLd28" @ Arialm9f5Ic,,i# " @ Tahoma`, "PageHeaderSectionLVALx Tv{]kB=k@K  Detailx KoL!/m0G;F{`6abY   Text3 "ContractorAddressx ޚ\[\CO.-.m;F{`6abY k@@@  Text4 =IIf(IsNull([ContractorAddress]),"",Trim([ContractorCity] & ", " & [ContractorState] & " " & [ContractorZip]))x յIi*U5FmF{`6axbM k Cont Contx dx#NEHGt?d278"`6abc,d# e% Label54 >Contractor Labels Sample Report" @ Tahomax lwC׬ys^d2`6b9c,̙  Label6 ave 5160x UMwRC;OK`, "PageFooterSectionx ?FG-:GLVAL Hyu08:<=5B>a)b*cB'e g:h6Iij-k ?y "[Event Procedure]lçu@ <qryRecordSourceRptInspections1 &Inspections Style 1 @ Arial 8888B' h !@dC odXXBeRLdMSACCESSArialHBeںں\\SOLARIS\hp psc 2400 series,LocalOnly,DrvConvert 5.USB001d278d# e%" @Times New Romane2g3I75jg4h5mf5I<C" @Times New Romann7=I" @Times New Romano3I:A" @Times New Romanp4I $PermitJurisdiction InspectionDateK`, ReportHeaderx &SI"@*  InspectionStatus $InspectionStatusID] Table/Query[ 6SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;  0;1440" @ TahomaY "SELECT tblInspectionStatus.InspectionStatusID, tblInspectionStatus.InspectionStatus FROM tblInspectionStatus ORDER BY tblInspectionStatus.InspectionStatus;";"tblInspectionStatus";"";"InspectionStatusID";"InspectionStatus";"PrimaryKey"mCF{`69bk InspectionID InspectionIDx rMeOsLs|oC:"D{`Fbc6enZ *"";"";"";"";"10";"50"x bMkCVHqu InspectionType  InspectionTypeID] Table/Query[ "SELECT tblInspectionTypes.InspectionTypeID, tblInspectionTypes.InspectionType FROM tblInspectionTypes ORDER BY tblInspectionTypes.InspectionType;  0;1440" @ TahomaY "SELECT tblInspeLVALctionTypes.InspectionTypeID, tblInspectionTypes.InspectionType FROM tblInspectionTypes ORDER BY tblInspectionTypes.InspectionType;";"tblInspectionTypes";"";"InspectionTypeID";"InspectionType";"PrimaryKey"m<"F{`6bk PermitNumber PermitNumber" @ Tahomax  GZW"N0UMm<"F{`6bk  Text49 =IIf([ContractorFileUnder]=1,[ContractorCompanyName],[ContractorLastName] & ", " & [ContractorFirstName])" @ Tahomax 2 !EMpm<"F{`6bk  Text23 b=[InspectorFirstName] & " " & [InspectorLastName]" @ Tahomax ;mZڸpJVYbK`,w GroupFooter1x C/1I6T%m;<"F{`6$aZbc,i#   Text40 2=Sum([InspectionMileage])" @ Tahomax sњ:O$d!m;<"F{`6RaZbHc,i# k  Text42 ,=Count([InspectionID])" @ Tahomax B$,$LԚ #)d8"aibCc,d#33 Label43 ,Number of Inspections:" @ Tahomax / BуN`#"of2 a-b3'333  Line45x _c3H)m;<"F{`6aibj%k33  Text57 x="Total " & DLookUp("DefaultMileageHours","tblConfig") & ":"" @ Tahomax NJR@A'JiϬ`, "PageFooterSectionx mB\kK`, ReportFooterx UMArǛ}|LVAL b i9rU 6\(6` &nrU Xd(X` &nrU 4`(4` &nrU 2\(2` &nrU 0`(0` &nrU .`(.` &nrU ,T(,` &nrU V$V` (AV`0&$V`$V` nrU T$T` <nrU R$R`<nrU *L(*` &nrU 8$8`p $A8`t nrU (\((` &nrU &T(&` &nrU "`("` &nͬ;3*LFLPvAReportHeaderPageHeaderSectionGroupHeader0fLine14fLine48mText35mText34mText51dLabel0f Line28d Label29d Label30d Label31dLabel48dLabel52dLabel55dLabel54DetailmInspectionDatemInspectionMileagemText21oInspectionStatusmInspectionIDoInspectionTypemPermitNumbermText49mText23GroupFooter1mText40mText42d Label43f!Line45"PageFooterSection#ReportFooter$PermitAddress%PermitCity&PermitState'PermitZip(InspectorID)InspectionInspectorID*InspectorFirstName+InspectorLastName,InspectorAddress-InspectorCity.InspectorState/InspectorZip0InspectionStatusID1InspectionTypeID2ContractorCompanyName3ContractorFirstName4ContractorLastName5ContractorFileUnder6PermitJurisdiction7PermitJurisdictionAddress8PermitJurisdictionCity9PermitJurisdictionState:PermitJurisdictionZipm;Text55m<Text57LVAL2%ͬ[`MSJI4ǐ喙FormHeaderDetaild Label2FormFootereBox15d Label20e Box23d Label25eBox28d Label33eBox35d Label37h cmdDeletePriorToIssueDateh cmdDeletePriorToExpirationDateh cmdDeleteFromJurisdictionh cmdDeleteAlld Label38oJurisdictionm ExpirationDatemIssueDated Label39eBox42oPermitStatush cmdDeleteStatus ^ _289 =5B>a)b*cZe gh6iijV"k O?l@ $tblInspectionTypes *Edit Inspection TypesN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx BIHS(`,  Detailx  .äO@Gm47UF{`6<be 333 &PermitJurisdication InspectionTypex UIHN~`,u FormFooterx (oFˈ%0ėd5U`6-b-c,u Label34 Do not type over an existing entry unless you wish to rename it and keep the same meaning and associations. If you want to get rid of an old one you must delete it. See Help-FAQ for more details.x 7@Lv5LVAL H ^ _:02389 =5B>CJa)b*ce g,h6rijk |?l1@ 0Select Records to DeleteN "[Event Procedure] @ Ariald2e12g23I75hg#h%" @MS Sans Serifi1g4h5j1g4h5k1l23I:mf4n2o2p5r35Izi#j%" @MS Sans Serif{5`, FormHeaderx J`VCD3u`,  Detailx  [LޕbQfd5]`6Ya} bc,e%  Label2 jDelete all records with a permit issue date prior to:" @ Tahomax G&1G N c<m47];F{`6ha bk IssueDate& Short Date" @ Tahomax 2D;xDQS4h1]`6 a] i 2cmdDeletePriorToIssueDate  Delete~ "[Event Procedure]" @ Tahomax P6DNmjsR(o25]D{`Fbc6hdenZ ,"";"";"";"";"10";"100"x 11 _O?s Jurisdiction] Table/Query[ *SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;  0;1440" @ TahomaY "SELECT tblJurisdictions.PermitJurisdictionID, tblJurisdictions.PermitJurisdiction FROM tblJurisdictions ORDER BY tblJurisdictions.PermitJurisdiction;";"tblJurisdictions";"";"PermitJurisdictionID";"PermitJurisdiction";"PermLVALitJurisdictionID"e5`6a bc,8  Box15x )^]BB1r%d5]`6Yaibc,e% Label20 tDelete all records with a permit expiration date prior to:" @ Tahomax V=JIR0@m47];F{`6habk ExpirationDate& Short Date" @ Tahomax )K#NzPhh1]`6 aIi <cmdDeletePriorToExpirationDate  Delete~ "[Event Procedure]" @ Tahomax {fyKKTƉpe5`6abc,8  Box23x [#nGo\5$d5]`6Yabc,e% Label25 jDelete all records that fall under this jurisdiction:" @ Tahomax N'}J{Ifmh1]`6 aqi 2cmdDeleteFromJurisdiction  Delete~ "[Event Procedure]" @ Tahomax ^9+B0Ն,e5`6abc,8  Box28x  ;FL ڥ{od5]`6YaUbc,e% Label33 HDelete all records in this database." @ Tahomax @?/~eN姟h1]`6Ya5bi cmdDeleteAll $Delete All Records~ "[Event Procedure]" @ Tahomax  akH5 N$ e5`6abc,8  Box35x 1sMQG d5U`6a`bc, Label37 >These actions cannot be undone.x CW|;C?%<d5`6Ya6bc, Label38 fThe program will be returned to its original state." @ Tahomax M5F̓O ;d5]`6YaJbc,,e% Label39 HDelete all records with this status:" @