Standard Jet DBnb` Ugr@?~1y0̝cßFN7h7לw(%`{6D߱gC~<3y[#&|*O|-_Hf_Љ$g'DeFx -bT4.0)Pbub a N M : 9 & %   ts`_LK87$ÇÇÇts`T`z yj7^T`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p T`z yj7^T`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p T`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p b 9`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p 9c 9`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p 9b tc t`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p tb sc s`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p sb r `dܚ'}[?nR2#)"έD2lE 8=; 7? ϲUáQt~gb0OԪcݒJ}6p r c r`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p r b q `dܚ'}[?nR2#)"έD2lE 8=; 7? ϲUáQt~gb0OԪcݒJ}6p q c q`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p q b p `dܚ'}[?nR2#)"έD2lE 8=; 7? ϲUáQt~gb0OԪcݒJ}6p p c p`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p p b o `dܚ'}[?nR2#)"έD2lE 8=; 7? ϲUáQt~gb0OԪcݒJ}6p o c o`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p o b n `z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p n c n`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p n b m `dܚ'}[?nR2#)"έD2lE 8=; 7? ϲUáQt~gb0OԪcݒJ}6p m c m`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p m b l `z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p l c l`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p l b k `z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p k c k`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p k b j `z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p j c j`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪcݒJ}6p j b i `z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? js.~gb0OԪcݒJ}6p i c i`z yj7^[?nR2߬,y&[ ^D2lE 8=; 7? Ui %s.~gb0OԪ*@x> YS  Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        ii ijjjjjjk k"k#k$k%k &k!l'l)l*l(m+m-m.m,n/n1n2n0o3o5o6o7o8o9o:o;oo ?o @o Ao4pBpDpEpCqFqHqIqGrJrLrMrKsNsPsQsRssssssssss  s  s  s  s  sssss sOttttttttttttt t !t "t #t $t%t &ttblPersons.LastName2 's @  'stblPersonstblPersonSessionf@ QE% sCountR@ ' osRetreatB@ + os WK10 tblPersonSession.Attended_Wk10E os WK9tblPersonSession.Attended_Wk9B os WK8tblPersonSession.Attended_Wk8B os WK7tblPersonSession.Attended_Wk7B os WK6tblPersonSession.Attended_Wk6B osWK5tblPersonSession.Attended_Wk5B osWK4tblPersonSession.Attended_Wk4B osWK3tblPersonSession.Attended_Wk3B osWK2tblPersonSession.Attended_Wk2B osWK1tblPersonSession.Attended_Wk1B ostblPersons.LastName2OYSY Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectIdx(xxy,zz{0|xt؝xLyyzP{{|888 YSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute'() * + , - ./0123456789:;<=>?@ A!B"C#D$E%F&G'H(I)J*K+L,M-N.O/P0Q1R2S3T4U5V6W7X8Y9Z:[;\<]=^>_?`@aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ{[|\}]~^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'() * + , - ./01234567 -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationship79:;<=>?AdfCDEFGHIJLMNOPQRSTUVXYZ[\]^_`abcghijkmnopqrstuxyz{|}~Root Entryu0DVBA  j0DVBAProject/-  j0DVBA  jODdir9 __SRP_0 Y__SRP_11__SRP_2 =   !"#$%&'()*+,-./023456789:;<>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxy{|}~l0* pHdtemplate,@ Z= n G`@ EJ< DAO>BDA@O *\G{000@25E01-0C  0046}#5.0#0#C:\Program Files\Common Microsoft Share d\w350.0DLL# 3.5 Object LibraryHTstdole>fstdole5]f\]04V3[V-]2]WINDOWS\SYSTEM\STDOLE2.TLB# Automation/VBIDE> VBIDECCE157C5.3PVBA \6E6EXT.O+RVisual Basic for Applic1s Extensibility +"*@Form_frmSess1@G]r@m_fSA`ssinPHBQEKNITGQDYDQWXODLBEYEQGVD28AH@N"QMKN@PT(GQQYQWXO@LEY@ QV@MA1B-@B,0Zp"(B+B4Persons4P4r4on@4VQBPHJDXCJUNXDLQZLBLHHRGGCHN4V0(BP'J*XCJU7X@RLZ3LHR3G HO $MQ@4MainMen0uG 4M"a@4nM`nu5APEHKLAMKGSRDJNFINHDCGCTOXL5A`EKAK`S DNF7ZND!T7X %H5dOReportSlelbP.RepbtQc@iREIULEKETFEVVNDQBNHUIFN@VECMCMCEE@U@EK NTQ@EV N8Q QU`F6V NC!aOOOLQC_rptE8HelpG@$R,e%_mpkM9HlUZNWIPBLJYLPLQNNFGIXJUZEKHZWP`L8Y`P&TUjNF _B_var_Doendwith;_B_var_endwith _B_var_EndFSourceG ChurchNameacQueryh directorymGwhicharet executing~ AlphaBase_B_var_AlphaBase"$_B_var_NamedListEnabledPrst2jstDestination_msg i Report_rptNameTags(3x4inch)v"Text2~Text4~erros=onerrw2 _B_var_onerrOnErrorMESSAG @@`HI I@2@`X@" 5&$3$?@a<z@?@9<{@ +kh+MSi`fQikdbk+kh+MMYmv+kh+OifmiQmiQJmiQUYkmiJmYdb+kh+Oid^Q:+YOhivMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb!BSi`fQikdb+JbO+kQkkYdbSi`fQikdbkSi`fQikdbkQkkYdbSi`fQikdbkQkkYdb+koLSi`iQfdimkQ^QMmYdbSi`kQkkYdbSi`omY^YmvxSi`fQikdb+JbO+kQkkYdb+diUMdfvdSSi`fQikdb+JbO+kQkkYdbifmJLdomifmJOOiQkk^JLQ^k ifmJ^^fJimYMYfJbmk!ifmJmmQbOJbMQ"ifmJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim#ifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb$ifmQ`JY^JOOiQkkQk%ifmUQbQiYM+kQJiMW+db+Md``Qbmk&ifmUQbQiYM+kQJiMW+db+Md``Qbmk+L\8'ifmUQbQiYM+kQJiMW+db+Md``Qbmk+diU(ifmUidofiQfdimko``Jiv)ifmUidofiQfdimko``Jiv+MdbOQbkQOifmUoQkmJUQ^YkmifmUoQkmJ^fWJLQmYMJ^^Ykmifm`JYb`QboWQ^fifmbJ`QmJUk:u<8:YbMWQkifmbJ`QmJUkYbMWifmiQfdimLvid^QifmiQmiQJmiQUYkmiJmYdbifmkQkkYdbUidofkifmkQkkYdbUidofk+OQmJY^k ifmkQkkYdb^QJOQik ifmomY^Ymv omY^Ymv: JomdQuQML Qufdim+JOOiQkk+Ldd\+Sdi+dom^dd\Y`fdim+mJL^Qk+Sid`+QuYkmYbU+OLJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`LoY^ObJ`QO^Ykm+kh+MMd`Ld8+kh+MSi`LoY^ObJ`QO^Ykm+kh+MbJ`QO+^Ykm+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MMLdSYbO+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MMYmv+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MSi`fQikdbkQkkYdb+kh+MSi`fQikdbk+kh+MMYmv+kh+MSi`fQikdbk+kh+MMd`Ld<>+kh+MSi`fQikdbkQkkYdb+koL+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+koL+kh+MkfkQkkYdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+kh+MkffQikdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MkfkQkkYdb+YO +kh+MSi`iQfdimkQ^QMmYdb+kh+MMLdiQfdimk!+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMLdSYbO+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q+YO+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q:+YO+kh+OifmJ^^fJimYMYfJbmk+kh+OkfkQkkYdb+YO+kh+OifmJmmQbOJbMQ+kh+OJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim+kh+OifmJmmQbOJbMQ+kh+OkfkQkkYdb+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q:+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+MdbOQbkQO+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJUQ^Ykm+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJ^fWJLQmYMJ^^Ykm+kh+OkfkQkkYdb+YO`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOokQiOQSYbQO3 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @            !"#$%&' (!)"#$%&'()*+ , - . / 0123456789:;<=>?@AB C!DEFGHIJKLM N O P Q RSTUVWXYZ[\]^_`abcdefgh i j k l mnopqrstuvwxyz{| }!~"FFFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFF F!F"F#[[9>\[e[j[o[r[{[ ~[ [ [ [[[[[[[[G[*K[+[,[-  28@H P X`h px  8    &    20hp x   D  . H X h x       .  ( 8 HX`h p x &   , ,@H ,P      *       0  @  P  `  p      .    ( x7=======================================================3 Scan the tblGroupReportSummary table, to determine. which leaders are associated with each Guest./ Assign these leaders as Leader1, Leader2, etc.7 and write this info to tblGroupReportSummary_condensed2 This version of the report will fill considerably less rows of paper.J Dick Hertel May 18, 2003cNorma8========================================================]`]x]]]]]] ]8]P]h]]]]]1 E    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKL       ! "!#!$!%"&"'"(#)#*#+$,$-$.%/%0%1&2&3&4'5'6'7(8(9(:);)<)=*>*?*@+A+B+C,D,E,F-G-H-I.J..///00011 1 2 2 2 3333444455556666777 7!8"8#8$8%9&9'9(9):*:+:,:-;.;/;0;1<2<3<4<5=6=7=8=9>:>;><>????@@@@A A A A B BBBCCCCDDDDEEEEFFFF G!G"G#G$H%H&H'H(I)I*I+I,J-J.J/J0K1K2K3K4L5L6L7LMMMMNNNNO O O O P PPPQQQQRRRRSSSSTTTT U!U"U#U$V%V&V'V(W)W*W+W,X-X.X/X0Y1Y2Y3Y4Z5Z6Z7Z[[[[\\\\] ] ] ] ^ ^^^____````aaaabbbb c!c"c#c$d%d&d'd(e)e*e+e,f-f.f/f0g1g2g3g4h5h6h7hiiiijjjjk k k k l lllmmmmnnnnoooopppp q!q"q#q$r%r&r'r(s)s*s+t,t-t.MNOP78/01293949596  !"#& Z @BS4cIs  }A9CGIJ>LOP QGSY V444444 4 4 55555 5 566 6!6 "67#7%7&7'7(7$8)8+8,8 -8*9.909192939/:4:6:7:8:9: ::5;;;=;>;?;@;<<A<C<D<E<F<B=G=I=J=K=L= M=H>N>>>>>???? ? ?@ @ @@@@ AAAAAABBBBBB BCC C!C"C #CD$D&D'D (D%E)E+E,E-E.E*F/F1F2F3F 4F 5F0G6G8G9G :G7H;H=H>H?H@HB@ADJlEFGHIKNLMOZ[QRSTUVWXYhi]^_`abcdefgkjmtnopqrsuyvwxz}{|08=Babc+e g8hi@j 3kf3̙f3f3ffffff3f3333f333f3f3̙f3̙̙̙̙f̙3̙ffffff3f3333f333f3f3̙f3f3ffffff3f3333f333f3ffffff3ffff̙fff3fffffff3ffffffffffff3fff3f3f3f3ff33f3ffffff3f3333f333333̙3f3333333f3333f3f3f3ff3f33f33333333f333333333f333f3̙f3f3ffffff3f3333f333f35!0b@"[Event Procedure]qryPersonslPerson's Comprehensive Information (Fixed and Session)"[Event Procedure]"[Event Procedure]"[Event Procedure] Arial8 hATI2DVAG*0<*0|~stuv x<|}d /  yK$d2d e333 Tahomae233f2433hg 33 Tahomai6gh3j6gh3k33l:33mi 33 Tahomanj 3333 Tahomaol 33 Tahomap33r4533zi j Tahoma{ Arial`FormHeaderU. DA `p DetailU. DA m7W`D%axcei jperson_idperson_idU. DA d5]`(#axbcd person_id_LabelIDU. DA m7U`ab8che i k Title TitleU. DA m7U`(ab che i kFirstNameFirstNameU. DA m7U`ab cJe i kLastNameLastNameU. DA m 27U`abc,e i kAddressAddressU. DA m7U` adb8cJe8i k State StateU. DA m7U`adb8c,e8i kZipZipU. DA m7W`(ab` cei k Phone Phone"[Event Procedure]U. DA d5]`abtcPhone_LabelDayPhoneU. DA m7W`(apb` cei k Phone2 Phone2"[Event Procedure]U. DA d5]`apbtcPhone2_LabelEvePhoneU. DA m 27W` a(b c,e i k Email tblPersons.EmailU. DA d5]`a(btcEmail_Label EmailU. DA m7W` ab ce i  @mL^fQikdbkQkkYdbmL^fQikdbkQkkYdbM 08:<=Babc&e ghhi`jkD"]ˇ;h@,qryRetreatRegistration tblPersonSession Arial8&hhCanon BJC-5000 Series` odhh4!*@'v,s4!*4!*4!*hhCanon BJC-5000 Series@'WINSPOOLCanon BJC-5000 SeriesLPT1:d278d eTimes New Romane2g37jghm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp4LastNameFirstName`HReportHeaderRI?jrd2`axbcXdeLabel10(Retreat RegistrationhFGZOtYtfU`"PageHeaderSectionT'P㮓AAyѶ d`<aXbDcd LastName_LabelLast NameDetachedLabeliŹ2KKvTd`aXbcd FirstName_LabelFirst NameDetachedLabelV"WFaKd` aXbcd Phone_Label PhoneDetachedLabel橛ʢOkd`$aXbDcd Role_id_LabelRoleDetachedLabel%%?Kgud`aXbcd Role2_id_Label Role2DetachedLabelj=3&^H[v @f2`<afb" Line13xfSOa}.) m`<axb chi ChurchNameChurchNameZ HV o`bc\de6fhl n,"";"";"";"";"10";"100"UJLs?Rspsession_idspsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"d7`axbHcwd Label16Session:lƵ8SA`,4d7`aXbvcLabel19 Group:7;SwG&a@G`h Detail=LVFiaz0m`<a<bDci LastNameLastName'GH^*m`a<b(ci kFirstNameFirstName ΔK]Rm` a<bci k PhoneComposite_Phonec8Sg?@ABIEFGH_dKLMNOPQRSTUVWXYZ[\]`abcehfgikjlmnopWK1_LabeldWK2_Labeld WK3_Labeld WK4_Labeld WK5_Labeld WK6_Labeld WK7_LabeldWK8_LabeldWK9_LabeldWK10_LabeldRetreat_LabeldCount_LabelfLine33DetailmLastNamemFirstName0*d _ Z g  ~K S 4jFAI8Vv| !b\63v@b\63v@rptG!cJb@cJb@rptGroupReportSummaryfLLLLLLLLLLJ  (X;k@(X;k@rptGeneric_Search_On_Comments_orgfddddddddddb /o@/o@rptGeneric_Search_On_Comments_bk1fddddddddddb }7`@}7`@rptGeneric_Search_On_Commentsf\\\\\\\\\\Z iYj@iYj@rptEmailAddressesfDDDDDDDDDDB _:h@_:h@rptCelebrationDinnerRegistrationfbbbbbbbbbb` 3z[fn@3z[fn@rptAttendance_Weekly_Counts subreportfllllllllllj 呍n@呍n@rptAttendancef<<<<<<<<<<: 4:h@4:h@rptAllParticipantsfFFFFFFFFFFD Qc@Qc@rptAddressLabelsfBBBBBBBBBB@ i'b@i'b@rptAboutf22222222220 &cuh@&cuh@Copy of frmPerson_and_Sessionf\\\\\\\\\\Z ӷb@S]Էb@zfrmPerson_and_Session_orgf@bbbVVVVVVVT @aX(j@aX(j@frmUtilityf66666666664  m\@|7_@frmSessionf>@BBB66666664 @[*sh@1+sh@frmPersonSession_subf~@VVVJJJJJJJH @g`@)`@frmPersonSessionf~@NNNBBBBBBB@ @Y29_@t_@frmPersonsf@BBB66666664 @bpa@B1;a@frmPerson_and_Sessionf@XXXLLLLLLLJ @ ot_@ ;a@frmMainMenuf@DDD88888886 @ 7`@7`@frmGeneric_Report_Preparationf@hhh\\\\\\\Z @ ,}i@,}i@frmEditRolesf::::::::::8  %b@m5j@frmBuildNamedListf@PPPDDDDDDDB @ ĘV\@lb@frm_ChurchInformationf@XXXLLLLLLLJ @ M7;%\@M7;%\@UserDefinedf88888888886  M7;%\@tj\@SummaryInfof|@DDD88888886 @[;%\@;%\@SysRelf.........., qu;%\@qu;%\@Scriptsf0000000000. qu;%\@qu;%\@Reportsf0000000000. ;%\@;%\@Modulesf0000000000. qu;%\@qu;%\@Formsf,,,,,,,,,,* qM=7_@qM=7_@DataAccessPagesf@@@@@@@@@@> >:%\@>:%\@MSysRelationshipsgDDDDDDDDDDB >:%\@>:%\@MSysQueriesg88888888886 >:%\@>:%\@MSysACEsg22222222220 >:%\@>:%\@MSysObjectsg88888888886 >:%\@WuSh@MSysDbf@ N:::......., @>:%\@>:%\@Relationshipsg<<<<<<<<<<: >:%\@>:%\@Databasesg44444444442 >:%\@>:%\@Tablesg.........., "&Z ~ ! K o  p x # VRHNH}FED)%DjBCJJ"k@R"k@~sq_cfrmReportSelection~sq_ccboReportsf( @4MR2KeepLocal CJJ"k@R"k@~sq_cfrmReportSelection~sq_ccboReportsf( @4MR2KeepLocal Tznnnnnnl `BFPSh@FPSh@~sq_cfrmPersonSession~sq_cspsession_idf4MR2KeepLocal Tnnnnnnnl @ [@FPSh@FPSh@~sq_cfrmPersonSession~sq_cRole2f4MR2KeepLocal T```````^ @?FPSh@FPSh@~sq_cfrmPersonSession~sq_cRolef4MR2KeepLocal T^^^^^^^\ @[=o;Wt@o;Wt@~sq_cfrmPersonSession_sub~sq_cspsession_idf4MR2KeepLocal Tvvvvvvvt @([[:LWt@LWt@~sq_cfrmPersonSession_sub~sq_cRelationshipIdf @!4MR2KeepLocal Tzzzzzzx `9~B4s@~B4s@~sq_cfrmPersons~sq_cCombo34f4MR2KeepLocal TXXXXXXXV @[7@Vt@@Vt@~sq_cfrmPerson_and_Session~sq_cfrmPersonSessionf4MR2KeepLocal T~ @6@Vt@\/@Vt@~sq_cfrmPerson_and_Session~sq_cCityf@A4MR2KeepLocal Tthhhhhhf `[3˦ok@Φok@~sq_cfrmBuildNamedList~sq_cCombo1f=.]34MR2KeepLocal Tpddddddb `2 I\@Cg@Adminf@8,,,,,,,,,* 1[t@[t@Import_Tables_From_Existing_DBf^^^^^^^^^^\ 0u@u@Export_Address_Book_for_Outlookf``````````^ /%O,_@0:a@Autoexecbf@@@@44444442 @.z1v@z1v@Utility2f22222222220 --G1v@-G1v@rptUtilityf66666666664 ,Th@Th@rptSessionLeadersfDDDDDDDDDDB +Ip@*%Jp@rptSessionGroups_Detailsf<@^^^RRRRRRRP @*4Th@$ o@rptSessionGroupsf<@NNNBBBBBBB@ @) d:h@ d:h@rptRetreatRegistrationfNNNNNNNNNNL (HZb@HZb@rptReportByRolef@@@@@@@@@@> 'z=b@z=b@rptNameTags(3x4inch)fJJJJJJJJJJH &LqGb@LqGb@rptNameTags(2x3 1/2 inches)fXXXXXXXXXXV %b`@b`@rptMainMenuHelpf@@@@@@@@@@> $4;h@4;h@rptGuestAlphabeticalListfRRRRRRRRRRP #;h@;h@rptGuestAgeListf@@@@@@@@@@> " o@ o@rptGroupReportSummary_Condensedf``````````^ O`6 nP2 Q E  ;  8 } M  iK|^.~LcE'`* b%] S @> G= dtblSession.session_id6 /=tblSession.Session1 g=tblSession.session_id4 g=tblSession%%% = G= = G<[tblRoles].[Role]0 g<[tblRoles].[Role_id]3 g<tblRoles!!! < G< < G;[tblRoles].[Role]0 g;[tblRoles].[Role_id]3 g;tblRoles!!! ; G; ; G:  [LastName]) ':Expr1![LastName] & ", " & [FirstName]H o:tblPersons.person_id3 g:tblPersons%%% : G: : G9[qryPersons].[FirstName]7 g9[qryPersons].[LastName]6 g9[qryPersons].[person_id]7 g9qryPersons%%% 9 9 G8 tblCities.City- '8tblCities.City- g8tblCities### 8 8 G7([__person_id] = spperson_id)< '7qryPersonSessionfrmPerson_and_Session[[1 7  G7__person_id''' O7 7 G6 tblCities.City- '6tblCities.City- g6tblCities### 6 6 G5 qryPersons.FirstName3 '5 qryPersons.LastName2 '5Expr1![LastName] & ", " & [FirstName]H o5qryPersons.person_id3 g5qryPersons%%% 5 5 G4 [tblNamedList].[Last_Name]9 '4 [tblNamedList].[Title]5 g4[tblNamedList].[Zip]3 g4[tblNamedList].[State]5 g4[tblNamedList].[City]4 g4[tblNamedList].[Street]6 g4[tblNamedList].[Email]5 g4[tblNamedList].[person_id]9 g4[tblNamedList].[Last_Name]9 g4[tblNamedList].[First_Name]: g4tblNamedList))) 4 G4 4 G3 D@ '3 [qryNamedList_Extract].[Email]= g3D@ g3F@ g3D@ g3qryNamedList_Extract999 3 G3 3 GLVALv2X  : @><b@DtblPersons.person_id = tblPersonSession.spperson_id(((tblPersonSession.spsession_id)=[Forms]![frmReportSelection]![cbo_session]) AND ((tblPersonSession.CelebrationDinner)=True))tblPersons.person_id = tblPersonSession.spperson_idtblChurch.Church_id = tblSelectedChurch.Selected_Church_id[tblPersons].[Phone] & " Home " & IIf(IsNull([tblPersons].[Phone2])," ",[tblPersons].[Phone2] & " Work ") & IIf(IsNull([tblPersons].[Phone3])," ",[tblPersons].[Phone3] & " Cell ")tblPersonSession.CelebrationDinner(((tblPersonSession.spsession_id)=[Forms]![frmReportSelection]![cbo_session]))tblPersons.person_id = tblPersonSession.spperson_idtblChurch.Church_id = tblSelectedChurch.Selected_Church_idHour_Codes.Hour_Code = Label_Extract_Hour.Hour_Code(((tblPersonSession.spsession_id)=[Forms]![frmReportSelection]![cbo_session]))tblPersons.person_id = tblPersonSession.spperson_id(((tblPersonSession.spsession_id)=[Forms]![frmReportSelection]![cbo_session]))tblPersons.person_id = tblPersonSession.spperson_idIIf([WK1],1,0)+IIf([WK2],1,0)+IIf([WK3],1,0)+IIf([WK4],1,0)+IIf([WK5],1,0)+IIf([WK6],1,0)+IIf([WK7],1,0)+IIf([WK8],1,0)+IIf([WK9],1,0)+IIf([WK10],1,0)+IIf([Retreat],1,0)tblPersonSession.Attended_Retreat[Attendance_Weekly_Counts].[Retreat][Attendance_Weekly_Counts].[WK10][Attendance_Weekly_Counts].[spsession_id]([__spsession_id] = spsession_id)SELECT [Attendance_Weekly_Counts].[spsession_id], [Attendance_Weekly_Counts].[WK1], [Attendance_Weekly_Counts].[WK2], [Attendance_Weekly_Counts].[WK3], [Attendance_Weekly_Counts].[WK4], [Attendance_Weekly_Counts].[WK5], [Attendance_Weekly_Counts].[WK6], [Attendance_Weekly_Counts].[WK7], [Attendance_Weekly_Counts].[WK8], [Attendance_Weekly_Counts].[WK9], [Attendance_Weekly_Counts].[WK10], [Attendance_Weekly_Counts].[Retreat] FROM [Attendance_Weekly_Counts][qryNamedList_Extract].[Last_Name][qryNamedList_Extract].[person_id][qryNamedList_Extract].[First_Name][qryNamedList_Extract].[Last_Name]8QRu5 p 0 g ' x F  e G  D &  dF(^guW'wC%tV8tV8tV8 *Qm. Con2= aKtblSession%%% K GK K GJExpr1[Role]/ oJtblRoles.Role_id/ gJtblRoles!!! J GJ J GIExpr1[Role]/ oItblRoles.Role_id/ gItblRoles!!! I GI I GH([__person_id] = spperson_id)< 'HqryPersonSessionfrmPerson_and_Session[[1 H  GH__person_id''' OH H GG tblCities.City- 'GtblCities.City- gGtblCities### G G GF qryPersons.FirstName3 'F qryPersons.LastName2 'FExpr1![LastName] & ", " & [FirstName]H oFqryPersons.person_id3 gFqryPersons%%% F F GE([__person_id] = spperson_id)< 'EqryPersonSessionCopy of frmPerson_and_Sessionkk1 E  GE__person_id''' OE E GD tblCities.City- 'DtblCities.City- gDtblCities### D D GC [tblReports].[ReportWords]9 'C[tblReports].[ReportWords]9 gCblReports].[ReportName]8 gCtblReports%%% C C GB dtblSession.DateStarted7 /BtblSession.Session1 gBtblSession.session_id4 gBtblSession%%% B GB B GAExpr1![LastName] & ", " & [FirstName]H oAtblPersons.person_id3 gAtblPersons%%% A GA A G@[tblRoles].[Role]0 g@[tblRoles].[Role_id]3 g@tblRoles!!! @ G@ @ G?[tblRoles].[Role]0 g?[tblRoles].[Role_id]3 g?tblRoles!!! ? G? ? G>Expr1![LastName] & ", " & [FirstName]H o>tblPersons.person_id3 g>tblPersons%%% > G> +'O\ L  K? ^ ZIoFE4eaCAA @^2r@2r@~sq_drptSessionGroups~sq_dCombo32f@4MR2KeepLocal^2r@2r@~sq_drptSessionGroups~sq_dCombo32f@4MR2KeepLocal Tpddddddb `[gfp@;fp@~sq_drptSessionGroups_Details~sq_dCombo30f4MR2KeepLocal Ttttttttr @Zrup@rup@~sq_drptSessionGroups_Details~sq_dCityf4MR2KeepLocal Tnnnnnnnl @X;h@;h@~sq_drptRetreatRegistration~sq_dRole2_idf4MR2KeepLocal Trrrrrrrp @W/;h@/;h@~sq_drptRetreatRegistration~sq_dRole_idf4MR2KeepLocal Tpppppppn @UPi@Pi@~sq_drptReportByRole~sq_dRole2_idf4MR2KeepLocal Tdddddddb @Tε [t@ε [t@~sq_drptGuestAlphabeticalList~sq_dspsession_idf @(4MR2KeepLocal T~~~~~~| `RMjg@Mjg@~sq_drptGroupReportSummary~sq_dspsession_idf4MR2KeepLocal Txxxxxxxv @QgZo@(Zo@~sq_drptGroupReportSummary_Condensed~sq_dspsession_idf4MR2KeepLocal T @PF rt@j'rt@~sq_drptCelebrationDinnerRegistration~sq_dspsession_idf4MR2KeepLocal T @Nj'rt@j'rt@~sq_drptCelebrationDinnerRegistration~sq_dRole_idf4MR2KeepLocal T @Mn@n@~sq_drptAttendance~sq_dspsession_idf4MR2KeepLocal Thhhhhhhf @KewTh@`fwTh@~sq_drptAllParticipants~sq_dspsession_idf @:4MR2KeepLocal T~rrrrrrp `J`fwTh@`fwTh@~sq_drptAllParticipants~sq_dRole2_idf}@<4MR2KeepLocal Tvjjjjjjh `)[H[uh@[uh@~sq_dfrmPerson_and_Session~sq_dfrmPersonSessionf4MR2KeepLocal T~ @G#uh@#uh@~sq_dfrmPerson_and_Session~sq_dCityf4MR2KeepLocal Thhhhhhhf @F[uh@#uh@~sq_dfrmPerson_and_Session~sq_dcboFindf4MR2KeepLocal Tnnnnnnnl @DdOƑuh@dOƑuh@~sq_dCopy of frmPerson_and_Session~sq_dCityf4MR2KeepLocal Txxxxxxxv @U=e; n 0 d ( d ( `   a C  N0Cs2tV$aC%aC%VNX GX X GWExpr1[Role]/ oWtblRoles.Role_id/ gWtblRoles!!! W GW W GV dtblSession.DateStarted7 /VtblSession.Session1 gVtblSession.session_id4 gVtblSession%%% V GV V GUExpr1[Role]/ oUtblRoles.Role_id/ gUtblRoles!!! U GU U GT dtblSession.DateStarted7 /TtblSession.Session1 gTtblSession.session_id4 gTtblSession%%% T GT T GS dtblSession.DateStarted7 /StblSession.Session1 gStblSession.session_id4 gStblSession%%% S GS S GR dtblSession.DateStarted7 /RtblSession.Session1 gRtblSession.session_id4 gRtblSession%%% R GR R GQ dtblSession.DateStarted7 /QtblSession.Session1 gQtblSession.session_id4 gQtblSession%%% Q GQ Q GP dtblSession.DateStarted7 /PtblSession.Session1 gPtblSession.session_id4 gPtblSession%%% P GP P GOExpr1[Role]/ oOtblRoles.Role_id/ gOtblRoles!!! O GO O GNExpr1[Role]/ oNtblRoles.Role_id/ gNtblRoles!!! N GN N GM psedtblSession.DateStarted7 /MsetblSession.Session1 gMsetblSession.session_id4 gMpsetblSession%%% Mse GMpse Mse GLB@ 'LrptAttendance@7+ 7L  GL__spsession_id--- OL L GK dtblSession.DateStarted7 /KtblSession.Session1 gKtblSession.session_id4 g @ @ @ @ @ @ @ @ @ @ @ @ @ @33333333 34 4 4 4 44444444 4 4 55555 5 566 6!6 "67#7%7&7'7(7$8)8+8,8 -8*9.909192939/:4:6:7:8:9: ::5;;;=;>;?;@;<<A<C<D<E<F<B=G=I=J=K=L= M=H>N>>>>>???? ? ?@ @ @@@@ AAAAAABBBBBB BCC C!C"C #CD$D&D'D (D%E)E+E,E-E.E*F/F1F2F3F 4F 5F0G6G8G9G :G7H;H=H>H?H@HH?H@HT9U?UAUBUCUDU@VEVGVHVIVJV KVFWLWNWOWPWQWMXRXTXXXXSYYYYYY  YZ Z Z Z Z [[[[[[ [\\\\\\ \]]] ]!]"] #]^$^&^'^(^)^ *^%_+_-_._/_0_,`1`3`4`5`6`2a7a9a:a;acDcFcGcHcE@ @@@ @@  @ Si`+MWoiMWYbSdi`JmYdbSi`LoY^ObJ`QO^YkmSi`QOYmid^QkSi`UQbQiYM+iQfdim+fiQfJiJmYdbSi``JYb`QboSi`fQikdb+JbO+kQkkYdbSi`fQikdbkSi`fQikdbkQkkYdbSi`fQikdbkQkkYdb+koLSi`iQfdimkQ^QMmYdbSi`kQkkYdbSi`omY^YmvxSi`fQikdb+JbO+kQkkYdb+diUMdfvdSSi`fQikdb+JbO+kQkkYdbifmJLdomifmJOOiQkk^JLQ^k ifmJ^^fJimYMYfJbmk!ifmJmmQbOJbMQ"ifmJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim#ifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb$ifmQ`JY^JOOiQkkQk%ifmUQbQiYM+kQJiMW+db+Md``Qbmk&ifmUQbQiYM+kQJiMW+db+Md``Qbmk+L\8'ifmUQbQiYM+kQJiMW+db+Md``Qbmk+diU(ifmUidofiQfdimko``Jiv)ifmUidofiQfdimko``Jiv+MdbOQbkQOifmUoQkmJUQ^YkmifmUoQkmJ^fWJLQmYMJ^^Ykmifm`JYb`QboWQ^fifmbJ`QmJUk:u<8:YbMWQkifmbJ`QmJUkYbMWifmiQfdimLvid^QifmiQmiQJmiQUYkmiJmYdbifmkQkkYdbUidofkifmkQkkYdbUidofk+OQmJY^k ifmkQkkYdb^QJOQik ifmomY^Ymv omY^Ymv: JomdQuQML Qufdim+JOOiQkk+Ldd\+Sdi+dom^dd\Y`fdim+mJL^Qk+Sid`+QuYkmYbU+OLJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`LoY^ObJ`QO^Ykm+kh+MMd`Ld8+kh+MSi`LoY^ObJ`QO^Ykm+kh+MbJ`QO+^Ykm+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MMLdSYbO+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MMYmv+kh+MSi`fQikdb+JbO+kQkkYdb+kh+MSi`fQikdbkQkkYdb+kh+MSi`fQikdbk+kh+MMYmv+kh+MSi`fQikdbk+kh+MMd`Ld<>+kh+MSi`fQikdbkQkkYdb+koL+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+koL+kh+MkfkQkkYdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+kh+MkffQikdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MkfkQkkYdb+YO +kh+MSi`iQfdimkQ^QMmYdb+kh+MMLdiQfdimk!+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMLdSYbO+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q+YO+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q:+YO+kh+OifmJ^^fJimYMYfJbmk+kh+OkfkQkkYdb+YO+kh+OifmJmmQbOJbMQ+kh+OJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim+kh+OifmJmmQbOJbMQ+kh+OkfkQkkYdb+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q:+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+MdbOQbkQO+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJUQ^Ykm+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJ^fWJLQmYMJ^^Ykm+kh+OkfkQkkYdb+YO`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOokQiOQSYbQO B@@  @@@+kh+MSi`fQikdbk+kh+MMd`Ld<>+kh+MSi`fQikdbkQkkYdb+koL+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+koL+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+koL+kh+MkfkQkkYdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MiQ^JmYdbkWYfYO+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q+kh+MSi`fQikdbkQkkYdb+kh+Mid^Q:+kh+MSi`fQikdbkQkkYdb+kh+MkffQikdb+YO+kh+MSi`fQikdbkQkkYdb+kh+MkfkQkkYdb+YO +kh+MSi`iQfdimkQ^QMmYdb+kh+MMLdiQfdimk!+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OMdfvdSSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMLdSYbO+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OMYmv+kh+OSi`fQikdb+JbO+kQkkYdb+kh+OSi`fQikdbkQkkYdb+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q+YO+kh+OifmJ^^fJimYMYfJbmk+kh+Oid^Q:+YO+kh+OifmJ^^fJimYMYfJbmk+kh+OkfkQkkYdb+YO+kh+OifmJmmQbOJbMQ+kh+OJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim+kh+OifmJmmQbOJbMQ+kh+OkfkQkkYdb+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+Oid^Q:+YO +kh+OifmMQ^QLiJmYdbOYbbQiiQUYkmiJmYdb+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+MdbOQbkQO+kh+OkfkQkkYdb+YO +kh+OifmUidofiQfdimko``Jiv+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJUQ^Ykm+kh+OkfkQkkYdb+YO+kh+OifmUoQkmJ^fWJLQmYMJ^^Ykm+kh+OkfkQkkYdb+YO+kh+OifmiQfdimLvid^Q+kh+Oid^Q:+YO+kh+OifmiQfdimLvid^Q+kh+OkfkQkkYdb+YO+kh+OifmiQmiQJmiQUYkmiJmYdb+kh+Oid^Q+YO+kh+OifmiQmiQJmiQUYkmiJmYdb+kh+Oid^Q:+YO+kh+OifmiQmiQJmiQUYkmiJmYdb+kh+OkfkQkkYdb+YO+kh+OifmkQkkYdbUidofk+OQmJY^k+kh+OMYmv+kh+OifmkQkkYdbUidofk+OQmJY^k+kh+OMd`Ld<6+kh+OifmkQkkYdbUidofk+OQmJY^k+kh+OMd`Ld<:+kh+OifmkQkkYdbUidofk+kh+OMd`Ld<6+kh+OifmkQkkYdbUidofk+kh+OMd`Ld<:+kh+OifmkQkkYdbUidofk+kh+Oid^Q+YO+kh+OifmkQkkYdbUidofk+kh+Oid^Q:+YO+kh+OifmkQkkYdbUidofk+kh+OkffQikdb+YO+kh+OifmkQkkYdb^QJOQik+kh+OMd`Ld:8+kh+OifmkQkkYdb^QJOQik+kh+Oid^Q+YO+kh+OifmkQkkYdb^QJOQik+kh+Oid^Q:+YO+kh+OifmkQkkYdb^QJOQik+kh+OkfkQkkYdb+YO+kh+OifmomY^Ymv+kh+OMYmv+kh+OifmomY^Ymv+kh+OiQ^JmYdbkWYfYO+kh+OifmomY^Ymv+kh+OkfkQkkYdb+YO +kh+OomY^Ymv:+kh+OMYmv +kh+OomY^Ymv:+kh+OiQ^JmYdbkWYfYO +kh+OomY^Ymv:+kh+OkfkQkkYdb+YO +kh+SSi`+MWoiMWYbSdi`JmYdb +kh+SSi`iQfdimkQ^QMmYdb+kh+iifmJLdom+kh+iifmJmmQbOJbMQ+sQQ\^v+MdobmkkoLiQfdim+kh+iifmUQbQiYM+kQJiMW+db+Md``Qbmk+kh+iifmUidofiQfdimko``Jiv+MdbOQbkQO+kh+iifm`JYb`QboWQ^fJmmQbOJbMQYbfomkJmmQbOJbMQ+sQQ\^v+Mdobmk`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkbJ`QO+^Ykm+WQJOQi+QufdimfJkmQQiidikhivJ^^fJimYMYfJbmkhivJffQbO+Y`fdimQO+MWoiMWhivJffQbO+Y`fdimQO+MYmYQkhivJffQbO+Y`fdimQO+fQikdbkhivJffQbO+Y`fdimQO+fQikdbkQkkYdbJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOch_Co=TZ<O  e + ^ P  o Q 3  >  q3g+g+c#tBaC%aC%aC%Y  Y  YetblSession%%% e Ge e GdExpr1[Role]/ odtblRoles.Role_id/ gdtblRoles!!! d Gd d GcExpr1[Role]/ octblRoles.Role_id/ gctblRoles!!! c Gc c Gb dtblSession.DateStarted7 /btblSession.Session1 gbtblSession.session_id4 gbtblSession%%% b Gb b GaExpr1![LastName] & ", " & [FirstName]H oatblPersons.person_id3 gatblPersons%%% a Ga a G`Expr1[Role]/ o`tblRoles.Role_id/ g`tblRoles!!! ` G` ` G_Expr1[Role]/ o_tblRoles.Role_id/ g_tblRoles!!! _ G_ _ G^ dtblSession.DateStarted7 /^tblSession.Session1 g^tblSession.session_id4 g^tblSession%%% ^ G^ ^ G] dtblSession.DateStarted7 /]tblSession.Session1 g]tblSession.session_id4 g]tblSession%%% ] G] ] G\ dtblSession.DateStarted7 /\tblSession.Session1 g\tblSession.session_id4 g\tblSession%%% \ G\ \ G[ dtblSession.DateStarted7 /[tblSession.Session1 g[tblSession.session_id4 g[tblSession%%% [ G[ [ GZ tblCities.City- 'ZtblCities.City- gZtblCities### Z Z GY dtblSession.DateStarted7 /YtblSession.Session1 gYtblSession.session_id4 gYtblSession%%% Y GY Y GXExpr1[Role]/ oXtblRoles.Role_id/ gXtblRoles!!! #O-)OZ MM L N JK I? lhHFo F,C}[~~ʔXk@4Yk@qryExtEAf&@@J>>22222220 @}O:h@B$~rt@qryCelebrat~ʔXk@4Yk@qryExtEAf&@@J>>22222220 @}O:h@B$~rt@qryCelebrationDinnerRegistrationf]@@znnbbbbbbb` @|Pu@u@@qryAppend_Imported_Sessionf@|@nbbVVVVVVVT @{U\u@x\u@@qryAppend_Imported_Rolesf@|@j^^RRRRRRRP @yq7u@u;u@@qryAppend_Imported_Personsf8@|@nbbVVVVVVVT @x" u@nu@@qryAppend_Imported_Citiesf@ |@l``TTTTTTTR @wE.u@E.u@@qryAppend_Imported_Churchf@ |@l``TTTTTTTR @vf;K:h@pr:h@qryAllParticipantsfT%7@@j^^RFFFFFFD `>u@u@Paste Errorsf::::::::::8 u8gb@:ob@@Named_List_Header_Exportf@@j^^RRRRRRRP @[63v@?\63v@MSysAccessObjectsfDDDDDDDDDDB tYn@=n@Attendance_Weekly_Countsf @@j^^RRRRRRRP @rH`@r`@~sq_rrptMainMenuHelpf4MR2KeepLocal TJJJJJJJH @qo@o@CCo@~sq_rrptGroupReportSummary_Condensedf4MR2KeepLocal Tjjjjjjjh @on@{n@~sq_rrptAttendance_Weekly_Counts subreportf4MR2KeepLocal Tvvvvvvvt @nN i@~ i@~sq_rrptAboutf4MR2KeepLocal T|||<<<<<<<: @ l(T Sh@(T Sh@~sq_ffrm_ChurchInformationf4MR2KeepLocal TVVVVVVVT @ko1v@o1v@~sq_dUtility2~sq_dspsession_idf4MR2KeepLocal T^^^^^^^\ @ io1v@o1v@~sq_dUtility2~sq_dCityf4MR2KeepLocal TNNNNNNNL @h^x8,1v@^x8,1v@~sq_drptUtility~sq_dspsession_idf@4MR2KeepLocal Tnbbbbbb` ` f;:8,1v@;:8,1v@~sq_drptUtility~sq_dCityf@4MR2KeepLocal T^RRRRRRP `c) wt@) wt@~sq_drptSessionLeaders~sq_dRole_idfz@D4MR2KeepLocal Trffffffd `bMW wt@MW wt@~sq_drptSessionLeaders~sq_dCombo21f@F4MR2KeepLocal Trffffffd ` `xr@xr@~sq_drptSessionGroups~sq_dRole2_idfz@4MR2KeepLocal Trffffffd ` @ @ @ @ @ @ @ @ @ @ @ @ @ @S5S6S 7S2T8T:T;TT9U?UAUBUCUDU@VEVGVHVIVJV KVFWLWNWOWPWQWMXRXTXXXXSYYYYYY  YZ Z Z Z Z [[[[[[ [\\\\\\ \]]] ]!]"] #]^$^&^'^(^)^ *^%_+_-_._/_0_,`1`3`4`5`6`2a7a9a:a;acDcFcGcHcIcEdJdLdMdNdOdKePeReSeee eQffff fgg g g g g hhhhhh hiiii ijjjjjjk k"k#k$k%k &k!l'l)l*l(m+m-m.m,n/n1n2n0o3o5o6o7o8o9o:o;oo ?o @o Ao4pBpDpEpCqFqHqIqGrJrLrMrKsNsPsQsRssssssssss  s  s  sO  S=]?! <  o 1 G A `  aCmO1yOk;yO1iKiK-YstblPersons%%% s Gs Gs s GrtblHelp r  Gr r GqtblGroupReportSummary_condensedOOO q  Gq q Gpn_itblGeneric_Search_ResultsCCC p _i Gpn_i p_i Go H@ go B@ go "[Attendance_Weekly_Counts].[WK9]? go "[Attendance_Weekly_Counts].[WK8]? go"[Attendance_Weekly_Counts].[WK7]? go"[Attendance_Weekly_Counts].[WK6]? go"[Attendance_Weekly_Counts].[WK5]? go"[Attendance_Weekly_Counts].[WK4]? go"[Attendance_Weekly_Counts].[WK3]? go"[Attendance_Weekly_Counts].[WK2]? go"[Attendance_Weekly_Counts].[WK1]? goR@ goAttendance_Weekly_CountsAAA o o GntblAbout!!! n  Gn n GmtblFlags!!! m  Gm m GltblChurch### l  Gl l Gk dtblSession.DateStarted7 /ktblSession.Session1 gktblSession.session_id4 gktblSession%%% k Gk k GjExpr1![LastName] & ", " & [FirstName]H ojtblPersons.person_id3 gjtblPersons%%% j Gj j Gi tblCities.City- 'itblCities.City- gitblCities### i i Gh dtblSession.DateStarted7 /htblSession.Session1 ghtblSession.session_id4 ghtblSession%%% h Gh h GgExpr1![LastName] & ", " & [FirstName]H ogtblPersons.person_id3 ggtblPersons%%% g Gg g Gf tblCities.City- 'ftblCities.City- gftblCities### f f Ge dtblSession.DateStarted7 /etblSession.Session1 getblSession.session_id4 g4=y9\  o 3 u  r T 6  } / E[ nmC%?{4T6l<Y  Y vtblChurch.ChurchName3 gv tblSelectedChurch333 v tblChurch### v tblPersons%%% v tblPersonSession111 v Gv Gv  v GuHour_CodesLabel_Extract_Hourf@UI% uZIPZIP" ". uStateState" "6% uCityCity " " & Now():! uStreetStreet[Specify Title]F) uAddressee_NameAddressee_Name"Named List "dI- uLabel_Extract_Hour555 uHour_Codes%%% u GuLabel_Export))) Ou u Gt @ 't tblPersonSession.spsession_id< gttblPersonstblPersonSessionf@ QE% t Retreat"Sum(IIf([Attended_Retreat],1,0))M ot WK10Sum(IIf([Attended_Wk10],1,0))D ot WK9Sum(IIf([Attended_Wk9],1,0))A ot WK8Sum(IIf([Attended_Wk8],1,0))A otWK7Sum(IIf([Attended_Wk7],1,0))A otWK6Sum(IIf([Attended_Wk6],1,0))A otWK5Sum(IIf([Attended_Wk5],1,0))A otWK4Sum(IIf([Attended_Wk4],1,0))A otWK3Sum(IIf([Attended_Wk3],1,0))A otWK2Sum(IIf([Attended_Wk2],1,0))A otWK1Sum(IIf([Attended_Wk1],1,0))A ottblPersonSession.spsession_id< gttblPersonSession111 ttblPersons%%% t Gt Gt t Gs tblPersons.LastName2 's@  'stblPersonstblPersonSessionf@ QE% sCountR@ ' osRetreatB@ + os WK10 tblPersonSession.Attended_Wk10E os WK9tblPersonSession.Attended_Wk9B os WK8tblPersonSession.Attended_Wk8B os WK7tblPersonSession.Attended_Wk7B os WK6tblPersonSession.Attended_Wk6B osWK5tblPersonSession.Attended_Wk5B osWK4tblPersonSession.Attended_Wk4B osWK3tblPersonSession.Attended_Wk3B osWK2tblPersonSession.Attended_Wk2B osWK1tblPersonSession.Attended_Wk1B ostblPersons.LastName2 gstblPersons.FirstName3 gstblPersonSession.spsession_id< gstblPersonSession111 C @ @ @ @ @ @ @ @ @ @ @ @ @ @cEdJdLdMdNdOdKePeReSeee eQffff fgg g g g g hhhhhh hiiii ijjjjjjk k"k#k$k%k &k!l'l)l*l(m+m-m.m,n/n1n2n0o3o5o6o7o8o9o:o;oo ?o @o Ao4pBpDpEpCqFqHqIqGrJrLrMrKsNsPsQsRssssssssss  s  s  s  s  sssss sOttttttttttttt t !t "t #t $t%t &t 'tu(u*u+u,u-u.u/u0u1u2u3u)v4v6v7v8v9v:v;vo ?o @o Ao4pBpDpEpCqFqHqIqGrJrLrMrKsNsPsQsRssssssssss  s  s  s  s  sssss sOttttttttttttt t !t "t #t $t%t &t@ P I vvv @ T (@XI )@ \ )@ ` A)Q@dAYa)WWW_0   xD<'8%'H%'X%:h %x$ `x `xlusDD$  x0   0   xK3)'h%x$ `x ,x<''$'Dd x?K[@@P(0SysAccessObjectsbLLLLLLLLLLJ K[r-ࡱ> ,13lJ.Root Entryuc.H@(VBA  j |HVBAProject/-  j |HVBA  j |H YZ  h&)ajc\b!#% 06@:;<=>? WCDEFGHIJLMNOPQRSTUVX|]wj f h nrupqxst^v% y{|}~Root EntryuK @(VBA  jKVBAProject/-  jKVBA  jK YaZ  &)c!#%j b$578gwj fh nrupqxst^v% y{|}~7/j;DBlob 1PropDataDTypeInfoEWBlobDelta2ŜjDBlob  PropData16+jIHBlob  PropDataTypeInfoK[Lß50Ÿ?ZNWIPBLJYLPSTDLQNNFGIXJUZEKH:[PROJECT.oPROJECTwmAcessVBADataTypeInfoBlobDeltaO3|ŜjfjBlob PBlob ? PropData TypeInfo6/jUDBlobDeltaKg8jPO9Blob  PropDataMTrim( [ChurchName])I75 m;`abik Text3(= Trim( [FirstName])J75 m;`abik Text4&= Trim( [LastName])K75 m;` a4barted DESC;";"tblSessͬchDϽϘDetailmText2mText3mText4mText5fLine6dLabel5SourceChurchName Title FirstName LastName Address CityStateZipGroupNamedListEnableddLabel8e_idIĥ6d m`<a<bhc,dmmmmmfddIĥ6d m`8bmeLastNameIĥ6d mͬ?E(ReportHeaderdLabel10PageHeaderSectiondLastName_LabeldBlob PropDatatTypeInfou12j \dD*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ? 8K[EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d28 Arialm5cij ArialLastName`@ Detail@75 m;`ab cXi Text2*= @Import_Tables_From_Existing_DBAutoexecbBExport_Address_Book_for_Outlookf,h`n\HiOBa R 0CB0 2CB0 1CB0lationshipTypeij""Spouse";"Friend"14MSysDb,RelationshipTypnocijk Text5 GroupL75 f2`HaHb Line6M75 d8`abcXde L;`ab k Text4^= Trim( [City] & "," & [State] & " " & [Zip])߃L<" 64;2160;2160;1008;576;576;;1440d5U`abTcLabel1ͬڃL<" DetailSourceChurchNameTitleFirstNameLastNameAddressCityState Zip Group NamedListEnabledm Text2m 13jp?@ABCDSuTVWXYZ[\]^`abcdefgiklmnqrstvwxyz{~PropDataTypeInfo23Dc.HBlob &essionForm_frmUtilityForm_frmUtilityReport_rptEmailAddressesReport_rptEmailAddressesReport_rptGroupReportSummaryReport_rptGroupReportSummaryReport_rptGroupReportSummary_CondensedReport_rptGroupReportSummary_CondensedReport_rptNameTags(3x4inch)Report_rptNameTags(3x4inch)Report_rptAddressLabelspecify which Named List to use NAMED LIST$      !"#$%&()*+,-./0123456789;<=>@ABCDEFGHJKLMOPQRSTUVYZ_`abdeghijklmnopqrsuvwxyz{|}~Blob PropData*TypeInfo+BlobDelta/gq   ,!"#$%&'()*-dKLMNOPQRSTUVWXYZ[\]`abcehfgikjlmorstu|}Blob K[1N  Y PropDataTypeInfoBlobDelta d8"`pa bcd Label7 Group~KH?Ul7 Group~KH?U  ͬ Iĥ6d DetailChurchNameFirstNameLastNamemText2mText3mText4dLabel5f Line6m Groupd Label7 H'WINSPOOLCanon BJC-5dmm                     ! " & ' ( ) * + - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y | } ~  mmdfmd7jghm5<CT08h:<=Babce g hi8j|k ""[Event Procedure]Gb@$qryNameTag_Extract Arial888@ EPSON Stylus C82 Seriespv odhhRLReportFootermMsgdLabel3m Text4m Text5 08:<=Babce ghitj7k\""[Event Procedure]m=b@$qryNameTag_Extract Arial8EPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d28 Arialm5cij ArialLastName` DetacilIĥ6d m;`+a,b i Text2*= Trim( [ChurchName])Iĥ6d m;`ab@c i k Text3$=Trim([FirstName])Iĥ6d m;`a` b@cXik Text4"=Trim([LastName])Iĥ6d d8`abcXde Label5Alpha atTimes New RomanIĥ6d f2`ab@ Line6Iĥ6d m;` a bik Group GroupIK[v1|@|@|@N]]Yĥ6dBlob PropDatakTypeInfol 11jj     f !"#$%&'()*+,-./0123456789:<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdfghijklmnopqrstuvwxyz{|}~ "  xoh`Attribute VB_Name = "Report_rptMainMenuH@elp" Bas0{62F18A9D-255A-11D7-96EF-043@B0BC1F} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT P&* Sub Activ D()End x    ID="{8BE2A588-2009-11D7-96EF-44410BC10000}" DocClass=Form_frmSePropData TypeInfoBlobDelta15`j+j     0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTYW(}]^pgcdefhoiklmnpq~stuvwxyz{|}essionForm_frmUtilityForm_frmUtilityReport_rptEmailAddressesReport_rptEmailAddressesReport_rptGroupReportSummaryReport_rptGroupReportSummaryReport_rptGroupReportSummary_CondensedReport_rptGroupReportSummary_CondensedReport_rptNameTags(3x4inch)Report_rptNameTags(3x4inch)Report_rptAddressLabelspecify which Named List to use NAMED LIST$+A/I_4      !"#$%&()*+,-./0123456789;<=>@ABCDEFGHJKLMOPQRSTUVYZ_`abdK[e+   -,!"#$%&'()*.-/0123456789:;<=>?@ACDEFG^dKLMNOPQRSTUVWXYZ[\]n`abcehfgikjlmopvwxyz{~ssion/&H00000000 DocClass=Form_frmPersons/&H00000000 DocClass=Form_frmMainMenu/&H00000000 DocClass=Form_frmReportSelection/&H00000000 DocClass=Form_frmPersonSession/&H00000000 DocClass=Report_rptMainMenuHelp/&H00000000 DocClass=Form_frmGeneric_Report_Preparation/&H00000000 DocClass=Form_frmPerson_and_Session/&H00000000 DocClass=Form_zfrmPerson_and_Session_org/&H00000000 DocClass=Form_frm_ChurchInformation/&H00000000 DocClass=Form_frmBuildNamedList/&H00000000 DocClass=Form_frmPersonSession_sub/&H0[V U "  xoh`Attribute VB_Name = "Report_rptMainMenuH@elp" Bas0{62F18A9D-255A-11D7-96EF-043@B0BC1F} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT P&* Sub Activ D()End x    ID="{8BE2A588-2009-11D7-96EF-44410BC10000}" DocClass=Form_frmSe!"#$%B'()*+,-.XYW2Z_}]^p`gcdefhoiklmnpq~stuvwxyz{|}ssion/&H00000000 DocClass=Form_frmPersons/&H00000000 DocClass=Form_frmMainMenu/&H00000000 DocClass=Form_frmReportSelection/&H00000000 DocClass=Form_frmPersonSession/&H00000000 DocClass=Report_rptMainMenuHelp/&H00000000 DocClass=Form_frmGeneric_Report_Preparation/&H00000000 DocClass=Form_fK[rmPerson_and_Session/&H00000000 DocClass=Form_zfrmPerson_and_Session_org/&H00000000 DocClass=Form_frm_ChurchInformation/&H00000000 DocClass=Form_frmBuildNamedList/&H00000000 DocClass=Form_frmPersonSession_sub/&H00000000 DocClass=Report_Copy of frmPerson_and_Session/&H00000000 DocClass=Form_frmUtility/&H00000000 DocClass=Report_rptEmailAddresses/&H00000000 DocClass=Report_rptGroupReportSummary/&H00000000 DocClass=Report_rptGroupReportSummary_Condensed/&H00000000 DocClass=Report_rptNameTags(3x4inch)/&H00000000 DocClass=Report_rptAddressLabels/&H00000000 DocClass=Report_rptNameTags(2x3 1/2 inches)/&H00000000 Name="template" HelpContextID="0" VersionCompatible32="393222000" CMG="7270EABB99BF99BF99BF99BF" D0000000 DocClass=Report_Copy of frmPerson_and_Session/&H00000000 DocClass=Form_frmUtility/&H00000000 DocClass=Report_rptEmailAddresses/&H00000000 DocClass=Report_rptGroupReportSummary/&H00000000 DocClass=Report_rptGroupReportSummary_Condensed/&H00000000 DocClass=Report_rptNameTags(3x4inch)/&H00000000 DocClass=Report_rptAddressLabels/&H00000000 DocClass=Report_rptNameTags(2x3 1/2 inches)/&H00000000 Name="template" HelpContextID="0" VersionCompatible32="393222000" CMG="282AB0C6B4C6B4C6B4C6B4" DPB="5052C8EBC9EBC9EB" GC="787AE013E113E1EC" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmSession=22, 22, 469, 259, C Form_frmPersons=123, 244, 935, 856, Form_frmMainMenu=44, 44, 491, 281, Form_frmReportSelection=44, 44, 491, 281, Form_frmPersonSession=44, 44, 491, 281, C Report_rptMainMenuHelp=88, 88, 535, 325, C Form_frmGeneric_Report_Preparation=88, 88, 535, 325, Form_frmPerson_and_Session=0, 0, 447, 237, Form_zfrmPerson_and_v@<GqG @@?1 rrr8$$  <Xvvv @ D xxxI@ H  zzz@ L ) |||I@ P A ~~~@ T i @ X  @ \  @ `   @ d 9  @:hY  I WWW0   0 @  l83(8%(H@%(X%(h%x$ `x \xD8$  xKmp$ `p XpCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  j, tx$,p 0 P  0   K{ Cx)'`%p$ `p ,p@'0%K[ @ @ @ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  x, tx$,p 0   0   0 h  KRCx@'0%ltF@%'P%lxF`%p$ `p `p<''' , pp ,>,F p6  O, tx$,p 0 0  0   dhh<@DH` L P T Xws and Settings\All users\DocurU L$`n (`0&$` $` $A` $` $`$` $A ` $ `PB="2527BD0CC3BEC4BEC4BE" GC="D8DA40734173418C" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmSession=22, 22, 469, 259, C Form_frmPersons=123, 244, 935, 856, Form_frmMainMenu=44, 44, 491, 281, Form_frmReportSelection=44, 44, 491, 281, Form_frmPersonSession=44, 44, 491, 281, C Report_rptMainMenuHelp=88, 88, 535, 325, C Form_frmGeneric_Report_Preparation=88, 88, 535, 325, Form_frmPerson_and_Session=0, 0, 447, 237, Form_zfrmPersoBlobCopyBlobDeltaCopyTypeInfoCopyrU .zy0 ||y}O}1~q)i~Y1# pipqqrr1IiIas!%ssI titt)uuvv9wy x\ X$X[yMyg@:4Y  @8 a1 ppp@ < MvvvI@ @ aMrrr @DI Mttt@ H  zxxxWK\ $ l\=l\CxCt2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L  K[L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,:! `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,:" `1t6L, 2ltF< L L,:# `1t6L, 2ltF< L L,:$ `1t6L, .' ','LtM<@^i6L, (<]4U+'' ',:<%NLL 6L, @'l'''' :&N,,:<'NLL (1p6L, l lp]=)Ch-\'%'%<%lhl l\=*`\K; ` *K l`hfh 4*kf) ` * ` *ch+Cd-\'%'%<%ldl l\=*`\Kg ` *K l``f` 4*kf ` * ` *c`>'%'%c%lpF%:<,%\ $ `\ -\<'' ',\ \\ , >\FL \6L,  $X \\  lX \e 1$X \\  lX \ $L 4 h`tdlx`hp0 \\L, l0 @  0 d  @<HHP:T %t Lt $ QPod@ @ %x t6d@ xWd % 5d l( x tPd@ 0 X  0   0 0  0 p  0   l83(8%(H%(X,%(h,%x$ `x \xD8$  xD:l%! L$  0   0   T x$ `x Tx $  x0   8T$  0 (  `X4444 4 4  < omeTag_Extract4dKqҗ&EK" Jc:\My Documents\Alpha_AddressBook.txt Zc:\My Documents\Alpha_AddressBook_Outlook.xls pin the directory frorU T$`$ $A`( $`, nsI titt)uuvv9wy x\ X#$X[q)O TV9WfZYZ ])[!^]^^kjIiiiii]I#ik lc hAjyllimcWMWg@:4Y  @8 a1 ppp@ < K[v1aMrrr @@I Mttt@ D MvvvIWK\$ Q\lCxCt2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, 2ltF< L L,: `1t6L, .' ','LtM<@^i6L, (<]4O+'' ',:<NLL 6L, @'l'''' :N,,:<NLL 1p6L, l lp]=Ch'\'%'%<%lhl Q\`K) ` K l`hfh 4kf `  ` ch Cd'\'%'%<%ldl Q\`KU ` K l``f` 4kf `  ` qc`>'%'%c%lpF%:\FL \6L,  $X #\\ $lX \S %$X #\\ $lX \ $L 4 h`tdlx`hp0 \\L, lT Kj P$ QPpy @   '`':%N:0&@ :':(^i@P6@ `P(0]AH'''':)N:*N  :0+N@@ 1T6@ lT]=*''' ,lT*F@ 6@ 0P$ `P "PF'p%'%:-%:!%lTF%:0.%P$ `P "PF'p%'%:/%:0%lTF%:0.%P$ `P "PF'p%'%:1%:2%lTF%:0.%P$ `P "PF'p%'%:3%:4%lTF%:0.%P$ `P "PF'p%'%:5%:6%lTF%:0.%P$ `P "PF'p%'%:7%:8%lTF%:0.%P$ `P "PCl'P'%'%0%llp QPXK) X K lX,*, 4k*l X  X ?c, Ch'P'%'%0%lhp QPXKU X K lX$*$ 4k* X  X c$9Cd'P'%'%0%ldp QPXK X K lX * 4k*n X  X Ac :Cd'P'%'%0%ldp QPXK X K lX* 4k* X  X c;Cd'P'%'%0%ldp QPXK X K lX* 4k*p X  X Cc<Cd'P'%'%0%ldp QPXK> X K lX* 4k* X  X cK+:0=%P$ `P d"P+:0>%P$ `P d"P+:0?%P$ `P d"P+:0@%P$ `P d"P+:0A%P$ `P d"P+:0B%P$ `P d"P&:0-%P$ `P "P&:0/%P$ `P "P&:01%P$ `P "P&:03%P$ K[ `P "P&:05%P$ `P "P&:07%P$ `P "P<'''  #PP ,$>F@ P6@  $ #PP $l PS t$ #PP $l P $ #PP $l P 3''' :0CN@@^iP6@  $ #PP $l P  $ #PP $l P<  $ #PP $l Ph  <'''  #PP ,$>F@ P6@  p l T,$ 0hdT`pP\xXlt8 P@ `<DP_rptAddressLabels2k!B:o>-c:c3Hd1ֳJSڃL<" N:D`[]O| Report_Error7jmC yM*."u^gH%"e Report_NoData We have no data. FNo Matching Reports for this Report "Cancelling Report_/{ܲDح=d2'#/C=^ӟwjVdDnCHn_and_Session_org=0, 0, 0, 0, C Form_frm_ChurchInformation=44, 44, 491, 281, C Form_frmBuildNamedList=66, 66, 513, 303, C Form_frmPersonSession_sub=22, 22, 413, 278, Report_Copy of frmPerson_and_Session=0, 0, 0, 0, C Form_frmUtility=66, 66, 457, 336, Report_rptEmailAddresses=110, 110, 796, 374, Report_rptGroupReportSummary=44, 44, 435, 300, C Report_rptGroupReportSummary_Condensed=51, 4, 442, 260, Report_rptNameTags(3x4inch)=54, 70, 901, 613, Report_rptAddressLabels=81, 105, 928, 648, Report_rptNameTags(2x3 1/2 inches)=108, 140, 955, 683, Z 683, Z , Form_frmSessionForm_frmSessionForm_frmPersonsForm_frmPersonsForm_frmMainMenuForm_frmMainMenuForm_frmReportSelectionForm_frmReportSelectionForm_frmPersonSessionForm_frmPersonSessionReport_rptMainMenuHelpReport_rptMainMenuHelpForm_frmGeneric_Report_PreparationForm_frmGeneric_Report_PreparaBlobDelta17+j+jBlob  PropData"      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~__SRP_166__SRP_17p__SRP_18 ]BlobDeltaW     !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGH K[r-IJKLMNOPQRSUVWXYZ[\^_`abcdefghijklmnopqrstuvwxyz{|}~eries@'WINSPOOLCanͬJQkD1 PageHeaderSectiondLabel3dLabel4dLabel5fLine6DetailmEmailmFirstNamemLastName PageFooterSectionm Text8d Label13d dmdddfdddmmm08:<=Babc)e ghij+kbܜR`  0 8  0 x  0   dd4t<<Ph l X, @` L P T X hp m xt86=Format(Date(),"Long Date") _  \ j[obdon LabelfLine39#FormFooterfwl n,"";"deghijkmnopz{mdmmmmmmmdmdmdmdmdmdmdopdfTINCTROW tblRole08:<=Babe ghij2k!g0v@*qryName_Extract_Email"[Event ProTypeInfo-<19@Sj@SjBlob PropData:_TwoSearch Condition Twom Last_Namem First_NamemPhonemCommentsPageFooterSectionmText9mText10fLine12Repo K[v1rtFooter<Mb: l;Ȥ: erФ: m ud278d eTimes Nͬ)2" ReportHeaderdLabel30ospsession_iddLabel37PageHeaderSectiondLastName_LabeldFirstName_LabeldWK1_LabeldWK2_Labeld WK3_Labeld WK4_Labeld WK5_Labeld WK6_Labeld WK7_LabeldWK8_LabeldWK9_LabeldWK10_LabeldRetreat_LabeldCount_LabelfLine33DetailmLastNamemFirstNamejWK1jWK2jWK3jWK4jWK5jWK6jWK7jWK8jWK9j WK10j!Retreatm"Count#PageFooterSectionm$Text31m%Session_org=0, 0, 0, 0, C Form_frm_ChurchInformation=44, 44, 491, 281, C Form_frmBuildNamedList=66, 66, 513, 303, C Form_frmPersonSession_sub=22, 22, 413, 278, Report_Copy of frmPerson_and_Session=0, 0, 0, 0, C Form_frmUtility=66, 66, 457, 336, Report_rptEmailAddresses=110, 110, 796, 374, Report_rptGroupReportSummary=44, 44, 435, 300, C Report_rptGroupReportSummary_Condensed=51, 4, 442, 260, Report_rptNameTags(3x4inch)=54, 70, 901, 613, Report_rptAddressLabels=81, 105, 928, 648, Report_rptNText32f&Line34'ReportFooterp(Attendance_Weekly_Counts_subreportAttendance_Weekly_Counts subreportpTitlemFirstNamemLastNaͬ@2" ReportHeaderPageHeaderSectionfLine24DetailmWK1mWK2mWK3mWK4mWK5m WK6m WK7m WK8m WK9m WK10mRetreatdLabel26fLine27PageFooterSectioneSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT 0 P&* SHub No(Cancel As Integer) Dim strRespo2n kMsgBox("No Matching+cords for this3", vbIn maO, "9l"9oCmd.SetWarns (5C Event@(O Za End @9=O8pen< ecords_To_Ndegjmnopdodddddddddddddcedure] Arial8 hEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2i     $K[% !"#(&'*1C+,-./025346:789;=<?>B@ADEFGHyQRSTUVWXYhi]^_`abcdefg jmnopqr"z{ e'[V9UddfmmjjjjjjjjjjjmmmfpocClass=Report_rptGroupReportSummary/&H00degjmnopddddddfmdodmmmoommmfsionCompatible32="393222000" CMG="FFFD67156715E319E319E319E31908:<=Babc4e g&hij+kn@"Attendance InputsrptAttendance Arial84hEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ***C+winspoollEPSON Stylus C82 SeriesuUSB001eriesUSB001d278d eTimes New Romane2g37jghm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp4LastName` ReportHeader5oD1 d25Q`<a<b cgdeLabel30AttendanceUoD1 o5Q`bc<def,hl ,"";"";"";"";"10";"100"2" spsession_idspsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarEPSON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d28 Arialm5< ArialLastName`"PageHeaderSectionj8eD1 d8"`a<b|cd Label3`View Email Addresses Selected for Export to FileJQkD1 d8"`xab0chd Label4ݞ1.) Two output files will be generated: JQkD1 d8"`Hatb`cd Label5&(a) One is "Alpha_AddressBook.txt" This is for email applications that will take comma-delimited information directly.JQkK[N""D1 fa,bl Line6JQkD1 d8"`Ha4b`cd Label13(b) A second is "Alpha_AddressBook_Outlook.xls" This is for import into Microsoft Outlook.ԸFvvؚ#d8"`a bcXd Label142) Use "Create File of Email Addresses" button on the Reports screen to initiate the actual file creText17stdocnamI%stdocna0stdocnO_stdocIst36stdst(_sjOpenFors_B_var_GoToRation. CL#d8"`a bcXd Label15ݞBoth reports will go into the directory from which you are executing AlphaBase.X,EPGMwz ` Detailj8eD1 m<"`<b chei Email Emailj8eD1 m<"`| chi kFirstNameFirstName!j8eD1 m<"`Xchi kLaLabel14d Label15`h"PageFooterSectstNameLastName#j8eD1 `h"PageFooterSectionj8eD1 mC`a<b@ Te$`|H(A`0&$` $` nrdLarU ( 9JQkD1 ON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d28 Arialm5< ArialLastName`<"PageHeaderSectionj8eD1 d8"`a<b|cd Label3`View Email Addresses Selected for Export to FileJQkD1 d8"`xab0chd Label4ݞ1.) Two output ted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"d5Q7`abc;d Label37Session:2" `"PageHeaderSection/oD1 d5Q`<a<bcd LastName_LabelLastNameDetachedLabel8oD1 d5Q`a<bcd FirstName_LabelFirstNameDetachedLabeloD1 d5Q`a<bcWK2_LabelWK2DetachedLabel@oD1 d5Q`a<bcWK3_LabelWK3DetachedLabelBoD1 d5Q`a<     uGHIJKLMNOPQRqrstvwxyz{A~bcWK4_LabelWK4DetachedLabelDoD1 d5Q`a<bcWK5_LabelWK5DetachedLabelFoD1 d5Q`,a<bcWK6_LabelWK6DetachedLabelHoD1 d5Q`H!a<bcWK7_LabelWK7DetachedLabelJoD1 d5Q`d#a<bcWK8_LaK[belWK8DetachedLabelLoD1 d5Q`%a<bcWK9_LabelWK9DetachedLabelNoD1 d5Q`'a<bXcWK10_LabelWK10DetachedLabelPoD1 d5Q`0*a<bcd Retreat_LabelRetreatDetachedLabelRoD1 d5Q7`-a<bcd Count_Label CountDetachedLabelToD1 f23S`<aYb0 Line33XoD1 ` Detail0oD1 m7Q`<a<bc,i LastNameLastName7oD1 m7Q`a<bc,e i kFirstNameFirstName;oD1 j2Q`a<eiWK1WK1=oD1 j2Q`a<eiWK2WK2?oD1 j2Q`a<e iWK3WK3AoD1 j2Q`a<eiWK4WK4CoD1 j2Q`a<eiWK5WK5EoD1 j2Q`,a<e:iWK6WK6GoD1 j2Q`H!a<e+iWK7WK7IoD1 j2Q`d#a<ei WK8WK8KoD1 j2Q`%a<e:i WK9WK9MoD1 j2Q`'a<evi WK10WK10OoD1 j2Q`0*a<ei RetreatRetreatQoD1 m7Q`-a<bce i k Count CountSoD1 `"PageFooterSection1oD1 m7Q;`<abc Text31 =Now()Long DateVoD1 m7Q;`abck Text32H="Page " & [Page] & " of " & [Pages]WoD1 f3S`<ab(2 Line34Yo DCd!X\  \  >X1x\lxJ=lxpblx p`kbk`<!xMH@8 8`1t58*(8xMH@ `1p68*(8xMH@ `1l68*ltld*#Xlp*#ld*#ll*1h2Xlh\  \  \>lD< $txphld$X\8DCd!X\  \  >X1x\lxJ=lxpblx p`kbk`<!xMH@8 8`1t58*(8xMH@ `1p68*(8xMH@ `1l68*ltld*#Xlp*#ld*#ll*1h2Xlh\  \  \>lD< $txphld$X\8DCd!X\  \  >X1x\lxJ=lxpblx p`kbk`<!xMH@8 8`1t58*(8xMH@ `1p68*(8xMH@ `1l68*ltld*#Xlp*#ld*#ll*1h2Xlh\  \  \>lD< $txphld$X\8dd4t<<Ph l X@8 a1 ppp@ < D1 `dReportFooter6oD1 p3Q`hab2cDAttendance_Weekly_Counts subreportXReport.rptAttendance_Weekly_Counts subreportspsession_idspsession_idDAttendance_Weekly_Counts_subreport2" T|F K[6 ` HT`p\PLhHxXdltP|xtplhd`0 0  4HPL   T \ `@gHPL   T \ `@g@<@@I9q~~~@DI9@HI9  !"#$%&'()*+,-./012356789:;<=>?@ABCDEFGHIJKLMOPQRSTUVWXYZ[\]^_`abcdefghijlmnopqrstuvwxyz{|}~qG  @@?1 zzz Plh$ `h h+:X%h$ `h dh$P( lh<X@DAY@HI9Q@La@Pa@TI9@Xa@\AY|||@`I9@dI9@ha@lAY9@pAYa@t a1 rrr@xI9 @ | 5  @ a@:Y  I K[v W  xK3)'h%x$ `x ,x<''$'Dd xx ,>dFT x6TD$ 0xx$  $dxTD$xD<'8%'H%'X%:h%x$ `x `xDD$  x0   |8H W  0 p rU Y1 K1@4iKQKppp@8iKQK@<GqG  @@?1 zzz |lh$ `h h+:X%h$ `h dh+:X%h$ `h ,h$|( lh<X%'X%:h%x$ `x `xrU l$`$A` (`&$`rU  $Y1 p цi H#$ I1?q?1IYiIq)iA!A9q!%sي! a9@4AYكttt @8 a1 ppp@< 1~~~@:@Y  @DI9Qxxx@HI9izzz@ L |||I@PI q rrr@TI @ X لI@ \ I  @ `  I WWWV:Td:h%x Lx $daD4%0 0)xd06D4$x xWD% x5D\$  xd0D48Kd$ Qdp Ch'd'4%'D%T%lhp Qdl ll0 0 $d! lQdo %:T%0 ( 5 $d! xQdo %:T%0 ( 5 $d! Qdo %:T%0 ( 5 $d! Qdo %:T%0 ( 5 $d! Qdo %:T%0 ( 5 $d! Qdo %:T %0 ( 5 $d! Qdo %:T!%0 ( 5 $d! Qdo %:T"%0 ( 5 A  ! TZ :T %0 ( 5 0 d c0d! <d #d<''' dd ,>F K[r d6  8< $0ltpxh.d 0   0 h  T x$ `x Tx $  xHKd$ Qdx Cp'd'4%'D%T%lpx Qdt lt0.0 4 k. 0 0 Uc0d! <d #d<'''( dd ,>(F d6 < $0tpxhl$(d0 p  0   xK3)'h%x$ `x ,x<''$'Dd xx ,>dFT x6TD$ 0xx$  $dxTD$KCx8'':0N  :PN@@^1t6@ lt3+''' :PN@@ 6@  Cp$ QhK''%'0%P%lph Q` ` K l` 4 k   c Cl''%'0%P%llh Qd d ld 4 kE@:P %  0 D@ (0]u)5@ ` ::P%  0Qo@%:0%` ( 5@::P%  0Qo@%:0%` ( 5@::P %  0Qo@%:0 %` ( 5@` d  d ^c$  l  <'''   ,>F@ 6@  H 0 `lhxdpt(@ 4L@X\ ` 0   8$ _ \ HSEFPILYDMNWFEIXFRSCGUHFZDBJ:LDIEUU_XFYKDFEZYXLZDDNLCKFOH: /SCOSNIBIISIXODPVUSHTKAHPPORE:_LJJSXGDJEBGZSDRUPLEOHVGTIUAN:XUNZIKSCMMLDSDEWNYETEGLBRICQI:.MSYOYVHODVAGXDBSLHTMGLFSVCLH:&}ZUCGZRNBBGHCWFEEDZMDFEDTVSSNB: K[v1`KRZEHSNAKJQWDEBIZQJXNTOMRBRJ:XWKKHXLDYYXVUDNMOAYGNCDHMXEB:HXHGEPZMNOYIIIERKBHICKBCFTLLK:p ZTSOKJMIXRNRRDNHSMJWFGXHUKH_:=VTPBIVGTVOKXDEIYMFCRGBDYPFVC: <YUUDTEFTLFOAWDNCPPJCMDQRYBHI:__LIHIIOJAZFIDVDXRKBYIJIYTZXGG:k YHVEBEGBWSUESDKANYLL_AHQEMKE:N=CNJYWKJTUAJUVDCLQJPKFYGATJKD:4`      !#$%&'()*+,-./0123456789:;<=>?@APropDataTypeInfoBlobDelta!24@eD?gD I_4mCLastNamemDPhone2dELabel38mFPhone3dGLabel41fHLine42mIEmaildJLabel44mKAddressLspperson_idmMFirstNamedNLabel46dOLabel47oPCitydQLabel48mRStatedSLabel49mTZipdULabel50tdLabel4Search_ConditiͬJyN.@P^< PageHeaderSectionDetailPageFooterSectionReportHeaderReportFootermLastNamedLastName_LabelmFirstNamedFirstName_Labelo spsession_idd spsession_id_Labelm Titled Title_Labelm AddressdAddress_LabeloCitydCity_LabelmK[StatedState_LabelmZipdZip_LabelmPhonedPhone_LabelmPhone2dPhone2_LabelmPhone3dPhone3_LabelmEmaildEmail_LabelmChurchdChurch_LabelmPerson_Commentsd Person_Comments_Labelm!tblPersons_DateAddedtblPersons.DateAddedd"tblPersons_DateAdded_LabeltblPersons.DateAdded_Labelm#tblPersons_DateUpdatedtblPersons.DateUpdatedd$tblPersons_DateUpdated_LabeltblPersons.DateUpdated_Labelm%Primary_Roled&Primary_Role_Labelm'Secondary_Roled(Secondary_Role_Labelm)Groupd*Group_Labelm+Aged,Age_Labelm-Session_Commentsd.Session_Comments_Labelj/Childcared0Childcare_Labelj1CelebrationDinnerd2CelebrationDinner_Labelj3HSWeekendd4HSWeekend_Labelj5Completedd6Completed_Labelo7RelationshipIdd8RelationshipId_Labelo9RelationshipTyped:RelationshipType_Labelm;tblPersonSession_DateAddedtblPersonSession.DateAddedd<tblPersonSession_DateAdded_LabeltblPersonSession.DateAdded_Labelm=tblPersonSession_DateUpdatedtblPersonSession.DateUpdatedd>tblPersonSession_DateUpdated_LabeltblPersonSession.DateUpdated_Labelj?Attended_Retreatd@Attended_Retreat_LabelmANum_ChildrendBNum_Children_LabelmCChildAgedDChildAge_LabeleEBox64dFLabel65mGText66mHText67dILabel68degjmnopdd!mdmdodmdmdodmdmdmdmdmdmdmdmdmdmdmdmdmdmdmdjdjdjdjdododmdmdjdmdmdemmel68All the Inon for each Person, for tͬI,N\/LD0*;GPageHeaderSectionnopddddddfmodmmmoommfm`,a8:<=Babc&e ghhi`jkD"ͬ7(cD1 ReportHeaderdLabel10PageHeaderSectiondLastName_LabeldFirstName_LabeldGroup_LabeldRole_id_LabeldRole2_id_LabelfLine13m ChurchNamed 08:<=Babc%e gEh|ijk!QG1v@qryFullDumpUtility Report Arial8%hEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d278d eTimes New Romane2g37jghm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp4LastNameFirstName`ReportHeaderv,Z]Gg7d2` b cXdeLabel65Utility ReportJR& 0d`ab!c,LabeK[LßTŸE?l68All the Information for each Person, for the specified Session (except attendance). For checking purposes.T[f|I&`"PageHeaderSection"*E@ ` Detailwy E[/!m5F`xatb c\i LastNameLastName(٩!D Sbd3`xaxb cLastName_LabelLastName _NA`m5F`P atb(c\i kFirstNameFirstName9CgvA0d3`P axb(cFirstName_LabelFirstNameK1qDKeo3D`bcdhe8fZn,"";"";"";"";"10";"100"76F ֹHspsession_idspsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"sessiontblPersons_1_FirstNametblPersons_1.FirstNamePageFooterSectionmText13mText14fLine16ReportFooterGroupRole2_idRole_id=sNlR›(`ReportFooter3N)_Phone0=Babc,.e giͬ 7Q5IBoPageHeaderSectionDetailPageFooterSectionReportHeaderReportFootermtblPersons_LastNametblPersons.LastNam_id";"Session";"PrimaryKey"d3`axb8c$spsession_id_LabelSession8tA~Uԡ/m5F`ahbP c\k Title Title9TKZ\:0LD)o0bcd<efl nᎍ"Hk[D RelationshipType RelationshipTypeValue List""Spouse";"Friend"1440m`4a<bci k*tblPersons_1.LastName*tblPersons_1.LastName*tblPersons_1_LastNameIV M}9CJmm`<a<bDci k,tblPersons_1.FirstName,tblPersons_1.FirstName,tblPersons_1_FirstName! bK*h f`,bc Line22MWп@5`"PageFooterSection6g$ JoTm;`<abc Text13 =NLabel15o spsession_idd Label16 DetailmLastNamemFirstNamemGroupoRole_idoRole2_idPageFooterSectionmText11mText12fLine14ReportFootermabik Text3(= Trim( ͬE ;PAOf,ReportHeaderdLabel12PageHeaderSectiondtblPersons_LastName_LabeltblPersons.LastName_LabeldtblPersons_FirstName_Labelnopddddmdmodooommmmmdo [Role] AS Expr1 FROM tblRolblRoles";"";"Role_id";"RoimaryKey"o`cd<efl n,"";ͬ$:(xOSיReportHeaderdLabel14ospsession_idPageHeaderSectiondLastName_LabeldFirstName_LabeldRole_id_LabeldRole2_id_LabeldPhone_Label Detailm LastNamem FirstNameo Role_ido Role2_idmPhonePageFooterSectionmText15mText16ReportFootersessionperson_idspperson_idRoleRole2GroupAgeCommentsChildcareCelebrationDinnerHSWeekendCompletedRelationshipIdRelationshipType DateAdded!DateUpdatedm"ChurchNameo#Combo21ns_LastName_Ladegjmnopdomdddddmmoommmolm tblPersons_1_Lasons_1.LastNamedtblPersons_1_LastName_Labelͬ_ӯHej{_FormHeaderDeta08w:<=Babc)e ghijk0! vuh@&qsel_SessionLeaders"rptSessionLeaders Arial8,hEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d278d eTimes New Romane2g37jghK[ĜMÜYm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp4LastNameFirstName`8ReportHeaderUQ_AݸVd2a<b cIdLabel14Session Leadersس\*JpXo9AD`bcdefl,"";"";"";"";"10";"100"@+ALF< Jspsession_idspsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"m;CF`a<bce ikChurchNameChurchNamex1Dtrr`"PageHeaderSectionB1D -~d`<a<bDcJd LastName_LabelLastNameDetachedLabeleîD@$xLd`a<b(cJd FirstName_LabelFirstNameDetachedLabelȎLr\Ed`a<bDcJd Role_id_LabelRoleDetachedLabel0DPPBGd`,a<bDcJd Role2_id_Label Role 2DetachedLabel8pa獤DM?-3d`\ a<bcJd Phone_Label PhoneDetachedLabelԂԉ-@9` DetailP`"H~mF`<a<bDcwi LastNameLastNameפԡHc^HmF`a<bdcwi kFirstNameFirstNamePU?NwݡaoD`cd<epfwl n,"";"";"";"";"10";"100"%RNsjlRole_idRole_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";"";"Role_id";"Role";"PrimaryKey"oD`chd<e fwl n,"";"";"";"";"10";"100"; VA=Role2_idRole2_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";"";"Role_id";"Role";"PrimaryKey"m;F`\ a<b$ cwi k PhoneComposite_Phoneb1KyuK`"PageFooterSectionޒZJs\Em;F`<ab c Text15 =Now()Long DateJcRJ>um;F`dab,ck Text16H="Page " & [Page] & " of " & [Pages]?@ABC^FGHIJLOPQRSTUVWYZ[\_`abcdefhijmnopqrsvwxyz{|}~Hr=j`4ab0ciChildcareChildcare\WkW H^.d3`4a b0cChildcare_LabelChildcareK[v1ĔO.sj`xabc,ei"CelebrationDinner"CelebrationDinnerVCGP8d3`xabc.CelebrationDinner_Label"CelebrationDinnerK0:J++j`xabc,eiHSWeekendHSWeekend;WDKXGs-d3`xa b8cHSWeekend_Label,Registered for RetreatQd6H`Mj`abc,e,iCompletedCompletedgBgB9d3`a bDcCompleted_Label Completed Coursei9/OEmo3D`b@ cdeHf,hn4"";"";"";"";"";"";"10";"0"g}N\@e_RelationshipIdRelationshipIdTable/QuerySELECT DISTINCTROW tblPersons.person_id, [LastName] & ", " & [FirstName] AS Expr1 FROM tblPersons; 0;2880b"SELECT DISTINCTROW tblPersons.person_id, [LastName] & "", "" & [FirstName] AS Expr1 FROM tblPersons;";"tblPersons";"";"person_id";"LastName] & "", "" & [FirstName";"PrimaryKey"d3`abHc(RelationshipId_Label$Friend or RelativeݙwQNPmQo03DbcdeDf,h`nanqO nÂK RelationshipType RelationshipTypeValue List""Spouse";"Friend"1440d3`abDc,RelationshipType_Label RelationshipType \Ggm5F`a bc,e k4tblPersonSession.DateAdded4tblPersonmfion.session_id, tblSesssion FROM tblSession ORDͬ)9(hmF&TReportHeaderPageHeaderSectiondRole_id_Labeldspperson_id_LabeldRole2_id_LabeldPhone_LabelGroupHeader0m Groupd Group_Label Detailo Role_ido spperson_idoRole2_idmPhoneGroupFooter1PageFooterSectionmText15mText16mText27dLabel28ReportFootersessionperson_idRoleRole2AgeCommentsChildcareCelebrationDinnerHSWeekend Completed!RelationshipId"RelationshipType#DateAdded$DateUpdated%Leader?o&Combo30m'Text31o(Combo32d)Label33*ChurchNamem+TexdegjmSession.DateAddedMedium Date4tblPersonSession_DateAddedDmad3`al bc,@tblPersonSession.DateAdded_Label$Session Info Added@tblPersonSession_DateAdded_Label]VGMԏ/RGm5F`abc,e k8tblPersonSession.DateUpdated8tblPersonSession.DateUpdatedMedium Date8tblPersonSession_DateUpdatedlqGKZ_d3`abcDtblPersonSession.DateUpdated_Label(Session Info UpdatedDtblPersonSession_DateUpdated_LabelSR=ҌH{v;[%j`abc,eli Attended_Retreat Attended_Retreat  M{ޫd3`a bHc,Attended_Retreat_Label Attended_RetreatYz@}caSm5F`0 hFN*rxK[r-PY:YCh @ڬihDA 6"IO9`yx6"IO9`yY:YCh MEP SLS S(LX(L>6<<<< <$<(<,<0<4<8<<<@ 2Vvx\ :l`2hh(L @< PX@HPX(, @ 4dPX @ @   (08@XX@X0 X p(08@H` 1\@ E6.D `@| (l h `x: `f  (08@HPh``I@(\ @X T0$hY@$*\Rffff*1N4059ba3d*\R2*#24*\R2*#2e*\R0*#19*\R1*#25*\R1*#1b*\R1*#8*\R2*#2e*\R2*#24*\R0*#f*\R1*#98*\R2*#0*\R1*#98*\R1*#99*\R0*#19*\R0*#13*\R0*#14*\R0*#1*\R0*#f4p8v<r@tDxH " : 8P 8 $ :(08@HPX`  h x 2K[v1 ..2820D2h<2$2"2"2@2h 22 2.2.2.2H.2x828262:2P .(+H) (  (  "8&`-          (-H` hx     0 L &>@ hp x *< $ (   $( 2@ x   " : 6 48 p "`  8 . 8 P h    ( :    08@H  P 0 * * *` 0y .  h  0 ,0 * 0 0  Hh (8   :! h XFH XF dFh TFx VF VF  0H ,8 .@ h 0x ,  0p &x '       ( 8HPX `'      ' 8 @P X` h x  ' 0 8@ H Xhp x' ( 8@ H Xhp `  '     0P 0 (8 & 0@ `.+` .+0 4+h ,+ .+ .+  0 2 & *x 0   0x . * 0&&&&,&0$&0$&$&  $ :  $ 2  $ 2 x$ 0 $ 0 h$p 0 P X p<x  " h! :# 6# &0$ "X$ $K[n) ,$ $ $ $ %  % 8% P% :X%p! x!!!%%% J#:8"x"J"4">h# !!" !"#8)  % %&%% && & (& 8&H&P&X& `&& &&& & &&& & &' ('8'@' H' X'h'p' x' '' ''' ' ''( ((0( H(X(`( h( x((( ( (( ((( ( )) ) !! !!! !)x3--------------------------------------------------- 2 Import external Excel spreadsheet into tblPersons2 after clearing out current contents of the table. Dick Hertel April 9, 20033---------------------------------------------------j]@]X]p]]]] R.:and qryAllParticipants'J+DoCmd.OpenQuery stDocName, acNormal, acEditL&Imports data from an Excel spreadsheet'  $to Table tblPersons.'  $------------------------------'  $)Spreadsheet MUST include following fields'  $!with the exact spelling as shown.'  $ FirstName'  $LastName'  $Address'  $City'  $State'  $ZIP'  $Phone'  $Phone2 (optional)'  $Email (optional)'  $Comments (optional)'  $Church (optional)'  $------------------------------'  $WARNING -- This WILL clear out'  $existing contents of Tables '  $ tblPersons and tblPersonSession.'  >$ '8 8OK, Cancelling the action. A@ |k" Verify if the file and path exist lV CLEAR OUT tblPersonSessionsSELECT * FROM tblPersonSession'2 2 V :%T.4n 4B@j 45Na 4B@ 4B@Vq CLEAR OUT tblPersonspxSELECT * FROM tblPersons'  V :%T.4r8 4B@j  45Na 4B@ 4B@Vq)Perform the transfer from the spreadsheetE Append to the empty tblPersons the new data in the Excel spreadsheet v x tblPersons l B@tz0|(j # Some error other than empty tables "!$A@ zn "! " tblPersonSession is already emptypkrx "! + tblPersons is already empty, no work to doz ko@ ]] ox 3===================================================0 Import key table data from an earlier AlphaBase. Version, so f K[ @ @ @ @ @ @eatures of latest version can be utilized.1 Tables that will be cleared out of current copy,( and then imported from Source file are:4==================================================== tblPersons tblSessions tblPersonSession tblRoles tblChurch tblCities` k h  <This will clear out several tables in current Database File, $)namely those that will be import targets. $Do you want to Continue ? >WARNING$ '  (MsgBox ("Response was = " & strResponse) (08|@@SELECT * FROM tblPersonSession'2 2 V :%T.44 tblPersonSession is already empty, so no work to do------x 4B@tblPer` 45Na 4B@ 4B@VN(q pSELECT * FROM tblPersons'  V :%T.4x 4B@N` 45Na 4B@ 4B@V(q SELECT * FROM tblSession'. . V :%T.4@ 4B@N( 45Na 4B@| ( "! p k  "! + tblPersons is already empty, no work to dox kp h ]]X]p] R.: X "!$A@  4B@V_Tableq]hVeed to]" Verify if the file and path exist   vMicrosoft Access  n tblPersonstblPersons_imported B@ "! + tblSession is already empty, no work to dokH@  vMicrosoft Access  n tblSessiontblSession_imported B@  vMicrosoft Access  ntblPersonSessiontblPersonSession_imported B@* ========================================= tblPersonSession_imported table& Step 2. Import the "changeable" info.==== July 6, 2003 Dick Hertel======* =========================================# from tables in the Source database) into shadow tables named tblXXX_imported*==========================================* =========================================( Step 6. Lastly delete all tblXXX_import$ tables to allow for future updates.on* =========================================* Step 4. Append the imported values to the( overcome the Relationship locks betweenio# using only the adjusted ID values.# Step 1. See if user really wanted======& to prepare them for receiving the new values.si* =========================================* =========================================* =========================================* =========================================* =========================================$ to import new values, and if Source " tblPersons and tblSession tables,$ database file is value path & name.* ========================================= to determine the new ID values.==+ Step 5. Merge old and new ID values in the8& Step 3. Clear out tblPersonSession to Tables.) Then, clear out tblPerson and tblSession*==========================================]] 4! Test for valid path and filenameqryAppend_Imported_Persons J B@FZstrQuery4 = "INSERT INTO tblPersons SELECT tblPersons_imported.* FROM tblPerso!K[ns_imported"X ntblPersons_imported B@ ntblPersonSession_imported B@ .Give full path and filename of SOURCE databaseSource Database8c:\Documents and Settings\All users\Documents\Source.mdb$2'p ntblSession_imported B@qryAppend_Imported_Session J B@F qryAppend_Imported_PersonSession J B@F NOT NEEDED  vMicrosoft Access  n tblCitiestblCities_imported B@  vMicrosoft Access  n tblChurchtblChurch_imported B@(  vMicrosoft Access  ntblRolestblRoles_imported B@SELECT * FROM tblCities'. . V :%T.4 4B@ 45Na 4B@ 4B@VXqPH "! 0 "! s'.k* tblCities is already empty, no work to do . V :%T.4 4B@ 45Na 4B@ 4B@VXqPSELECT * FROM tblRoles'.* tblCities is already empty, no work to dok ntblCities_imported B@B@ ntblChurch_imported B@orte ntblRoles_imported B@xp  "! '. . V :%T.4 0 4B@  45Na 4B@ 4B@VqSELECT * FROM tblChurch'.* tblCities is already empty, no work to dokxp  B@@h!qryAppend_Imported_Cities J B@FB@qryAppend_Imported_Church J B@F qryAppend_Imported_Roles J B@F!3MsgBox ("File will be = " & strDBpath_and_Filename)"&!]P d](p!|h!&`! "!$A@ (H!o@!]  >WARNING$ '  $YOU WILL LOOSE YOUR DATA.' dat  $ to prepare to receive your data.'  $'out  $0DO NOT RUN THIS IF YOU HAVE DATA ALREADY LOADED,' ProceedingA@ AbortingA@ AThis will clear out all the data in the existing (demo) database '  $ $Do you want to proceed?'H#|3=================================================== 0 Clear out demo data from key tables so user canl  beging loading their own data.ca July 2, 2003 Dick Hertely 2, 2% Tables that will be cleared out are:ill tblPersonsrren tblSessionshen  tblPersonSessionare: tblRoless tblChurchns tblCitiesSessio4====================================================blCiti]]] R.:SELECT * FROM tblPersonSession'2 2 V :%T.4 4B@ 45Na 4B@ 4B@VqpSELECT * FROM tblPersons'  V :%T.4 4B@ 45Na 4B@ 4B@Vhq`XSELECT * FROM tblSession'. . V :%T.4 4B@ 45Na 4B@ 4B@VqSELECT * FROM tblCities'. . V :%T.4 4B@ 45Na 4B@ 4B@V(q SELECT * FROM tblRoles'. . V :%T.4 4B@ 45Na 4B@ 4B@VqxSELECT * FROM tblChurch'. . V :%T.4 4B@ 45Na 4B@ 4B@Vqh)k))<Specify the full path and filename for the Excel"K[n) source fileSource Excel File8c:\Documents and Settings\All users\Documents\Source.mdb$ 2'l`)ζAttribute VB_Name = "Form_frmUtility" Bas0{69ACDA40-68F9-11D7-96EF-44410BC10} |Global!SpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  P&* Sub GetExcel_Click() '-/ Import externaDl - spdsheet into tblPe rsonsaf clearing out c urrenonts of the [. D@* Hertel April 9, 2003/On Error GoTo_OG1 Dim stDocAs$ Sng Ms g EPath`AndFiP dbsGmrQuXery2rstRecordset*CSfA= C^Db:qryAllParticip0antsA''DoCmd.OpenC( , acNalAEdi stAJ@s d from a?d)H & Chr(13) h& "LTbaL.;FS\MUST ]clude @follow![f0ield%with]exactellas shown"Fi=aSLast?+Addres9"CBSt#ZIPPhXone2("o£al)Ema`Pm"? 'WChurch? * W 0WARNING -- This WILLA#existScps gt}d'SME]HpResp@cv0CBox(r , vbOKCanplk If (2)9 enS ("OK, 61f3 7 "ExitrEnd ss\= Input $("S@pecifytransferq=د#' Ap@Nhe @tB6rnewin@7TacSxType70F'XEM, sQ Pok$RIrrk1' Soe2oran1DBZй.Descri{`^Pitk32bNumb= 3H021 , no work do. b a %__Alphaa}h=c ke`1P e data from an earlier AlphaBase ' Version, so features of latest v< c~b`utilized.zJuly 6, 2003 Dick H`ertel<BTablQthat will be cled outjcurrent copy,3and the@n impoKdSource file are:* tblPonsSes RoL)Ch.hit,ie =0 On Error GoTo_Ig_Cl  m stDocName As String `rRepsodbsDb*rQuery2345r@7RecordsetJ8DBpath_~_FwnB Set 1) T`Exit SuBE`IfD3:1bD2. v"e "change," info;«;/ $%C in"shadow%5.blXXX_E`?E% IMPORT#qi= InputbHGivu@BTASOURCE"ǡZ7"IAc:\`umsBbs >gs\A+ is\.mdb>ifyAi!&!bexisOpF #1 ' Tf@ vidp#ECl]#1P?AePp*$RDoCmd.` Warns OfN! Transfe2rsacKcMicrosoft 8Accؠ,, xbacB '6&"3 a t s d[ x s Q. ʂ4 :     fo  BD? ? ? ? ? Y (CD \ o o o o o o ble1Se "Z%Vb3. CByV7-@qozco1ORe@ship lockstweenfm,SSDaaPfprep!km Preceiv`IRl? CLEAR_PERSON_SESSIONgPSSELECT * FROM'Wt GR Q=.o^ơA~,DtynЭtDWcT_'z:&.MpFi##Wxith1 ppUl .EOFVaDelet@ҏ$QNexlLoop!5{S 2erAbs2a 0Q oho E_)a3Oׇ3OOt3O OD$/O O$_(10Gk rst.MoveNext !Loop0En@d With4 CLEAR_C@ITIES:(strQuery3 = "SELECT * FROM tblCities"TSet Pdbs.OpenRecor dset(F, dbDyna):On Error GoTo _Import_g`$Fi 7lickpKDo Until .EOF 0Delete ROL$Rolڠ37A2?P?PHURCH#hurch?P_?@ P' =% ' Step 4. Apud the i"oed valueps to~Persons a Session tabX,o d hrmine new ID .@% DO_APPENDW$A#K[n @ @ @ @ @ @w4~'4aINSERT INTO!DG_.ǛFdLDoC mdB "qrFy(Ėed_D", , acAdd c?d_*>D7csHndg ryr(C{ LH$\5. Merge oldWR iXh'D'?\ usin@g only"\adjust f\q@ NOT NEEDEDD 6. Las tdl all XXXt :=!ow fwfuture updatesq: )-sObject/TA, "6~d4_[M_bl7!B/F?uO`Ble-L Exirt44_CQMOq SubS@prreCIf (0.@NumberP3021) TheNn<. i]lready empty, so no work#doResume cPERSONSIf nsO O  L s  s SESSION z "   t   o #T_ _ Z cO O O _; QB2o o o $&%r:C z 35 %,c ։_ [ h2>sh=2~ a#?>3R>$>3__?>7@?>h?>CITIE>sCitie>t_t]]w<_ ]EROL?}Roles|CHURCHL}t>hurch?}?N)N/ 0AN>q> a_InP,al_q_Entry_Click7drrkErrHscript`)numeRiodXk  $to Table tblPersons.'  $------------------------------'  $)Spreadsheet MUST include following fields'  $!with the exact spelling as shown.'abc,kNum_ChildrenNum_ChildrenFӠI#jӀd3`0a bc$Num_Children_LabelNum_ChildrensXDBDA@O *\G{000@25E01-0C  0046}#5.0#0#C:\Program Files\Common Microsoft Share d\w350.0DLL# 3.5 Object LibraryHTstdole>fstdole5]f\]04V3[V-]2]WINDOWS\SYSTEM\STDOLE2.TLB# Automation/VBIDE> VBIDECCE157C5.3PVBA \6E6EXT.O+RVisual Basic for Applic1s Extensibility +"*@Form_frmSess1@G]r@m_fSA`ssinPMBEOFMTOZHCCEJIQMCRMRWJXUTG28AM@NEOF@T ZHC@EJ@TQ@CR@RW@XUhTGB@ j1B@dB,0Zp"(B+B4PersoTns4P4r4o n@4GPWMKWCVKRPBPDYLMUATDXVCRZNL4GP*MKQ@CVR@BADYL2U5TX@7ZN&K*@-CQ 4MainMen0uG 4Ma@4neu5ENOLQQDACEHJZDMLCFLKIJYDPDPPBE`OQQQ A4HU2ZMC8LU`I`Y`DP@;ReportXSelbP.Re6ptQc@iRZQBJOJEGGWIMXDSEIPRDNY@SDFAZDCZU@BO`E`MGU9I&XS |IU@R`N9SF'9 O3OL QC_rptE8HelpG,ka(_mpM9H`lpD:HSEFPILYDMNWFEIXFRSCGUHFZDBJH`$E6PlL`D`N`FbX R C U mFa"@mo6aUGen eric_PrPeparG*o"%Gn`ZrXc=_`2r`p[r`t`vvLDIEUU_XFYKDFEZYXLZDDNLCKFOHc!L JIU_aYUYD`EY LUDBuC`F`HI7#o>q!:e!sHV?HVSCOSNIBIISIXODPVUSHTKA@HPPORECSP;O NjII OPHUHUK-HP &R@OiO>O<_subG21,JUe_`Xub.LJJSXGDJEBGZSDRUPLEOHVGTPIUANUJ0jz$t_@,n_ e`'A1g$XWKKHXLDYYXVUDNMOAYGNCDHMXEt[X=K*H@A.Y>qgU0N?OYN!DMpE[I /'D/ ;4_ChurPchIn m=4_hu?hchn0?a \XHGEPZMNOYIIIERKBHICKBCFTLLKcXp GP ;MrkYI0E`K HUAS UNZIKSCMMLDSDEWNYETEGLBRICQIU$ZKBCјDWY0T0G0.B!I6Q_]i] 9s_ +UtB/U5;l-t@# MSYOYVHODVAGXDBSLHTMGLFSVCLxM YYjHpDpA aBL`,T! FNV 1/ DOrbx/ GEmailAddrU e0rt`mZE`D`A ^Y LnA\Q@MEP_>g~&<2x3 1/2 ">CNJYWKJTUAJUVDCLQJPKFY@GATJKDc!CUJ`XW J:Um@?J!>C aPU`F`G`T`_K@Bퟑa]""     <C*axME am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PRO&K[v @ @ @ @ @ @ GRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE AutomationZ*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 G`@        *8PMBEOFMTOZHCCEJIQMCRMRWJXUTG01406bd298Form_frmSessionZp8GPWMKWCVKRPBPDYLMUATDXVCRZNL02406bd2983Form_frmPersons*8ENOLQQDACEHJZDMLCFLKIJYDDPPB03406bd298 Form_frmMainMenu08ZQBJOJEGGWIMXDSEIPRDNYSDFAZD04406bd298.Form_frmReportSelectionLH38HSEFPILYDMNWFEIXFRSCGUHFZDBJ05406bd298,Report_rptMainMenuHelp6`8LDIEUU_XFYKDFEZYXLZDDNLCKFOH06406bd298DForm_frmGeneric_Report_Preparationx7#8SCOSNIBIISIXODPVUSHTKAHPPORE07406bd298*Form_frmPersonSession8LJJSXGDJEBGZSDRUPLEOHVGTIUAN08406bd2982Form_frmPersonSession_sub 8XWKKHXLDYYXVUDNMOAYGNCDHMXEB09406bd298->Form_zfrmPerson_and_Session_org'D8XHGEPZMNOYIIIERKBHICKBCFTLLK0:406bd29874Form_frm_ChurchInformation[ 8ZTSOKJMIXRNRRDNHSMJWFGXHUKH_0;406bd298K,Form_frmBuildNamedList#.8VTPBIVGTVOKXDEIYMFCRGBDYPFVC0<406bd2984Form_frmPerson_and_Session/8UNZIKSCMMLDSDEWNYETEGLBRICQI0=406bd298HReport_Copy of frmPerson_and_Session9 8'K[ @ @ @ @ @ @ @MSYOYVHODVAGXDBSLHTMGLFSVCLH0>406bd298Form_frmUtilityrx8D8UCGZRNBBGHCWFEEDZMDFEDTVSSNB0?406bd2980Report_rptEmailAddresseshPm8KRZEHSNAKJQWDEBIZQJXNTOMRBRJ0@406bd2988Report_rptGroupReportSummaryh8YUUDTEFTLFOAWDNCPPJCMDQRYBHI0A406bd298LReport_rptGroupReportSummary_Condensed8LIHIIOJAZFIDVDXRKBYIJIYTZXGG0B406bd29856Report_rptNameTags(3x4inch)a8YHVEBEGBWSUESDKANYLL_AHQEMKE0C406bd298;.Report_rptAddressLabels8CNJYWKJTUAJUVDCLQJPKFYGATJKD0D406bd298ADReport_rptNameTags(2x3 1/2 inches)axP0h `8Hg('F'y.`Z >EBїT{CkIihG13QqEj#[圼eaFm.S !;A谖>P{{n@KTK<;Ovh~Enjm}'F1.P[&՟yЈAףkflKQtJ'eF*ougG*m L<եč|@.z-WGE"hj^H{L%Eu͊%gGG0I|IPHYhV^L(GC.b2A[DmAccessVBAWin16~Win32MacVBA6#templateDAOstdole`VBIDEAForm_frmSessiony _EvaluateClose_Session_Form_ClickErr_Close_Session_Form_Click%DoCmdƧOpenFormExit_Close_Session_Form_ClickMsgBoxRErro Description  Form_Open-CancelMoveSize@ GoToRecordM6 acDataFormacLastForm_frmPersonsCity_BeforeUpdateCity_NotInLists:NewDatax_ResponsedbsǂrstCity Recordset strQuery1NewCityTitle~ MsgDialogFMB_YESNO<MB_ICONEXCLAMATIONyMB_DEFINITION1gIDYESaIDNO& CurrentDbS OpenRecordset| dbOpenDynaset AddNewaCityDUpdateUndoÞRequeryDATA_ERRCONTINUE Close_ClickErr_Close_ClickExit_Close_Click/ Combo34_AfterUpdatexErr_Combo34_AfterUpdate?rs_Clone FindFirstM=StrCombo344&BookmarkCExit_Combo34_AfterUpdateDuplicate_Current_Record_Clickõ"Err_Duplicate_Current_Record_Click# DoMenuItem&e acFormBar acEditMenu acMenuVer70X#Exit_Duplicate_Current_Record_Click Form_Close[OpenArgsBacNormalacNewRecYLastName_BeforeUpdatePhone_LostFocusstrPhoneNumber strAreaCodeB} strPrefix strSuffixstrNewPhoneNumber strSeparator) intPosition1 intPosition2Phone+WPhone2_LostFocusPPhone2Phone3_LostFocusPhone3Form_frmMainMenucmdRoles_ClickErr_Open_frmPersons_ClickFExit_Open_frmPersons_Click Form_Load{Open_frmPersons_Click$z stDocNamezstLinkCriteriaYMinimizeoOpen_frmChurches_ClickErr_Open_frmChurches_ClickExit_Open_frmChurches_Clic(K[n)k.Open_frmSession_ClickErr_Open_frmSession_Click?Exit_Open_frmSession_Click|NRun_Reports_ClickErr_Run_Reports_ClickExit_Run_Reports_ClickCustomize_Click=Err_Customize_Click stMsgText[BChrK~ vbInformationnExit_Customize_Click}Enter_Person_Session_ClickErr_Enter_Person_Session_ClickExit_Enter_Person_Session_Clickۃ Help_ClickAErr_Help_ClicknQ OpenReport acViewPreview2MaximizeFyExit_Help_ClickRComprehensive_Click_Err_Comprehensive_ClickacDialogaExit_Comprehensive_Click About_Click$Err_About_Click' acPreviewoExit_About_ClickJ6Build_Named_List_ClickErr_Build_Named_List_ClickTExit_Build_Named_List_Click#~Maintenance_ClickErr_Maintenance_ClickExit_Maintenance_ClicklForm_frmReportSelectionH^Command2_ClickstMsgGReport_1_Click4Err_Report_1_ClickExit_Report_1_Click+Generic_Report_ClickxErr_Generic_Report_Clickx itResponseԧ cbo_SessionSetFocus intResponse vbCritical+}Exit_Generic_Report_ClickGroupReportSummary_Click0Err_GroupReportSummary_ClickExit_GroupReportSummary_ClickOption13_AfterUpdatezZReportByRole_ClickNErr_ReportByRole_Click[Exit_ReportByRole_ClickRPNameTags_3_x4___ClickLErr_NameTags_3_x4___ClickExit_NameTags_3_x4___ClickHNameTags_2x_3_1_2_inches__Click+#Err_NameTags_2x_3_1_2_inches__Click$Exit_NameTags_2x_3_1_2_inches__ClicktAddress_Labels_5160_Click|Err_Address_Labels_5160_ClickExit_Address_Labels_5160_ClickFcboPrint_ClickErr_cboPrint_Click cboReportsKQExit_cboPrint_ClickXcmdNamedList_Click*Err_cmdNamedList_ClickExit_cmdNamedList_Click.RSendEmail_ClickErr_SendEmail_Click stResponse/XstDestination_msg istrQueryM?rstrst2jstrEmailB$ strFirstName strLastNameKstrPhone strPhone2' strPhone3' strOutput9c strHeader strTrailerIstrPathl SetWarnings WarningsOff MoveFirstNNamedListEnabled vbOKCancelx?EOFDeletexMoveNextL! OpenQuery acViewNormal RacAdd dbReadOnlyEmailIIfzIsNull FirstNameLastNameRunMacroXExit_SendEmail_Clickj!Attendance_Click?Err_Attendance_ClickacEditIExit_Attendance_ClickҋReport_rptMainMenuHelpW<Report_Activate"Form_frmGeneric_Report_PreparationpDefine_Report_Conditions_Clickx"Err_Define_Report_Conditions_ClickacTable OpenTable!#Exit_Define_Report_Conditions_ClickTEdit_Report_Header_Click_Err_Edit_Report_Header_Click=Exit_Edit_Report_Header_Click]Display_Generic_Report_Click9 Err_Display_Generic_Report_ClickstQueryF stCondition2<off!dbedit^TSearch Condition TwoEdit+ acReadOnly!Exit_Display_Generic_Report_Click#&Close_Generic_Report_Preparation_Click*Err_Close_Generic_Report_Preparation_ClickQE(Exit_Close_Generic_Report_Preparation_ClG Form_GotFocus SelectObjects^acFormmsgtext9 current_text strSearchMHelp_ConditionP Help_Message Copy_Records_To_NamedList_Click#Err_Copy_Records_To_NamedList_Clickه rstSourse rstTargetE strQuery2strMsgG& strResponseOstrTempMErr_No_Target_Record Clear_Named_Listj rstSource[ Last_Name First_Name?StreetAddressStateZipm$Exit_Copy_Records_To_NamedList_Click;Number-Form_frmPersonSession6Close_PersonSession_Click˗Err_Close_PersonSession_ClickExit_Close_PersonSession_Click"spperson_id_ChangelForm_frmPersonSession_sub Form_DirtyPRelationshipId_BeforeUpdateŚRelationshipId_NotInList~k NewPerson)K[ِRelationshipIdFormsfrmPerson_and_SessioncboFindForm_zfrmPerson_and_Session_orgjForm_AfterUpdate tblPersons} DateUpdated"Now%Form_frm_ChurchInformation Form_CurrentErr_Form_Current record_numbertX Church_idZSelected_Church_idExit_Form_CurrentKcmdClose_Click!PErr_cmdClose_ClickExit_cmdClose_ClickForm_frmBuildNamedListCombo1_AfterUpdateRecordsetClone8Combo1Add_To_Named_List_ClickErr_Add_To_Named_List_ClickDmsgQ person_idf Named_ListExit_Add_To_Named_List_ClickNCombo26_BeforeUpdate Combo26_ClickX selectionZCombo26&NLCID] Full_Name , Label_Coded Desc_ListReset_Named_List_Click=Err_Reset_Named_List_ClickExit_Reset_Named_List_ClickdSave_Named_List_ClickZErr_Save_Named_List_Click`rstDescription y strQuery3found+InputBox GIDƓExit_Save_Named_List_ClickGet_Named_List_Click fErr_Get_Named_List_Click Exit_Get_Named_List_Clicks;Copy_to_Email_ClickErr_Copy_to_Email_ClickstQuery2B[Err_Copy_to_Email_Click2#Exit_Copy_to_Email_ClickForm_frmPerson_and_Session8cboFind_AfterUpdate(|DateUpdated_BeforeUpdateҜCombo42_AfterUpdatemNzu^Combo42W&frmPersonSession_EnterfrmSubView_AfterUpdatew frmSubViewValueKfrmPersonSessionForm DefaultViewշ$Report_Copy of frmPerson_and_SessionCBForm_frmUtility.GetExcelData_ClickjErr_GetExcelData_Click1v[stExcelPathAndFilemJErr_GetExcelData_Click2w[ CLEAR_PERSONSErr_GetExcelData_Click3x[TransferSpreadsheeteacImport+sacSpreadsheetTypeExcel7Exit_GetExcelData_ClickImport_from_AlphaBase_ClickJ&Err_Import_Click strRepsonse strQuery4 strQuery5strDBpath_and_Filename$IMPORTiTransferDatabase)CLEAR_PERSON_SESSIONhErr_Import_PersonSessionP,Err_Import_Persons) CLEAR_SESSION Err_Import_Session CLEAR_CITIES5Err_Import_Cities9r CLEAR_ROLES.)Err_Import_Roles CLEAR_CHURCH&Err_Import_Church DO_APPEND72 DeleteObjectTExit_Import_ClickInitial_Data_Entry_Click[Err_Initial_Data_Entry_Clickes strReponseOExit_Initial_Data_Entry_ClickReport_rptEmailAddressesl Report_OpendacQueryhReport_rptGroupReportSummaryk&Report_rptGroupReportSummary_Condensed  rstTargerEstrGuesti strFullNameAAstrPreviousGueststrPreviousFullName strLeader1 strLeader2• strLeader3Õ strleader4ĕ intLeader intSessionX\intGroup(Err_Report_ClickContinue_Reporting"Guest FullNameОLeaderj spsession_idXGroupLeader1Leader2Leader3Leader4Report_rptNameTags(3x4inch)v" Report_NoDatay CancelEventURReport_rptAddressLabelsZ Report_ErrorDataErr6"Report_rptNameTags(2x3 1/2 inches)Ž8  *-08w:<=Babc4&e g&h|i4jk"duh@$qsel_SessionGroups rptSessionGroups Arial84&hEPSON Stylus C82 Seriespv odhhRL*(i*'DxME*K[v PSLS S<<<N0{0C658B01-3600-11D7-96EF-F4350BC1FFFF}  4@11i6` i8" :$ p % <pt t%`@ 1`BHert`D`Fpene@HL @JL$ @LL@NL@PL d j0`n '@ |p   &0i( jusxP%x0pP0pPP Y@n "  . @ ,` *  " 0 6( 0`       0 &Hp6    (0 88p  @  "     0 8"@H P 0X,   " 8.X    " " "   0@x(======================================== NOT-IN-LIST ERROR HANDLER% Allow user to add to a pick list, byp$ popping a dialog box and accept theMe new text 16 Dec. 2002 Dick Hertel) Modified 6 Jan. 2003 Changed table name/ to "tblCities" for compatibility to Alphabase.as)=========================================]]]]]]] ]08]Ph R.:SELECT * FROM tblCities'@ @ V :%T.< Find out what User wants to do H J L 'FCity Not In List'DDo you want to add a new City ? F D$ 'B B N <C@X 6:Z 6 (ZC@\ <B@Bqd2 User probably just made a type, return to control !ZB@^kx !ZB@`9 Continue without displaying default information message. b'8of B@Bh|f "!$A@ hol]* +K[v1 @ @ @ @ @ @ @Find the record that matches the control. !>!p.n[person_id] = "v$t nB@r n!x (xz|lzo0~    B@    B@    B@= Paste Appendp|h~` "!$A@ Ho@p$ !(o,, B@*o B@oAttribute VB_Name = "Form_zfrmPerson_and@_Sessi,o rg" Basl0{0C658B01-3600-11D7-96EF-F4350BC1F} |@Global{SpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustomizD$Opt Comp@ DT P&* Sub City_NotInList(NewA As Sng, Respon Integer) '=$ NOT-IN-LIST ERROR HANDLERAllow user t o add p ick l$, by popping a dialog box @ accept th_' ne@w text 16 Dec. 2P002 DH ertelModifiU6 Jan 3 Changvn !&"tblKies" for cVtibilP-@AlphabY. @ G=AdDim 8dbs]jrstAhRecordse@6AstrQuery1j| p kTitvMsgDCSC{t MB_YESNO4 ICONEXCLAMAT(IONA8DEPFINIA10, ID@6EB7A@1{)@F=!n^rs.!Fi' "[peid," &k(Me. ]aBookmark@ N_u t2c%+%Dup$6_DQ__&T&?9 'DoMen`uItem`s!Bar,Edit, 8, Ver70.2cu, 5 'Pas`Ap]d!/)/ 4OOV_5Ui#6[;}6@ )Pns.Wes8ѡNow8{HQB "XAMoveSize 30PxB`Q P0A!s(Can8celGaxi8h] !B@ !dMake a Session Selection first. $ '|(k rptAddressLabels'   B@| "!$A@ o( ]h !"'- 7 3   K !5;A14hPersons 4qryAppend_Imported_Persons 0Bad Import of tblPersons (tblPersons_imported2 (tblPersons_imported3 (tblPersons_imported4 (tblPersons_imported5 (tblPersons_imported6 (tblPersons_im(S<S<S<<N0{F9FE8B63-C268-44D1-9ACF-BDB57F18F2CF} 6@i( @ x%Pxx,K[n)  "  Lh xx]`#No Matching Records for this Report Cancelling Report$ 'epor B@| B@8x B@|o`XAttribute VB_Name = "Report_rptTags(2x3 1/2 inches)" Basr0{F9FE8B63-C268-44D1-9ACF-BDB57F18F2CF} |GloballSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT` P&* Sub No(Cancel As Integer) Dim strRespdon kMsgBox("No Matching+cords for this3", vbIn maO, "-9l"oCmd.SetWarns (5C Event@(O CZ End @9 @ \ {*xME (S<S<S<<N0{B54C83DA-3CFA-11D7-96EF-F4220BC10000}0 <@i>` i: 6 i(@  % "   "  L(x  xoh]#No Matching Records for this Report Cancelling Report$ ' B@| B@8 B@|oPHAttribute VB_Name = "Report_rptAddressLabels" Bas0{B54C83DA-3CFA-11D7-96EF-F4220BC10} |Global!sSpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  P&* Sub Error( As Integer,spon )"0End 'No%(Cancel'Dim stxrRe+ MsgBox("No Matching@!cords for this", vb$In@ma;, :"l oCmd.SetWarns (IC Event NDO n =p[*xME (S<S<S<<N0{C449E799-36A5-11D7-96EF-64190BC10000} 6x@ i(@  i( Ap%x "  Lh x "  x]`#No Matching Records for this Report Cancelling Re-K[LßdŸE?port$ ' B@| B@8x B@|o`xoPHAttribute VB_Name = "Report_rptTags(3x4inch)"  Basd0{C449E799-36A5-11D7-96EF-64190BC10} |GlobaBleSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT 0 P&* SHub No(Cancel As Integer) Dim strRespo2n kMsgBox("No Matching+cords for this3", vbIn maO, "9l"9oCmd.SetWarns (5C Event@(O Za End @9=O8pen< @Pa(*xME PS<S<S< :P 4 6 > 8@ x " > (08@HPX`hpx   4 *2 @@J  28@H P X`h px  8    &    20hp x   D  . H X h x       .  ( 8 HX`h p x &   , ,@H ,P      *       0  @  P  `  p      .    ( x7=======================================================3 Scan the tblGroupReportSummary table, to determine. which leaders are associated with each Guest./ Assign these leaders as Leader1, Leader2, etc.7 and write this info to tblGroupReportSummary_condensedfo2 This version of the report will fill considerably less rows of paper. Dick Hertel May 18, 20038=========.K[v===============================================]`]x]]]]]] ]8]P]h]]]]] T.<. First, run the query that will regenerate the# source table tblGroupReportSummary ~ B@|qryGroupReportSummary_table   B@#SELECT * FROM tblGroupReportSummary'b@ Source table-SELECT * FROM tblGroupReportSummary_condensed'@ Target table b X <%V.  X <%V.+ Clear out current contents of target table 5aC@C@q 'None'  2Debug.Print "Previous Guest = " & strPreviousGuest5a6"'6$'  Debug.Print "Name = " & strGuest   , Just starting, so nothing to save to Target'6&' ' ' '6('6*'>Debug.Print "Leader1 = " & strLeader1 & " Group = " & intGroup '  'd' Save the previous record to the Target B@Z  ($  ((  abel5Alpha atTimes New RomanW75 d8"`a4bcd Label8 Group. BWnopsReport_rptAddressLabelsReport_rptNameTags(2x3 1/2 inches)Report_rptNameTags(2x3 1/2 inches)rt_rptNameTags(2x3*#99*\R1*#98*\R1*#254p8(*  ("  (,  (.  (0  (2 B@^' Now save new info on the current Guest6*'6&' ' ' ' '  ''kd This guest has multiple leaders  ' KT6&'%Debug.Print "Leader2 = " & strLeader2KT6&'%Debug.Print "Leader3 = " & strLeader3KT6&'%Debug.Print "Leader4 = " & strleader4TZVBDW_UOETGZDROTXORNMYZFXOG:) #UNBOJLFAQZZLMDSIIYSQDXZRJYXF:; VQBPHJDXCJUNXDLQZLBLHHRGGCHN:'+ GWOYZZU_ANLOGRDCACGPDGSAOFKJL:,/KSxnpkh B@P$ Save the final record to the Target B@Z  ($  ((  (*  ("  (,  (.  (0  (2 B@^qxClose rstTargetClose rstSource@ "! (Table is already empty, so no work to do koAttribute VB_Name = "Report_rptGroup8Summary_Condensed" " Basz0{6E95630C-8889-11D7-96EF-44410BC1 0} |GlobalSpacI False dCr@eatablTru PredeclaId"pExpo_TemplateD`erive!BustomizDOption Comp@ DT` P&* Sub Open(Cancel As Integer) '=3 Scan the tbl , to determin' which leaders .associ@,d with eaGuest.Assig| s L1,@2, etcB an@rithis info!)X_coT v&VofB7r&`ll fi@ si@/dy less rows @ paperB!Dick Hert\ May 18, 2003 s]== Dim strQu(erysSngŎ2dbsArstSour€RecordsetTar#kA#FulShviousE A 1"`33#N4int#aDj&&SBHn"f*Set 4= CurrentDb!' Fi0, runq?thatCSr zner{`rdsc:_D oCmd.@Warnings (%OffDbN"qry~_B ", acViewNorma/K[lAddB `.SELECT * FROMS"G' $UB 2" y~@ ' B[t 0- =2.!&_(%,`!DyntC% 3dbb' C@Or out jcCA t@BtqOn Error GoToA_Cl b W#B*Do Until .EOF.Del )MoveNexC@LoopE'@  tinueD@J:"'3x= 0@ !None{ P'Debug.pnnt " D &Qju?Op e![]%6H= ![?9 U# If $ <> ) Then01jOP ' &Jarg,@ so noqngpsav{o/w+1PO17![Ia r9 # 3;Wqp eVspsCW_idSW? Q"& " ӥtr=A h&EVQhe preu r|"`?A.ZNew 7/@  ]8 t ׿S2:2??|r3:  h 44$2yUpd>' Now @newpaUgD E/R4pC#?C9oCp+__SRP_13o_VBA_PROJECTdYBYFWKCFRRJYVXDROMEHYGEGDFGPE:eEIULEKETFEVVNDQBNHUIFNVECMCM:I aSLS S<$<(<<<<< <,<0<4<8<<<N0{62F18A78-255A-11D7-96EF-043B0BC1FFFF} @ @`@ `8@ `%@@ %p %@ Filesx @h @d @T @D @4 $ $@  px @h @X @H @8 HxY@ "  ) (0 8<@P X "`<h "  xh B@BlGenerP|H@ "!$A@ lS(o @ frmMainMenu B@xop B@`oPHAttribute VB_Name = "Form_frmPersonSessi on" Bas0{62F18A78-255A-11D7-96EF-043B0BC1F} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustomizD$Opt Comp@ DT P&* Sub Cl?_ _Click() On Error GoCDVg7nC"`p"PageHeaderSectionsЋ-JVNd`@ abHcJd Role_id_LabelRoleDetachedLabelh!fјNMd`abvcJd "spperson_id_LabelNameDetachedLabel%gQoH2d`abcJd Role2_id_Label Role 2DetachedLabel2VfM7Ĕd`abcJd Phone_Label PhoneDetachedLabeleGmH *]o#m0;F`adb cYij Group GroupamN_)+d`<adbcYdGroup_Label GrouprqM'dfm;F`a<bcwi k Text31ChurchNameC3n$5 o9D`bcdefl n,"";"";"";"";"10";"100" C3n$5 Combo32:tblPersonSession.spsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"d2bz cIdeLabel33Small Groups C3n$5 `GroupHeader0jBIih` Detailx2^Od:;oD`c@ d<e` fwl ,"";"";"";"";"10";"100"Y Gro,Role_idRole_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";"";"Role_id";"Role";"PrimaryKey"oD`b@ cd<epfwhSl n4"";"";"";"";"";"";"10";"0"؈5w@7)spperson_idspperson_idTable/QuerySELECT DISTINCTROW tblPersons.person_id, [LastName] & ", " & [FirstName] AS Expr1 FROM tblPersons; 0;2880b"SELECT DISTINCTROW tblPersons.person_id, [LastName] & "", "" & [FirstName] AS Expr1 FROM tblPersons;";"tblPersons";"";"person_id";"LastName] & "", "" & [FirstName";"PrimaryKey"oD`cd<efwl n,"";"";"";"";"10";BlobDelta __SRP_19T__SRP_1a   __SRP_1bbsl L1K[v1, 4Xo*a@MIu~68#chDϽc29&CCPxc29&CCPMIu~68#ME$SLS S6LL<(<,<0<4<8<<<N0{F9FE8B63-C268-44D1-9ACF-BDB57F18F2CF} (%L` kpa( e0 % %@l @p @\ @ L @8< @P, @h 44@ -1@ 41@ @ @ 00DG`@$*\Rffff*0740604959*\R0*#1*\R0*#14*\R1*ZpxME (  " L;  p x0oh]#No Matching Records for this Report Cancelling Report$ '\ B@@ B@ B@@XAttribute VB_Name = "Report_rptTags(2x3 1/2 inches)" Basr0{F9FE8B63-C268-44D1-9ACF-BDB57F18F2CF} |GloballSpacI False dCr@eatablTru PredeclaId"Expose_Template DerivCustomizD$Option Comp@ DT` P&* Sub No(Cancel As Integer) Dim strRespdon kMsgBox("No Matching+cords for this3", vbIn maO, "-9l"oCmd.SetWarns (5C Event@(O CZ End @9 @< t]w_ *@d2'#/C=^ڃL<" ӟwjVdDnCHxӟwjVdDnCHd2'#/C=^ME,SLS S6LLLL<0<4<8<<<N0{B54C83DA-3CFA-11D7-96EF-F4220BC10000} (%L `| pa ea8e % %L`k` a( e 0@l 8P 0`2K[v @ @ @ @ @ @ @x ion, s@\ er@L Re@< t@, t@0 r@H rU T(`T &nial_Data_Entry_CrU h Y1 #q$ 1?q?1"100"] DuBۚ^Role2_idRole2_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";"";"Role_id";"Role";"PrimaryKey"mF`a<bcwi k PhoneComp( *xME PSLS S<<<N0{62F18A1C-255A-11D7-96EF-043B0BC1FFFF}  @  0## : 1 % 4%`2`L p%X0@0@@ p0pY@= "  "  "( 60 6h  " 4 "  8H    (   ( 0 @H PX `"hp  x   xoh@oX0================================================0 Capture the record number and save as church_id in tblSelectedChurch Dick Hertel 2 Feb. 2003. 14 Feb. 2003 Added error handler for case of null record.1=================================================x]]]] !' R.:SELECT * FROM tblSelectedChurch'2 2 V :%T.4 4C@ :C@\q 4B@B|o0 B@Bp|h` "!$A@ Ho@8Attribute VB_Name = "Form_fChur chInf@at@ion" Basb0{62F18A1C-255A-11D7-96EF-043@B0BC1F} |GlobalvSpacIFalse dCreatablTru Predecl3K[naId"Expose_TemplateDerivCustomizD$Op Comp@ DT P&A* Sub AfterUpd ()EndClXurrHent'=, ' Capture the record nu@mber a(save as c‚_id in tblSelectedDick Hertel 2 Feb. 2003A14A Add[e@rror h@l cof Cnull(.@:= On BEGoTo_ fCPYDim dbs Asr(rstRGset AstrQPueryS@n6gQ_QIn`teger=0 Me.PVSet = D%Db  SELECT * FROMOa ,=.Open-(F,ADyn.tARWith  ..Edi ![%=_&] m*3c[ A[ .YaExituj.: Ca rrResu?@mkocmd_ClSd@k!C DoCmdkMsgBoxN.Descri# IDK*(M*9xME PSLS S<<<N0{CD925FBC-AFD3-4896-B2EE-656A7B885FFE} JX`n  411i6Hi8 : % < N%`@% A`Ba pi`D$ p`Fand @HL n@JLc. 2@LL@NLn. 2@PLame d0 |p   P0i(KV &i(rs P `n  X pH%pX0P8pX0P HHY@ "   0 P,h   "  .  ,( *X  " 0 6 0( X`hpx       &8P6h     88H P @`  "      " 8.X   4K[v1 @ @ @ @ @ @ @ "  " "   "   ( 8"@ 0Hx 6  "68Ph   xlh]@* Find the record that matches the control. !>!p.n[person_id] = "L$t nB@r n!x (xzP|Hl@z8o0X(======================================== NOT-IN-LIST ERROR HANDLER% Allow user to add to a pick list, by$ popping a dialog box and accept theL new text 16 Dec. 2002 Dick Hertel) Modified 6 Jan. 2003 Changed table name/ to "tblCities" for compatibility to Alphabase.J)=========================================]]]]0]H]`]xpo]0pa] R.:DTPSELECT * FROM tblCities'@ @ V :%T.< Find out what User wants to doo H J L 'FKVCity Not In List'DDo you want to add a new City ? F D$ 'Bm B Nrs <C@X 6:Z 6 (ZVBC@\ <B@BDROqd2 User probably just made a type, return to control !ZB@^k !ZB@`9 Continue without displaying default information message. b'8oPf@ B@Bh(| f "!$A@ ho0~    B@    B@    B@= Paste Appendp|h~` "!$A@ Ho@po0,, B@*o$'oP B@o* Find the record that matches the control.] !>!p.n[person_id] = "T$R$t nB@r n!NG n!x (xjo !Z!\ option "datasheet is chosen !^!`(b !Z!\e !^!`(bkxophgAttribute VB_Name = "Report_Copy of frmPerson_and_Session" Basv0{CD925FBC-AFD3-4896-B2EE-656A7B885FFE} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$OptA Comp@ DT P*. Sub cboFiAfterUpd ()On Error` GoTom`bo34_ Dim rs As ObjecHt ' - the recordat ma tches co@ntrol.Set= Me.RB set.ClonXArs.First "["pid] & Str(Me!:[D5]@2 Bookmark E Exi=7:AK rrA ResuUAKEndC aCity_NotInList(NewnT4ing, ponYInteger@7'=$ ' NOT-IN-LIST ERROR HANDLERAllow user to adk pick l$, by popp$ a dialog box acceptAu new tex@' 16 Dec. 2(002cDHertel Modifi\6 Jan3 Changln@a@"tbl%ies(" fSc!]tibil`(aAlphab`^J#'3XdbXfc[t!41R !strQuery1g5@8E5Tit8;MsgD)C=t MB_ YESNOW4  fICONEXCLAMATIO N8DEFINI!1@0, lID@6A 7!!n!= CurrentDb gSELECT * FROM g/ u#= .Open#(F,ADyn2tVA9bout w hUOwanto do g"{ +!m(  ,B0j In !k3 sgBox("Do you e_a X!?", f, cB BIf g +ThenCWith`##!_.Add`![a aNG= K.gaAA '`a' ,prbly j deytype,turn $c 1d.Un!3A IfGReq`: Ttinue w Q;disyadefault i.nwmage:N= DAT A_ J@.TINUfEQSu)Slt_Cl0Ekokcsea DoCmd _~_ _! $q.Descriw3 `` Dup x_49_35Oy?9}DoMen uItemP[Fo@rmBar,Edit, 8, Ver70C S2'Bcu, 5 'PasApEd v/) _O5K[O>Ot=ISO. =0/ ,aMoveSize 30]BvQ%Dirty(Cancelqk`!eFNow1? ]0R ax^i` X ʏo42/tb/%zA sjp KS˯_Nzҥbo42], 0.)Pq `o.EOF a`1O!-Q`Viewp .Val V= 1'oSD"dshepis chQt+}. `K2YQ2E c?422ono` 3CcU%able 2 V :%T.  V :%T.+ xME (SLS S<N0{C449E677-36A5-11D7-96EF-64190BC10000} ~@i(`%h``Y@ "   xoh`Attribute VB_Name = "Report_rptGroup8Summary" Basf0{C44 "   "8 L;P   @x0oh] B@@s@ o0#No Matching Records for this Report Cancelling Report$ '$8 B@@u B@@(Attribute VB_Name = "dir __SRP_0N___SRP_11 __SRP_2 = 08:<=Babc)e ghij+kQ4:h@$qryAllParticipants&rptAllParticipants2 Arial8)thEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ***C+winspoollEPSON Stylus C82 SeriesuUSB001eriesUSB001d278d eTimes New Romane2g37jghm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp4LastNameFirstName Group`ReportHeader-@X؎Xd25Q`<a<bcXdeLabel10.All Participants Report K P `"PageHeaderSectionvX-LqFr d5Q`<abDcd LastName_LabelLastNameDetachedLabelE~'@t{^cwd5Q`abcd FirstName_LabelFirstNameDetachedLabelbk0 HF4Fd5Q7`abXcd Gr6K[oup_Label GroupDetachedLabel-H >d5Q`abDcd Role_id_LabelRoleDetachedLabelnr@aFӵzп?d5Q`abDcd Role2_id_Label Role 2DetachedLabelCD"p@.f23Q`xab@) Line13á;a@_vyfCm7S`aKb e i ChurchNameChurchNameh!CpGc}d5Q7`<a<bcLabel15Church Name:'TPPG3lo5S`bcdn,"";"";"";"";"10";"100"b}xԟN=ny|spsession_idspsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"d5Q7`axbcLabel16Session:L}huL[guk0`t DetailMNZX')}m7Q`<bDc,i LastNameLastNamex \L}?m7Q`bc,i kFirstNameFirstNameB]MeEbm7Q;`bXc d9Q^ = \TsIfH?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxy{|}~3021) Then'Table is alr@y empty, so no wHorkKdoResume Co@ntinueingE]Sub Y  \ `0* pHdtemplate,@ Z= n G`@ EJ< DAO>BDA@O *\G{000@25E01-0C  0046}#5.0#0#C:\Program Files\Common Microsoft Share d\w350.0DLL# 3.5 Object LibraryHTstdole>fstdole5]f\]04V3[V-]2]WINDOWS\SYSTEM\STDOLE2.TLB# Automation/VBIDE> VBIDECCE157C5.3PVBA \6E6EXT.O+RVisua7K[n)l Basic for Applic1s Extensibility +"*@Form_frmSess1@G]r@m_fSA`ssinPHBQEKNITGQDYDQWXODLBEYEQGVD28AH@N"QMKN@PT(GQQYQWXO@LEY@ QV@MA1B-@B,0Zp"(B+B4Persons4P4r4on@4VQBPHJDXCJUNXDLQZLBLHHRGGCHN4V0(BP'J*XCJU7X@RLZ3LHR3G HOx:@-CQ 4MainMenuG #4Ma@4n"M`nu5APEHKLAMKGSRDJNFINHDCGCTOXL5A`EKAK`S DNF7ND5!T7X M))ReportSelUbP.Rpt6Qc@iREIULEKETFEVVNDQBNHUIFNVECMTCMCE@U@EK NT@EV N8Q QU`F6V C!aOPOLQ!C_rptE8He`lpG,a(_-mpM9H`lpD:ZNWIPB LJYLPLQNNFGIXJUPZEKHZWUP`L8Y`PU&TUNFjz$tj_@,n_.A1g$FDMPJFKAJNABBETHUCYYJRCPJQCWt[F,MU,J4K,J@=AUPBH@Cp YU?RJiCL/o/'D/ ;4_Chu`rchIn G4_hhrch0*n0?a \LJAIRXEXRMKWYDSSCCGJBGYWOCK4LA0RE0RVKP ASCGB CP\W jY.UB/S3@,9+UtWB/U;l-t@# BYFWKCFRRJYVXp[MEHYGEGDPFGPECBbWU*C`KR@ JVBq[M H{MQP0/ NOKrbx/ GEmailAddrU e0rt0mZY`_W`K`IL`C@!/0<2x3 1/2 IOHZLGKWTFXOTDRDWUQYISBNQVQUIH"GW:!OD $D VU!S !N`V%`D>o!a]"o!a]"rU D(` &nam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC98K[v1A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office10\MSACC.OLB#Microsoft Access 10.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE AutomationZ*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 G`@ *8PHBQEKNITGQDYDQWXODLBEYEQGVD1=4059b9fcForm_frmSessionZp8VQBPHJDXCJUNXDLQZLBLHHRGGCHN014066a4413Form_frmPersons: 8PAPEHKLAMKGSRDJNFINHDCGCTOXL1O4059bba8 Form_frmMainMenu0M)8EIULEKETFEVVNDQBNHUIFNVECMCM02405ddffa.Form_frmReportSelectionLHP8ZNWIPBLJYLPSTDLQNNFGIXJUZEKH01405dd434e,Report_rptMainMenuHelp6`R8ILGEDVNTSQRVZDTPORBADYERUYGJ024066aeddiDForm_frmGeneric_Report_Preparationx- 8JCPICTKVYHCSXDZCZOBLNKBRLUBC1D4059b9fc*Form_frmPersonSession 8TZVBDW_UOETGZDROTXORNMYZFXOG04405de0252Form_frmPersonSession_sub8FDMPJFKAJNABBETHUCYYJRCJQCWL1F4059b9fc>Form_zfrmPerson_and_Session_org'Do8LJAIRXEXRMKWYDSSCCGJBGYWOCKL1G4059b9fc4Form_frm_ChurchInformation 8WOYZZU_ANLOGRDCACGPDGSAOFKJL08405def07,Form_frmBuildNamedList<8PNAPGKMRYFDLXDYCUFQPDKMLSAYD03405de025I4Form_frmPerson_and_Session>8LYDYUMHICTBXAECRWAPGEKYCUGBJ1J4059b9fceHReport_Copy of frmPerson_and_Session9 S8BYFWKCFRRJYVXDROMEHYGEGDFGPE1N4059ba3dgForm_frmUtilityrx8N 8UNBOJLFAQZZLMDSIIYSQDXZRJYXF0:4066fcf1}0Report_rptEmailAddresseshP8MNYNYV_FXGYIHEXDQAWSFLKFDTGD1L4059b9fc8Report_rptGroupReportSummaryh8KJOMJKJOGSIEFENNXUFJGJPRGMAL0340604925LReport_rptGroupReportSummary_Condensed 8QHDAYQGIVLXCDENEAAXJITM9K[n)NTYMJ0;406049f26Report_rptNameTags(3x4inch) 8NHLRSFFYVXRMVDIKYQWOKKIBLWCC0D406047da.Report_rptAddressLabelse 8IOHZLGKWTFXOTDRDWUQYISBNQVQD0740604959DReport_rptNameTags(2x3 1/2 inches)aHh`0xP 8I&K3<*~;t0DΦ4U?lLLJdruDXD-}FBZhS$k+J7|z\C9"b>_5lO p@<NޏEE}9[G{EJBJRzh6lKs#ԍ?I K-W^On]G>5ye%B=2x~#>aK|SLS S<N0{8BE2A5B5-2009-11D7-96EF-44410BC10000}  @ &i(%(@@@Y@ "  ( HP X`p x "  0 xh B@BOGR frmMainMenu B@MIC0|( "!$A@ .o@4! B@** Move to most current Session as a default . frmSession 0 B@,oAttribute VB_Name = "Form_frmSession" Bas0{8BE2A5B5-2009-11D7-96EF-44410BC10} |Global!SpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Opt Comp@ DT P&* Sub TCl?__Click() On Error GoTo_* DoCmd. Open- "Mai nMenu Exit*:!*# MsgBox+.Desc riBResuπZC &ndE LH4 E^`:S?r@¬b`|0MWSr@$`\8KcCԸ`AccessAnd As  Close.Debug=Dim@DoDelseEelseifGEndHendif^Goto_ifbinyLoop{MeonOrResumeSELECTSubthenUntilwithVBAWin16~Win32MacVBA6#templateDAOstdole`VBIDEAForm_frmSessiony _EvaluateClose_Session_Form_ClickErr_Close_Session_Form_Click%DoCmdƧOpenFormExit_Close_Session_Form_ClickMsgBoxRErro Description  Form_Open-CancelMoveSize@ GoToRecordM6 acDataFormacLastForm_frmPersonsCity_NotInLists:NewDatax_ResponsedbsǂrstCity Recordset strQuery1NewCityTitle~ MsgDialogFMB_YESNO<:K[v1 @ @ @ @ @ @ @MB_ICONEXCLAMATIONyMB_DEFINITION1gIDYESaIDNO& CurrentDbS OpenRecordset| dbOpenDynaset AddNewaCityDUpdateUndoÞRequeryDATA_ERRCONTINUE Close_ClickErr_Close_ClickExit_Close_Click/ Combo34_AfterUpdatexErr_Combo34_AfterUpdate?rs_Clone FindFirstM=StrCombo344&BookmarkCExit_Combo34_AfterUpdateDuplicate_Current_Record_Clickõ"Err_Duplicate_Current_Record_Click# DoMenuItem&e acFormBar acEditMenu acMenuVer70X#Exit_Duplicate_Current_Record_Click Form_Close[Form_frmMainMenucmdRoles_ClickErr_Open_frmPersons_ClickFExit_Open_frmPersons_Click Form_Load{Open_frmPersons_Click$z stDocNamezstLinkCriteriaYMinimizeoOpen_frmChurches_ClickErr_Open_frmChurches_ClickExit_Open_frmChurches_Click.Open_frmSession_ClickErr_Open_frmSession_Click?Exit_Open_frmSession_Click|NRun_Reports_ClickErr_Run_Reports_ClickExit_Run_Reports_ClickCustomize_Click=Err_Customize_Click stMsgText[BChrK~ vbInformationnExit_Customize_Click}Enter_Person_Session_ClickErr_Enter_Person_Session_ClickExit_Enter_Person_Session_Clickۃ Help_ClickAErr_Help_ClicknQ OpenReport acViewPreview2MaximizeFyExit_Help_ClickRComprehensive_Click_Err_Comprehensive_ClickExit_Comprehensive_Click About_Click$Err_About_Click' acPreviewoExit_About_ClickJ6Build_Named_List_ClickErr_Build_Named_List_ClickTExit_Build_Named_List_Click#~Form_frmReportSelectionH^Command2_ClickstMsgGReport_1_Click4Err_Report_1_ClickExit_Report_1_Click+Generic_Report_ClickxErr_Generic_Report_Clickx itResponseԧ cbo_SessionSetFocus intResponse vbCritical+}Exit_Generic_Report_ClickGroupReportSummary_Click0Err_GroupReportSummary_ClickExit_GroupReportSummary_ClickOption13_AfterUpdatezZReportByRole_ClickNErr_ReportByRole_Click[Exit_ReportByRole_ClickRPNameTags_3_x4___ClickLErr_NameTags_3_x4___ClickExit_NameTags_3_x4___ClickHNameTags_2x_3_1_2_inches__Click+#Err_NameTags_2x_3_1_2_inches__Click$Exit_NameTags_2x_3_1_2_inches__ClicktAddress_Labels_5160_Click|Err_Address_Labels_5160_ClickExit_Address_Labels_5160_ClickFcboPrint_ClickErr_cboPrint_Click cboReportsKQExit_cboPrint_ClickXcmdNamedList_Click*Err_cmdNamedList_ClickExit_cmdNamedList_Click.RSendEmail_ClickErr_SendEmail_Click stResponse/XstrQueryM?rststrEmailB$ strFirstName strLastNameK strOutput9c vbOKCancelx? SetWarnings WarningsOff vbYesNoCancelq OpenQuery acViewNormal RacAdd dbReadOnlyEOFEmail FirstNameLastNameMoveNextL!Exit_SendEmail_Clickj!Attendance_Click?Err_Attendance_ClickacNormalacEditIExit_Attendance_ClickҋReport_rptMainMenuHelpW<Report_Activate"Form_frmGeneric_Report_PreparationpDefine_Report_Conditions_Clickx"Err_Define_Report_Conditions_ClickacTable OpenTable!#Exit_Define_Report_Conditions_ClickTEdit_Report_Header_Click_Err_Edit_Report_Header_Click=Exit_Edit_Report_Header_Click]Display_Generic_Report_Click9 Err_Display_Generic_Report_ClickstQueryF stCondition2<off!dbedit^T MoveFirstNIsNullSearch Condition TwoEdit+ acReadOnly!Exit_Display_Generic_Report_Click#&Close_Generic_Report_Preparation_Click*Err_Close_Generic_Report_Preparation_ClickQE(Exit_Close_Generic_Report_Preparation_ClG Form_GotFocus SelectObjects^acFormmsgtext9 current_text strSearchM;K[Help_ConditionP Help_Message Copy_Records_To_NamedList_Click#Err_Copy_Records_To_NamedList_Clickه rstSourse rstTargetE strQuery2strMsgG& strResponseOstrTempMErr_No_Target_Record Clear_Named_ListjDeletex rstSource[ Last_Name First_Name?StreetAddressStateZipm$Exit_Copy_Records_To_NamedList_Click;Number-Form_frmPersonSession6Close_PersonSession_Click˗Err_Close_PersonSession_ClickExit_Close_PersonSession_Click"spperson_id_ChangelForm_frmPersonSession_sub Form_DirtyPForm_zfrmPerson_and_Session_orgjForm_AfterUpdate tblPersons} DateUpdated"Now%Form_frm_ChurchInformation Form_CurrentErr_Form_Current record_numbertX Church_idZSelected_Church_idExit_Form_CurrentKcmdClose_Click!PErr_cmdClose_ClickExit_cmdClose_ClickForm_frmBuildNamedListCombo1_AfterUpdateRecordsetClone8Combo1Add_To_Named_List_ClickErr_Add_To_Named_List_ClickDmsgQ person_idf Named_ListExit_Add_To_Named_List_ClickNCombo26_BeforeUpdate Combo26_ClickX selectionZCombo26&NLCID] Full_Name , Label_Coded Desc_ListReset_Named_List_Click=Err_Reset_Named_List_ClickExit_Reset_Named_List_ClickdSave_Named_List_ClickZErr_Save_Named_List_Click`rstDescription y strQuery3found+InputBox GIDƓExit_Save_Named_List_ClickGet_Named_List_Click fErr_Get_Named_List_Click Exit_Get_Named_List_Clicks;Copy_to_Email_ClickErr_Copy_to_Email_ClickstQuery2B[Err_Copy_to_Email_Click2#Exit_Copy_to_Email_ClickForm_frmPerson_and_Session8cboFind_AfterUpdate(|cboFindDateUpdated_BeforeUpdateҜCombo42_AfterUpdatemNzu^Combo42W&frmPersonSession_EnterfrmSubView_AfterUpdatew frmSubViewValueKfrmPersonSessionForm DefaultViewշ$Report_Copy of frmPerson_and_SessionCBForm_frmUtility.GetExcelData_ClickjErr_GetExcelData_Click1v[stExcelPathAndFilemJErr_GetExcelData_Click2w[ CLEAR_PERSONSErr_GetExcelData_Click3x[TransferSpreadsheeteacImport+sacSpreadsheetTypeExcel7Exit_GetExcelData_ClickReport_rptEmailAddressesl Report_OpendReport_rptGroupReportSummaryk&Report_rptGroupReportSummary_Condensed  rstTargerEstrGuesti strFullNameAAstrPreviousGueststrPreviousFullName strLeader1 strLeader2• strLeader3Õ strleader4ĕ intLeader intSessionX\intGroup(Err_Report_ClickContinue_Reporting"Guest FullNameОLeaderj spsession_idXGroupLeader1Leader2Leader3Leader4Detail2Label0,Open_frmPersonsɔOpen_frmChurches_`Open_frmSessionR Run_Reports$Helpf ComprehensiveAbout)Build_Named_List OLEUnbound16\IEnter_Person_Session(cmdRoles sClick FormHeader person_id_LabelPhone+W Phone_LabelPhone2 Phone2_Label& Email_LabelChurchM Church_Label֝Comments)Comments_Label+ DateAddedDateAdded_LabelG&DateUptated_Label3RfrmPersonSession_LabelYTLine39 FormFooterTFind_Person_Label^Option51eLabel52Option53eLabel54Phone3Label55 AfterUpdate NotInList BeforeUpdate6CurrenteDirtyVGotFocusKEnterspsession_id_LabelRole!T Role_Label\Role2k Role2_Label[w Group_LabelLHAgegs Age_LabelK Childcare Childcare_LabelZCelebrationDinner@CelebrationDinner_La<K[ @ @ @ @ @ @ @bel HSWeekend~HSWeekend_Label CompletedCompleted_LabeluRelationshipIdRelationshipTypelRelationshipType_LabelDateUpdated_LabelPRole_idGRole2_id+tblPersonSession.CommentsEtblPersonSession.DateAddedtblPersonSession.DateUpdatedtblPersons.CommentstblPersons.DateAddedtblPersons.DateUpdatediGsessionperson_idα spperson_id Num_ChildrenxLabel33ChildAgeyLabel34Course_LocationeLabel35ControlsKItemz _B_var_Str Title_LabelFirstName_LabelLastName_Label Address_LabelT City_Label State_LabelYJ Zip_LabelxDSearch_Name_Label}Duplicate_Current_Record  DateUptated~ALabel37City_BeforeUpdateRelationshipId_NotInList~kRelationshipId_BeforeUpdateŚ NewPersonِ _B_var_Exit Temporary_B_var_NewCity: _B_var_CityqCollect _B_var_IDYES%OpenViewIMoveLastacActiveDataObjectacnomal9acnomaacnomacnoacnrac}\AXstdocnamI%stdocna0stdocnO_stdocIstdo^3stdst(_sjOpenFors_B_var_GoToRecord _B_var_IfPOpenArgsBeq]Generic_Report5Option13dLabel14DNamedListEnabledSession_Selection_LabelycboReports_LabelMcboPrintLabel23h cmdNamedList5 SendEmail Attendance NewRecord_B_var_Response *_B_var_Exit_Duplicate_Current_Record_Click)_B_var_Err_Duplicate_Current_Record_Click,Move>yMov̴OnOpenacNewPhone_LostFocus LostFocusMS strPhoneNumbstrPhoneNumberIncoming8LastName_BeforeUpdate strAreaNumber) strPrefix strSuffix strAreaCodeB} _B_var_LeftQstrPhone _B_var_MidpstrNewPhoneNumber strSeparator) _B_var_Chr\;InStrstrPhoneNumber?_B_var_InStrstrPhoneNumberCXo_B_var_X_B_var_strTempP intPosition^_B_var_intPosition@ inPosition_B_var_inPosition+ intPosition1 intPosition2 inPosition1Phone2_LostFocusPPhone3_LostFocuslengthY _B_var_length> frmPersonsE_B_var_frmPersonsp( GoToRecordldacNewRecYRequer4sessionperson_id_Label|spperson_id_LabelnRelationshipId_LabelClose_PersonSessionChangerel msgbt _B_var_msgbacDialoga_B_var_cboFind,!FormsfrmPersons_and_Session<_B_var_frmPersons_and_SessionUfrmPerson_and_Session_B_var_intResponse Define_Report_ConditionsڝEdit_Report_HeaderXDisplay_Generic_ReportULabel5,Label6,Label7, Close_Generic_Report_PreparationCopy_Records_To_NamedListœ _B_var_off2{ _B_var_dbedit_B_var_Search Condition TwoKFields7_B_var_WarningsOffS  _B_var_Emailg_B_var_FirstName_B_var_LastNamec strPhone2'ScreenI strPhone3'StdFont} _B_var_Phone _B_var_Phone28 _B_var_Phone38IIfzReport$PageHeaderSectionwLabel3,Label4,Line6PageFooterSectionText8~ strHeader strTrailerIImport_from_AlphaBase> GetExcelData{[Label1,Import_from_AlphaBase_ClickJ&Err_Import_from_AlphaBase_Click Exit_Import_from_AlphaBase_Click} RunCommand` RunComman: DoMenuIte strRepsonse_B_var_strResponse0 acDatabaseacFileacGetExternalData4_B_var_acDatabase{_B_var_acGetExternalData7o&_B_var_Err_Import_from_AlphaBase_Click-younamelych\cZErr_Import_Click2AErr=K[&_Import_Click1@Err_Import_Click3BRunMacroXExit_Import_ClickErr_Import_ClickTransferDatabase)acReport%strDBpath_and_Filename$inbox _B_var_inboxzmsgbo _B_var_msgbo| _B_var_msgbrFile%wilwillJbe\ _B_var_beL CLEAR_SESSION Err_Import_Click4CIMPORTivmCLEAR_PERSON_SESSIONh strQuery4 strQuery5 _B_var_OpenltblPersons_imported1FROM~ _B_var_A DO_APPEND72 DO_IMPORTh_B_var_Exit_Import_ClickErr_Import_Click5DD[_B_var_D_B_var_DO_APPEND+docmeǧ _B_var_docmek DeleteObjectT CLEAR_CITIES5Err_Import_Click6E CLEAR_ROLES.)Err_Import_Click7F CLEAR_CHURCH&Err_Import_Click8G PersonSession_B_var_PersonSessionActivate| Maintenance !Maintenance_ClickErr_Maintenance_ClickExit_Maintenance_ClicklErr_Import_PersonSessionP,Err_Import_Persons)Err_Import_SessionErr_Import_Cities9rErr_Import_RolesErr_Import_ChurchInitial_Data_EntryInitial_Data_Entry_Click[Err_Initial_Data_Entry_ClickesExit_Initial_Data_Entry_Click strReponseOstrMdg$ _B_var_strMdgŞ_B_var_strQuery2_B_var_strQuery3 SEARCH_LabelText3~Last_Name_TextAdd_To_Named_Listd Label16FReset_Named_ListQ  Copy_to_Email4_B_var_First_Namez_B_var_Last_Name0_B_var_person_idZo _B_var_Street/t _B_var_State% _B_var_Zip~ _B_var_TitleBInDatabaseWindow_B_var_InDatabaseWindow̍_B_var_Err_Attendance_ClickTstrPathlthe'Firstz _B_var_First> _B_var_Doendwith;_B_var_endwith _B_var_EndFSourceG ChurchNameacQueryh directorymGwhicharet executing~ AlphaBase_B_var_AlphaBase"$_B_var_NamedListEnabledPrst2jstDestination_msg iReport_rptNameTags(3x4inch)v"Text2~Text4~erros=onerrw2 _B_var_onerrOnErrorMESSAGE_B_var_MESSAGE# _B_var_On6_B_var_strQueryU _B_var_dbs?Count0v _B_var_Count:OpenQuerx qryNameTag'qryNameTag_Count4TotalU _B_var_Total RecordCount{_B_var_qryNameTagRm_B_var_qryNameTag_Count.URunSQLSQL"qd^QueryDefdb\ _B_var_db QueryDefs& _B_var_rsFindLastzAbsolutePosition~ CopyQueryDefcReport_rptAddressLabelsZ Report_ErrorDataErr6 Report_NoDatayNoData CancelEventURdecmd _B_var_decmd  WarningsOn_B_var_WarningsOn] ReportHeaderŃLabel10@Line139Label19I Guest_LabelW} Leader_LabelLine14:Line15;Text11rText12r ReportFooterR.Text20r_B_var_rstTargetO _B_var_Guest._B_var_FullNameYv _B_var_Leader"_B_var_spsession_ida _B_var_Groupճ"Report_rptNameTags(2x3 1/2 inches)ŽText5~Label8,nto^Label13C8  *,}  ei3  I   e g +!4h>K[v +ThenCWith`##!_.Add`![a oaNG= K.gaAA O`a' ,prbly j deytype,turn $cc d.Un!3A IfGReq`: Ttinue w(Cancel As Int0egerL@MoveSize 4H00,855300 '  to most current a as a default  CA`Record acr!,S ",@Las .a8eT[*h `@1yMA1Be}bN*Cv5xME SLS S<$<(<<<<< <,<0<4<8<<<N0{4AAE9FA9-6B51-11D7-96EF-44310BC1FFFF}@ ~`X@@p i(  `%h %| %Pl Jj h  X (0``Ltp  "  4 $Hp F(+$+@ 4 px. Run the Query to update the AddressBook table April 17, 2003 Dick Hertel  B@@qryNameTag_Extract H J B@F. (Above line creates and loads tblAddressBook)o?DoCmd.OpenQuery "qryExtractEmailAddresses", acViewNormal, acAddr jqryNameTag_Extract B@BAttribute VB_Name = "Report_rptEmailAddresses"  Bas0{4AAE9FA9-6B51-11D7-96EF-44310BC1F} |GlobaBltSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT 0 P&* Sub Open(Cancel As Integer) ' Run the Query to 8upd Book April 17, 2003 Dick Hertel DoCmd.SetWarnings off C4"qry@ExtracMz, acViewNormalA!C pTag_"9Clb,  7(Above line ces and loads tbŤEP EZ  Book April 17, 2003rU l$`l $A`p $`t $`x DrL*6H Ƴ]AkTyRbZ%; HVR+)LoۖxH,i k Group GroupoKA"}׳o5Q`ce f,l n,"";"";"";"";"10";"100"(lEqiRole_idRole_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";""h Ax   NewD?K[j% @ @ @ @ @ @ @ataresponse aResponse ( iK G ?  DataErU ( {nw{@4iKQKppp@8iKQKvvrr#,5(lTF%:%,hi@` tr@ . @ e,@ od80 DG`@$*\Rffff*0D406047da*\R1*#25*\R1*#98*\R1*#99*\R0*#14*\R0*#1*\R1*#98*\R1*#254p8$+*xME (S<S<S<<N0{C449E677-36A5-11D7-96EF-64190BC10000}K*m       rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~O ;^~B >d  a  !a  .-)3Y3a o 9qAak a 9,))) *I****1+q+++ ,9a  LIoqa  ><<!=i=) A=a    ) #!1qa  > 1;"Role_id";"Role";"PrimaryKey"o5Q`ce4f,l n,"";"";"";"";"10";"100"bΘGہ¨4Role2_idRole2_idTable/Query߆SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles; 0;2880"SELECT DISTINCTROW tblRoles.Role_id, [Role] AS Expr1 FROM tblRoles;";"tblRoles";"";"Role_id";"Role";"PrimaryKey"m37QF`'a<bc,i k Text17=1ЬO)foժ`"PageFooterSectionGɠZJDDÍ(m7Q;`<abc Text11 =Now()Long DateV t/C6Dcm7Q;`abck Text12H="Page " & [Page] & " of " & [Pages]P '-xI#f3S`<ab$ Line14;|ŪuBItD2`ReportFooter43{ K-kR@K[v1aх 1ia I ) Q-)3Y31qA yzM N9z Ia yz;aa 1Ia 1  Form_frmSessionForm_frmPersonsForm_frmMainMenuForm_frmReportSelectionReport_rptMainMenuHelp "Form_frmGeneric_Report_PreparationForm_frmPersonSessionForm_frmPersonSession_subForm_zfrmPerson_and_Session_orgForm_frm_ChurchInformationFormosite_Phone8+*K H *m3F`<a<bc,i k Text36=1Cd%GnBi0`GroupFooter1?K+xI!^I`:"PageFooterSectionDO6ЊHQ{aUam;Fabpc Text15 =Now()Long Dateqϴ|GdN,Fy.I09O Q" x frmPersonSession0ЕrG~ nX0gAJ.whzxbZ%; "\RA|*sessionperson_id spperson_idBK[Close_PersonSessionH=Dab\;|? RelationshipId ,frmPersons_and_Session @Need to requery about right here Combo34 *frmPersonsSession_sub퓽[O\K_: *RequerycboFind(aN?+UIEf. >Make a Session Selection first. :frmGeneric_Report_PreparationmvHH$(z&.NM*\XMR_U&D1 T(McsHhDDefine_Report_ConditionsEdit_Report_HeaderDisplay_Generic_ReportLabel5Label6Label7 Report_Open  Close_Generic_Report_PreparationCopy_Records_To_NamedListDefine_Report_Conditions_ClickEdit_Report_Header_ClickDisplay_Generic_Report_Click &Close_Generic_Report_Preparation_ClickCopy_Records_To_NamedList_Click l DSELECT * FROM tblSearch_Conditions (Search Condition TwoSm. *Qm. Con2= aC7? PqryGeneric_Search_On_Comments_Criteria_2 :rptGeneric_Search_On_Comments (tblSearch_Conditions 0tblGeneric_Report_Header Q0  pOutput file name to receive the email addresses will be: 0qryExtractEmailAddresses Lc:\My Documents\Alpha_Address_Book.txt FILE OUTPUT 2OK, Cancelling the action Skip It pAll current session members? (If NO, then use Named List Email Source dSource will be all participants in current sessionWC7?Report 8SELECT * FROM tblAddressBook 0.\Alpha_Address_Book.txt Email FirstName LastName , Phone Phone2 Phone3  Q  BL@u53"oH\'ЗC6j)JQkD1 %/M@niz?PageHeaderSectionPageFooterSection L E: , N: , TEL: N:q[1M.9梌N3B@ڬihDA ;v~;>I`t GetExcelDataLabel1Import_from_AlphaBaseGetExcelData_ClickImport_from_AlphaBase_Click P- This will clear out several tables in current Database File, do you want to Continue ? WARNING Response was =  Database File "Get External Data Import? This will clear out several tables in current Database File, namely those that will be imported, do you want to Continue ? >Made it through import, hurrah!aAkXMW_wm xThis will clear out several tables in current Database File,# namely those that will be import targets, do you want to Continue ?˙Afa<;(b@8~]we Rnamely thoseCK[LßKŸ%(I that will be import targets. 2Do you want to Continue ?~ZM 9߰#n$Ak* <SELECT * FROM tblPersonSession 0SELECT * FROM tblPersons HImport_Tables_From_Existing_Database \Give full path and filename of SOURCE database Source Database File will be = Microsoft Access tblPersons rptAbout <Import_Tables_From_Existing_DB QT  &tblPersons_imported 0SELECT * FROM tblSession tblSession &tblSession_imported tblPersonSession 2tblPersonSession_imported (tblPersons_imported1 frmUtility( INSERT INTO tblPersons SELECT tblPersons_imported.* FROM tblPersons_imported;( INSERT INTO tblPersons SELECT tblPersons_imported.* FROM tblPersons_imported 2qryAppend_ImportedPersons 4qryAppend_Imported_Persons 0Bad Import of tblPersons (tblPersons_imported2 (tblPersons_imported3 (tblPersons_imported4 (tblPersons_imported5 (tblPersons_imported6 (tblPersons_imported7 (tblPersons_imported8 pc:\Documents and Settings\All users\Documents\Source.mdb/DkD_i? 4qryAppend_Imported_Session tblRole tblRole_imported tblCities $tblCities_imported tblChurch $tblChurch_imported @qryAppend_Imported_PersonSession tblRoles "tblRoles_imported ,SELECT * FROM tblRolesMaintenance_Click .SELECT * FROM tblChurch 0qryAppend_Imported_Roles 2qryAppend_Imported_Cities 2qryAppend_Imported_Churchq Z<NorޔrBhD)_K<9>eCG rptMainMenuHelpQn,E+͈dC|AGG#( ,bZ%; ~RCGďo(1Report_Activateg-qLNjLYWeGS+y Maintenance x $qryAllParticipants LImports data from an Excel spreadsheet (to Table tblPersons. <------------------------------ RSpreadsheet MUST include following fields Bwith the exact spelling as shown. Address State ZIPqFSuu &Phone2 (optional) &Email (optional) &Comments (optional) &Church (optional) <WARNING -- This WILL clear out 8existing contents of Tables  @tblPersons and tblPersonSession. 6OK, Cancelling the action. HVR+)LoۖDK[vSmD_N7NcnUAiay xSpecify the full path and filename for the Excel source file "Source Excel File>AE4;,vwsCR,Z˳Y:YCh 6"IO9`yInitial_Data_EntryInitial_Data_Entry_Click T zThis will clear out all the data in the existing (demo) data BI7[M~J Ƴ]AkTyR @to prepare to receive your data. `DO NOT RUN THIS IF YOU HAVE DATA ALREADY LOADED, 2YOU WILL LOOSE YOUR DATA. Proceeding Aborting" This will clear out all the data in the existing (demo) database .Do you want to proceed? XH;Eԋ>Y H Xoa{1CuSNdJ E'䕗-\ @$id{" @_\`YA9@J2#.t6GR`ɯE}^(y0 BEGIN:vcard VERSION:3.0 END:vcard (EMAIL;TYPE=INTERNET: TEL;TYPE=VOICE: "frmBuildNamedListY= ~B'6hLGbn'O75 oGə{m!Combo1KC7? Named_ListText3Last_Name_TextAdd_To_Named_ListLabel16Reset_Named_List Copy_to_EmailCombo1_AfterUpdateAdd_To_Named_List_ClickCombo26_BeforeUpdate Combo26_ClickReset_Named_List_ClickSave_Named_List_ClickGet_Named_List_ClickCopy_to_Email_Click# This action will clear out the current email list in this database $Replace Email List Skip it 4SELECT * FROM tblNamedList First_Name Last_Name 6qryLoad_AddressBook_OutlookOpenQuery Combo1 person_id Street Zip TitleZ;|? ,tblAddressBook_Outlook DataBase Export# c:\Documents and Settings\All Users\Documents\Alpha_AddressBook.xls ,Have exported to Excel Tables 8tblAlpha_AddressBook_Outlook{%㬉3Cٽ "Attendance Inputs >Export_Address_Book_for_OutlookK}UF-PZ D{{FrPNZԋS `Specify path to directory to which you want both Tthe Excel file and the text file exported. PATH Zc:\Documents and Settings\All users\Documents bOutput files receive the email addresses will be: <Named List items will be used. \c:\My Documents\Alpha_Address_Book_Outlook.xls 8Using Named LIst information 6qryNamedList_to_AddressBookٔc(GOQq ssDGB7BD aOr:W(xեDpA vBdҝ $qryNameTag_Extract4dKqҗ&EK" Jc:\My Documents\Alpha_AddressBook.txt Zc:\My Documents\AlphEK[a_AddressBook_Outlook.xls pin the directory from which you are executing AlphaBase. ,SELECT * FROM tblFlags NamedListEnabled "Select Named List .Select All Participants ..\Alpha_AddressBook.txtIĥ6d  fAll participants from current session will be used. DSelection will be from Named List. pSelection will be all participants from current session. fOutput files receiving the email addresses will be:Report_rptNameTags(3x4inch)XMg1܀dMvls}=Ir"Ml;AN|/  fMay be no records that match the selected criteria. NO DATA!Q>G9~i؀.Ne!U <SELECT * FROM qryNameTag_CountOpenRecordset&HXR JۡɋM6 4ύL3 [w6@"=N> Count `No records match the current selection criteria.  qryNameTag_Count qryNameTag_Count tblFlags*ơ2t!P dSELECT COUNT(*) FROM qryNameTag_Extract AS [Count]QueryDefsym. Record count = RecordCounta. kDpX)$uI:u?d>yVER~Report_rptAddressLabels2k!B:o>-c:c3Hd1ֳJSڃL<" N:D`[]O| Report_Error7jmC yM*."u^gH%"e Report_NoData We have no data. FNo Matching Reports for this Report "Cancelling Report_/{ܲDح=d2'#/C=^ӟwjVdDnCHbIM7pЌ?b@@3kw< cnDA M#Nk=`E ReportHeader ReportFooter 6qryGroupReportSummary_table FSELECT * FROM tblGroupReportSummary ZSELECT * FROM tblGroupReportSummary_condensedEOF DeleteMoveNext None Guest FullName Leader spsession_id Group AddNew Leader1 Leader2 Leader3 Leader4 Update "Report_rptNameTags(2x3 1/2 inches)Lߛ)mIK=hMIu~68#chDϽc29&CCP FNo Matching Records for this ReportvvKO_~7+JW&G/@*@vMo(lHT2Iw =Q%%crFon>= "LDn#gmztBaM eB*.)PAJKDfw5@k!-" pxwAUL#mβ=a[D<_psq#iCKyh#Q `@1yMA1Be}bN*Cv5]* Find the record that matches the control. !>!p.nql[person_id] = "v$t nB@r n!x (xz|lz @i(<`%h`` " FK[v  xoh`Attribute VB_Name = "Report_rptGroup8Summary" Basf0{C449E677-36A5-11D7-96EF-64190BC10} |Global!xSpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  P&* Sub Open(Cancel As IntegeDr)End $+g*hxME (S<S<S<<N0{4AAE9FA9-6B51-11D7-96EF-44310BC1FFFF} @ i(6`%h``  "  4 $Hp F($ 4 P`x. Run the Query to update the AddressBook table---- April 17, 2003 Dick Hertel  B@|?DoCmd.OpenQuery "qryExtractEmailAddresses", acViewNormal, acAddqryNameTag_Extract   B@ qryNameTag_Extract B@B. (Above line creates and loads tblAddressBook)oAttribute VB_Name = "Report_rptEmailAddresses"  Bas0{4AAE9FA9-6B51-11D7-96EF-44310BC1F} |GlobaBltSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT 0 P&* Sub Open(Cancel As Integer) ' Run the Query to 8upd Book April 17, 2003 Dick Hertel DoCmd.SetWarnings off C4"qry@ExtracMz, acViewNormalA!C pTag_"9Clb,  7(Above line ces and loads tbŤEP EZ zzz\(eU *xME P( D*rxxME PS<S<S<>LLLLLLLL ` o >>3`x`0t`~p`Bl :h % d% `%@%p@hhp@hhP%8%@x XpP 8 > RV"2@ P ON@ @ 2 @( 0 @@ @X  W@p @ us@ s@ SO  `er%  St@ er `% &od@ @ @ P h 8  " @x *@ h h@d 16IE@ T @ D @ 4 @ $ S@ Se@   x@ x @h @Hd @`T @0D @4 @0 @ 0HRV IK[jZ@d @`T @xD @4 0`% @8 D "  @ @P @h @ (X8P RV " @d @hT @D @4 0`%@. @( @ @0 @H @  lY@$*\Rffff*08405def07*\R2*#24*\R2*#2e*\R1*#99*\R1*#98*\R1*#25*\R0*#1*\R0*#14*\R2*#0*\R2*#28*\R2*#29*\R2*#2a*\R0*#13*\R0*#19*\R1*#c1*\R1*#39*\R1*#5e t4p8~<@xDzH|LrPTX\`q " 0*VH$x "    "'  ($0$8$@$H$P$X$`$hApx      <  "    "      `0  ( "  ( 0 8@H PX ` p           & HP X h x  "  "     "'0  HP  X  `hp x  < "  (.@   p PZ (0Xpx   "      0 @ P ` p     & &, P Dh        JK[ @ @ @ @ @ @ @        .  H  X  `  p  x            "      ( 0 8   @ PP (       (  0 8 @ H P  X  h  x            & @ H  P  `  p        "   )    < " ( 08@HPX` h 2r88+H`h  4p$ '2 8 @H  P  X`h  Dp @"'  8 HP EX h :x : :   $ &8@H<P` hxxp* Find the record that matches the control.[person_id] = " !B@r !!x (xoh@X]]]]] R.: %SELECT * FROM tblNamedList'2if 2 V :%T. C@X :  : : : Z:Z : : D:D P:PC@\qx B@``|XP "!$A@ 8o0o h]]]]] ]8]P R.:Yselection = InputBox("Enter 1 or 2 to specify which Named List to use ", "NAMED LIST", 1) !!d'SELECT * FROM Named_List_ '@ @ V :%T.SELECT * FROM Nametag_Prep'  V :%T. 5NaC@C@Vq 5Na B@X6 )6 )6 )6 )6 )6 )6Z )Z6 )6 )6 )x B@\C@V move through source tableq B@B B@B B@` B@`o`h B@o@$0]]](]@]X R.:SELECT * FROM tblNamedList'@ @ V :%T. 5NaC@C@Vq B@`&p|h$` "!$A@ &Ho@p*0]]]]]0]H]`]x]] Description of Named List] Flag that record has been found R.:0Enter 1 or 2 to specify which Named List to use NAMED LIST$2''Enter descriptive title for Named List NAMED LISTSpecial Named List$2'$SELECT * FROM Named_List_ '@ @ V :%T. 5NaC@C@Vhq`SELECT * FROM Nametag_Prep'  V :%T. KK[5Na B@X X )6 )6 )6 )6 )6 )6Z )Z6 )6 )6 )64 )4 B@\C@V move through source tableqstrQuery3 = "SELECT * FROM ABC"$SELECT * FROM Named_List_Description'. . V :%T.,>Set rstDescription = dbs.OpenRecordset(strQuery3, dbOpenTable)'0 ,5Na6 XC@ $:$C@\'0xkC@V( Cover case were selection is new number 0C@X X: $:$C@\kxqp B@B B@B B@`68|0*( "!$A@ 6o:]]8]X]x]]] R.:0Enter 1 or 2 to specify which Named List to use NAMED LIST$2'SELECT * FROM Named_List_ '@ @ V :%T.SELECT * FROM Label_Prep'  V :%T. 5NaC@C@Vq 5Na B@X6 )6 )6 )6 )6 )6 )6Z )Z6 )6 )6 ) B@\C@V move through source tableq B@B B@B B@` B@`<h|`:X "!$A@ <@o8f( B@Bh|f "!$A@ ho@]X]p]]]]]qryAllParticipants'+DoCmd.OpenQuery stDocName, acNormal, acEdit BThis action will clear out the current email list in this database >Replace Email List$ '0 0Skip itA@ |k- CLEAR OUT current contents of tblAddressBookSELECT * FROM tblAddressBook'~ R.:D ~ V :%T. B@" check to see if any records exist@ 5NaC@C@Vq= Now read tblNamedList email-related info into tblAddressBook: skipping records that have no email address in the sourceSELECT * FROM tblNamedList'B B V :%T. B@ 5Na6P  B@X6 )R6 )T6P )P B@\k@ B@V(q F|D "!  tblAddress_Book is already empty k @ "!$A@ F o 2Attribute VB_Name = "Form_frmBuildPdList" Bas0{05DC4F86-3798-11D7-96EF-F4350B(C1F} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T  ]BookmarkǀO E%/-0PH- 2Add_ToBd_A_C:k4On Error GotTo_ A?Dim stDocA As SnFgC*msgd&Ty`Aw  apSourŠ{1 Ni%m2selecbE(ӆ#''= Input7("E!`(r 1 `2 to specify whichZ I aau", "NAMED LIST1Ą D7.Tex߁ E!1KL7,_"cLDLtL1M#SCnTtag_}p@ dD]og2oCT Do Until .EOF 58let`q.M0oveN!LoopA s2F_^4![NLCKÄd![IDpCFull^![_Yixzh![h e0,![_XfϰqgSttgϏgh![/hLLK[5555555555555Ρ ] [ s C e;abel_Codig( ' m(0rough sQ2)P3).P IwAmgg0Su@ )RLoadSDoCmd.Maxi6_le3oy1ta gd=e/SS,`crcYNQq> sSs21SRARSRR`R (#?&qo __}VOAs(.SaveOǯ**ick*H$Aa?R#= آO As Recordset Dim str@Query1Stringp2p38DocName8electionDescrip  ' of \d LisfoundTBoolean' Flag @that r has been xSet dbs = CurrentDbs_= InputBox("Enter 1 or 2 to specify w0hichV use ", "NAMED LIST1)/s0dve titleM`r /+"SDa:l "3= "SELECT @* FROM _Y_" & F>IrstTargK=L.Open5(F,Dy naWith FlDo Until .EO&F.D@_te MoveNexC Loop E߀CC%2x<tag_Prep"C 9Source@ 929C?Da0H!vq eHhϬ֠S S1H /ߞo +3oo Top/X_ #o?%̶?#Ys3A@\ponseSQ2dbsDataba"ƧRecordsetG#C 3= "qryAllParticipants"C 'tOpen0 , acNormalAEdiD$stA= Cr("0This A will clear out the currenHt eh l ,in@ d>", _$AcvbO@KCance "ReplacB A" If ($2) TheD@D("Skipx it@Gq 2E eIf' CLEAR OUBTfcont`s of tblAddressBodokcst).SELECT * 0FROM/SeDt @= Cc$DPrW2CBz= .!:F$,@DynMt$(F.MoveFi ' check to see if any rCQ ex8?`CWith c@ Do Until .EOFletA1aNexQ Lo|op8A ' Nowad0BGCQ-rel@rdQfo`Q:'4 s@Gpthat have tnoZa#Ab^s˃dB2 BfHB`$ C929D9/c'/!k@Len(![]) > 1k@F:.aNewf ![K!] ]wLastG=" C .UpH &Y@ #1' 'uq:qp}_C2NumbDer 302'*_1H qXlready`)ptĊ P[ _يSq?/( P c,d eLabel28 Group=9N=Ogeaxo9D`bcde fJl n,"";"";"";"";"10";"100"ZU HuOCombo30:tblPersonSession.spsession_idTable/QuerySELECT DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC; 0;1440P"SELECTVR+)Loۖ Ƴ]AkTyRME(SLS S6N0{62F18A9D-255A-11D7-96EF-043B0BC1FFFF}  f`|+h@%hx %d %`MK[X@@LY@$*\Rffff*01405dd434p4v8<r@     ( 8HP 0X 0 ( & 08@ `H. . 4 ,@ .p .  0 2 &8 *` 0  DISTINCTROW tblSession.session_id, tblSession.Session FROM tblSession ORDER BY tblSession.DateStarted DESC;";"tblSession";"";"session_id";"Session";"PrimaryKey"`ReportFooternMoi" of " & [Pages]q:jM:K另Ҧm0;F`abc,i k Text27 GroupG\Ol}d`ab c,  0 . *0 0`&&,$$8$`   :  2(`h px 2  0(0 8@ 0XrU  ɩ)Y1!Ѱ@4GqG @8?1 ppp';'' :<N,,@:\NLL^il6L, f\%$ ` $ ` (c\%$ ` ee( 1 pppW0 0  ;'' :<N,,@:\NLL^il6L, f\%$ ` $ ` (c\%$ ` ee( l L, 44P4X4XrU D,`&&(A` &n4GqG I@8?1 pppW0 0  ;'' :<N,,@:\NLL^il6L, f\%$ ` $ ` (c\%$ ` ( l L, 44PPX$\ptx l4X  T[ *X0gAJ.whzxbZ%; "\RA|*xME   0NK[v    " :( 6h & "  , (! @! X! x! ! ! ! :!" "" "("0"8" J@":""J"48#>p# ### #$$ $  ($ 8$&@$h$ $$$ $ $$$$ $$ % %(% 0% @%P%X% `% h%% %%% %Forms t@ j+eD03` j jBlob NPropData240=Babc\e ghiWj5%kĘV\@tblChurch.Your Church Information"[Event Procedure]"[Event Procedure]"[Event Procedure] Ariald2e12f5g237hghMS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zijMS Sans Serif{5`FormHeader` Detail m47U`axbeChurch_idChurch_idd5U`<axbcChurch_id LabelIDChurch_id_Labelm 47U`abce i jkChurchNameChurchNamed5U`<abcd ChurchName LabelChurch Name ChurchName_Labelm 247U`ab@ c e i kAddressAddressd5U`<abc d Address LabelAddressAddress_Labelm47U`a b@ ce i kCityCityd5U`<abcd City LabelCityCity_Labelm47U`abbcek State Stated5U`<aqbcd State Label StateState_Labelm47U`abcekZipZipd5U`<abcd Zip LabelZipZip_Labelm47U`a bc ei k Phone Phoned5U`<a# bc d Phone Label PhonePhone_Labelm47U`a] b@ ce i k Email Emaild5U`<al bcd Email Label EmailEmail_Labelm47U`a b@ ce i kWebsiteWebsited5U`<a bcd Website LabelWebsiteWebsite_Labelm47U`ab ce i k ContactNameContactNamed5U`<abcd "ContactName LabelContactName"ContactName_Labelh1U`abci cmdCloseClose Form"[Event Procedure]ajOZ*b``FormFooterourŠ{1 Ni%m2selecbE(ӆ#''= Ito specify whichZ I aau", "NAMED LͬbZ%; FormHeaderDetailmChurch_idd Church_id_LabelChurch_id LabelmChurchNamed ChurchName_LabelChurchName LabelmAddressd Address_LabelAddress LabelmCityd City_LabelCity Labelm StOK[ated State_LabelTypeInfo5pBlobDelta11;8 j jBlob sState Labelm Zipd Zip_LabelZip LabelmPhoned Phone_LabelPhone LabelmEmaild Email_LabelEmail LabelmWebsited Website_LabelWebsite LabelmContactNamed ContactName_LabelContactName LabelFormFooterh cmdClosep@ DT 0 Pdefghijklmnoprz{ mdmdmdmdmdmdmdmdmdmdhZ  NDrL0=Babcxe ghij*!k}p[j@qrySessionSession Form"[Event Procedure] Arial8 hATI2DVAA| ~` X<%`    !"#$&'()*-./01356789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdehijklnorstuvwxyz{|}~(Hd2hgh Tahomam45o2` Detail m 457U`` axci @@@session_idsession_idd5U7`(axbcd Label1Session IDm457U`` ab ci k@@@SessionSessiond5U7`abcd Label3Session Namem457U;`` aHb ci k@@@DateStartedDateStartedLong Dated5U7`taHbcd Label5Date Startedo025Ubc` de fl n@@@DayofWeekDayofWeekValue Listߌ"Sunday";"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday"1440d5U7` abcd Label7Day of the Weekm457U;`` aci k@@@TimeTimeMedium Timed5U7`abcd Label9Timem 2457U`` ab8ci k@@@CommentsCommentsd5U7`(ab cd Label11Commentsm457U;`` a0 ci k@@@HSWDateHSWDateTypeInfo?9BlobDelta%i08=Babc e g&hij*kf3̙f3f3ffffff3f3333f333f3f3̙f3̙̙̙̙f̙3̙ffffff3f3333f333f3f3̙f3f3ffffff3f3333f333f3ffffff3ffff̙fff3fffffff3ffffffffffff3fff3f3f3f3ff33f3ffffff3f3333f333333̙3f3333333f3333f3f3f3ff3f33f33333333f333333333f333f3̙f3f3ffffff3f3333f333f3'z29_@qryPersons2Persons Fixed Information"[Event Procedure]"[Event Procedure] Arial8 hGoToMyPC - HP LaserJet 4pcXXLetter 9''''L*winspoolGoToMyPC - HP LaserJet 4Ne01:d2d e333 Tahomae233f2433hg 33 Tahomai6gh3j6gh3k33l:33mi 33 Tahomanj 3333 Tahomaol 33 Tahomap33r4533zi j Tahoma{ Arial`FormHeaderU. DA `pT DetailU. DA m7W`axcei jperson_idperson_idU. DA d5]`<axbtcd person_id_Labelperson_idU. DA m7W`ab ce k Title TitleU. DA d5]`<abtcTitQK[jle_Label TitleU. DA m7W`aHb che i kFirstNameFirstNameU. DA d5]`<aHbtchFirstName_LabelFirstNameU. DA m7W`ab cJe i kLastNameLastNameU. DA d5]`<abtcJLastName_LabelLastNameU. DA m 27W`abpc,e i kAddressAddressU. DA d5]`<abtchAddress_LabelAddressU. DA m7W`a b8cJe8i k State StateU. DA d5]`<a btcJState_Label StateU. DA m7W`a@ b8ce8i kZipZipU. DA d5]`<a@ btcZip_LabelZipU. DA m7W`a b` cei k Phone Phone"[Event Procedure]U. DA d5]`<a btcPhone_LabelDayPhoneU. DA m7W`ab` cei k Phone2 Phone2"[Event Procedure]U. DA d5]`<abtcPhone2_LabelEvePhoneU. DA m 27U`(a b c,e i k Email EmailU. DA d5U`a bcEmail_Label EmailU. DA m7W`(a@ b ce i k Church ChurchU. DA d5]`Xa@ bcChurch_Label ChurchU. DA m7W`ab|ce i k CommentsCommentsU. DA d5]`<abtcComments_LabelCommentsU. DA m7W`(a bce8i k DateAddedDateAddedMedium DateU. DA d5]`a btcDateAdded_LabelDateAddedU. DA m7W`(a bce8i kDateUpdatedDateUpdatedMedium DateU. DA d5]`a b(c"DateUptated_LabelDateUpdatedU. DA h1U`abcXg i Close CLOSE"[Event Procedure]U. DA o5Wcde f,h l n "";"";"10";"100"U. DA CityCityTable/QueryzSELECT tblCities.City FROM tblCities ORDER BY tblCities.City;"[Event Procedure]"[Event Procedure]d5_`<abtcCity_LabelCityU. DA o5U6S`ab<cde f,n8"";"";"";"";"";"";"10";"100"U. DA Combo34Table/QuerySELECT [qryPersons].[person_id], [qryPersons].[LastName],[qryPersons].[FirstName] FROM [qryPersons]0;1440;1440"[Event Procedure]d5U`<abdc"Search_Name_Label&Search NameU. DA h1U`abcXi0Duplicate_Current_Record0Duplicate Current Record"[Event Procedure]".!D1 m7U`axb` c,i k Phone3 Phone3"[Event Procedure]נYD1 d5U`<abcLabel37CellPhoneנYD1 `FormFooterU. DA orm_frmMainMenuForm_frmMainMenuForm_frmReportSelectionForm_frmReportSelectionForm_frmPersonSessionForm_frmPersonSessionReport_rptMainMenuHelpReport_rptMainMenuHelpForm_frmGeneric_Report_PreparationForm_frmGeneriͬ(U. DA FormHeaderDetailmperson_idd person_id_LabelmTitled Title_LabelmFirstNamed FRK[irstName_LabelmLastNamed  LastName_Labelm Addressd  Address_Labeld  City_LabelmStated State_LabelmZipd Zip_LabelmPhoned Phone_LabelmPhone2d Phone2_LabelmEmaild Email_LabelmChurchd Church_LabelmCommentsd Comments_LabelmDateAddedd DateAdded_Labeld DateUptated_Label FormFooterh !Closeo"Cityo#Combo34d $Search_Name_Labelh %Duplicate_Current_Record&DateUptatedmDateUpdatedm'Phone3d (Label37tGrdefhijklmnoprz{mdmdmdmdmdmdmdmdmdmdmdmdmdmdhododhmdurch.Your Cmation"[Event Proceduͬ.#D1 Detaild Label0h Open_frmPersonsh Open_frmChurchesh Open_frmSessionh Run_Reportsh Helph Comprehensiveh Abouth  Build_Named_ListBuild Named Listr36UB@ա j@Blob "PropDataAC+TypeInfoD,Z      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~SK[      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~)0238=Babche gh ij6kV_@"Twin Cities Alpha"[Event Procedure] Arial8 hEPSON Stylus C82 Seriespv odhhRL*** xhhDLLName32=E_DU16IE.DLL d 2EPSON Stylus C82 Series  ? 8EPSON Stylus C82 SeriesEPSON Stylus C82 SeriesUSB001d2 Tahomahgh Tahomar35`@ Detaill.#D1 h1]` bci(Enter_Person_Session8Session-specific Information"[Event Procedure]JNJYL*::)Md257` ab\ cXde Label0ALPHABASEm.#D1 h1U`@ a(b4cHg Open_frmPersons@Enter Person's Fixed Information"[Event Procedure]t.#D1 h1U`a(bcHg i Open_frmChurches4Enter Church's Information"[Event Procedure].#D1 h1U`abcg iOpen_frmSession6Enter Session's Information"[Event Procedure],3#D1 h1U`@ abcg hiRun_ReportsRun Reports"[Event Procedure],3#D1 h1U`ab8cg iHelpHELP"[Event Procedure]bZ%; h1U`@ ab4cg iComprehensive6Comprehensive Personal Info"[Event Procedure]G7+D1 h1U`abcg i About ABOUT"[Event Procedure] 75 h1U`a bcg i Build Named List Build Named List"[Event Procedure] Build_Named_ListIXh:D1 r7Uab,cd' g OLEUnbound16ࡱ> 567TK[ N R   K_ 6 h HƱ΄2[;h  !"#$%&'()*+,-./012349:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entryc$$o+@Ole Contents"`OlePres0008) 88JFIFddCC" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?((((w~cD^ մ #H|!49kV~'ß菉uxQoYѢx(pv}6#|9P쯮--'{ƶ/NKhm_9'ƟO M |W!5v1~_XnW+<+ 9?hk'{Wt5 ,Wws #q[}өm acP0Ag8ni.83Xf1BZ^WJ?9TSTpnIU~}?T2V/1}[ ] *teSYZ'JJ\?he.*Y_[A}ZTrXP|ү䶴G?N)n];ğiWx>[Y/[KwK}cZ1f><'ŚTJckq2f2_lS~Ežf5վ |Jwᯍ>&Ƨ;??nً?ltVO~Ѭ|=oM'OÝYn \1,6ռ!h:{#8Oq&Up>qx{>EUK[v)PT3\O|gN/3Wu'k.H{5<..TҤ%^?c^J5)sJ4좊+ꏄ ( ( ( ( ( (?2m'|S׀~3k78u(>>#ׯm5[|Hs VZݕKKhgIfiv'VOhRh/Νowp O٢ZOicI _EEx%̫OpD}^XZj5i[=TUę5 \:`1R NT[US|m7qg_1mt!׏ Í"S]]\]ixk\-7(^H<5|0R`=32JtsFj ?cQFI'Of{SqUF g3 kbRpy E*T>%J*5fį~ ]xRAo7* _IG oiO͑?<; COxb ~~7&A-0_hwzZ=G//'$ Z_Ī05?l-jvڜ#ɸrsӸ3S{g/)阇T>Qf?iG̜=4_g[ f6p vk`Py!kMnݪѧ6Xn>e&aùRӭOZW?0ڪrQh=&(((((ֵZFzEvvi[K;$U #" \|@7h_\~ Ծڳ~ m?B}?jn_~Oj /?ߌ >/v[s:? wxoQT*ImM:4R1Nq(T*rۛp?/4y{]E?|<+/>7|F}, I{=#Z-|S^曪QFrvoߨNJ9>XBQc[mχ?z핯 D'o~Va>;qoځ cY|ռ7|<:h5oi^Cjfgu"J'|i O >o:G*_Ziƻ6^/GJoY|.>(𭝇-V>=ּ9g{_#ko}Mt/hVv,ϒHsZ 搖,GOu+^|O1XTkrSF"#c(TWߣT.8oW;jաNLI0[1uZ4p|g_Z _'ߊ1%žuls3AG/3 Ϯ9^+sk$/^~6si-iFׇJYG9 y~h|HMK+YҡԭD0܏|f{ZCDx?noR~ `?d~*-{yOxV[sG|#|Vּ7_RӤ[|VB<8WÈB?*Wi{lwņ>' z1|7SW<ٖey.&Z0+P'/i?.N?]ߋZǯ#mk.9xHƯk?z,|!{I>6hx-$xUXd2Ckօ$RGT 'M4-JY5>Uu}>N4Fnlsiyc{jVHRU*S\f W *jSOӷgNsO?^pp#5Jy*rKᓋQEtEPEPEP SOKi|>Pp|-!a#X[jC6~~/;¿Nk|nд? c~0>.k K/RׂhOFWwI_Vg-ƿ}{X@~v% ($|CE 1}pǯmm{^:etچ_%΂ЦV+;+NVG<|O3'6{C1n_e8Qecf8%hTӡ 5c*TWt#?jxW'n; ڦj  K+Cgl )h BP??7ӣ~˟%Y|8mѼyge _xgźcj59i{+7??cC>6ѠԢG܋kK}oIҵkP1vK*09ןXIOk?yj~yyG_ C"CTsV3hЧKrs\r%[lLfr\s0 G&Y>p 돳.Xִ˟Z .ϝx, kۯ+P\<8qةBn|{Ks|FY0o0ΟU/YNZTexSuV;ſ~w?Mox\Gwu;Wx6/KԿt϶?|yu>O>%FmشK^%l NK[?jfC]w^+7 Y..*U:-gV4a>n~nVin]$[_ٳ.ӃrIqN.KZ&)L7/U/gJtr߮|j?!?Ŀ.4;6OYxoKҴdeRLo|x+whZWt77&Y=cmb(fO\MXZeQT̰mL*lFaVʄqx]L5LʥYqXxVVnTbbҜF&W.F"ťԖeEW臄QEQEQU82q'8 cW7n ?|FXvkW$ќƹn=;Z9$i;Aw7/?=þ5wxsīmym?:_ 5oC֘2H߂H> .J5jҫ4%O-l׎g`l0~cR񷁿f ~_ajG]7"~h~>|L]Gÿ|?uh@o|kKh^(𯄵~ /h<-;$Gś1#oxCÖ~ƴ5 c{߈x6M ?20|GS$̸fy&L ?JYc<ƽjXjU uZJ#՚~ dyv/G b(RK=U_WYF#,x<#V玫C {U h;~+FЬ>1ދ~ߴ/mI-:x ]YNLt}sA`tI(~(h^g?O>%j x+^, {xY4_Ai0˧ɤC0~/G}g϶|c晪xzċMG,yccĚa(gG׾1ZBoA:^qkXKR>1hq'a+ pmɧ:JbMRyd\9{x:UxVxN?biѫT`k{99?T?{ ԟ 5Կb~)jk_xF|Xou6 -.<4{wA|=Im|igH7Sҵ?7H/- /UB+b[ɵ=MԵ}7N/c뎞xMiy$x4;[>)|F2nMoEdžr68̡7n>7q(ȱyvm"akpNYW0T.}jqEޢb+s:D1J^ά8ݸ9_qms6ލkρ<7W~Nx_м!<\\AΓe_j9o'O NAҊ+]>(((+mߊ~>R{gDžO?ĺwx9np't[KԼNn3_@Aƿ oGGƍGzū_]V?VzE:iD5uܮżxx:{I'7$zzۣID>N0Dxsþ"Q1:Y~*R36x3L;8Ϛ"*Ҕ?#&|Q¿/FݯN?joٚ6 >ɯxgY~-x?_ 6ᯉko&g~𜺖|m^𾙡xK,'5=SS!tA5*գajѯVW JtBXҫ.K{Τ$y$w_[T'񳉸׈p#/ɩf|Of,f9 <8es<= ` [(U2>1gy#>Vk|4կ<#|'O%~8xU=6Z}m.O}^7"> KJ$?_R_*Kr]Z_5ZWvZ'5kdhv'?0#x0(.ΰ0hу,2O+r/k]/iO]%J3̡1 iOq?1nsb9{IF|˗_Gj4|A5;z0[Ģ ujmtKK;FPlClhy ѡ>gM2{@ڛ1lAo]r=/C֢jZ}嵭ŜY->>#|B>>z~Sg|Azt?O7A='ׁ<=[}+ߴNfsF_S]Fæ??xy x_b#/ Wt;þ𞋦{zm]7JдUҬ,eeq;9f?|ukkL>$Yˇ Դ00k5~/%?/u [?]Ӟ_ 4xq#ῂ~2G<׼QK'3ݙ|@$_KNËZm);CVl]:4qr㈔+Sj*i%a*Ư̧ Yf. S GӝZgKZHF*t{Ny8rKė~iA#S#~kwZƛyou[ }^϶/ ztq$~V4W}=~֞8>8|B996ះ7ŏ76U/O~$xKFM_ ?Po]v- G/?k]ׅho l>^Z~x%σ NYiíh$ y^ [pŸNnt;hMލ|Y rq <%$e>0d. a)0x>3+SWx\6*tpjVX F'YL*J?}_J:Ԗ*4NN&{ܼ{In{eQ_Q@Q@Q@Q@Q@wVڍՍݝݽյݭ\[\V*<`_ AjKK|EI+I~*Ϛ9v+i!KhGZ"O_S߂?b_4coqaZe}k_ GbVּO^%khqr}qV/-ͨTFc*U1;poHU ٴ^2/X̲:OWW:%RHU.W teRJMBIC^*¯_٫SUᏊ/-ޏz?/Co`tfm 'f aIua\ZT-\~?Ǟў'~ξ-ޛׅImRVjmt_]^X|`ocX}Fqk_i_*p?IVJ4jX:5kgDU?a$¼h¶|MZVmd|qys6׼Gj^t Ꚇltgb<eW~?/_|Wg|wGm'fY'7VMz_?>%Y;:y-xxgV(Դdumo]a~i͵Լ8Z9?k CEU~e^o%ʓuj[x3v+ŗt ?.}O.o]C wxvWFCѯ5}NMLLSjL"<4a֕MHk}KG,-5}Qךvkfٺd7#4Q@Q@Q@Q@Q@Q@(_?be/ ?ۿ7_?dbhy_ڟ`>3(xbyk~..t<+AZ|>G`OxC-|GVޤtMsGއC@aoړsa=xtc: l].d_ xH|,ۉ|=ۜp@ai/ aeVbXþe'F/gfG-Ufyn3քiաui0UiՔ3L6!>X֊%+XSuMZuƿڟFO/Aұ )N<7op|+/OGeۛ__?O77]/W_u!xĺį^SBѾ"xkN/o\|?x|tu]xxP߈ҦZi=w6McwݧJYGU 7)W Ǻg/xkXx3{? -dZx?+En  \(Jz/EX*Ẍ́,4a1b+)Tt卣S8oΕZy_ pu䣉JkRҩjtW59և?4m(#߱__j7Ծ.X~˟h:g _k0OOO/?{K7^񶉯xRX4zP<q_5`enžR'kk>=<}0t_◄-/,"ċ ABh̦|_ syjZo|mk3%~M;sϥp(J!KS?tS.24 JQ.oU}\yNz}jHARK{u=73ܰOcSx 'lk~6K 4:٧Ad6^!EDo/ x6Ttm:k?~+Lh|"eh>#Ꚇ;UgW )Z6,*CXGĝSLRh %Xcn8idCRXLG.' KӄѺ^ʬgh}"?k 74`t+? Eh>0:ֹxg+  (L53 Uv NfsJj.ES"F,i^T|3q4𐫅jΌ#5}w YJ_V8ڿ >W5x?>%>~xúޯsQ5Ь/!MM!Հ9gJ|#4? |u#Qʲ,9 k搣G 8QR 'eNkE+f9#.a~ lYƥ~ohO{74O׵!O״/G_Kc|G:ōhgĚVk_ؿ:O+FxbEoŞ ?| j~i7Vw(#}hJ(ۿoK-3 my|7[XïxcZ=z߅Oj^_ ;񖯦_^(kƝg w7zX忋5%ggC2R. R8%99UܭkZ \G0U Aw쒧=[nZ++[tW ]"y\|G}]h:c1ƌxW $A1mʼn?<9B<Ş}:CyknhFF&Q <,X__k+5)T*s̯tM_[{l~iJj5*Ҝ[SU!QEbvQ@Q@Q@Q@|'&6׾h~/5t'Ѷ8l_kZr|HAw?!,<?|=u]]<+>bUf S'!(5k[TgCPg ! X.!@ЬSsר$vTSך]_u۠SJycNVw(-OV4k5cPl w}qoomm3.{\>2#j>%|?m4%4Xz&xx2 b)ߖ2vr5w2G0جn/`T;K Z T(K%KԜc V97*|QEP(((lU?(^i65Hԡu/Lۡd&fW_xįXxgѮkw,m&2w]\ mJgH.P VW|)%Z]xĿŸIc6έw\;mPG準o&%hQhSx8jT%)JM/*]r-NE>9V<> .argV FJ*?XqWmr*;|6g_'_4_~${Nؾjg^qDfC%mXFL7_(muKCu~~Եخf>q_GvG/xP wi$g?gM6n,>";+; ZdcG,_Y8COIq*Sk[Z׸|xXq3j><I*6G8dt!*k&EXS-#k_?'o˭KK/ůky (uZ31^,gs.h/k|$x|K|Mҵ-[žΧ戚̟ͪ0ٺI>ɧ9ҎgsNUk7UFCsV_\5txs&R $F|CFWgho uoV~$ηj:]c W@99-uׂ099bNQњI6gOLĮx;5!p*KթC\F# ^ҩBiוZ(WIs^߆~!Mx3>_x/_yyVeO܍+ ZmeĶKRY-#'l*YHikkIϦ}}k.e'1Q:b8 ЅXFpsqn2/kolK5 ,('ȷ7773`" TN72mOP]5>xa4M? O7OF=i"3 2YBڿN; %?g,Ez&O\j)Gu&Խ(T%Ü_l9qc՞U)JVWZ]Y&o5Jߪhl>מރ_Tߏ__ YQM<:mJx3'l/mw|EեSIu8=  PwXD|UQvg?~Ygӻ8%͸4rԣlfw)sC7V|J)Mh7mc>1x>s[~٫c_6vnǙxmTI IG&_?"= 3<gawxzڂ^~rǵDO Y hVXSp3ccqzv_ƛ_dho U,a[>%Lk/ Zc }[;N 3Y  mroyQXLOe|/ᾗ⟉<67ī_6o>sேp^Aޡޭ~jd f?gok\}[o>57@)׉ M1u"+c>$1i < o&aJ^^ fqAvqӚ^^M^Rx9'w#<?Y^+-|cYfk}Z8n Ɣ+bS Х곧9`#DO?5l9=~^$m}KO~>}o=xs1!f޵?.HCjKM-G 6>0D~,'_Her@WW-85tB?^JiJN;ce~/}#~V70ˉ8ޤc8Yp+Ępntẏ ?k~1?_F^=ҏ |(_}KEq{~vF^McW֑{:eOP_^Sx)/g%Ƌ~g|8OUY\?a&;VYݹoݲ__IE-}3~ЇNw/ًG"ޭvo >)ʮxU 4e8 f.F- 3z\6#H_`tev.o=5q/^OgV{rl?q& )V֯|K.wYnc9U9CW)8!~~j?Ul ]6|F*۵+L ck/ W<=JDGgn. x?u%2c!tf6'<=?kW_nm,9 3`w#OoU \iwڅ4~ѵC fxWR1/e<6SW ᇗ`h}W J*0upnWٿU7tn@/im47Ȁ.h< j'᫭?[([xc|Kf-?=qd99!J\%2s TxJ5j{DJ5hJ-KE{G_I/_[*-~%Q0xJxQ?2d˺RgO i/׾^7ZMdž7~Q7e5ݑ$zsͥxL֥_+-߱99x^4h>:6k'$ ߏmos%HHR3 <;/CN=Ѵ$s;XXZy5Hy#a2ls9^Xl6`=A9<=_nU{ӗ䂼<+{$qWf30u8hqF_GwSX_f9~)&&~;!F/O ~<x2[kxڭ;kcyyw$Hb.ZFb@?oZ-v|:UF6Olk#>A}gd5 9$TW?iڥmuY$#{lX&_ u"K BUiUՓӊI+IZK[YS5#1<)ySƏ`s%P|&/S S3v7hiB,$cjѧP<܏_{3GG_W]/ç׉4j^-4ѥmUsc?_)9KLu%Ulq.Gg"/RBvt^2~Q)'|#o,Ryoi<rdsoV 3x3{OxW~2֢j~~D|Kmolے`y9Øp\c/v4b#䚦_YQA58^Z98s}-x[2[JZ~fy\~c,/?Kdُ傥Och MN:'E^CxwEx mw xvj'N/.KJΛ-cD]#r.׎_ [^⟈0 DG|.eGo|0ேZ4+cN>glYGn9 q'DŽqX)ӯ΋?|>3qon>Q|a i/gћ׋)[ ,_kV_RӢVz RTVoƚQ'Ücp*nGE Y6{33’u0)en[ⲏp|%1ṮVm,ڋ◊>,x> ΁|[Fu}bPu]^zn1YY>D57GM izu-oO36K:g<$&'BWAe0iƱ⟌_< Al&M&/iȏ; ,nٟ|3oI_5~|FOt_ iAϣ+(ȱ.Zp\m?jS'<>))F^ז-']ߚ6n~wW,u.ax/>~4 \w- +p|_|.UͰ|;2q:ΧaJ '{5ӼME'$vgdO/.#<˨ziZT0-_OS`|U5.7~Wbu߲I>GnyNsq> ]x_÷w2~YѴg8,s$^iTE _;FteKJMUm4J)5%BxX?s<79N'3' p+dY^S8FңT4|?FyflGK∮mj?k:݌uzi,  ˬxYYvfwχh[\]Gӯ ŚljC8 ] ((Ɏ"qg\skxK#i7jU\5t;6Y6'Ya%O9-8Iu!e;s]Tne&io?#cه8n,!O[s̿6Y~.tq)XJ\:8O?|7+gc/?_=_~Akv!-^| 𦟪:iMl4={4O Z7ŋgo؀ =uG}t NYYW`$v57 |P/!tȓ>UrskVwk"~}<q>jrT.mi  (RQQ8kr=O xJ|wf^+s OG/Ya8lN34e^6f6F<-\.$mڏ4_oË;/}zo~i@sRMk_| 85[ /SNXt-Vk(WS⮥_~~8΃Շ+>W~ޓ#x"sahi`A8QO#+? xw𮉥FZ%[( x_?>ɖq{/\@k1//^u ;'X S5:I8Nz8ᗳThУ S>XΣ֢5>%8?heFgd;xl4\MWS/gUGcbJxNz9> U19#cBu/C^?#>tWGUͶwkmviImt h# " 2Q_4WS˔!VEJB.KG$bOIQ.+936pMt.Se X:qZ游тg9ZmkJ"J%Q^EPEP[{07OFm|YP~-j1jN׾#f 6ނ+}ϋ7oxZO]j:lju-BRgDhaذ&I J+_*T#OV4E{s.yYsfpMvx\7qgq&OB^;Y=eyTa u%GK MjTzԩԏ]-{F|=տfxCe/K1emKYFմK-/mWVw9 nMiY;E.E9TrNs)6톡k?O p}$*ᜫ؈\tcxl3B5jT+Wʍ =:giS (S$(((([K[v      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~n) L  LC (TI;E *0 7/<61014 9Y۵뒁A#* ". ($"F"bﳔN;"(!$&1߭? &"&,$?(lK1!%(@($'&'3\K[A"#&$#-閐lY%!'#(jX)#(%"?: &#$%$)޾_=)$) $މz*#']B̽jX-I Y7׋s) #!-4²i;K#<K&hJߙ⚃ժȴZ:G^7Ϗq`DDK%kO⫞\I3 %+ * ,,*'$?kNaFA2 !'+# &5,9 +% **7R,1" 1"'߅tB.!%-!&( 4 Ԃls`A3.J7⨣t-+** $ ,_C=&!4S/V4*# "1 擉) &&"%">꫙dK)$+!(sd뽷Ȼm\"#!&+/D&˟xh&$-(&1oEy^**"%)$ K4ܾ=* 5oU-+"#%9W=' %"$Ӂf|2 #'"]K["&1҆xXC&)""&!)+~ix2%#b?]C##&#(($.夘I,$$( 4O(=]7.$%"+$/ԑ90-O<ν<)$ 'Ψ)%"*%% ('nPG*#&'$&%/ܑJ./)#' #'&{2 ' nH/ "##"' F&Q,("""#%R=3\J; $(""6㾼*1!CޫfJ(& %"'z\0&'C4kM3sa/+)!$&)#//֡sb.%$"%&M4ꋑYD0˰- #N>!*"'#X;}[!%%% #U@+ْpY--$$ ږw_1B$Ѷ(($!&#I ? !*||+ԟ)&"'*++ pei^+7 %"+ $%jYlNEx.4~eQ7+'(, _>!(# <<гm*# &&'_HC% )$M,5#!'.]>!%%&.hJnU,̻g* #('$҉t;O/ᰵ9$&)!Q=C a@d!2 ֧aI" #!$#"U,3")(,ݷ{[➃,%%! (4'$'_@X:##"% +ێk'$()@F,w[i(# (',ɻ-̈́zU5' !(#, xZOE!:s['&"' #V&SA(%,a?$%%"&)ۦK8#'(؉mya'&) $(^/-")'%- ͭl"''3p.X6(#&+"Q(!A*ya&#"G!3"$#%E pU%#(*+pT'( '!4 ൣ껼+)!$(0翼]6%  ,%(XA|* ) %,X?$#& %*mHż:*W8f,"(&#"Eƻ7 "'% 5׼'",($M,żC"!%#iNB,&"# /x[n '$!>#("#$ )ܾ8+# *&I!+3kW