Standard Jet DBnb` Ugr@?~1y0̝cßFNl7+Ӝ(e!`"{6߱cC83By["|*|pЂf_Љ$g'DeFx -bT4.0dv Y2S 22 Y   Y Y  Y Y  Y  Y  Y   Y u Y o Y n Y z Y 2lY  Y  z Y  pY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYhiS1Y Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YhiSY  Y iY Y  Y  Y iY  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Orderii iY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/   "DD@@@@@@ @ @ @ Si`MJiOkSi``QboSi`bQsmiJbkSi`id^^dqQi`kUSi`miJbkJMmYdbkifmmiJbkJMmYdbkJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`MJiOk+kh+MSi`bQsmiJbk+kh+MSi`MJiOk+kh+MSi`miJbkJMmYdbk+kh+MSi``Qbo+kh+M^Ykm8+kh+MSi``Qbo+kh+M^Ykm>+kh+MSi``Qbo+kh+M^YkmD+kh+MSi`id^^dqQi`kU+kh+M`dbmW+kh+SSi`bQsmiJbk`kvkJMMQkkdL[QMmk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivJOObQsmiJbkJMmYdbk hivJ^^miJbkJMmYdbk!hivLJ^JbMQ^YkmYbU"hivMJiO`dbmWk#hivM^QJibQsQbmiYQk$hivM^QJiid^^dqQi%hivMd`fJbv^dd\of^Ykm&hivOQ^QmQMJiO'hivkQ^QMmQOMJiO(hivmiJbkJMmYdbk)hivofOJmQ`dbmWJbOSv*hivofOJmQid^^dqQik+hoQiv8,mL^MJiOk,mL^`dbmWk,mL^bQsmiJbk,mL^miJbkJMmYdbk,JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOmL^MJiOkmL^miJbkJMmYdbk,^  @ @ @ @ @ @           !"#$%&'( )!*"+#,$,-,2,6,;, @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @AAAAAAAAA A A A AAAAAAAAAAAAA$A% A& A' A( A) A* A+ A, A- A. A/ A0 A1 A2 A3 A4A8A9A:A;A<A=A>A?A@AAABACADAEAFAGAHAIAJAKALAMANAOAPEEEEEEEEEEEEEEEEEEE E!E"E#E$E%E&E'E(E)E* E+ E, E-!E.!E/!E0"E1"E2"E3#E4#E5#E6$A5$A6$A7EEE EEE E E E EEEEE-E7-E8-E92E:2E;2E<6E=6E>6E?;E@;EA;EBAAAA AA AAAA!A"A# @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @       "#$!%'(&)+,-./01234 5 6 7 8*9;<=>?@ABCDE F G ) )):)))) ))) ) ) ) ))))) ) ) ) )) ))))))))) )!)" )# )$ )% )&))')))*)+),)()-)/)0)1)2 )3 )4).)5)7)8)9):);)<)6)=)?)@)A)B)C)> )D )F )G )H )I )J + + + + +  +  +  +  +  + + + + )E!+ !+!+!+!+!+!+"+"+"+"+"+"+"+#+#+#+#+#+ #+!#++ + + + +  +  +  +  +  +  +  +  +  )E!+ !+!+!+!+!+!+"+"+"+"+"+@mL^MJiOkmL^miJbkJMmYdbk@ @mL^miJbkJMmYdbk@mL^MJiOk@!,d _ Z g  ~K a  @ @ ,lP+@={+@ qryDeleteCard:@I|@HTHH<<<<<<<: @(Xy@4@qryCompanyLookupList@D|@HbVVJJJJJJJH @4@ p9@0qryClearRollOver~@D|@FZNNBBBBBBB@ @ ,~y@*+9@qryCardMonths@G@FTHH<<<<<<<: @y@ g4@qryBalanceListing@G|@F\PPDDDDDDDB @V_+@%DΝ@qryAllTransactionsn@G|@F^RRFFFFFFFD @퐟9@9@@qryAddNewTransactions@D|@BdXXLLLLLLLJ @@bH@MSysAccessObjectsDDDDDDDDDDB ,:@HB:@~sq_cfrmRollOverMsg~sq_cMonth4MR2KeepLocal T\\\\\\\Z @Sy@!y@~sq_cfrmMenu~sq_cList74MR2KeepLocal TNNNNNNNL @ ,3↶@3↶@~sq_cfrmMenu~sq_cList14MR2KeepLocal TNNNNNNNL @, A:@ A:@~sq_cfrmCards~sq_cfrmNewTrans4MR2KeepLocal T\\\\\\\Z @ >دy@)Ry@Admin@B8,,,,,,,,,* *z@*z@rptTransactions0@DLLL@@@@@@@> @, }г :@}г :@frmRollOverMsg@CJJJ>>>>>>>< @ E9@E9@frmNewTrans@CDDD88888886 @ Rm8y@Rm8y@frmMenu<@C<<<0000000. @ J y@J y@frmCards@C>>>22222220 @ s=dy@s=dy@UserDefinedA@CDDD88888886 @ s=dy@s=dy@SummaryInfo@CDDD88888886 @,s=dy@s=dy@SysRel.........., s=dy@s=dy@Scripts0000000000. s=dy@s=dy@Reports0000000000. s=dy@s=dy@Modules0000000000. s=dy@s=dy@Forms,,,,,,,,,,* s=dy@s=dy@DataAccessPages@@@@@@@@@@> ڔdy@ڔdy@MSysRelationshipsDDDDDDDDDDB ڔdy@ڔdy@MSysQueries88888888886 ڔdy@ڔdy@MSysACEs22222222220 ڔdy@ڔdy@MSysObjects88888888886 ڔdy@5@MSysDb@C:::......., @ڔdy@ڔdy@Relationships<<<<<<<<<<: ڔdy@ڔdy@Databases44444444442 ڔdy@ڔdy@Tables..........,  Hx4k t 5 u G  f H  [  o . aC%dAN[P L C tblTransactions.Company6 g tblTransactions.Amount5 gtblTransactions.Type3 gtblTransactions.Division7 gtblTransactions.TransDate8 gtblTransactions.Item3 gtblTransactions.FY1 gtblTransactions.Month4 gtblTransactions.CardID5 gtblTransactions.TransID6 gtblTransactions///  G G  G CertifiedblNewTrans].[Certified]J# w RollOver[tblNewTrans].[RollOver]G! w Company[tblNewTrans].[Company]D w Amount[tblNewTrans].[Amount]A wType[tblNewTrans].[Type]; wDivision[tblNewTrans].[Division]G! wTransDateblNewTrans].[TransDate]J# wItem[tblNewTrans].[Item]; wCardID[tblNewTrans].[CardID]A wFY[tblNewTrans].[FY]5 wMonth[tblNewTrans].[Month]> wTransID[tblNewTrans].[TransID]D wtblNewTrans''' tblTransactions/// O  GtblNewTrans'''   G  G[tblMonths].[Month]2 g[tblMonths].[MonthID]4 gtblMonths###   G d[tblChits].[Date]2 /[tblChits].[Division]4 g[tblChits].[Date]0 g[tblChits].[Requsition#]7 g[tblChits].[Chit#]1 gtblChits!!!   G[tblCards].[Cardholder]6 g[tblCards].[CardType]4 g[tblCards].[CardID]2 g tblCards!!!    G[tblCards].[CardType]4 g[tblCards].[CardHolder]6 g[tblCards].[CardID]2 gtblCards!!!   G ([__CardID] = CardID)4 ' qryTransactionsfrmCards??/   G__CardID!!! O   G([__CardID] = CardID)4 'tblNewTransfrmCards77'   G__CardID!!! O  G YiiiNY Y iDataIDj(YAOIndexv1K[DH(@3DTwtjctLLS@LL莬pyj {j`zjxjqjqj{j0~jP؍MSysAccountsxiMxi:KeepLocal T xiK[ࡱ> z! + "R#$%&'()*,Q-./S123456789:;=>?@ABCDFGHIJKLMNOPYTUVWXcd[\]^_`abeifghjxylmnopqrstuvw|}~Root Entry/PL:bVBAP:P:VBAProjectP:P:VBAP:P:dir__SRP_0__SRP_1__SRP_2 6  !"#$%&'()*+,-./012346789:;<=>?@ABCDEFGHIJKLMOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{}~Ƴ0* pHd PurchaseLog8@ = t  kuA( J< rstdole>stdole f%\*\G{00020430-;C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automatio&n^gAD@ODB> APDOBC]CD1C10-8CAA00@6D2EA4C1CProgram Files\C`ommonM\9\msado21NMicrosoft ActiveX Data Objects 2.1 LibpraryHM SACALMSACL^~t^8E27C92E-1264-101C-8A2F-040224009C02}#7PPROGRA~1\MICROS~2\Office\MSA.OCX#G+Calendar Control X9.0DFBzForm_frmM@enuG F}rm_}Mnu@EDPASTIFBWYUODMTKQAO_YZGJOGM28AkP@=STIFBWYUqM(KQ@OY ZGJ@G"MBH@1BBE,-?"B(B+BWE2CardsG+A2Cars3IQEPKQJAFYKXYDPZSNSCCVYIPYTJ3I+PEP-J-FQ2KX@D@ZUxNCyVIY8J3343RollOverMsgG&LRltOv4r(sgVSRMPUGVZLOPNDKKAQMANWWQCUH_UVR`P3GV1L1PNU`8KAMN`8W`CH 7!AIk5U`K*mrU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~U  BKd  A !'  $$K[&1a  Q9! a )#9! Form_frmMenu Form_frmCards PurchaseLogF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA ) Q0J_N? 3C:\Program Files\Microsoft Office\Office\MSACC9.OLBAccess ! I@0FC:\WINNT\System32\stdole2.tlbstdole )QPm.4C:\Program Files\Common Files\System\ADO\msado21.tlbADODB 1`.'d/$ %C:\PROGRA~1\MICROS~2\Office\MSCAL.OCXMSACAL Ap? K5:+@D5ÝF3H Lg?< fD2N4%31?FormSC7?DetailKC7?List1AC7?Label0EC7?Command3Command3_ClickList1_DblClick P frmMenuɤs h)aN?`GXGP frmCardsMi-L} WJrBz)x0,νXH* ҞB݃E| u;|?Page10@C7? Cardholder-'d/$ Calandar1p W* ActiveX Controls in Access  1 r;|?TabCtl8 Command13 FormHeader FormFooterCardIDBalancePage9LC7?CardTypeCommand13_Click Form_Open ph;|?VBE6.DLL  " n,'cnDlFғ8իG=]hO?BCommand4Command5Command6Command4_ClickCommand5_ClickCommand6_Click \^WFW2tn: 3>Lf~[$Combo15Text17"FQ2rG/OtxtFycboMonthT &KbI4gws_De|frmTransactions_LabelText21PC7?frmTransactions |ի9KDpVK}GΉrJ5hYearMonth tblDivisions;ztAU=ztAU<ztAU-ztAU݋_vM7O sCL sF Command23Command23_Click d;|?)/Eٻ[.K)Command7 &aryUpdateMonthandFY &qryUpdateMonthandFY Form_Form1Form_frmUpdateMessage؄ztAUxztAUwztAU frmUpdateMessageۄztAUtztAUlztAUsztAUCommand1Command1_ClickForm_frmUpdateRollOver+ztAU*ztAU Command24Command24_Click xbC!L&(+ Do you want to Update the transactions listed with the Month and Year on the Form? &Update Transactions  S 0 You are about to Roll Over the selected transactions listed below. Do you wish to continue?Command34_Click $qryUpdateRollOversl w'Du>20{tAU0{tAU CommaK[nd25Command25_ClickHQISu|ܬb`G_(mCombo26b[LAQkX=_SƢ|'$ITN rptTransactionsڹ1(H~\B֡<@{>@:8E7NHDS@OITabCtl28Page29Page30 frmNewTrans Command33Command33_Click ++bů:ElnR03I&^'AH Command34 *qryAddNewTransactions (qryClearTransactions $qryClearNewEntriesForm_frmRollOverMsg3@y=b}i[F(0I$C qryClearRollOver frmRollOverMsgP,j~&J`THz3I8H(9 QZJL wuu[׼LlH1Label4FY X}C}F}rbBzKHZsP JHj-C 7UCBa՚Command7_ClickZ;|?H|v#M+ε1* &HLLu·wN֎ Command8Command8_Click ` TAre you sure you want to delete this card? Deleting Card qryDeleteCardVLEx1H6BjCCommand9Command9_Click d $qryAllTransactions G You are about to alter any transactions that you have entered for the selected card. If you wish to continue select yes. Gary is Gay!!!!7rU~~~~~~~~~~~i      )( i8 HCancel 9 X y h q x      ErU (A' ! ( &Y&#@ 4$I@8irrr@<)Qttt@ @xxx @ DizzzI@ H|||@ L~~~ @Pa@Tppp@ X&sWW0 0  0 X  0   0   0 8  0   h4'''<:lN\\^6\<a+:l%$ ` dh$  \<0 K[  @DHL4X< rU d$` $A` $` $`__SRP_35"__SRP_4 Nn __SRP_5| __SRP_6 $` $A` $` (`(&n@<ppp@@)Qttt @Dirrr@ Hxxx @ LizzzIjW\( x$ `x px($  x0 X  0   0   0   HL4@8  0   <'8%'H%'X%:h%x$ `x `x<'8%'H%'X%:h%x$ `x `xD$  xH48@L8rU $` $A` $` $` $` $A` (`0&n@< @ @1I@ Da@ H  @La@Prrr@T) ppp@XI @\y 9i ttt@ `@dy 9 xxx@h  |||@ l y@p9 @t9 K[@x 1@| @  @ IWWl+:h%x$ `x ,x<'8%'H%'X%:h%x$ `x `xDl$  xh4x! x xx! x x4$  x0   0   +:h%x$ `x dx+:h %x$ `x dx+:h %x$ `x dxx! x xx! x xx! x x$  xPx! x x$  xH@D`0rU 81I ! yi i9 !"Y$i! !1@4y 9@8y 9@< @ @1I@ Da@ H  @La@Prrr@T) ppp@XI @\y 9i ttt@ `@dy 9 xxx@h  |||@ l y@p9 @t9 @x 1@| @  @ IWWl+:h%x$ `x ,x<'8%'H%'X%:h%x$ K[`x `xDl$  xh4x! x xx! x xU4$  xxD<'8%'H%'X%:h%x$ `x `xFDD$  xh4.'H%'X%:h%x$ `x x44$  x+:h%x$ `x dx+:h %x$ `x dx+:h %x$ `x dxx! x xx! x xx! x x$  xPx! x xd$  xPx! x x$  xH@D`L(L(/$ %C:\PROGRA~1\MICROS~rU h  ! !""""a"@ 4||| @ 8~~~I@<ppp@@ rrr@Da@Hi#zzz@Ly 9#vvvmW+:h%x$ `x dx+:h%x$ `x dx+:h%x$ `x ,xi$  x0 0  48P8իG=]hO?BCommand4Command5CorU X$` $A` ny 9!@4i@ 8  @<y 9__SRP_7_VBA_PROJECT 0aEDPASTIFBWYUODMTKQAO_YZGJOGM:<IQEPKQJAFYKXYDPZSNSCCVYIPYTJ:E@@y 9@D @ H1I@La@Prrr@T) ppp@XI @\y 9i ttt@ `aK[@dy 9 xxx@h  |||@l 1WL<'':LN<<:lN\\^6\<+:l%$ ` d+:l %$ ` ,+:l %$ ` ,<' %',%'L%:l %$ ` `$  \<0 H  p<'':LN<<:lN\\^6\<i+:l %$ ` dp$  \<8H`HDGFUTz3I8H(9 QZJL wuu[׼LlH1xuam  *\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{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office\MSACC9.OLB#Microsoft Access 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ADO\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\G{8E27C92E-1264-101C-8A2F-040224009C02}#7.0#0#C:\PROGRA~1\MICROS~2\Office\MSCAL.OCX#Microsoft Calendar Control 9.0kuAF8EDPASTIFBWYUODMTKQAO_YZGJOGM124201e0d8sForm_frmMenu?8IQEPKQJAFYKXYDPZSNSCCVYIPYTJ1>41756e09Form_frmCards 8VSRMPUGVZLOPNDKKAQMANWWQCUH_1?41756f5e&Form_frmRollOverMsgU8P 8xTJGd$8ƯErhfNK 5L\Iɠhg)pztAUXA::j\wpi}؎9C]2 l@4B AccessHendifQF_If{meThen VBAWin16~Win32MacVBA6#Project1  stdole` PurchaseLog ADODBsForm_frmAddMsgl5 _EvaluateCommand5_CliK[ckYDoCmdƧRunMacroXacForm acSaveYesCommand6_Clicki Form_frmChitsCommand18_Click#OpenFormacFormDS acFormEditCommand19_Click\ OpenReport acViewPreview2Command20_Click&RequeryCommand2_ClickacNormalCommand9_Click\Combo12_AfterUpdaters_ RecordsetClone FindFirstM=StrCombo12%BookmarkC Form_Close[ Form_Open-Cancel DataEntryfrmChitProductsVisibleCommand9 Command19Label21fRequsition__Exit} RunCommand`acCmdSaveRecord>Form_frmCommandInfomCommand13_Click!acHiddenForm_frmDivisions Form_frmIntroL Form_TimeracWindowNormall Form_frmMenuQCommand1_ClickV acFormAdd Command11_Clickm OpenQuery acViewNormal RacEditIList7Command14_Click$Quit9 acQuitSaveAll.d Form_GotFocusList7_DblClickԵForm_frmProductsyForm_frmShoppingList%J Form_DblClick$ Form_frmCardsCommand6FormDetail2 FormHeader  FormFooterTCardID CardID_LabelH Cardholder Cardholder_Label#CardTypezCardType_LabelClickfrmTransactionsText9~Label10@Text11rLabel12BText13rLabel14DText15rLabel16F Command17Command17_Click OpenTable! Command18Command1Label0,Command2List4Command7Command7_Click Form_Form16 Command10Text2~Label3,Text4~Label5,Label6,Label7,Label8,Command10_Click% Form_frmDatesgCommand3List1Command3_ClickacFor[acFoacFrac}\aXClosList1_DblClickPDblClickfrmMenunfrmMenXfrmMeQfrmM4 frmÏfrE]docm{ _B_var_docmdocmeǧ _B_var_docmek Command13Balance V Balance_Label TabCtl8@Page9yList11(Page10_ MSACAL ActiveXCtl14  Calandar1d=ValueK _B_var_DatevNow%Command4Command5Command4_ClickIZCombo15% Month_LabelUText17rLabel18HcboMonthutxtFy#frmTransactions_LabelText21rLabel22gYear6nMonth Command23Command23_ClickpForm_frmUpdateMessageNForm_frmUpdateRollOver8 Command24MsgBoxR _B_var_ifPvbYesNovbYesa? _B_var_EndFCommand24_Click% Command25Command25_Click]Combo26& frmTransac>W_B_var_frmTransacReport$TabCtl28-Page29`Page30` frmNewTransF Command33Command33_ClickSetFocus Command34Command34_ClickB&Combo0Label4, Form_frmRollOverMsg+FYH]Command8Command8_ClickIl s 6@Prrr@T) $s F?`VLE3H Lg?< x1H6BjCxx1H6BjCМVLEME[LS S6<<<LLLL<N0{0AAB4833-B1B0-4CDE-A667-F43F3CE60B82} p(K[%LX`xJ@ %r % L`8J %aP ex(L0`8JL`8J L 8`hJ0XL`xJP L`JL:`H80X0(Z| (l (P\ @L p< @@@, p P@ `P 0xd kuA$*\Rffff*124201e0d8*\R1*#25*\R1*#98*\R0*#2*\R0*#14*\R0*#1*\R1*#25*\R1*#98*\R1*#99*\R1*#18 4r8t<x@zD|H~LPpTX) "   " $<"< " $<@"< " "h "   " R< +  "h$+xp " 0$<@"<h8Px0oh  B@BtPo frmMenu 8 h B@&XfrmCards 8 * B@&(XofrmMenu 8 h B@&frmCards 8 v B@&33o(ofrmCards 8 * B@&frmMenu 8 h B@& tblDivision | ~ B@8o B@4"po qryDeleteCard | B@z B@4lete tk(*Are you sure you want to delete this card? X Deleting Card$T Zpp`oXqryAllTransactions | B@zp(kyYou are about to alter any transactions that you have entered for the selected card. If you wish to continue select yes. X$T Z`²Attribute VB_Name = "Form_frmMenu" Bas0{0AAB4833-B1B0-4CDE-A667-F43F3CE60B82} |GlobalSpacFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT P&* Submand3_Click() DoCmd.Qu it acSaveAll E,nd!4 !Open ",(BNal, acHidden;Cards" DacAdd$5 ?$d.&$Edit]$6Q$Tm"tblDivism 3If9Y@aaboualter any transacfs thath_ enpfor e sct . &!a%wishA$co ntinu yes.$"y"`nTHac)#q !&_Dbl#{Cancel As IgerF}J\b?Mnt{t WWl (F73 K[@y=b}ԉ,νXH* i[F(0I$Cxi[F(0I$C3@y=b}MEH@[LS S6LLLL41756e09*\R1*#72*\R0*#2*\R0*#14*\R0*#1*\R1*#f*\R1*#18*\R1*#10*\R1*#d*\R1*#25*\R1*#98*\R1*#99*\R1*#3*\R1*#a*\R1*#7248<@DHLrPpTXt\`xd|hlptx| K[& "+"< "( 8 0 "P <X "". "X*+h,+(+H   ` "  0( "x "  X0o@Ho B@40ho@HfrmRollOverMsg 8 B@&` frmCards  B@BfrmMenu 8 * B@&B PorptTransactions 0 B@.po(qryUpdateMonthandFY | ~ B@zqryAddNewTransactions | ~ B@z rB@4 B@4 B@x` B@xo( rB@xqryClearNewEntries | ~ B@z`HoP B@xee8If Me.DataEntry = True Thenx9Attribute VB_Name = "Form_frmCar ds" Bas0{CE2C1089-58BD-4884-90B4-F4E82AEC9120} |Global!SpacFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  P&* Submand13_Click() DoCmd.DClL ac, ", SaveYesOpenMenu"Nal, #Edit Elnd<D2D9T@ransaces.Requery SetFolcu$4M9.RollOverM,sgH0^,5Report "rpt0Viewv3eA,QA "qryUpdA@rMonth@qFYE_acC]u AddNew' ClearEnes@kpv^3h;)~C!W_#(Cancel As Integera'If Me.gyx Th`en Qb .0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common FVSRMPUGVZLOPNDKKAQMANWWQCUH_:` PROJECT PROJECTwmAcessVBAData     !#$%&'()*+,-./0123456789:;>?@CDEFGHIJKOPQRSTUXYZ[\]^_`abcdefghijklmnopstwx|}~u[׼LlH1z3I8H(9ME,SLS S6LL<0<4<8<<<N0{E9B5E90A-51CD-4A5A-8598-4CA694DA0A77} p0(%L `|  % % L0`@hk0` K[|~|@x @h P0xX(kuA$*\Rffff*1?41756f5e*\R1*#18*\R1*#f*\R1*#99*\R1*#98*\R1*#25*\R1*#a*\R1*#3|4~8p<r@DzHvL  "H(+X&+$+P " $ x0oh` frmRollOverMsg  B@Bzao8qryUpdateRollOvers | ~ B@zqryClearRollOver | ~ B@z frmRollOverMsg  B@BHgAttribute VB_Name = "Form_frmRollOverMsg" Bas0{E9B5E90A-51CD-4A5A-8598-4CA694DA0A77} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT P&* Submand5_Click() DoCmd.OpenQuery "qryUpds", acViHewNalEditClearCl-, " SaveYes En6d0363qxID="{56A4925E-7782-4216-8415-65C880F53F9D}" DocClass=Form_frmMenu/&H00000000 DocClass=Form_frmCards/&H00000000 DocClass=Form_frmRollOverMsg/&H00000000 Name="PurchaseLog" HelpContextID="0" VersionCompatible32="393222000" CMG="5456F3A913F917F917F917F917" DPB="A8AA0F5010501050" GC="FCFE5BF1FB44FC44FCBB" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmMenu=-9, 24, 611, 376, C Form_frmCards=51, 122, 671, 474, C Form_frmRollOverMsg=198, 198, 804, 666, C $<"< Form_frmMenuForm_frmMenuForm_frmCardsForm_frmCardsForm_frmRollOverMsgForm_frmRollOverMsg " R< + "hForms .P:PL:0P:P:Blob ZPropData 0289=Babc$'e g#hfiYj*k>)Dy@h}OX(Gf U$B[Dq,f0u4@qrySelectedCardO{ 9ھ0HnWL$B[Dq,fCardID"!eL4qF$B[Dq,fCardHolder/#TJ!ZBt$B[Dq,fCardTypeջxh`LK"'h}OX(GfrmTransactionsmt3ɿANe VR@ tblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonth7Bi9HIF@ @`0frmNewTransFye}C8"8%:@7BitblNewTransL 5pFormHeaderd TransID_Labeld CardID_Labeld Item_Labeld Tra08=BabcPe gh ij.k"E9@7Bi9HIF\ UFye}C8"8%:@tblNewTrans KI| %FFye}C8"TransIDL R%m7U`a<b,cefkTransDateTransDateMedium Date8The date of the transaction.8MGa o5Ua bpcpd<e fhin "";"";"10";"100"Qyv7M+#X@DivisionDivisionTable/Query SELECT [tblTransactions].[Division] FROM tblTransactions GROUP BY [tblTransactions].[Division] ORDER BY [tblTransactions].[Division]; 1440@The division of the transaction.o05Uabpc d<e fhHin H;Й K,j2U`a<befiRollOverRollOver(Select to roll over.0E$sZj2U`a<ef iCertifiedCertified0Certify the transaction.L.Out-M/^qbo5Uabcd<ein "";"";"10";"100"<+ǕM tItemItemTable/QuerySELECT [tblTransactions].[Item] FROM tblTransactions GROUP BY [tblTransactions].[Item] ORDER BY [tblTransactions].[Item]; 2880o5Uabcd<eh> in "";"";"10";"100"vH O a,CompanyK[CompanyTable/QuerySELECT [tblTransactions].[Company] FROM tblTransactions GROUP BY [tblTransactions].[Company] ORDER BY [tblTransactions].[Company]; 4320`FormFooter K1HV̉}`Ne VR@H0tblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonth*ztAUAdEEt FYtz3M)3AdEEt Companytz3M)3ڤUf601D˂Iw'CompanyEVN \jCJ=+enCardIDiPropData#%MTypeInfo&NPropDataCopyV4)PL:PL:nsDate_Labeld Division_Labeld Type_Labeld Amount_Labeld Company_Labeld RollOver_Labeld Certified_Label Detailm TransIDm CardIDmTransDateoDivisionoTypemAmountjRollOverjCertifiedoItemoCompanyFormFooterMonthFY rE d5U7`\ a<bcType_La 0289=Babe ghvipj%k}Blob WQPropData(*qTypeInfo+rPropDataCopyuг :@@?2JRѬ Umt3ɿANe VR@hU HtblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonth"Roll Over Message Ariald2 Tahomahgh Tahomam45 Tahomao2 Tahoma`@  Detail QNL o5U`bc@ dep,"";"";"";"";"10";"100"Kr8.Bk"6 MonthTable/Query߄SELECT [tblMonths].[MonthID], [tblMonths].[Month] FROM tblMonths; 0;14401"SELECT [tblMonths].[MonthID], [tblMonths].[Month] FROM tblMonths; ";"tblMonths";"";"MonthID";"Month";"PrimaryKey"d125U7`DabceMonth_Label Month -M˒m7U`@ abkFY,=Format(Date(),"yyyy")5faJ d125U7`Dabce Label3FYraBM\d125U7`a,bcd Label4݌Select the month and Fiscal Year you want the transaction to rollover..J*5C%FY hNhh 1U2R`ahiCommand5&Roll Over"[Event Procedure]R"vFfh 1U2C`ahiCommand6&Cancel"[Event Procedure]O)gƫ[Kytion.J2D\hm7U`0a<bceTotaliROG$o5Uabctͬ QZJL wDetailK[d Month_Labeld Label3d Label4h Command5h Command6oMonthmFY@h |||"frmTransactionsfrmMenufrmCardsfrmNewTrans frmRollODirData'-vPropDatay;CmdbarsPL:PL:Modules7PL:PL:verMsg Tahoman2 Tahoma` 2CB0 1CB0 0CB0 3CB0 4CB0 Lase Log/\E~6%DFn3U`aͬ%0{tAUReportHeaderdLabel22PageHeaderSectionGroupHeader0mCardIDd TransDate_Labeld Item_Labeld Division_Labeld Type_Labeld Amount_LabeldCompany_LabeldCertified_LabeldTotal_LabelfReports5PL:PL:03PL:PL:Blob PropData24z08:<=Babc-e g&hXiJj,k*z@9u$DoVU  UAdEEt  9@qryTransactionsIz.WDHAdEEt CardID/#TJ!ZBtAdEEt CardType(F@ G$n]XAdEEt TransDate׃Eu!K*ڦAdEEt TransIDA j*KX5~AdEEt Item((̒LªpAdEEt Divisionr °IEtJL&AdEEt Type HF|YAdEEt Amounttz3M)3AdEEt Company湶C|AdEEt Certifiedw[YmBUPAdEEt Total1[.OYdd09u$DoVU TotalqryTransactionsrptTransactions Arial8-,h`HP LaserJet 5/5M PostScriptS odXXLetterPRIV0''''\K\KH<C-winspoolHP LaserJet 5/5M PostScriptLPT1:d278d eTimes New Romane2g37jghm5<CTimes New Romann7=Times New Romano3:ATimes New Romanp40 CardIDTK[ransDate` ReportHeaderBFO CHc d27`a<b$cXdeLabel22DUSS Stephen W. Groves Purchase LogT KA9N8c`"PageHeaderSectionx-?D@x#`*GroupHeader0u@si(:m0`<a<bc,i CardID CardID&The card ID number.GfqsIC"گd7`tabcd TransDate_LabelDateDetachedLabeltT8#LkJ#L!d`abcd Item_LabelItemDetachedLabel:6 p>NEssd`abtcd Division_LabelDivisionDetachedLabel~xB {i['d`dabtcd Type_LabelTypeDetachedLabelŽp*wBhJd`abtcd Amount_Label AmountDetachedLabelmyJZIѡ6W\d`abtcd Company_LabelCompanyDetachedLabelB/$BId`"abcd Certified_Label Cert.DetachedLabel-)s@+5nd`D%abcd Total_Label TotalDetachedLabel6MJ?KL .R-f2`tabP( Line29DetachedLabel-HGaf2`tabP( Line30DetachedLabel3~Jd=~0f2`tabP( Line31DetachedLabel D1jf2`ta bP( Line32DetachedLabelg,75YRFѣTo0ab@ cd<ef,l n0{tAUCardTypeCardTypeValue List*Consumable;Repairable2160The card Type.d7`<a<bdc,Label35Card Type0{tAU`, DetailVG:Dun m;`tbcTransDateTransDateMedium Date8The date of the transaction.X9,A\O5m`xbkTransIDTransID4The transaction ID number. =uMOIpdem;`bckItemItem8The Item of the transaction.<ňXFV-Qo`a bpcetfn9`!Ob?DivisionDivisionTable/Query1440@The division of the transaction.o0abpcdetfn{j)OQ*cLTypeTypeValue ListCredit;Debit14400The type of transaction.m;`btck Amount Amount*$#,##0.00;($#,##0.00)The company of the transaction.xk LFbRj`"iCertifiedCertified0Certify the transaction.COg$m;`D%ck Total Total1[.OYdd0`hGroupFooter00{tAUm 0;`D%a<bc,i j Text36=Sum([Total])*$#,##0.00;($#,##0.00)0{tAUd7`xa<bTc,d Label37Total Balance0{tAU`"PageFooterSection&SM L}nLm;`<abc Text23 =Now()Long Date,iN9Em;`abck Text24H="Page " & [Page] & " of " & [Pages]VARu `ReportFooter& _VrM f!D%SELECT [tblTransactions].[Item] FROM tblTransactions GROUP BY [tblTransactions].[Item] ORDER BY [tblTransactions].[Item]; 2880o5Uabcd<eh> in "";"";"10";"100"vH O a,CompanyK[,[!KA6odItemITypeInfo{DirData16(PropDataScripts09PL:PL:Line29fLine30fLine31fLine32oCardTypedLabel35DetailmTransDatemTransIDmItemoDivisionoTypemAmountmCompanyj!Certifiedm"Total#PageFooterSectionm$Text23m%Text24(ReportFooterm)Text36d*Label37+GroupFooter0,RollOver] ORDER BY [tblTr"rptTransactions]; 4320`, 0CB0ooter%՗*J"Hsm07U`txtBaijCount([CardID])=0,0,SMSysDb)*$#,##0.00;($#,##0.00)' vAYtC Form_frmCards=51, 122, 671, 474, C Form_frmRollOverMsg=198, 198, 804, 666, C $<"< Form_frmMenuForm_frmMenuForm_frmCardsForm_frmCardsForm_frmRollOverMsgForm_frmRollOverMsg " PropDataDatabases8=:PL:PL:0<;PL:PL:Blob DirDataCustomGroups>PL:PL:DataAccessPages PL:PL:3ɿANe VR@ tblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonth7Bi9HIF@ @`0frmNewTransFye}C8"8%:@7BitblNewTransL  @u6jL[1E [tblTransactions].[Item]7 g [tblTransactions].[TransID]: g [tblTransactions].[CardID]9 g tblTransactions///  tblCards!!!     Gf@* '[tblCards].[CardType]4 g[tblCards].[CardHolder]6 g[tblCards].[CardID]2 gtblCards!!!   Gf@* '[tblCards].[CardType]4 g[tblCards].[CardHolder]6 g[tblCards].[CardID]2 gtblCards!!!  G  G tblTransactions.Company6 ' tblTransactions.Company6 gtblTransactions.Company6 gtblTransactions///  G G  GtblTransactions.RollOver0OA wtblTransactions///  G G  G blNewTrans].[Certified]8 g [tblNewTrans].[RollOver]7 g [tblNewTrans].[Company]6 g [tblNewTrans].[Amount]5 g[tblNewTrans].[Type]3 g[tblNewTrans].[Division]7 gblNewTrans].[TransDate]8 g[tblNewTrans].[Item]3 g[tblNewTrans].[CardID]5 g[tblNewTrans].[FY]1 g[tblNewTrans].[Month]4 g[tblNewTrans].[TransID]6 gtblNewTrans'''  G  G l@* ' tblTransactions.FY1 g tblMonths.Month. g tblTransactions.CardID5 gtblTransactionstblMonthsR@*MA/ tblTransactions.FY1 gtblMonths.Month. gtblTransactions.CardID5 gtblMonths### tblTransactions///  G G  G [tblTransactions].[CardID]9 gBalance@*+ o[tblTransactions].[CardID]9 g tblTransactions///    Gl@* ' tblTransactions.Certified8 g tblTransactions.RollOver7 g$ LVAL R 4 H (((tblTransactions.Division)=[Select Division]))((([tblTransactions].[RollOver])=-1))((([tblTransactions].[Month])=[Forms]![frmCards].[Month]) And (([tblTransactions].[FY])=[Forms]![frmCards].[Year]))[tblCards].[CardID]=[tblTransactions].[CardID]IIf([Type]="Credit",[Amount],[Amount]*-1)((([tblCards].[CardID])=[Forms]![frmMenu].[List1]))((([tblCards].[CardID])=[Forms]![frmMenu].[List1]))(((tblTransactions.CardID)=[Forms]![frmMenu].[List1]))tblTransactions.Month = tblMonths.MonthIDSum(IIf([type]="Credit",[Amount])-IIf([Type]="Debit",[Amount]*-1))(((tblTransactions.CardID)=[Forms]![frmMenu].[List1]))"o+V  S  q S 5  {   w Y ;  S)#`@ * '#tblTransactions.Division[Enter Updated Info]cA w#tblTransactions/// # G# G# # G"J@ * '"tblTransactions.Month"[Forms]![frmRollOverMsg].[Month]i; w"tblTransactions.FY[Forms]![frmRollOverMsg].[FY]`5 w"tblTransactions/// " G" " G!tblNewTrans.FYorms]![frmCards].[Year]T- w!tblNewTrans.Month[Forms]![frmCards].[Month][3 w!tblNewTrans''' ! G! G! ! G @* ' tblCardstblTransactions\@*K?!  [tblTransactions].[FY]5 g  blTransactions].[Month]8 g  [tblCards].[CardType]4 g  TotalR@*' o  [tblTransactions].[Certified]< g  [tblTransactions].[RollOver]; g [tblTransactions].[Company]: g [tblTransactions].[Amount]9 g [tblTransactions].[Type]7 g [tblTransactions].[Division]; g [tblTransactions].[TransDate]< g  B 6Cy@0u4@qrySelectedCard@I|@HXLL@@@@@@@> @Au9@#eu9@ qryClearNewEntries@G|@F^RRFFFFFFFD @d?}:@d?}:@~sq_ffrmNewTrans4MR2KeepLocal TBBBBBBB@ @ ׀y@ ׀y@~sq_cfrmMenu~sq_cList44MR2KeepLocal TNNNNNNNL @ A:@ A:@~sq_cfrmCards~sq_cfrmTransactions4MR2KeepLocal Tdddddddb @ f"Sy@f"Sy@frmTransactions\@DLLL@@@@@@@> @ 6y@?̆|@AccessLayout4MR2KeepLocal T@Bzz:::::::8 @$ Q9@ Q9@tblCardstblTransactionsPPPPPPPPPPN ;42y@gѹ:@tblTransactionslN+LLL@@@@@@@> @6i9@8%:@tblNewTrans>L+DDD88888886 @2|R@ VR@tblMonths@K@@@44444442 @-A0y@ Q9@tblCardsE@K>>>22222220 @#I:@IJ+:@0Query1h@I|@JF::......., @6YN..Y  Y d Y d CardIDCardHolderCardTypeDD.0.1Y;YY.rC CardIDPrimaryKeyv1-SK2(SW)RosenbergRepairable$SK2(SW) RosenbergConsumable%-//-//Y iiiN33 Y  Y idMonthID Month35YPrimaryKeyv1 2 {gUB/ September August July  June May April March FeburaryJanuaryDecemberNovemberOctober 2 @44444444 4 4  4  4  cYN  77Y Y  Y dY  Y DdY   Y d Y DdY  Y  dY  Y  TransID MonthFY CardIDItemTransDateDivisionType AmountCompanyRollOverCertifiedDD78DDD79DDD7:DYYY CardIDPrimaryKeyTransIDv1 6 6 6 =Y8XN  << Y Y Y  Y Zd Y  dY   Y d Y dY  Y  dY  Y  TransID CardID MonthFYItemTransDateDivisionType AmountCompanyRollOverCertified<><?YY-Y CardID.tblCardstblTransactionsTransIDv1@  ;A  n F 2 6 @ 2006Dry suit050DebitSAFTEY SYSTEMSK;4.$ @2005Fort Worth050CreditSERVMARTH>60$ @P 2005wrench05dDebitSEARS@92,$ @$S2005FT Worth050DebitSERMARTD;4.$ Se }@72003TURN BUCKLESDECKDebitGULF SALES & INCSA:2$ Se `}@J2003Carb CutterEM04DebitNEW HERMESL@91$ Se `}@Í2003P-GOULAEM02DebitSERMARTE<5-$ Se `}@2003SOFT CHARTSON01DebitCAPN NAUTICAL TECHNOLOGIES\@91$ Se }@2003Tool sharpenerEM04DebitSEARSJC<4$ Se |@P-2003HYDRO BOTTLESEM04DebitSAFTEY SYSTEMSRB;3$ Se |@%2003P-GOULASS02DebitSERVMARTF<5-$ Se |@!x2003SupplysEM04DebitTRIDENT SUPPLYL<5-$ Se |@2003WALL MOUNTSSupplyDebitEXPO@NETSOD=1$ Se @|@PS200312FT BoatDECKDebitMCLEOD MARINEM>7/$ Se @|@<2003Plastic fuel tankDECKDebitMCLEOD MARINEUF?7$ Se @|@p2003Dry suitOC03DebitDIVERS DENI=6.$ Se {@m2003Port-o-pottiesSupplyDebitDisposall incVG@4$ ; B! ========== = = = = === ; @ @== ========== = =  =  =  = _otblCardstblTransactionstblTransactionsCardIDtblCardsCardIDvfZ<QQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'     Sf]\F5׍zC2S! 16Jse Z†|.*ά&qtblNewTransά( &btblCardstblCardsDotblTransactionstblTransactionsʾtblCardsqryDeleteCard frmMenurptTransactions^3LVAL | ; IMR2 GUIDNameMap @?2JRƴ  Umt3ɿANe VR@hU HtblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonthMR2 GUIDNameMap 7Bi9HIFd \ UFye}C8"8%:@tblNewTrans KI| %FFye}C8"TransIDL +   z g T @-}iVC/ lXE2 ; ;Sf]\F5׍zC2S! 16Jse Z†|.z&qtblTransactionsLVAL MR2RecordLocksODBCTimeoutUseTransactionFailOnErrorOrientationNameMapDOL  <     UFye}C8"Ҽ1i9@Ho"tblNewTrans KI| %FFye}C8"TransIDQ(@#?Fye}C8"MonthiG+yENʔFye}C8"FYL The company of the transaction.      m   0Z'L/):fRollOver   0 (Select to roll over. Yes/No    j r NTF! Certified   8 0Certify the transaction. Yes/No    j Gs8ÝJ׺-_VType   8 0The type of transaction. "Debit"      o Value List  Credit;Debit    1440  2160twip    ^xޡH-Ӽ FY   N FThe Fiscal year of the transaction.      m   iG+yENʔ Month   @ 8The Month of the transaction   0    o Table/Query SELECT [tblMonths].[MonthID], [tblMonths].[Month] FROM tblMonths ORDER BY [tblMontLVALhs].[MonthID];     0;2160   2880twip  Q(@#?Division   H @The division of the transaction.      m    `aDt.-*LVAL+OMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlAllowZeroLength$UnicodeCompressionGUIDRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList    UڤUf601D˂Iw'8o:@tblTransactions׃Eu!K*ڦڤUf601D˂Iw'TransIDIz.WDHڤUf601D˂Iw'CardIDmt3ɿANe VR@R tblMonthsi0K)Nh/r%Umt3ɿANeMonthIDU} ]rWF Lfmt3ɿANeMonth#gQxN9;ڤUf601D˂Iw'Month*ztAUڤUf601D˂Iw'FYA j*KX5~ڤUf601D˂Iw'Item(F@ G$n]XڤUf601D˂Iw'TransDatebFNb~MrkMێ :@tblDivision=}9`O5ڤUf601D˂Iw'Divisionr °IEtJL&ڤUf601D˂Iw'Type HF|YڤUf601D˂Iw'Amounttz3M)3ڤUf601D˂Iw'Company@qG]GLvsڤUf601D˂Iw'RollOver湶C|ڤUf601D˂Iw'Certified ڤUf601D˂Iw' CardID    . &The card ID number.    0  m Iz.WDHTransDate    @ 8The date of the transaction. Medium Date =Date()  (F@ G$n]XItem    @ 8The Item of the transaction.   m  A j*KX5~ Amount    D <The amount of the transaction.2 *$#,##0.00;($#,##0.00)    0   HF|YCompany    F >The company of the transaction.   m  tz3M)3RollOver    0 (Select to roll over. Yes/No  j @qG]GLvsCertified    8 0Certify the transaction. Yes/No  j 湶C|VType    8 0The type of transaction. "Debit"   o Value List  Credit;Debit    1440  2160twip   r °IEtJL& FY    N FThe Fiscal year of the transaction.   m  *ztAU Month    @ 8The Month of the transaction    0  o Table/Query SELECT [tblMonths].[MonthID], [tblMonths].[Month] FROM tblMonths ORDER BY [tblMonths].[MonthID];     0;2160   2880twip  #ghLVALxQxN9;TransID    < 4The transaction ID number.    0  m ׃Eu!K*ڦDivision    H @The division of the transaction.   m  ((̒Lªp