Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6Vx߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{nefitCode_GotFocuscboBenefitCode_KeyPressQtxtBenefitName_Change BenefitNameŃtxtBenefitName_KeyPresstxtRateMultiplier_KeyPress. acCheckBoxq rstBenfitDescvbYesa?MultiplyHoursWithRatehvbNo% Form_frmEmployeeDataOrstEmployeeDataZcboExistingRecords_AfterUpdatecboExistingRecordsStmpCompanyCodeIcboCompanyCodtmpCompanyCodetmpEmployeeCode&txtHoursDcboBenefitNameVtmpBenefitCodeȉ ClearCodekItmpEmplobeeCode FieldMarkerDRecordOKcboExistingRecords_EntercboExistingRecords_GotFocuscboCompanyNamecboEmployeeName Form_frmMainMenubtnBenefit_ClickErr_btnBenefit_ClickA stDocNamezstLinkCriteriaYOpenFormExit_btnBenefit_ClickbtnCompany_ClickErr_btnCompany_Click٤Exit_btnCompany_Click8 btnEmployee_ClickErr_btnEmployee_ClickExit_btnEmployee_Click[btnDataEntry_ClickQErr_btnDataEntry_Click_Exit_btnDataEntry_Click; btnBenefit btnCompany( btnEmployee{  btnDataEntryBenefitName_LabelIBenefitShortDescription_LabelBenefitLongDescription_LabelNfRateMultiplier_Label$MultiplyHoursWithRate_LabelwtxtBenefitShortDescription=txtBenefitLongDescriptionvtxtRateMultiplierh[Benefit_Code_LabelchkMultiplyHoursWithRate-KLabel21fLabel23hchkIsEmployerContribution>chkIsEarningCodew NotInList Hours_LabelG2 Rate_LabelbStar 8_!@?VC3S FF          2                   IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        ~&e@~&e@~sq_cfrmEmpl)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmplo)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmployee)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmplo)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' @pd@e@rptSummaryBenefitStatement n_0x]DNNNNNNNNNN9 #Zd@A( e@frmMainMenu n_0x]D??????????* @Rd@Jae@frmEmployeeData n_0x]DCCCCCCCCCC. lud@Ne@frmBenefitDesc n_0x]DBBBBBBBBBB- DžV@k*e@frmEmployeeDesc n_0x]DCCCCCCCCCC. +vT@?BRU@modUtilities n_0x]D@@@@@@@@@@+  CjwV3d@-e@frmCompaarVCS  E   2  ObjectIdSIDACM FInheritable ObjectIdJJJJJJJJĀ n( B)k!N!H&\( B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ( B)( B)k!N!H&\( B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ( B)( B)k!N!H&\( B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ( B)( B)k!N!H&\( B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ( B)( B)k!N!H&\( B)k!N!H&\( B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o      B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o VC?S             ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  VCS             szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationship {qg]SI?5@@A`` @@o{< @7 u<g?P@7@7 @7@7 @@7@75@7M@7@7@7(@7@@7@7@7@7@7@7@75@7M@7    2   2    EmployeeDesc.EmployeeCode EmployeeDescEmployeeDesc.LastNameEmployeeDesc.FirstNameEmployeeDesc.SSNumber@7x@7 @7H@7 X@7~&e@p@7@7 @70vl @70vl 5@70vl M@70vlEmployeeDesc@7@7@7@7X@7 ,d@(~sq_cfrmEmployeeDesc~sq_cCboEmployeeCode@7 @7@@7 H@7h@7 p@7@7  @7@7[EmployeeDesc].[EmployeeCode] @7[EmployeeDesc].[LastName]H@7[EmployeeDesc].[FirstName]p@7[EmployeeDesc].[SSNumber]@7 @70vll>@70vl~w5@70vltlM@70vltlEmployeeDesc @7@7 @7@7 5@7@7 M@7@7 @7H@7p@7@7 @7@7P@7 X@7@@7P@7`@7p@7@7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7 @7@7@7 @7@7@7@7 @7@7 @7@7 @7@7 |@7 @7@7@7xl@7@ @7p @7@7 @7 @7 @70@7 @ @7 p @7  @7  @78@7@7@7@7@ @7p @7 @7 @7@7 EmployeeDesc (@7 0@7 o{@5@@ @ @@@@@guoafpfgjwdfvbguobros`p}dfvbguofosmr}ffd`w`guofosmr}ffdfvbguoifms%guoo`jpofpxguovxoo`u}afpfgjwufsruwordxwjmjwjfvuswvxoo`u}afpfgjwvw`wfofpw uswvxoo`u}afpfgjwvw`wfofpwvxa`xwrf|fba`b`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv1vt,bguoafpfgjwdfvb1vt,bbarafpfgjwbrdf#1vt,bguobros`p}dfvb1vt,bbarbros`p}brdf1vt,bguofosmr}ffd`w`1vt,bbarafpfgjwbrdf1vt,bguofosmr}ffd`w`1vt,bbarbros`p}brdf1vt,bguofosmr}ffd`w`1vt,bbarfosmr}ffbrdf1vt,bguofosmr}ffd`w`1vt,bbarf|jvwjphufbrudv1vt,bguofosmr}ffdfvb1vt,bbarfosmr}ffbrdf1vt,bguovxoo`u}afpfgjwufsruw1vt,bbarlf}fpdjph1vt,bguovxoo`u}afpfgjwufsruw1vt,bbarlf}vw`uwjph1vt,gguoifms1vt,gguovxoo`u}afpfgjwufsruw1vt,uuswvxoo`u}afpfgjwvw`wfofpw"afpfgjwdfvbbros`p}dfvbfosmr}ffd`w`fosmr}ffd`w`txfu}fosmr}ffdfvbifms$ov}v`bfvov}vordxmfvov}vordxmfvX ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdafpfgjwdfvbfosmr}ffd`w`bros`p}dfvbfosmr}ffd`w`fosmr}ffdfvbfosmr}ffd`w` o ! "Total2@M o ! "Total2@M o ! "Total2@M o ! "Total2@M o ! "Total2@M o it  it o{ @ #V`#Vl#Vm#Vn#Vo#Vp#Vq#Vr#Vs#Vt#Vu#Va%V%V%V%V' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' (88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(88(= @ @ @ @ @ @           "#% !"#$%!+13 h$ GCompanyDesc  GCompanyDesc  G G GCompanyDesc ompanyDesc].[CompanyName]3 gompanyDesc].[CompanyName]3 g  GBenefitDesc  GBenefitDesc  GBenef GBenefitDesc  GBenefitDesc  GBenefitDesc  G G G GBenefitDesc  GBenefitDesc  GBenefitDesc  GBenefitDesc  G G GBenefitDesc enefitDesc].[BenefitName]3 genefitDesc].[BenefitName]3 g  G GCompanyDesc ompanyDesc].[CompanyName]3 gompanyDesc].[CompanyName]3 g  {qg]SI?zenable  ControlType acTextBox~ _B_var_IfPSetFocusValueK DeptRecordsetAddNewaDeptO txtNewDeptπDscrpB txtNewDscrpUpdateCompDescRecordset/ Recordset _B_v@@@  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @I^ Y\ !"#$J % & ' K ( )  L    M    O    P   _[]X  !Z  789*+,=>?N@AB C D E!F!G!H"c"c"c"c#c#c#c#c$c$c $c $c %c %c %c%c   !S"T!!!!U++ + +V1 11333h:h;h<hWR    Q.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0. 0.0.0.0. 0.CompanyDesc PrimaryKey0. 0.h0.x 0* (((((((( ( ( ( ( (( ( ( ( ( ((((((((((((( (!("(#($(%(& ('!(("()#*$*%*&*'*(*)***+** * * (**'*%*&* *!*"*#*$**(***+*,*-*)tyxvwuz~|}{      !!!~~~~~~~~~~~ afpfgjwdfvbfosmr}ffd`w`bros`p}dfvbfosmr}ffd`w`fosmr}ffdfvbfosmr}ffd`w`ocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl h CompanyName     Company Name    mh CompanyCode     Company Code    mY City     City    m[ State     State    m_ Zipcode    Zipcode    mp PhoneNumber    Company Phone Number    ml FaxNumber    Company Fax Number    ms FedNumber   ! Company Federal ID Number    mmPeriodStartDate   (  Start Date for Benefit Reporting  i PeriodEndDate   & End Date for Benefit Reporting  gAddress1    Address Line 1    mgAddress2    Address Line 2    m|GeneralBenefitStatement   & General Benefit Statement Text   @fosmr}ffd`w`fosmr}ffd`w`fosmr}ffd`w`afpfgjwdfvbbros`p}dfvbfosmr}ffdfvb+i +iT2Od@+i+i}+im}+imBenefitDesc`+i0+iP+i( +i+ipd@,~sq_cfrmEmployeeData~sq_ccboBenefitCode+i +i +i +i(+i+i+i +ims+imsBenefitDesc +ix+i +i+i+i+i +i +iX +i +i@+iH+iP+iX+i`+i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i +i+i+i+i+ix +i +i( +i +i( +i |+i  +i+i +im+i +i +i8 +i  +i  +i0 +i +i +i +i( +i BenefitDesc  +i +iPrimaryKey BenefitCode +i n_0x]D+iv  +i+i+i+i +is +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +i +ip+i +i+i`+i+i +iBenefitDesc PrimaryKey+i +i +iH +i +i+i +i+iP+i+i+i( +i;!QJFnjE Er3t8eaBAsoA&Ņ3333ѱ1d@3ѱ1d@3ѱ1d@ѱ1d@MSysModules2 n_0x]D@@@@@@@@@@+ 1ѱ1d@ѱ1d@MSysModules n_0x]D??????????* +Z62d@ ,d@EmployeeDesc999-------+ @ !|1d@tVd@EmployeeData@999-------+ @ A1d@pd@BenefitDesc@888,,,,,,,* @ d2d@ d2d@BAC Admin n_0x]D@I=========(  @pd@Z 11e@rptSummaryBenefitStatementSub>>>>>>>>>>< +vT@Y$-e@modUtilities----------+  3\4d@ >3e@frmSummaryBenefitReport88888888886  #Zd@ e@frmMainMenu,,,,,,,,,,*  DžV@:be@frmEmployeeDesc0000000000.  @Rd@Jae@frmEmployeeData0000000000.  CjwV3d@{\e@frmCompanyDesc//////////- lud@ae@frmBenefitDesc//////////-  Oѱ1d@Oѱ1d@UserDefined n_0x]D??????????*  Oѱ1d@Oѱ1d@SummaryInfo n_0x]DX@KKK???????* @ѱ1d@ѱ1d@SysRel n_0x]D::::::::::% ѱ1d@ѱ1d@Reports n_0x]D;;;;;;;;;;& ѱ1d@ѱ1d@Modules n_0x]D;;;;;;;;;;& Oѱ1d@Oѱ1d@MSysRelationships22222222220 Oѱ1d@Oѱ1d@MSysQueries,,,,,,,,,,* Oѱ1d@Oѱ1d@MSysACEs))))))))))' Oѱ1d@Oѱ1d@MSysObjects,,,,,,,,,,* Oѱ1d@Oѱ1d@MSysDb n_0x]DE@FFF:::::::% @Oѱ1d@Oѱ1d@Relationships.........., Oѱ1d@Oѱ1d@Databases**********( ,б1d@,б1d@Tables''''''''''% VCN    2        BenefitCode BenefitNameBenefitShortDescriptionBenefitLongDescriptionRateMultiplierMultiplyHoursWithRate IsEarningCode !.rC BenefitCode PrimaryKeygruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r +r+r+r+r(+r +r +rX +r  +rX +r |+r  +r+r +r)+r +r( +rh +r  +r ( +r0 +r +r +r( +rX +r CompanyDesc  0 +r  8 +r  H +rZipcodePrimaryKey CompanyCode` +r n_0x]D+rv h+rH+rX+r+r+rs+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r+r +r+r+r+r +rCompanyDesc PrimaryKey+r +rh+rx +rh+r{qg] @ @ @           K K K8 KP KHAs(K(K(K(K(K(K(K(K(K(K(K(K(K K K K K K K K K K K K K K K K K K K K K K K K K K K K K KKDKhKKKKK K$ K< KT Kt K K K K K$ KL Kl K K K K K K8 K` K K K K K K K)- KM Km K K K K K K KE K     2   2   2                       @@ l ^,x/@    @@guoafpfgjwdfvbguobros`p}dfvbguofosmr}ffd`w`guofosmr}ffdfvbguoo`jpofpxguovxoo`u}afpfgjwufsruwordxwjmjwjfvuswvxoo`u}afpfgjwvw`wfofpw`xwrf|fba`b`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd8KHAsPKxKHAsKKHAsK KHAs K0 KHAsH K h KHAs K  KHAs K  KHAs K @ KHAs` K  KHAs K KHAs K Koyee KQuerH Kp K K K K K K K@ K` K K K K K K K8 K KP K!K K@s& K@sXs' K@s (E K@s??VLTCVol LT DisVoluntary Long-term DisabilityAA ?VisionVisionVSP Discount Card22 ?medicalMedicalUnited Health Care PPO-Option 2BB ?HCSAHC Spend AcctHealth Care Spending AccountBB ?ESPPEmpl Stock Purchase Plan1@11% ?EmprSTDisShort Term Dis'@,,  ?EmprLTDisLong Term Dis&@++ ?DentalDentalMetlife Dental// ?CERAComm Exp Reimb Acct&@,, ?BasicADDBasic AD&D0@'' ?401K401(k) Plan8@$$ LiLi17Medical InsuranceMedical Insurance(@E9 ?06401K401K Retirement Plan@;/ ?01Example EarningsShort 1 Line DescriptionU@K? LVALqI0K 80K h0K 0K 0K 0K (1K X1K 1K 1K 1K2K H2K x2K2K2K3K 83K h3K3K3K3K(4KBKԇ >K(>K0>K8>K@>KH>KP>KX>K`>Kh>Kp>Kx>K>K>K>K>K>K>K>K>K>K>K>K>K>K>K>K>K?K?K?K?K) ?K(?K0?K8?K@?KH?KP?KX?K`?Kh?K EKPFKFKx,K,K,K-K8-Kh-K-K-K-K(.KX.K.K.K.K/KH/Kx/K/K/K0K80Kh0K0K0K0K(1KX1K1K1K1K2KH2Kx2K2K2K3K83Kh3K3K3K3K(4Kt?K?K?K?K ?K?K?K ?K /K[MultiplyHoursWithRate] ?K?KXAK,?K?KX@K?K@K0@K @K 3K[Rate] 4@K 3K [Hours]\@Kh@Kl@Kx@K,|@K@K@K@K@K@K@K /K[RateMultiplier]@K~w @K@KAK @K~wAK(AK ,AK /K[RateMultiplier]\AKhAKlAKxAKAK|AK 3K[Rate]EKAKAKAKAK AKAK0BKAKAKBKAK /K[RateMultiplier]BK~w4BK@BK`BKDBK~wdBKpBK tBK /K[RateMultiplier]BKp?KAK(;K xBKBKAKBK@KBK8@KBK0AKBK@KCK-?KCK9K7K86KX4KEmployeeData CK CK CK DK DK (DK @DKPrimaryKeyEmployeeDescEmployeeData EmployeeCode%CompanyDescEmployeeDataCompanyCode4BenefitDescEmployeeDataBenefitCodeEKEmployeeDesc DK DK  EJ< DAO>BDA@O *\G{000@25E01-0C  0046}#4.0#0#C:\Program Files\Common Microsoft Shared\w\dao350.dll# 3.51 Object Li`braryH QForm_frm8panyDesc _VBA_MOD@ULE2VBt_MvDULE H1`q ,Q6"(+modUtilities<__SRP_0'K)^ rU ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~u @MAP7C у͚p    A&&HRKRKRKxRKRKKJK@SK PSKXSKdSKPrimaryKeySK MKtSK R401(k) Up to 15% of Pretax income 50% of 4% Contrb Match401(k) Up to 15% of Pretax income 50% of 4% Contrb MatchGroup Accidental Death and Dismemberment BenefitShares of Company Stock Purchased at 15% DiscountEmployer Provided Short-term DisabilityEmployer Provided Long-term DisabilityCommuter Expense Reimbursement Accountm@ @ VWV\W]ZVWla`vjb`ddbfu`dfpw`mfosumwdjvfosuvwdjvfvss ibv` ofdjb`m zjvjrp zmwb UpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtra  Id ParentIdName        ~&e@~&e@~sq_cfrmEmpl)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmplo)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmployee)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' (~&e@~&e@~sq_cfrmEmplo)\^e@\^e@AutoExec n_0x]D_@ CH<<<<<<<<<' @pd@e@rptSummaryBenefitStatement n_0x]DNNNNNNNNNN9 #Zd@A( e@frmMainMenu n_0x]D??????????* @Rd@Jae@frmEmployeeData n_0x]DCCCCCCCCCC. lud@Ne@frmBenefitDesc n_0x]DBBBBBBBBBB- DžV@k*e@frmEmployeeDesc n_0x]DCCCCCCCCCC. +vT@?BRU@modUtilities n_0x]D@@@@@@@@@@+  CjwV3d@-e@frmCompaarm@ @ VWV\W]ZVWla`vjb`ddbfu`dfpw`mfosumwdjvfosuvwdjvfvss ibv` ofdjb`m zjvjrp zmwb se 2  sx)r  sx)r!%sx)ralBeiEmployeeDescsss s0s ,d@(~sq_cfrmEmployeeData~sq_ccboEmployeeCodeHs ss ss sssss sx)r . sx)rCon%sx)rmberEmployeeDesc ss ss %sssss sss 0s@sPs`spsss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss sssss@s s s s s s s |s spss,rHs@ sp s s s s @ s p s  s4 xsss@ sp s s s EmployeeDesc s s sZipcodePrimaryKey EmployeeCodes n_0x]Dsv ssssssssssssssssssssssssVCN     2  2  2        ny  e  s    CompanyCode CompanyNameAddress1Address2CityStateZipcode PhoneNumber FaxNumber FedNumberPeriodStartDate PeriodEndDateGeneralBenefitStatement efCeefD !.rD CompanyCode PrimaryKeyZipcode  8+h8+h+h+h+h8+h<+hm%+hmE+hmEmployeeData +h+h %+h+h E+h+h+h+h8+h EmployeeData +hp+h +h X+h@+hP+h`+hp+h+h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h +h+h+h+h+h +h+h +h "+h +h "+h +h "|+h +hH+h+hXm+h +h8 +h +hh +h +h h+h  +h 8 +h h +h8 +h+h+hLL +hX +h8+h\ +hh +h+hl +hx +h +h| +h +h +h +h  +h [CompanyCode] +h",-," +h 8 +h[EmployeeCode]+h",-," <+h h +h [BenefitCode]l+hH +h +h +h +hx+h@+h+h +h8 +hh +h +h EmployeeData H+h X+h x+h +h +h +hE{qg]WtpMc匞t[GF߁NUx9ZQ9UZ PSLS S<L LLLLLLLLLLLL<<<<<<<<<<<<<<<<<<<<<<<<<<<<<N0{151C923A-6B63-4F75-900E-0AB4DF31CDC5} ]>*\R2*#2d"*\Rffff*e3e5d13d2*\R1*#2b*\R1*#3d*\R1*#3f"*\Rffff*d3e5d138f*\R2*#2f*\R2*#30*\R0*#4*\R2*#1b*\R2*#31*\R0*#c*\R1*#50*\R1*#52*\R0*#2*\R1*#56*\R1*#58*\R1*#6*\R1*#2a*\R1*#1c*\R1*#a*\R0*#11*\R0*#16*\R0*#10*\R0*#1*\R0*#d*\R1*#2e*\R1*#85*\R2*#28*\R1*#8e*\R1*#8f*\R2*#0 X<(h(LVAL p<+':ug?X +'+'+' +'  +'+'+'+'+'+'+'+'    2 #CompanyDesc.CompanyCodeCompanyDescCompanyDesc.CompanyName+'+'+'+' +'\A6be@+'+'H&+'i+'i CompanyDesc+'  p+'+'X +'+'yOMd@,~sq_cfrmEmployeeData~sq_ccboCompanyCode+' +'@+' H+'h+'ompanyDesc].[CompanyCode] +'ompanyDesc].[CompanyName]H+' +'i+'iCompanyDesc +'+' +'+' +'H+' +'+' +' +'@+'H+'P+'X+'`+'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+' +'+'+'+'(+' +' +'X +' +'X +' |+'  +'+' +'i+' +'( +'h +'  +' ( +'0 +' +' +'( +'X +' CompanyDesc 0 +' 8 +' H +'ZipcodePrimaryKey CompanyCode` +' n_0x]D+'v h+'H+'X+'+'+'s+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+'+' +'+'+'+' +'CompanyDesc PrimaryKey+' +'h+'x +'LVAL 8(H(hx(;v%F4My)?AX,cQFb(CENL>zHCu ID̒Qiqh7G"Nz:eq{CSqzh3EDwaQ8)KjY%I_G"n7N AccessAnd as=DimCEachDElseGEndUFor_Goto`IfcIn|MeNotOrPrivateRedimSELECTSetSubThenToTrue VBAWin16~Win32Mac DAO benefitstatement7 Form_frmCompanyDescA _EvaluateForm FormHeader Detail2 CompanyNameCompanyName_LabelAddress1OAddress1_LabeloAddress2PAddress2_LabelCityD City_LabelState State_LabelYJZipcode; Zipcode_Label% PhoneNumberPhoneNumber_Label FaxNumberFaxNumber_Label FedNumberFedNumber_Label'PeriodStartDatePeriodStartDate_Label PeriodEndDate@PeriodEndDate_Labelu=Combo24&Company_Code_Label FormFooterT CompanyCode Form_Load{cboCompanyCodetxtCompanyName7 txtAddress1 txtAddress2txtCitytxtState txtZipcode.txtPhoneNumberX- txtFaxNumber1 txtFedNumbertxtPeriodStartDatetxtPeriodEndDateAxcboCompanyCode_AfterUpdateJRecordsetClone8 FindFirstM= cboDeptNumqNoMatch/3BookmarkC LVAL 9AfterUpdate _B_var_ForjLControlctlControlsK Properties+Itemzenable  ControlType acTextBox~ _B_var_IfPSetFocusValueK DeptRecordsetAddNewaDeptO txtNewDeptπDscrpB txtNewDscrpUpdateCompDescRecordset/ Recordset _B_var_Set OpenRecordset|_B_var_OpenRecordsetsP Workspace3_B_var_Workspace SecureSpaceNDBEngineQCreateWorkspacek5dbUseJetGSecureDbl: OpenDatabase` CurrentDbSSpace Db\ CompanyDesc]o dbOpenDynaset _B_var_CompanyDesc>QCollect _B_var_Error) ActiveControly Application*ParentEnabled۪RequerycboDeptNum_AfterUpdate~ NulcblCompanyCode|/_B_var_cblCompanyCodeNzu^RefreshRepaintcboCompanyCode_GotFocus2GotFocusK RecordSourceb CurrentRecord@Ri_B_var_R_B_var_BFields7rstCompanyDesc*FormFillF SetControls! ReadRecordcboCompanyDesc 3_B_var_cboCompanyDesc cboCompany^CTrim@ _B_var_TrimmTrecordField3Fiels 4Count0v _B_var_MidpToUpper_B_var_ToUpper1aX_B_var_aStrConvx' vbUpperCasek._B_var_StrConv{strngaNamerstCompanyDescrst _B_var_rst, RecordLockI LockRecord+ LockEditsEdit+GlobalRecordLocked7_B_var_GlobalRecordLockedB WriteRecordȳOnbE _B_var_OnbV| _B_var_On6LockRecord_Lock_Failed#msgQ _B_var_msgbrMsgBoxRvbOKOnly CancelRecord1 CancelUpdate5 NewRecordGlobalNewRecordC ClearFormcmdSave cmdSave_CliLVAL :ck btnCancelIVbtnCancel_Clicke Form_Close[Click vbOKCancelx?vbOK%txtCity_BeforeUpdate/Cancel BeforeUpdate6 _B_var_ctl=ItemData  _B_var_LeftQNameThenbtnSave{ btnSave_ClickRdbLabel_B_var_dbLabel acLabel Label1, _B_var_Label16 Address1Label_B_var_Address1LabelhLabela _B_var_Label%CompanyNameLabel}acCommandButtonMd _B_var_field(DinŃ _B_var_Din@cboCompanyCode_Enter+Enter btnDelete6btnDelete_Click  DeleteRecordHDeletexErroQ[OriginalValues= _B_var_Redim RecordChangedLoclRecord_New_Failed}LockRecord_New_FailedForm_Load_FailedErro _B_var_ExitDoCmdƧacFormFormNameI_B_var_OriginalValues?Number-_B_var_LockRecord_Lock_Failed IIfzModule1b (LimitKeyPressԱiMaxLenKeyAscii#Err_LimitKeyPress5R SelLength vbKeyBack2BeepExit_LimitKeyPress:LogError&' Description  (LimitChangeCErr_LimitChangeF/ vbExclamationSelStartZExit_LimitChangeiG modUtilitieshktxtCompanyName_KeyPress4KeyPressqCZ ompanyNameSize_B_var_LogErrortxtAddress1_Change?txtAddress2_ChangetxtCity_ChangegtxtState_Change6utxtZipcode_ChangetxtPhoneNumber_ChangeDtxtFaxNumber_ChangeU@txtFedNumber_Change}ptxtPeriodStartDate_Change|txtPeriodEndDate_Change+txtCompanyName_ChangeLimitKeyPressedChange_B_var_LimitKeyPressedXtxtAddress1_KeyPressAztxtAddress2_KeyPressstxtCity_KeyPresstxtState_KeyPress)txtZipcode_KeyPresstxtPhoneNumber_KeyPressytxtFaxNumber_KeyPresstxtFedNumber_KeyPress!txtPeriodStartDate_KeyPreLVAL Qss5txtPeriodEndDate_KeyPressBocboCompanyCode_KeyPress*cboCompanyCode_ChangeitxtCompanyCode Form_frmEmployeeDescdLastNameLastName_Label FirstNameFirstName_Label MiddleNameoMiddleName_Label(SSNumber|SSNumber_LabelHireDateHireDate_Label HourlySalaryHourlySalary_LabelH AnnualSalaryAnnualSalary_Label  HoursWorked\lHoursWorked_Label\Employee_Code_LabelXCboEmployeeCodeFull_Part_Time_LabelcboFullPartTime\Salary_Hourly_LabelcboSalaryHourlyn Form_KeyPressɔCboEmployeeCode_KeyPressrstEjDescGPrstEmployeeDesc EmployeeCodeLastName_KeyPressn txtLastNameFirstName_KeyPress: txtFirstNameMiddleName_KeyPress&  txtMiddleName<Address1_KeyPress$6Address2_KeyPress/ City_KeyPressYState_KeyPressZipcode_KeyPresscboSalaryHourly_KeyPresstxtSalaryHourly SalaryHourlyscboFullPartTime_KeyPress'etxtFullPartTime:W FullPartTime`HourlySalary_KeyPress.txtHourlySalary;AnnualSalary_KeyPressswtxtAnnualSalary\HoursWorked_KeyPress)txtHoursWorkedtxtHoursWorked_KeyPressPtxtLastName_KeyPresstxtMiddleName_KeyPress^txtAnnualSalary_KeyPresstxtFirstName_KeyPressftxtHourlySalary_KeyPressDSSNumber_KeyPress txtSSNumberHireDate_KeyPress txtHireDateCboEmployeeCode_ChangetxtLastName_ChangegtxtFirstName_ChangetxtMiddleName_Change^SSNumber_Change!HireDate_ChangeӅcboSalaryHourly_Change5cboFullPartTime_ChangetxtHourlySalary_ChangetxtAnnualSalary_ChangeitxtHoursWorked_ChangetxtSSNumber_Change(txtSSNumber_KeyPressXtxtHireDate_ChangemtxtHireDate_KeyPress=QKey_B_var_rstCompanyDesc^cboEmployeeCode_AfterUpdatetxtEmployeeNamecboEmployeeCode_EntercboEmployeeCode_GotFocustxtEmployeeLastNameAsc!uChrKLVAL 0236=BCabcJe g h i j.k!ާd@Company Description Maintenance[Event Procedure]Arial8 h\\testbed\lee_lofgren4C odXXLetterDINU"4z=P)winspool\\testbed\lee_lofgren\\testbed\lee_lofgren[Event Procedure]d2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`Detailm7U81`ab ce ktxtCompanyName Company Name[Event Procedure][Event Procedure]d5U7`<abcCompanyNameLabel&1: Company Namem7U82`ab ce k txtAddress1Address Line 1[Event Procedure][Event Procedure]d5U7`abcAddress1 Label &2: AddressAddress1_Labelm7U83`8ab ce k txtAddress2Address Line 2[Event Procedure][Event Procedure]d5U7`xabcAddress2 Label &3: AddressAddress2_Labelm7U84`ab ce ktxtCityCity[Event Procedure][Event Procedure]d5U7`HabXc City Label&4: City City_Labelm7U85`8abcektxtStateState[Event Procedure][Event Procedure]d5U7`,abc State Label &5: State State_Labelm7U86`abcek txtZipcodeZipcode[Event Procedure][Event ProcedurLVAL @i_VBA_MODULExS$M8ࠠvLHCVݤ-Zx)+OQGE+H [LS S<023=Babce ghj'k~*Fd@Benefit Description Maintenance[Event Procedure]Arial[Event Procedure]d2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`Detail m7U81`ab ce ktxtBenefitNameBenefit name shown on report[Event Procedure][Event Procedure]d5U7`<abcBenefitName Label&1: Benefit NameBenefitName_Labelm 27U82`aHbcHe ktxtBenefitShortDescription*Short description used for summary reportsd5U7`<aHbcBenefitShortDescription Label&2: Benefit Shor tDescBenefitShortDescription_Labelm 27U83`abcHe ktxtBenefitLongDescriptionLong descriptiond5U7`<abcBenefitLongDescription Label&3: Benefit Long DescBenefitLongDescription_Labelm7U84`a b ce ktxtRateMultiplierGeneral Number&Multiplier against EmployeetData->Rate[Event Procedure]d5U7`<a bcRateMultiplier Label&4: RateMultiplierRateMultiplier_Labelj2U35`a0 ichkMultiplyHoursWithRateQIf Yes EmployeetData Total = Rate * Hours else Total = Rate for EmployeeDataQueryd5U7`<a0 bcMultiplyHoursWithRate Label&5: Mult Hrs W/ RateMultiplyHoursWithRate_Labelo5U`bcdxef,"";"";"";"";"10";"20"cboBenefitCode Table/Query_SELECT DISTINCTROW [BenefitDesc].[BenefitCode], [BenefitDesc].[BenefitName] FROM [BenefitDesc]; 1440;2880[Event Procedure][Event Procedure][Event Procedure][Event Procedure][Event Procedure]d5U7`abdcBenefit Code_Label Benefit CodeBenefit_Code_Labelh1U2S`@ ab c,ibtnSave&Save[Event Procedure]h1U2C`Lab c,i btnCancel&Cancel[Event Procedure]h1U2D`Xab c,i btnDelete&Delete[Event Procedure]j2U36`a\ ichkIsEarningCode7If Yes then is Employee Income else if Employee Expensed5U7`<a\ bcLabel23&6: Is Earningsh1U2E`dab c,i LVAL btnExit&Exit[Event Procedure]GLVALS      ͬvLHCVݤ-ZCDetaild CBenefitName_LabelBenefitName Labeld CBenefitShortDescription_LabelBenefitShortDescription Labeld CBenefitLongDescription_LabelBenefitLongDescription Labeld C RateMultiplier_LabelRateMultiplier Labeld C MultiplyHoursWithRate_LabelMultiplyHoursWithRate LabelmCtxtBenefitNamemCtxtBenefitShortDescriptionmCtxtBenefitLongDescriptionmC txtRateMultiplierd CBenefit_Code_LabelBenefit Code_Labelh CbtnSaveh CbtnCancelh CbtnDeleteoC cboBenefitCodejC chkMultiplyHoursWithRated CLabel23jCchkIsEarningCodeh CbtnExitLVAL AwxJ `@ ]wwww`|D44jwwww0`D""ww(`|Dw$$$:`|D fffB `Dwwww wx(``|D  $`D vffgi   wxvffg$`vDP`v@ $`pwwvf $D`@ -D0`@ 9 `x@ Xd`x@J`x@wwww0X H0P`p0 Thepx`0 $` $ $ $ $$$0 $  $ $ $ $H $x LVAL B$ $ $ $8 P $h $ $$$ $D H`@pH $x $  $  P 00`p0 HX$$H $x $$@P 00`p0 HXh `0$@xB`x @h @X @H D @@ 6`p0 (`, @ @ @ (z$@ (t @p 8HlO P `LVAL C\ (L @< @, @ @ @ P6@ `@ @ @ $P6R(x @h @X @H @8 ( @&   @h0`$P6R(0Hx @h @X @H @@8 (( @&  0p 0P6R(0z 0h X @H 0X8 @( @ 0 h  @(p @l 0@hO p(f @@d b P @@ @0 @ @ (p LVAL D @ @ @ h Xh 6R( h l \ @L < @,  @ h @ h (hh hh  X   x @t @d ` @\ (X @V xh Xl @\ @@L (@< !! `, @ (  @ ! hhp"P  @ " (@ @O 8"H"( @ `"p" ""@ "( " "p @ @ (#  LVAL E  @ #p # @ @ @ #P$6R(l $\ @L (%< @, X% @  B Private b 8&Bde)) <> ""Thh`P(ME "     ( " 0 8  @ P "  2< X`h /  " X ` h  p  "  "     " Y " A   2<  @ H P X `  "h Ax   2<       p " \H@" Y " h\xp " "( LVAL F0 8:F@ " $E  88` =Xp" x     6FOP         + A0 HX .`*H     .<(7h        2 ( Hhp x"   +A   &   0 8 HPX` h pH3x   "   .n 8@x <X8        "     08 @ "H PX6`FO            ( " 0  8 @  H X ` LVAL Gh Bp x      . <  0; @  H P  X  h x xp0l` !Z ".! A@l8 ! "! A@ l ! "! A@lXPlH ! "!A@l ! "!A@Z@XZ@Z@Z@0 $Save Current Record PSave$6 RA@(hphhl`pP BenefitDesc  %.'$'@ !x! A@Bu  - During Form Load 8Error A@6  ! B@BfglZZ('$'@ v !x Clear previous data from formvf v! z'vh v(wwh vffffww $' $wwww B@ffffwwap(Find the record that matches the controlww BenefitCode=' ' B@hwwwwww !l v!cboBenefitCode v(ww  !! v!$ $  %! $  %'vwwww v +h  h vwwwwwwa'@ rstBenefitDesc.AddNewww +rstBenefitDesc!BenefitCode = cboBenefitCodewwww rstBenefitDesc.Updatew cboBenefitCode.RequerywwwwhHh@l8( $'wwA@ $ @wwww B@  ) B@wwwwhA@ ( 0 B@"wwwwww'$a`A@BhPuH0@'Record currently locked by another user 8 Record LockedA@6'$uA@Bl0ZLVAL HZZh $ @ $$x v !xwwww v!$ $  %! $w v  ,h  v B@'$ B@hlx B@<'@A@BlPZ8 v !x Clear previous data from form v! z'vh v(h v' B@'$'@ B@< B@l8  $  B@hA@Bl`ZZ' v !x  !! v!$ $  %! $ $ v v!cboBenefitCode'hh  vflA@ Read Record ! B@hl $ $ Save Current Record PSave$6 RA@(hA@Bhhl $ $ Save Current Record PSave$6 RA@(hhxA@BhhA@:A@B H(l8A@ (lHA@(A@B b(l 'va(h v!   % $'v ctl.C v!'  (l B@B,  B@B v!cboBenefitCode v!btnExit v! j v!cboBenefitCode v!btnExit v! j  l B@Bege $ oMatSave Current Record PSave$6 R FA@(h h  !! 9| Reverse of read. Match control field names (excluding the first 3 cLVAL Iharacters of the control name) to the table field names.\ v !x(k Match up control field names (excluding the first 3 characters) to table field names and assign the valuesemen 7Attribute VB_Name = "Form_frmBenefitDesc" Bas0{4CD67612-B101-4348-9E82-56DDA48F2D5A} |Creatabl!True ]Pr@edeclaId"ExposBeFals @TemplateDeriv%Cus`tomizD$Option Codmp@ DTv P%) rst As Rec@ordsetG lobal Lo ckBBoolean New&OriginalValues()Varian7Vlici@Sub btnCancel_Ck() 6KFr{ . EnDVEnd  -DDeleteG C)Exit8If R$Chang@WTheU @ MsgBox("Save CurrentDi", vbOKAd, ")A GAWrite2CABIf DoCmd.ClII!3CG_ &JcboDCode_AfteprUpdy+  A0 'ReadAJtxYn!lSetFocusc e"!E,7LimiBt Me.,m!.Siz@g!/ En $ " Nz( ) <> ""(?O*O-OOA `.P%-aaH#Go9?$*m?$?$ss>$ (%#kKeyss(AAsciiI Jger"XeXnX, Ԉ+o_vgug"}zg o)sfbfRMMultiplier_? v' @0 [.On Error ResuNex@t?|/O>/fwq%f, 0fa) > ^,)gO< Load  GoTo_Faile.dZ[m=urDb`.Open3c0("0r, dbDyn@t/1_@Oug= R`eDim \p`Controls.Cou- 1N :t& " - During  TOnlyP!" &13~ ac,.a,{& wc "" ?G@ ]A&Go ߇-___Failed@igl I3, (!i# AEdits+ A "+2 e'[g`Clea:rmDtxidt F _ A: MsgBox " currently l@L`by another user"OKOnly, ed"FavIA?(@@i`Write`DimB ` As trol a"Integer{ StringafB`/ Or (ϣ`D? A`gql)#h)c%&EO!EachbIn MensCQ?! ' Reverse of r~. Mat ob fns (exclud# @@U 3 charact!c) totable .a`.?ux?uL7p3BbiR fj)Go%#1> YGb0 aCa0ncel0%xt c o- 8iH8a9 O ?/6/ 'R previous 0va from forP1`%oB7;"R: b8tnERCTypeacLabelmCommandButtonR==@u#"@&q En4!`" k({p&"Z.SetFocuDE**?" %_@)/FQ S?%Dele;^ %% 4as/.fFuncti6Changed()QeBoo/seQ4!3BQh f 7 / ! 1``ePXͭvXPldrRtpQ &Form_frmCompanyDesc 243e5d0bd3*D (modUtilities 253e5d0bd6*D (8HReport_rptSummaryBenefitStatementSub 113e5d000e*DYG&&Form_frmBenefitDesc 13e5d0f1c*DGhH(Form_frmEmployeeData 293e5d0c78*Dw Form_frmMainMenu 1a3e5d09b3*DP{8Form_frmSummaryBenefitReport 1e3e5d09d4*DEE(d(Form_frmEmployeeDesc 2a3e5d0c7d*DHForm_frmHelp 1b3e5d09bb*DeHLVAL O $  $p `|J {X$$$ !`VJd!i $ )`VJ()i  `VJ8i 0`VJ@i 0 `VJH\i +`VJ+i 0 `VJ0i stEmDdp `chkIsEarningCodew NotInList Hours_LabelG2 Rate_LabelbStartDate_LabelExisting_Records_Label*txtRate)) txtStartDateaLabel25jLabel28mText33sLabel34txtEmployerContrib!ptxtEmployerMatchAmountW=LVAL SReport_EmployeeSummaryStatement GroupHeader2Report$ PageHeader- PageFooterv ReportHeaderŃ ReportFooterR. GroupHeader0 GroupHeader1 GroupHeader3Expr1002gCompanyDesc_Address2EHCompanyDesc_CityCompanyDesc_StateCompanyDesc_ZipcodeG%BenefitShortDescriptionBenefitLongDescriptionգRateMultiplierhEmployeeDesc_Address2EmployeeDesc_CityHEmployeeDesc_State0,EmployeeDesc_ZipcodegHoursGPRatek EmployerMatchAmount݅ StartDateETotalULabel80CText81sText82sLine83<Line84=Line85>txtEmployeeFirstNamejetxtCompanyDescZipcodeotxtCompanyDescStatetxtCompanyDescCitytxtCompanyDescAddress2itxtCompanyDescAddress1h IsEarningCodelblEmployeeEarningsQlblEmployeeExpenses(GroupHeader2_Format FormatCountIsEarningsCode_B_var_IsEarningsCodeIVisible_B_var_ExplicitTGroupHeader2_Print 7 PrintCount Report_oldq!Report_rptSummaryBenefitStatementzLabel97oText98tLabel100&Label105+Text108Label110KLabel111LBox112Label113NLabel114OLabel115PLabel117RLabel118SLabel119TText124 txtFirstName1txtGeneralBenefitStatement txtLastName1Text125Text126Text127Label129yLabel130Label131Label132Label133Text134Text135Text136Box138Line140Line142Line143Line144Line145Line146 lblEarnings lblExpenses$txtIsEarningCodeDtxtIsEarningsCode_B_var_txtIsEarningsCode3Box149Label150Label151Label152Text1539Text155;Text156<Text157=Label158Label159Line160)Line161*Line162+Line163,Line164-Line165.Line166/Line1670Line1681Line1692 txtJobTitleLabel45Label48 tLVAL TxtCommenttxtJobTitle_ChangeԲJobTitlegtxtJobTitle_KeyPressKtxtComment_KeyPress/CommentHstxtComment_Changep txtFullName1q txtFullNameKLine170NtxtFullNameasdnText171Text173Text175Line176T Detail_Print:< EarningTotal BenefitTotalfCompensationTotal=BenefitPercent6txttotalRDeductionTotal= _B_var_DeductionTotalM EmployerTotal!V txttotal1dBox177Label1781Box181Label182PLabel183QtxtTotalEarningText186Text187Line188{Line189|Line190Line191Line192Line193Line194Text195Text196ReportFooter_PrinttxtEmployerTotalGLabel197zText198Line199Line200Line201txtCompensationTotalTxtBenefitPercenttxtDeductionTotal Report_testCompanyDesc.Address1=CompanyDesc.Address2>CompanyDesc.CityQCompanyDesc.StateQCompanyDesc.ZipcodeRGeneralBenefitStatementjEmployeeDesc.Address1EmployeeDesc.Address2EmployeeDesc.CityZEmployeeDesc.StateEmployeeDesc.Zipcode_B_var_lblEarnings%qIfaCompensationTotalBenefitPercent'PageFooter_Print Report_OpendtxtEarningTotal _B_var_FormatFormatEmployerTotalf#_B_var_FormatEmployerTotalIt] _B_var_It^_B_var_txtEarningTotaltxtEarningsTotal_B_var_txtEarningsTotalGroupHeader1_PrintPreviousEmployeeqatxtEmployeeCode_B_var_txtEmployeeCode'Line202Line203Line204Line205cmdSummaryBenefitReportscmdSummaryBenefitReport_Click. OpenReport _B_var_Chr\; acViewPreview2MrH^ _B_var_Mr EmployeeCVisibeV NextRecordtxtBenefitCode{_B_var_txtBenefitCodeL+_B_var_txtBenefitNameB`OpenDb^} _B_var_OpenDb OpenSnapshotk OpenLVAL USnapsho OpenSnapsh] OpenSnapsOpenSnapOpenSnaOpenSnOpenS_OpeOp^OfdbOpenSnapshot CurrentRSj_B_var_CurrentRS"rs_ Form_frmSummaryBenefitReport StartingRecordm9_B_var_StartingRecord} keyEnding keyStarting cboKeyStartingLabel7, cboKeyEndingcboKeyStarting_BeforeUpdate/7cboKeyStarting_Changeltmp _B_var_tmppostnFtxtKeyStarting7BtxtKeyStarting_GotFocus)txtKeyStarting_Enter2Y txtKeyEndingStxtKeyEnding_Enter-*txtKeyEnding_GotFocustcboKeyEnding_BeforeUpdate1PcboKeyEnding_Changepos _B_var_poscboKeyStarting_AfterUpdate7u OpenRecorsetPseparatorPositionC rstEmployee__B_var_rstEmployee@cboStringStartingaTLeft_B_var_keyStarting,_B_var_cboStringStarting-keyStartingDefaultkeyEndingDefault%d[cboKeyEnding_AfterUpdateVcmdPrintcmdPrint_ClickbfErr_cmdPrint_Click-acNormalExit_cmdPrint_ClickX- cmdPreviewqcmdPreview_ClickErr_cmdPreview_ClickZW acPreviewoExit_cmdPreview_ClickcmbExit;8 cmbExit_ClickErr_cmbExit_ClickQuit9Exit_cmbExit_Click2cmdExit\ cmdExit_Click#cmdSummaryBenefitReport_Click_ErrorAErr_cmdExit_ClicksExit_cmdExit_Click acViewPrevie\ acViewPreviTe acViewPrev5 acViewPreacViewPracViewPAcViewacVieacVi0acVrac}\ OpenRepor__B_var_OpenReport#_B_var_OpenFormpDisplayApplicationInfoPobjobjApp:intI\strProps UserControl _B_var_objzScreenI ActiveForm> ActiveReportO _B_var_WhileIfcmdPreview_Click_ReportDone acViewNormal RcmdPrint_Click_ReportDoneemployeeCodeStart companyCodeEndScompanyCodeStartfemploLVAL VyeeCodeEndtemployeeCodeEndselectorPositionS cboKeyStartB_B_var_cboKeyStart)4companytCodeStart_B_var_companytCodeStartEemployeeeCodeEnd_B_var_employeeeCodeEndkeyStart!keyEnd  Report_NoDatayNoData Report_CloseYabcrstWhere_B_var_stWhere cboExit cboExit_Click}~btnExitvbtnExit_DblClickbDblClick btnExit_ClickobtnExit_ClickedEOF NextRecordsetTFindnFindNextuthrow" _B_var_throws"_B_var_cmdPreview_Click_ReportDoneJrptReports _B_var_Report| ReportActive  stillActive2_B_var_stillActiveRqdfEmployeeDataMQueryDefCreateQueryDefzNSQL"MoveNextL! MoveFirstN_B_var_Exit_cmdPreview_ClickbRFROM~  EmployeeData 7WHERE֍ _B_var_FROMcmdPreview_Click_ErroracPrint$ Report_rptSummaryBenefitStatementSubG_B_var_acPrint Form_Form16HelpCodeHelpMemo]ZText0~ Form_frmHelpVucmdHelpG cmdHelp_Click QErr_cmdHelp_ClickExit_cmdHelp_ClickqLabel31Y   eEdirB>0* pHdbenefitstatementL@  Z= ~  ]> EJ< DAO>BDA@O *\G{000@25E01-0C  0046}#4.0#0#C:\Program Files\Common Microsoft Shared\w\dao350.dll# 3.51 Object Li`braryH QForm_frm8panyDesc _VBA_MOD@ULE2VBt_MvDULE H1` ,Q6"(+modUtilities<N? Y V ~~~~~~~~~~~~~~~~~~~~ /([CompanyCode] & ',-,' & [EmployeeCode]) >= '( 5)' AND ([CompanyCode] & ',-,' & [EmployeeCode]) <= '( )'=pot@Qgd}4U!^# Nh7_  Report_NoData Report_Close +(CompanyCode & ',-,' & EmployeeCode) >= '( 1)' AND (CompanyCode & ',-,' & EmployeeCode) <= '($ D(CompanyDesc.CompanyCode & ',-,' & EmployeeDesc.EmployeeCode) >= '(' K)' AND (CompanyDesc.CompanyCode & ',-,' & EmployeeDesc.EmployeeCode) <= '( /([CompanyCode] & ',-,' & [EmployeeCode]) >= (' 6') AND ([CompanyCode] & ',-,' & [EmployeeCode]) <= (' ')c[<CWkDE.F"yp:{ _CT+5 4<L.fJ4;O KgNO7:GcsK[*b zzzzzzzzzzzzzzzzzzzzqK*=My9npPJPݐ,ljG8@EA ((([CompanyCode] & ',-,' & [EmployeeCode])>='abc,-,123456789' And ([CompanyCode] & ',-,' & [EmployeeCode])<='abc,-,123456789')) -((([CompanyCode] & ',-,' & [EmployeeCode])>=' 1' And ([CompanyCode] & ',-,' & [EmployeeCode])<=' '))g#p@Z, +zzzzzzzzzzzzzzzzzzzz,-,zzzzzzzzzzzzzzzzzzzz ,zzzzzzzzzzzzzzzzzzzz,-,zzzzzzzzzzzzzzzzzzzzzAdA KD.6:I/-Zi_B2`#PcboExit cboExit_Click |4< "EVVi=W87,INAk?3Zm4+KL#0(use2zGMu4Z[ hC,oS@P &&48<@H=-^A.q=qK D0_u1Hb-Co EMX$Z4K(GvfKXܸaOlGDb, HAW۾B2lJ MIt2 4<scrikDfuAT zVnFIIfI: avM5hT- |[gJtieZeM BLq82*XN  O OC[=jJLf (CompanyCode = ' >>>9 oSELECT DISTINCT CompanyCode, EmployeeCode FROM EmployeeDesc WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='ߗ)@Nv/} r5CϽ[ SELECT EmployeeData.CompanyCode, EmployeeData.EmployeeCode, [CompanyCode] & ',-,' & [EmployeeCode] AS Key FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='abc,-,123456789' And ([CompanyCode] & ',-,' & [EmployeeCode])<='abc,-,234567890'));F SELECT DISTINCT EmployeeData.CompanyCode, EmployeeData.EmployeeCode FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>=' '));Mi8I]z-SKT̠A6^`hfoE>I $Report_rptSummaryBenefitStatementSubYBO(y$I"KuuOjw&%AZ3*N5iFfbhr0ĞJB=쑥;=TWAl?8 DjG]G{9/A^M,Kf++/xo}Ak__SRP_1)rU~~~~~~~~~~k   Y ( 8 )HKeyAscii yXctliMaxLen 9*hNewDataResponse <x = !>Cancel FormatCount PrintCountobj/LVAL ` x4< MiddleName SSNumber Y `  H S FullPartTime P F HourlySalary AnnualSalary HoursWorked4TN"w%Ka 0Sˑ3VgmNsml` &&48<@HEA.xS2`+'-Ap:hϐuI}F ؗjHIr! 8prmCompanyCode = 'abc' AND prmEmployeeCode = '123456789' 5parameters(0) = 'abc' AND parameters(1) = '123456789'txtKeyStarting_GotFocustxtKeyEnding_EntertxtKeyEnding_GotFocus 2CompanyCode = 'abc' AND EmployeeCode = '123456789'Ì_sF0+DT/VSI;ˠForm_frmSummaryBenefitReporth%]xDV.Yd%o١\I19U{IVֳB̽@ cMaE8# cboKeyEnding FormHeader FormFootertxtKeyStarting txtKeyEndingcboKeyStartingcboKeyEnding_BeforeUpdatecboKeyEnding_ChangecboKeyStarting_ChangetxtKeyStarting_EnterW#2VFg]+G d48 +~~~~~~~~~~~~~~~~~~~~,-,~~~~~~~~~~~~~~~~~~~~ zzzzzzzzzz All Records  tblEmployeeDesc ALL RecordssKR8m4BZGh3iTCN)etm=fFa1ԒcboKeyStarting_AfterUpdate \ ~~~~~~~~~~t]ZJ<|/1KҏMcboKeyEnding_AfterUpdate First Employee Last EmployeeBAҜ KfȐFBM1)cmdPrint h48%iNf}qnReYHFt cmdPreviewcmdPrint_Click l48cI[K1Bvt: +D7o' 1cmbExitcmdPreview_Click p486|0D;(E$8WRaKDˊp&l˴*Nΰb9cmdExit cmdExit_ClickID_Hh+8PYLdes(OI;@QW0 gMqi frmSummaryBenefitReportRILVAL a3#t -2L EOÂ|c-?ר`]H.5=u\?K5J ȁWf^ZGQ +LJ=OtlKhDisplayApplicationInfo`}O_0fLSP5UGW7ˈ- Application Visible property =  UserControlDBEngine PropertiesCount DBEngine Properties .+@GMX/At̸S5KMw^Qfk(aN?k>N? Y V ~~~~~~~~~~~~~~~~~~~~ /([CompanyCode] & ',-,' & [EmployeeCode]) >= '( 5)' AND ([CompanyCode] & ',-,' & [EmployeeCode]) <= '( )'=pot@Qgd}4U!^# Nh7_  Report_NoData Report_Close +(CompanyCode & ',-,' & EmployeeCode) >= '( 1)' AND (CompanyCode & ',-,' & EmployeeCode) <= '($ D(CompanyDesc.CompanyCode & ',-,' & EmployeeDesc.EmployeeCode) >= '(' K)' AND (CompanyDesc.CompanyCode & ',-,' & EmployeeDesc.EmployeeCode) <= '( /([CompanyCode] & ',-,' & [EmployeeCode]) >= (' 6') AND ([CompanyCode] & ',-,' & [EmployeeCode]) <= (' ')c[<CWkDE.F"yp:{ _CT+5 4<L.fJ4;O KgNO7:GcsK[*b zzzzzzzzzzzzzzzzzzzzqK*=My9npPJPݐ,ljG8@EA ((([CompanyCode] & ',-,' & [EmployeeCode])>='abc,-,123456789' And ([CompanyCode] & ',-,' & [EmployeeCode])<='abc,-,123456789')) -((([CompanyCode] & ',-,' & [EmployeeCode])>=' 1' And ([CompanyCode] & ',-,' & [EmployeeCode])<=' '))g#p@Z, +zzzzzzzzzzzzzzzzzzzz,-,zzzzzzzzzzzzzzzzzzzz ,zzzzzzzzzzzzzzzzzzzz,-,zzzzzzzzzzzzzzzzzzzzzAdA KD.6:I/-Zi_B2`#PcboExit cboExit_Click |4< "EVVi=W87,INAk?3Zm4+KL#0(use2zGMu4Z[ hC,oS@P &&48<@H=-^A.q=qK D0_u1Hb-Co EMX$Z4K(GvfKXܸaOlGDb, HAW۾B2lJ MIt2 4<scrikDfuAT zVnFIIfI: avM5hT- |[gJtieZeM BLq82*XN  O OC[=jJLf (CompanyCode = ' >>>9 oSELECT DISTINCT CompanyCode, EmployeeCode FROM EmployeeDesc WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='ߗ)@Nv/} r5CϽ[ SELECT EmployeeData.CompanyCode, EmployeeData.EmployeeCode, [CompanyCode] & ',-,' & [EmployeeCode] AS Key FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='abc,-,123456789' And ([CompanyCode] & ',-,' & [EmployeeCode])<='abc,-,234567890'));F SELECT DISTINCT EmployeeData.CompanyCode, EmployeeData.EmployeeCode FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>=' '));Mi8I]z-SKT̠A6^`hfoE>I $Report_rptSummaryBenefitStatementSubYBO(y$I"KuuOjw&%ACancel FormatCount PrintCountobj/ k\M+xRC4 lYF3{h<`&["" ! G! EmployeeDesc ![EmployeeDesc].[SSNumber]1 g![EmployeeDesc].[FirstName]2 g![EmployeeDesc].[LastName]1 g![EmployeeDesc].[EmployeeCode]5 g!  !    G CompanyDesc  ompanyDesc].[CompanyName]3 g ompanyDesc].[CompanyCode]3 g    (((Help.HelpCode)="MAIN"))2 'Help  Help.HelpMem%  %  % B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o % n_0x]D $  $  $ B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o $ n_0x]D #  #  # B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o # n_0x]D "  "  " B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o " n_0x]D LVAL e< &-ug? & & & &   & & & & & & & &    2 #BenefitDesc.BenefitCodeBenefitDescBenefitDesc.BenefitName & & & &  &5be@ & &  &@i  &@iBenefitDesc` &0 &P &( & &pd@,~sq_cfrmEmployeeData~sq_ccboBenefitCode &  &  &  &( & &efit &].[B &@i  &@iBenefitDescitNa  &x &  & & & &  & &X &  &@ &H &P &X &` & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &x &  &( &  &( & | &  & & &i & & & &8 &  &  &0 & & & &( & &BenefitDesc  &  &PrimaryKey& BenefitCode &" n_0x]D &PrimaryKey BenefitCodeX & n_0x]D &v   & & & & &s & & & & & & & & & & & & & & & & & & & & & & & & & & & & &p &  & &` & &" &BenefitDesc &PrimaryKey & & &  &H &  &LVAL & & &P & & & &( &d-yf,@ @ @ @ @ @ @ (**'*%*&* *!*"*#*$**(***+*,*-*)tyxvwuz~|}{      !!!!!!!!"""""### !S"T% G%CompanyDesc %ompanyDesc].[CompanyName]3 g%ompanyDesc].[CompanyCode]3 g% % $ G$EmployeeData $EmployeeData.BenefitCode0 g$EmployeeData.EmployeeCode1 g$EmployeeData.CompanyCode0 g$Key>@) o$ $ #EmployeeDesc #EmployeeDesc.FirstName. gLVAL k<[&ug?[&[&[&[&  [& [&%[& [&[&[& [&[&[& [& [&%[&    2   2 EmployeeDesc.EmployeeCode EmployeeDescEmployeeDesc.LastNameEmployeeDesc.FirstNameH[&@[&[&[& 0[&96be@8[&H[&lil[&ili. [&ili%[&iliEmployeeDesc[&[&[& [&0[& ,d@(~sq_cfrmEmployeeData~sq_ccboEmployeeCodeH[& [&[& [&[& [&[&[&[&[& [&ili. [&ili%[&iliEmployeeDesc [&[& [&[& %[&[&[&[&[& [&[&[& 0[&@[&P[&`[&p[&[&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[& [&[&[&[&[&@[& [& [& [& [& [& [& |[& [&p[&[&iH[&@ [&p [& [& [& [& @ [& p [&  [&4 x[&[&[&@ [&p [& [& [& EmployeeDesc [& [& [&ZipcodePrimaryKey EmployeeCode[& n_0x]D[&v [&[&[&[&[&s[&[&[&[&[&[&[&[&[&[&[&[&[&[&[&[&[&VCNii  co  HelpCodeHelpMemoij@il HelpCode PrimaryKeyiiyii{qgg@@ho`jpn LVAL[&[&[&[&[&[&[&[&[&[&[&[&`[&[&p[&P[&[&[&EmployeeDesc PrimaryKey[&[&[&[&[&[&[&p[&@[&p[&[& [&ho`jpn& @:s3e@:s3e@~sq_cfrmBenefitDesc~sq_ccboBenefitCode n_0x]D{*@ rrrfZZZZZZE `"1e@9#1e@~sq_rrptSummaryBenefitStatement n_0x]D@*@kkk_SSSSSS> `Q,e@Q,e@~sq_ffrmSummaryBenefitReport n_0x]D` *@hhh\PPPPPP; `Q,e@Q,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyStarting n_0x]Dc *@{{{occccccN `fJ,e@J,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyEnding n_0x]Db *@yyymaaaaaaL `>c+e@1e@rptSummaryBenefitStatement n_0x]D@LWF000@4xlZZNNNNNN9 ݖ2d@Th-d@EmployeeDataQuery n_0x]D7@@i]]QEEEEEE0 `B 2d@yOMd@CompanyDesc n_0x]D7@KKK???????* @\^e@\^e@AutoExec n_0x]D_@H<<<<<<<<<'  3\4d@ >3e@frmSummaryBenefitReport n_0x]DKKKKKKKKKK6  CjwV3d@-e@frmCompanyDesc n_0x]DBBBBBBBBBB-  C3d@Se@AccessLayout n_0x]D*@@XLL@@@@@@@+ @ѱ1d@ѱ1d@Scripts n_0x]D;;;;;;;;;;& ѱ1d@ѱ1d@Forms n_0x]D9999999999$ b2d@b2d@EmployeeDescEmployeeData n_0x]DLLLLLLLLLL7 ]2d@]2d@CompanyDescEmployeeData n_0x]DKKKKKKKKKK6 `2d@`2d@BenefitDescEmployeeData n_0x]DKKKKKKKKKK6 LVAL o< & ug?&&&`&  @&&%&E&&&&8&&&&&&&%&E&         KeyEmployeeData.CompanyCode EmployeeDataEmployeeData.EmployeeCodeEmployeeData.BenefitCode&x& &H& X&96be@p&& &i &i0%&i&iE&ipiEmployeeData&@&p& &X&tVd@+~sq_cfrmEmployeeData~sq_ccboExistingRecords& & & &(& &0& 8&8&&&&8&&i %&i E&i EmployeeData && %&& E&&&&8& EmployeeData &p& & X&@&P&`&p&&& && && && && && && && && && && && && && && && && && && && && && && && && && && && && &&&&& && & "& & "& & "|& &H&&أi& &8 & &h & & h&  & 8 & h &8 &&&LL &X &8&\ &h &&l &x & &| & & & &  & [CompanyCode] &",-," & 8 &[EmployeeCode]&",-," <& h & [BenefitCode]l&H & & & &x&@&& &8 &h & & EmployeeData H& X& x& & & & &PrimaryKeyEmplohN  #:@ MSysRelationshipsMAIN(LVAL(yeeDescEmployeeData EmployeeCode#CompanyDescEmployeeDataCompanyCode#BenefitDescEmployeeDataBenefitCode& n_0x]D&v &&&&p&ps&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&p&8& &H&(&&`&EmployeeData PrimaryKey&`&&&&&p&H&&H&x& &LVAL @ @ @ @ @ @ @ @ @ @ (**'*%*&* *!*"*#*$**(***+*,*-*)tyxvwuz~|}{      !!!!!!!!"""""##f###f#$f$f $f$f$f$f$f$f%f %f%f %f %f 11333h:h;h<hWR  ar; [?Ch+'+'+'+'+'+'+'X +'LVAL s023=BCabce g2hij,k _W@ Employee Description Maintenance[Event Procedure]Arial[Event Procedure]d2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`hDetailm7U81`abce k txtLastNameEmployee Last Name[Event Procedure][Event Procedure]d5U7`<abcLastName Label &1: Last NameLastName_Labelm7U82`aHbce k txtFirstNameEmployee First Name[Event Procedure][Event Procedure]d5U7`<aHbcFirstName Label&2: First NameFirstName_Labelm7U83`abce k txtMiddleNameEmployee Middle Name[Event Procedure][Event Procedure]d5U7`<abcMiddleName Label&3: Middle NameMiddleName_Labelm7U84`abce k txtAddress1Employee Address Line 1[Event Procedure][Event Procedure]d5U7`<abcAddress1 Label &4: AddressAddress1_Labelm7U85`abce k txtAddress2Employee Address Line 2[Event Procedure][Event Procedure]d5U7`<abcAddress2 Label &5: AddressAddress2_Labelm7U86`abce ktxtCityCity[Event Procedure][Event Procedure]d5U7`<abc City Label&6: City City_Labelm7U87`aP bcektxtStateState[Event Procedure][Event Procedure]d5U7`<aP bc State Label &7: State State_Labelm7U88`a b8cek txtZipcodeZipcode[Event Procedure][Event Procedure]d5U7`<a bc Zipcode Label &8: Zipcode Zipcode_Labelm7U89`a b8ceuk txtSSNumberSocial Security Number[Event Procedure][Event Procedure]d5U7`<a bcSSNumber Label &9: SS NumberSSNumber_Labelm7U8A`ab8ce9k txtHireDate Short Date Hire Date[Event Procedure][Event Procedure]d5U7`<abcHireDate Label &A: Hire DateHireDate_Labelm7U8F`a bce k txtHourlySalary$#,##0.00;($#,##0.00) Hourly salary[Event ProceLVAL yk1 D `("k ?DdX`xJ $ $@ DJ`xJ D`xJ D `| 0 ^ha ePaeX` $a e$$$`Lph(XX  ( pp  X 0 HhX 0p @0 0 0  p( D^H`VJDb `VJ  Xp0  (H p  @0 X (X0hp H  hX p0 (0 $($X$$$$$ D `  x$LVALȐe  ee ee ee ee  ee @ ee ` ee ee eedure][Event Procedure]d5U7`a bcHourlySalary Label&F: Hourly SalaryHourlySalary_Labelm7U8G`a8bce ktxtAnnualSalary$#,##0.00;($#,##0.00) Annual Salary[Event Procedure][Event Procedure]d5U7`a8bcAnnualSalary Label&G: Annual SalaryAnnualSalary_Labelm7U8H`adbce ktxtHoursWorkedGeneral NumberHours worked in the year[Event Procedure][Event Procedure]d5U7`adbcHoursWorked Label&H: Hours WorkedHoursWorked_Labelo5U`bcdxe4f,!"";"";"";"";"";"";"";"";"10";"20"CboEmployeeCode Table/QueryߗSELECT DISTINCTROW [EmployeeDesc].[EmployeeCode], [EmployeeDesc].[LastName], [EmployeeDesc].[FirstName], [EmployeeDesc].[SSNumber] FROM [EmployeeDesc];1440;1440;1440;1440[Event Procedure][Event Procedure][Event Procedure][Event Procedure][Event Procedure]d5U7`axbdcEmployee Code_Label Employee CodeEmployee_Code_Labelo05U6E`b@ cdef,n cboFullPartTime Value List"F";"Full Time";"P";"Part Time"0;1440[Event Procedure][Event Procedure]d5U7`habdcFull/Part Time_Label&E: Full/Part TimeFull_Part_Time_Labelo05U6B`bcdxen cboSalaryHourly Value ListS;Salary;H;Hourly0;1019[Event Procedure][Event Procedure][Event Procedure]d5U7`haxbdcSalary/Hourly_Label&B: Salary/HourlySalary_Hourly_Labelh1U2S`a b c,ibtnSave&Save[Event Procedure]h1U2C`(a b c,i btnCancel&Cancel[Event Procedure]h1U2D`4a b c,i btnDelete&Delete[Event Procedure]m7U8I`abck txtJobTitle[Event Procedure][Event Procedure]d5U7`abcLabel45 &I: Job Titlem7U8J`aCbck txtCommentd5U7`aCbcLabel48 &J: Commenth1U2E`@a b c,ibtnExit&Exit[Event Procedure]?LVALK        De@Qm%e@Qm%e@Qm%e@Qm%e@Qm%e@Qm e@Qm$ e@QmsKuJ< e@QmKu T e@QmKu t e@QmKu  e@QmKu Address1Address2CityStateZipcodeCompanyDesc e'e De'e \e'e e'e e'e e'e e(e e(e $ e(eͬ)t[GF߁NUCDetaild CLastName_LabelLastName Labeld CFirstName_LabelFirstName Labeld CMiddleName_LabelMiddleName Labeld C Address1_LabelAddress1 Labeld C Address2_LabelAddress2 Labeld CCity_LabelCity Labeld CState_LabelState Labeld CZipcode_LabelZipcode Labeld CSSNumber_LabelSSNumber Labeld CHireDate_LabelHireDate Labeld CHourlySalary_LabelHourlySalary Labeld CAnnualSalary_LabelAnnualSalary Labeld C HoursWorked_LabelHoursWorked Labeld C"Employee_Code_LabelEmployee Code_LabeloC!CboEmployeeCoded C$Full_Part_Time_LabelFull/Part Time_LabeloC#cboFullPartTimed C&Salary_Hourly_LabelSalary/Hourly_LabeloC%cboSalaryHourlyh C'btnSaveh C(btnCancelh C)btnDeletemCtxtLastNamemCtxtFirstNamemCtxtMiddleNamemC txtAddress1mC txtAddress2mC txtCitymCtxtStatemCtxtZipcodemCtxtHourlySalarymCtxtAnnualSalarymCtxtHoursWorkedmCtxtSSNumbermCtxtHireDated C+Label45mC*txtJobTitled C-Label48mC,txtCommenth C.btnExitLVAL       01=BCabc&e ghij>+ke@OSELECT Help.HelpCode, Help.HelpMemo FROM Help WHERE (((Help.HelpCode)="MAIN")); About / HelpAriald2hgh MS Sans Serifm45`Detailm27`<axb%cti Text0HelpMemod5]axb cLabel1Text0:h1U2E`!adb cicmdExit&Exit[Event Procedure]LVAL w<e+uxg?X eee e  eeeeeeee    2 #CompanyDesc.CompanyCodeCompanyDescCompanyDesc.CompanyNameeeee eYe@ee e@am e@amCompanyDesce  peeX eeyOMd@&~sq_cfrmCompanyDesc~sq_ccboCompanyCodee e@e HeheompanyDesc].[CompanyCode] eompanyDesc].[CompanyName]Hee@am e@amCompanyDesc ee ee eHe ee e e@eHePeXe`ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee eeee(e e eX e eX e |e  ee ecme e( eh e  e ( e0 e e e( eX e CompanyDesc 0 e 8 e H eZipcodePrimaryKey CompanyCode` e n_0x]Dev heHeXeeeseeeeeeeeeeeeeeeeeeeeeeeeeeeeee eeee eCompanyDesc PrimaryKeye ehex eheLVALxcboCompanyCode_KeyPress*cboCompanyCode_ChangeitxtCompanyCodeForm_frmEmployeeDescdLastNameLastName_Label FirstNameFirstName_Label MiddleNameoMiddleName_Label(SSNumber|SSNumber_LabelHireDateHireDate_Label HourlySalaryHourlySalary_LabelH AnnualSalaryAnnualSalary_Label  HoursWorked\lHoursWorked_Label\Employee_Code_LabelXCboEmployeeCodeFull_Part_Time_LabelcboFullPartTime\Salary_Hourly_LabelcboSalaryHourlyn Form_KeyPressɔCboEmployeeCode_KeyPressrstEjDescGPrstEmployeeDesc EmployeeCodeLastName_KeyPressn txtLastNameFirstName_KeyPress: txtFirstNameMiddleName_KeyPress&  txtMiddleName<Address1_KeyPress$6Address2_KeyPress/ City_KeyPressYState_KeyPressZipcode_KeyPresscboSalaryHourly_KeyPresstxtSalaryHourly SalaryHourlyscboFullPartTime_KeyPress'etxtFullPartTime:W FullPartTime`HourlySalary_KeyPress.txtHourlySalary;AnnualSalary_KeyPressswtxtAnnualSalary\HoursWorked_KeyPress)txtHoursWorkedtxtHoursWorked_KeyPressPtxtLastName_KeyPresstxtMiddleName_KeyPress^txtAnnualSalary_KeyPresstxtFirstName_KeyPressftxtHourlySalary_KeyPressDSSNumber_KeyPress txtSSNumberHireDate_KeyPress txtHireDateCboEmployeeCode_ChangetxtLastName_ChangegtxtFirstName_ChangetxtMiddleName_Change^SSNumber_Change!HireDate_ChangeӅcboSalaryHourly_Change5cboFullPartTime_ChangetxtHourlySalary_ChangetxtAnnualSalary_ChangeitxtHoursWorked_ChangetxtSSNumber_Change(txtSSNumber_KeyPressXtxtHireDate_ChangemtxtHireDate_KeyPress=QKey_B_var_rstCompanyDesc^cboEmployeeCode_AfterUpdatetxtEmployeeNamecboEmployeeCode_EntercboEmployeeCode_GotFocustxtEmployeeeeeeeeX elLVALxͬ`S)E(uA@CDetailCHelpCodeCHelpMemomCText0d CLabel1h CcmdExitLVAL $$$$J$@xB`hp @pX0% 0 H  X(Hp p0  @0 (p p X 0  (0hX Xh 0 H  X(Hp p0  @0 (p p X 0  (0hX Xh @x @h @X /@H @D @@ (86@0 @, @0 P6@H @ 0Hxjz8$@J@t @Xp p0y@lO Xy@\ @L @< @( , @ @ @@ @ @X X@p @@ XtLVALͬ"KUPJl$]CDetaild CHours_LabelHours Labeld C Rate_LabelRate Labeld C StartDate_LabelStartDate Labeld CCompany_Code_LabelCompany Code_Labeld CExisting_Records_LabelExisting Records_LabeloCcboExistingRecordsmCtxtHoursmC txtRatemC txtStartDated CLabel25oCCboEmployeeCodeoC cboCompanyCoded CLabel28oCcboBenefitCodeh CbtnSaveh CbtnCancelh CbtnDeletemCcboCompanyNamemCcboEmployeeNamemCcboBenefitNamed CLabel34mCtxtEmployerMatchAmounth CbtnExitLVAL |i_VBA_MODULEuse2zGMu4Z"KUPJl$][ hC,oS@PxN!Qw[ hC,oS@Puse2zGMu4ZN LPTpX\`dhl~ptx|  [LS S8L t><<<LLLLLLLLLLL<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<N0{55E34B22-50D8-4A9B-8BF9-6C2483F55DA8}.U>*\R2*#2d$*\Rffff*233e55366f*\R1*#2b*\R2*#2f*\R2*#30*\R0*#4*\R2*#1b*\R2*#31*\R1*#52*\R0*#2*\R0*#c*\R1*#56*\R1*#58*\R1*#6*\R1*#2a*\R1*#1c*\R1*#a*\R0*#11*\R0*#16*\R0*#10*\R0*#1*\R0*#d*\R1*#2e*\R1*#85*\R2*#28*\R1*#8e*\R1*#8f*\R2*#0 @G(e $$$$ $"HH@  $$$$LVAL }a L`H%oT JX`kXt8 `|N\HHip wx$`v` N`99 j(`NdT wxh$$`vpp`Hp`:`xNh oode=B@`h|ol|v wx8!$`|Np  $`'o ti   wx$`v"4x4@.Addb$hD D@Codeb@PF F@panyDdX `J0@"8H8@ $08@X"< <@$$DH `JH ..bxe&e$D `J< XP$$$"J@@( @@8Xt$t$t$t$$LVAL ~$$t$ t$H t$P t$ t$ t$ t$t$t$t$ $t$t$@ H DH`!k4x t$t$@HD`J$$$`x  J `J)) %`J''2h`t 0 d `J ((`D `J@ 6 X t$p`x@`t`p8   `x`t`p`x|$|$|$`pDX `JD KX `xD`J,t$t$`xD0`J(`x`tX |$|$`xLVAL H |$|$|$|$`x`tD `"k8 P0X|$|$|$$`D `.JLP$$$$D`.JP@HX PhX    @X 0H 8$@HX PhX    @X 0H 8($X$$$$$$$$`p`l`t`p$$$`x  $$$`h$$$$@HPXLVAL L`h(0 @HX PhX    @X 0H @8$$J$@@x H& (0@h @X @@H @D h80 X H0hP% @ X @ XH (PxB86@@ @0 @, @  @8 @   x8 xjzL$@@t @Pp @lO !P@\ @L 0@< @@ , @  @( @X @ @LVAL ` @` @P @@ @0 @ 2 @ 2 08Bdh27$P6R7p @` @P @@ @0 @ 2 @ 2 18Bd7` h47LB7p @` @P @@ @0 @ 84 @ 7 @ `3"5P6588Bd5 l 6` v ` x``5p`l`h8 \ @L @< @, 6  5$86`78 8x88"8xjz8d @` @\O 8xL @< @, @ (8 8h"8< 8LVAL @ @ @ 78Bd9999 @ (9( @ @ 0:( 0: 9@~ @x 9 9tO d99r :X:0:p : : =XxHx;=8(Bd=l @\ @L @< =(, @ :b@L8x<@l @\ @L `?X4<>pp?;>8< @, @ (= @ = P= @ @ @ @ @ > (>(:==>>Xx ?t @d @T =p>x>ED @4 @$ ?( @ @ ? @ @O ?X?@ ?( @ ?Y? @Y(@ @]LVAL ^E`@E6R(<El (A\ @L XA< @, A @ E E@ @ @ B @x Ct @d @T @D @4 @$ B( @ @ C @ PCX`CO CXC@C( @ (CYC CYD hD] ^EpDE6R(El E\ @L HE< @, xE @ E ` d pFpFEX:<;X<;;:@;6`F @ hFE Px 1@ME  LVAL  P  (0"  (08 +@+P+`#0#8#@ HPX Ap D  X  $ $ $ $  "  +h+x+###   A D(0 8PX`h p` # $ $ ($  "@& P&2<`&&&& x'H&"  +++###   A D @H Ppx h  @$ P$ `$ p$   " @  P N  ` ,Hp     # #        "  ##  (0  # 8H H LVAL "   ( N 2< H# #`hpx #  X  "  X` N 2< ## (08 # @ P  " ( N8  P      ,H  H X  ` h  "p  (  ` h p 0 " N 2<( `hpx P#   " N 2<    h# (  " p N  P      ,H  @ P X # ` ` (  0 h M   #p x       "  N0 H2<X # #     "  N0 H2<X LVAL # #    "   ( N- 49- 09x4@pXh p 0 #H #P #X 8 @ ` h p x          " ! H! P!2<`! !!!$H$!0!8!! @# #! (! " @! H8" "2<" !!""H8%"%%% % %% H! "8 @ H:FP " $E$E $E $E   8 (8`0=h"     6P&     !   + + +A0 HD# D #8#@HPX`h pLVAL X .`p   (E  .<70HX `  p x    2  08 @" H PX` +++A D(#@HPX `Dp## h   & &p &       (H30 x  "   ^  . <08p           "     X h x   "  (068hg' p         "    08 @BH PX ` h%%%p % .LVAL < @%     'xpZ@l`Z@@Z@hZ@P8 $Save Current Record PSave$6 RA@(h`hXlP@ EmployeeData  %.'$'@ !x! PA@Bu  - During Form Load 8Error A@6  ! B@BlxXZZ'$'@ v !x Clear previous data from form'vh v(h v0` L$'L L$ppp LB@`a`(Find the record that matches the controlP !l`p v !x pP v(0pp  !! v!$ $  %! $  %'vppp v +`h ppph v a'@ rstEmployeeData.AddNew ,rstEmployeeData!CompanyCode = cboCompanyCode v rstEmployeeData.Update cboCompanyCode.Requery$h8h0l(ZZhA@ 8 )LA@ @' B@  L )H B@h ( ecord0p B@"'$A@Bh@u800'Record currently locked by another user 8 Record LockedA@6'$uA@BlZPZpZ 8B@@ B@$ B@nth v !x  !! v!$ $  %! $h v  , (h H vB B@'$ LB@ hlxh B@<'@A@Bl@Z ( v !x Clear previous data from formLVAL v! z'vh v(h v'L LB@'$'@ B@< LB@l(@ $ B@hA@BlZZ' v !x  !! v!$ $  %! $'hh  vfl L$$ 8(aA@Bh` 8B@0* '8 Z@Z@ CompanyDesc  %. BenefitDesc  %. B@CompanyCode = ' L' B@hO> !l'LA@Ba "'0000 ' h Xl ' l 8$$Z` 8$$ JB@ L'A@d 8B@Compan J!l '8'A@Ba( L'A@Bh a h B@enefit' ' '8 J",  J"'A@d 8B@A@ "'' EmployeeDesc  %.J Z@ 'L Z 'L EmployeeCode = ' 8' JB@hX l L$$'LA@B LB@ A@(( 8B@0 lP (P+* B@BenefitCode = ' ' B@hpp$ !lForm' L'A@B 'LA@d 8$'8nta 8' '8A@h a L'A@B 'LA@d B@A hH ZH cboBenefitCode.RequeryrosocboBenefitCode = ""B $'geA@B L'Z8ZPZA@B 'L 8$bA@d 8B@~ $bD L' 8'A@B 'LA@dLVAL '8A@ B@\ProgX v!$ $CBO L$'L 8$'8 $' L$A@B LB@ 8$b L'A@B 'LA@d 8B@ $b L' 8'A@B 'LA@d '8A@ B@aZ  ) $ @ L$$ 8$$ $$ LB@ 8B@ B@ B@ A@:A@B H(l A@ (l A@(A@B b(lXZ Z Z L$'L 8$'8 $' L$a LB@ 8$b 'LA@d 8B@ 8'P 'LA@d '8A@ B@A@B H( L' 8' ' 'L '8 'p L$'L/ 8$'8& $' L' 8' 'A@B (  'L '8 ' L$a LB@ 8$bC:\P 'LA@d 8B@\VBA\V 8'P 'LA@d '8A@ B@\Progr L$'L/ 8$'8ce $' L' 8' 'A@BA@B 'L '8 ' L$gram F LB@Micros 8$b350.dlA@B 'LA@d 8B@/* 8'PA@B 'LA@d '8A@ B@L]ZHZ'ZxZZ`ZA@CompanyCode = ' L' And EmployeeCode = ' 8' And BenefitCode = ' ' B@hhhh H lX 8$$'8A@B 8B@hZ L'@ @'LA@dlZ 8$$'8 L'@A@BLVAL @'LA@d 8B@urrenthph0lHA@( $$' L'@A@B @'LA@d B@urrenthZ 8'P P'8A@lZZ $$' L'@ 8'PA@B @'LA@d P'8A@ B@ h0ax`Hl L$$'LA@B LB@ h@'L LB@ $ vSave Current Record PSave$6 RA@(hA@BhA@( L$$ $ Save Current Record PSave$6 RhP'LA@B LB@h(h  8$$ $ Save Current Record PSave$6 R A@(h'8A@B LB@ hh L'@A@B @'LA@d 8B@ L'A@B 'LA@d 8B@( 8$$ $ Save Current Record PSave$6 RA@(hh'8 L'A@B 'LA@d 8B@hhA@B LB@ L$$ $ Save Current Record PSave$6 R hh'LA@B LB@hh $$ $ Save Current Record PSave$6 RA@(hh L' L'@A@B @'LA@d 8B@h 8'A@B 'LA@d '8A@ B@ $$ $ loyeSave Current Record PSave$6 R' L' 8'A@B 'LA@d '8A@ B@ hZhZ0 `Zx5  ker= ,-,}'   $$   $'Lh' Z`5'    $'8 8,-,}'   E01-LVAL 8  $'8 !l(chh 8  $'CompanyCode = ' L' And EmployeeCode = ' 8' And BenefitCode = ' ' B@hh Z5Z5Z5 A@d '8 L' 8' 'A@ 'A@A@ B@ax A@B B@hX P ! v! a'v! v! zh!!!Hl!'8' l $ PSave Current Record PSave$6 RPA@(h`!hX!'LA@(A@BhA@d 8B@@h! L$$ 8$$ $$ L$$ 8$$ $$ $ 6Save Current Record PSave$6 Rh8 'L'8'A@Bh  B@.hq.# &B@# &B@/. B@ LB@# LB@$ 8B@3q.0$ 8B@H$ B@/. B@0P$ B@$ B@.8m. LB@ 8B@$ B@$ B@/. LB@ 8B@x B@ B@ LB@+ 8B@ B@#$p%h%% L$$ 8$$ $$`% L$$ 8$$ $$'8'A@B B@P B@hx%p%ZE r' $'  v!'  $$ v v!$ $CBOX&%l& $ ISave Current Record PSave$6 Rg TA@(h`&hX&P& v!$ $CBO v!btnExit v! j v!cboCompanyCode v!LVAL cboExistingRecords v!btnExit v! j' B@BJ`'Attribute VB_Name = "Form_frmEmployeeData" Bas0{55E34B22-50D8-4A9B-8BF9-6C2483F55DA8} |CreblTrue ]Pre declaId"Expose!Fals @TeateDeriv%CustomizaD$Option Comp@ ~bv PC%) rst As Recor0dset!nyDescBenpefit7%G lobalDLo ckzLBooleanKNew%OriginalValues() Varian7G_lici$ <$+  If Nz)" TheK .SetFocus E@s#--O[@; _AfterUpdr q U =f +>n0d If0@Ex@isting#As.Requerym@ ;v.EnE @{A!}Delete'}|`:!ЀM.||tb|1RM= /|AB)2} #M* #,' +=>(de)">pa|ny5>/bZ >o3,>g2>@@ t>_>_>_> _>-Z>3;_>Zu>\>` t7>3@ A+Ch8angaMsgBox("Save Current$", vbOKn, ""A#QfQ!Write52IARuDoC`md.Cl ?TKA?KS-OIpEQp?K06z?K?K!<,P>|.?KxCCɉ,67o5, /K/K %/K/Kee//K (;@,/K@ZMde i-/KPk OKOKOKsIL!;/K/>">{y ?=> !'rp'|)) <> '?pݗFindFi@ "Ha('" &7"'a 0NoMatchSK.$ cboBenefitName = ""  tmpCompanyCodp@ PEmploy "" 0Then0 Gl0obalÄAed A.Chang@G E@ MsgBox("Save Current ", vbOKCancel, ")AAWrite*Ri+ Ń &=+N&= UT`( `k ow  RlQQQGoY?R?R?R?R?R?R?RDR?R.:?R=?R?R FIV?R=?RܬNJl?R R u?C)PHxNNm>.EPnablpM=Ru4u:^;ePwQw[FindFi@ " #'" & K"'NoMatchT{5 q-LVAL %d!')]Ivx%qrsotys!! oo|FooOKFP/4"{[)oL*~_kbҨh @E [x^).zq/z_S9o1IR -__29CU RRR\ RS=5/SB$?|X%\, \!Las& qil^92\k  b1XForm cboCompanyCode =0 tmp@_AfterUpdateFCboEm@ployee.SetFocus End IfSub PPriv=  # 8_En]()&Dim As String If Trim(Nz( |)) <> "" Th en,GlobalRecordLocked AMChangMsgBox("Save Current ", vbOKCancel, y") = Write i*"" Clear  z y$.RequerygGGo ???Ł?\?AodeAA AaZAxist@|CesFieldM arkerLo'ADOKBoo`@HɐBenefitbȐ &= FalsjE= In (@,-,"@!I` > 0L˻Left 8- 1 Mid~+ 3h  +a> 3= N +LcB&: %% rstIData.FindFi "k20'" &A& "'B R= bm+ A4du qA`Not (= NoMatch)l/Tru؀m? uR}VxNbPf#CSP"9fISY8 V8O1txtHoursI\J q  1S)'z(RVR1T?h&$ l/Ph!1PE0ue" Or o6(_ X$ ?/;)Ψ?&pte 뤯v/'v?/' /'/'/'/'/'/'/'/'@%X}/'f/'$1p/' /'/'b=@OM/'/'OpO'D'_CloseOn Errorsume Nextmo H , 0 _a N End If  pSub Private 8 Form_@Load()h On Erro@r GoTo@_Failed FSet rstEmployeeData = CurrentDb.OpenRecordset("A '", dbD8ynawQCompanyDescP&OBenefit''dP(GlobalLockedx`FalseN ew ReDim OriginalValues(Me.Controlsunt - 1WCle arA{ExitY Fx:M sgBoxD& "During B 5vbOKOnly, "Ì" & DoCmd.Close ac, (xNam9R8ead<Ǥ;ctl As D8DA FieldAIn tegerGtmBpCodeSt0JEjDMqB Each 7InAGEp 'l previous dfrom fAIf 5 v(Left (.W, 3), vbUpperC@m) <> "CBO" AbtnAB'LVAL TypeacLabel The>nG!  /mandButtonzheckO a` b""!E&hicHl}.Enab`KrNext:#cboiQ= T0rim(EuboRdC S DENzM(3l .Focusc!. m r= k C a gk _AfterUp@h *` ) l;L&G= AKe@  Y @h'FiH the rB that matchese csl'܆.FiPM3Y= '!h6}k'2O l" uYqH10o.NoM ?P Resume !C'Ab&~`v`2_`V1NTru5q! 3x= 0 z  Midul4l=6o( )pJpu? I| h'dbU_ 'j/q_t?!'MAddKM!q;[5b  6.ׁq End IfResume Next MFREdits@"A] [ J[Cui ed*xit Sub x  u:CMsgBox " currently l@by another user", vbOKOnly, Aed"(FaŪ& &%ClearFormA063PrivA6 Write()A Dim ctl As Control FieldAIntegerC@ Stringy C7Z POr (AENz(Trim(])) <> ""~ Il[rYE)x.S`( EachB#In Me.?#@a^a$= \0 `MPs unt - 1&' v(Mid(0.Name, 4)EUpperCase)(3 ( )vbHKE `kdx  q'] K@.Requery l?>nExistUSsE`l QSIfCancelcfFe_hvuuFFuncti>Changed()pBoo2pQT!3Q3QFs W ? 1 !7a!Var(iana@txerMatchA$mo0e OriginalValues(5`}kk1&fc)l\r Ǐl$Str@OlOl#OloOl`0r~\$Lheftv3vqCBO"_<2 =@ :1; LVAL  ;''1__SRP_11rU  ') 5 A -I2 1 yy 9 Qy96awIan q9y3yn@L)14@PYQ@ Ta9@Xppp@\1@ `a 1@dY4Q@h)3@l)+@p)4~~~@ ta@x)4@| !q@*1q@);LVAL @ avq@) 4~???___0   0    dDzt kz]<''(:HN88:hNXX^ 6X8([d dudd$ ] X8(0   0   0   0 0  0   <NH'X%x! HQxoh%"$ ,H8 8:(]>6hXH8\Dt k<'8'H:NXX:(Nhh^ 6hXH8d :(%! Pl x! Hx @xx! Hx Hx x$ $xhXH8<NH'X%x! HQxoh%"$ ,H8 8:(]>6hXH8\Dt k<'8'H:NXX:(Nhh^ 6hXH8d :(%! Pl x! Hx @xx! Hx HxDx$ $xhXH80   0   0   0 X  0 H  0   hK D`F: NLVAL (:LN<<:lN\\^ 6\<^d oh$ ` \<dKoED'H%'X%h%x"$ x QD4x6XHED'H%'X%h%x"$ x QD8x6XHED'H%'X%h%x"$ x QD<x6XHED'H%'X%h%x"$ x QD@x6XH D F8@x x ( l@Hxl `'XH @ xx '' l@#,*FH:h0 /,x6 XH0 =, >,FX%x"$ `x ,x5X $ o 0 ,xDXH0 0 X  0   0   0   8Kt Qt[pxlgxWL:\]><xW:,]> 'xW:]>'xWd]>'|6L\xWL\h]><5L\:\%x,f\%x xl%:\%! Pt! Ht Ht D F_4 `t! Ht @t80 plx< tL< |0 @  <  K`! Q`oPdHd` Q`[LxHxWPd.vF`_4 `  kF`cBxWP'0P !kvD%`_4 ` 0# ,$  " >F " 1)`6 P0 \xW % 0'P%kvH"$ ,0xa > " :&]>'6 P0 \  vdB xHYyee4 LHxd< `P0 LVALT`t\\ \ | | | dddPP__SRP_10rU $` $)` $i` $`  $`$$)`($i`,$$`0$`4$) `8$$i `<$ `@$  `D$$I `H$`L$`P$$ `T<$I`X $`\$``$ `d$I`h$`l$`p( `t#pLVAL 023=BCabce g$hiUj,kfꯤd@ Employee Data[Event Procedure]Arial[Event Procedure]d2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5` Detailm7U85`aTb ce ktxtHours#Hour or Unit Accumulated or Accruedd5U7`<aTbc Hours Label &5: Hours Hours_Labelm7U86`ab ce ktxtRateRate per Hour or Unitd5U7`<abc Rate Label&6: Rate Rate_Labelm7U89`a b9ce9k txtStartDate Short DateDate Benefit Startedd5U7`<a bcStartDate Label &9: StartDateStartDate_Labelo5U62`b@ cdeTfn"";"";"";"";"10";"20"cboCompanyCode Table/Query_SELECT DISTINCTROW [CompanyDesc].[CompanyCode], [CompanyDesc].[CompanyName] FROM [CompanyDesc]; 1440;1440[Event Procedure][Event Procedure][Event Procedure]d5U7`abcCompany Code_Label&2: Company CodeCompany_Code_Labelm457U`\ ab@ kcboCompanyNameo5U61`bcdxeTf!"";"";"";"";"";"";"";"";"10";"20"cboExistingRecords Table/Query߼SELECT DISTINCTROW [CompanyCode] & ",-," & [EmployeeCode] & ",-," & [BenefitCode] AS [Key], EmployeeData.CompanyCode, EmployeeData.EmployeeCode, EmployeeData.BenefitCode FROM EmployeeData;0;1440;1440;1440[Event Procedure][Event Procedure][Event Procedure]d5U7`<axbcExisting Records_Label&1: Existing RecordsExisting_Records_Labelo5U63`bcdeTfn"";"";"";"";"";"";"10";"20"cboEmployeeCode Table/QuerybSELECT EmployeeDesc.EmployeeCode, EmployeeDesc.LastName, EmployeeDesc.FirstName FROM EmployeeDesc;1440;1440;1440[Event Procedure][Event Procedure][Event Procedure]d5U7`iabcLabel25&3: Employee Codem457U`\ ab@ kcboEmployeeNameo5U64`b@ cdeTfn"";"";"";"";"10";"20"cboBenefitCode Table/QueryISELECT BenefitDesc.BenefitCode, BenefitDesc.BenefitName FROM BenefLVALitDesc; 1440;1440[Event Procedure][Event Procedure][Event Procedure]d5U7`ab(cLabel28&4: Benefit Codem457U`\ ab@ kcboBenefitNameh1U2S` a bHc,i btnSave&Save[Event Procedure]h1U2C` a bGc+i btnCancel&Cancel[Event Procedure]h1U2D`a bGc+i btnDelete&Delete[Event Procedure]m7U87`a3 b ck txtEmployerMatchAmountRate per Hour or Unitd5U7`<a3 bcLabel34&7: Employer Contribh1U2E`da bGc+ibtnExit&Exit[Event Procedure]SLVAL_e]d5U7`abHc Zipcode Label &6: Zipcode Zipcode_Labelm7U87`aTb7ce7ktxtPhoneNumberCompany Phone Number[Event Procedure][Event Procedure]d5U7`xaTb(cPhoneNumber Label&7: PhoneNumberPhoneNumber_Labelm7U88`taTb7ce7k txtFaxNumberCompany Fax Number[Event Procedure][Event Procedure]d5U7`aTbtcFaxNumber Label &8: FaxNumberFaxNumber_Labelm7U89`abcek txtFedNumberCompany Federal ID Number[Event Procedure][Event Procedure]d5U7`,abtcFedNumber Label &9: FedNumberFedNumber_Labelm7]8A`ab8ce9k txtPeriodStartDate Short Date Start Date for Benefit Reporting[Event Procedure][Event Procedure]d5U7`l abcPeriodStartDate Label&A: Start DatePeriodStartDate_Labelm7U8B`abtce9k txtPeriodEndDate Short DateEnd Date for Benefit Reporting[Event Procedure][Event Procedure]d5W7`abcPeriodEndDate Label &B: End DatePeriodEndDate_Labelo5U`b@ cdxef,"";"";"";"";"10";"20"cboCompanyCode Table/Query_SELECT DISTINCTROW [CompanyDesc].[CompanyCode], [CompanyDesc].[CompanyName] FROM [CompanyDesc]; 1440;1440[Event Procedure][Event Procedure][Event Procedure][Event Procedure][Event Procedure]d5U7`xaxbcCompany Code_Label Company CodeCompany_Code_Labelh1U2S`abHc,i btnSave&Save[Event Procedure]h1U2C`(ab c,i btnCancel&Cancel[Event Procedure]h1U2D`4ab c,i btnDelete&Delete[Event Procedure]h1U2E`@ab c,ibtnExit&Exit[Event Procedure]m 27U8E`xa bxcDk txtGeneralBenefitStatementd5U`xa` bcLabel31&E: General Benefit StatementLVAL P!h!!!"8$P6R(@x @!h @!X @!H @!8 @( @& @ 8!B""@#p##8$P6R(@x @#h @(#X @X#H @#8 @( @& @ "B$p$X$$P6R(@$l @$\ @$L @$< @%, @% @ @ Lh'X @H @8 %( $@VLH& L0&( '&L%xjz8&(p @l & &hO 'O 'X @'(H @8 @( '@ @ @ '(X@(@ @ p@  (0(O H( X( p(( ((@LVAL @ @ (L#P)//x @t @d *` @\ /HX @V /*/x /`x @t @d x+` @\ /X @V /HH,//x @t @d ,` @\ /X @V /X-//x @t @d 8.` @\ /(X @V X/(<(<x @t @d /` @\ (<X @V (<h0(<LVAL (<x @t @d 0` @\ (<X @V (<X1(< (<x @t @d X2` @\ (<(X @V (3(< (<x @t @d 3` @\ (<(X @V 4(< (<x @t @d 5` @\ (<X @V x(<X5(< (<x @t @d x6` @\ (<(X @V (H7(< (<x @t @d 7` @\ (<X @V (<XLVAL 8(< (<x @t @d 89` @\ (<(X @V :L Lx @t @d :` @\ LXX @V L(h;L Lpx @t @d ;` @\ LX @V L8<hHX hH@x @t @d X=` @\ hHX @V hH(>hH hHx @t @d >` @\ hHhX @V hH8(KhLVAL @HD@XHDl @\ @L HD< HDAHDdHDx @t @d pB` @\ HDpX @V HD@D @4 @$ ChHxXhH`x @t @d D` @\ hHX @V hHDhH(XhHx @t @d xE` @\ hHX @V hHXHFhHHXhHx @t @d F` @\ hH(X @V 8GLHXL0x @t @d 8H` @\ LX LVAL @V LILXLx @t @d I` @\ LXX @V L(hJLhXLpx @t @d J` @\ LX @V LKL(bLx 0NMLL 8xJMl @\ @L @< @, @ M @ M @ N @ NU NO PNU `N( @ xNVN @NVN@4 N( N NZ[O6R(@l O\ @L  P< @, PP LVAL @ 8 PU Ux @t @d HQ` @\ UX @V UXRU Ux @t @d R` @\ U(X @V 8xSSx @t @d T` @\ X @V PTXU@x @t @d hU` XU@\  X @V p @l UVhO 0V @V(f @d XVhVb XWxWP @@ @0 @ @ xWp xW @ @ @ hWBAWWW33pX X SMELVAL  ( "  ( 0  " @ P X H " p 2 x "    " ` p" h " Y " A 2<  (08@  "H AX p2< P " Y,   "  H,h H   "  "@ P X:F`H "0 $E  8 (8`0=h 8 "  @@ "   L " Y " \ " PY`X "  X\h` " `Yph "  \ " Y "  (\80LVAL i_VBA_MODULECxQ 8P <` B H /0 P ` hpxLVAL   " ` < 8( > : 88 Lp  R-     (0xp`7 Purpose: Limit the text in an unbound text box/combo.5 Usage: In the control's KeyPress event procedure:g; Call LimitKeyPress(Me.MyTextBox, 12, KeyAscii)yA Note: Requires LimitChange() in control's Change event also. v!f v! ar  tx'A@hhxuph0l(7 Purpose: Limit the text in an unbound text box/combo.3 Usage: In the control's Change event procedure:1 Call LimitChange(Me.MyTextBox, 12)E Note: Requires LimitKeyPress() in control's KeyPress event also. v!f  v!f $ v(f  v(hxuph8l0(Cancel Error code Cancel Error CodePLMsgBox "Truncated to " & iMaxLen & " characters.", vbExclamation, "Too long"T1 http://users.bigpond.net.au/abrowne1/ser-34.html1 http://users.bigpond.net.au/abrowne1/ser-34.html(6 Example code by Allen Browne abrowne1@bigpond.net.au6 Example code by Allen Browne abrowne1@bigpond.net.auAttribute VB_Name = "modUtilities" Option Compare Database`Explicit Sub LimitKeyPress(ctl Aszntrol, iMaxLen&Integer, ,Ascii)^n Erro@r GoTo _C Y ResuNext 'Cancel:cod' Example  by AllBrown e ab1@bigpond.net.au ' http://users.  //-34.htmlPur@pose:  the tMin an unbound box/@combo.Usag Inco's event procehLVALtdure : CallMe.MyT@Box, 12A' Not `RequimChange() -"C!alsA.  If @vA|B.) - @.Selgth >=ThenC Dƀ<> vb@Back = 0ABeepGE@XIf ExitO @@O@O׺ZU C_]_]_]^]*L] E]C( ][ IC \!_\t) >4Z'Msgm "Tru ncate}o (" &&ch aracta",^Exclama,@oo long`ATaiakLeftfm i`oStart7bc(a&ahaLVAL  " (Y80 "  `\ph " \H@ " \5   "  T5   " Y "  X\h` " Y "  \ " Y "  0\@8 " XYh` "  \ " Y "  h\xp " 0Y@8 "  \ " Y "  \ " Y0( "  \ "     6H       0  8 +H AX  p  . *H         8  .H <h 7            4p 0  P X ` " h p +x  A     &           0 8 @ H P bLVALnͬ:ckuO 1ŘCDetailmCtxtCompanyNamed CCompanyNameLabelmCtxtAddress1d CAddress1_LabelAddress1 LabelmCtxtAddress2d CAddress2_LabelAddress2 LabelmCtxtCityd CCity_LabelCity LabelmC txtStated C State_LabelState LabelmC txtZipcoded C Zipcode_LabelZipcode LabelmC txtPhoneNumberd CPhoneNumber_LabelPhoneNumber LabelmCtxtFaxNumberd CFaxNumber_LabelFaxNumber LabelmCtxtFedNumberd CFedNumber_LabelFedNumber LabelmCtxtPeriodStartDated CPeriodStartDate_LabelPeriodStartDate LabelmCtxtPeriodEndDated CPeriodEndDate_LabelPeriodEndDate LabeloCcboCompanyCoded CCompany_Code_LabelCompany Code_Labelh CbtnSaveh CbtnCancelh CbtnDeleteh CbtnExitd CLabel31mCtxtGeneralBenefitStatementLVAL X H3`      "    .n  (  .@  <` 8            "    ( 8@ H "P X`6hHOP          0 " 8  @H P`h pB x     .< 2;  ( 0 @ Pxp00 !Z ".! A@l8 !8 J"L! A@l !P J"! A@lX !T J"! A@l( !X J"! A@l !P J"! A@Hl !R J"! A@Xl !T J""! A@lh !V J"&! A@hl8 !X J"*! A@(ll !< J"n! A@l@ !r J"*! A@l !v J".! A@l !z J"2! A@S'@aH'@hMLimitKeyPress Me.cboSalaryHourly, rstEmployeeDesc!SalaryHourly.Size, KeyAsciih0 lX ! J""! A@p l(6LVALB $er$Dz0`(JP  aV e0ae$$$ `$$$$b| 44@PX$$$$bDD@$$$$b@LL@$$$bTT@aV e$D ` |+h\   $$$$p x CfPeriodEndDateCgGeneralBenefitStatementChBenefitNameCiBenefitShortDescriptionCjBenefitLongDescriptionCkRateMultiplierClMultiplyHoursWithRateCmIsEarningCodeCnLastNameCoFirstNameCpMiddleNameCqEmployeeDesc.Address1CrEmployeeDesc.Address2CsEmployeeDesc.CityCtEmployeeDesc.StateCuEmployeeDesc.ZipcodeCvSSNumberCwHireDateCxSalaryHourlyCyFullPartTimeCzHourlySalaryC{AnnualSalaryC|HoursWorkedC}JobTitleC~CommentCHoursCRateCEmployerMatchAmountCStartDateCTotalLVAL l !8 J"L!A@ 0l !P J"!A@#$%pl` !T J"!A@;<=l0 !X J"!A@STUl !P J"!A@klm0 l !R J"!A@ & p l !T J""!A@: S lp !V J"&!A@ l@ !X J"*!A@ l ! J""!A@(l lhaH'@= "S" l !< J"n!A@Employ0 l !r J"*!A@b P l !v J".!A@ii As  lx !z J"2!A@, rstEPF'<aP'<h''  <PF'<HihZ@X Z@ Z@ Z@X  lh lXP $Save Current Record PSave$6 RA@(hh EmployeeDesc  %.J#'$'@ !x! A@Bux  - During Form Load 8Error A@6  ! B@BZZ( '$'@ v !x Clear previous data from form v!cboEmployeeCode v! z'vhx v(#_ #h` v 8$'8# 8$ 8B@a(Find the record that matches the controlEmployeeCode=' 8' JB@h J!l v !x#w # cboEmployeeCode.Requery v(  J!! v!$ $  J%! $  J%'v v +#h #h v##a'@ rstEmployeeDesc.AddNew rstEmployeeDesc.UpdateY #hhl 8$'8A@ 8LVAL $# # @# # JB@# # 8 J)L # JB@hH@A@ J( 0  JB@"'$aA@Bhu0'Record currently locked by another user 8 Record LockedA@6'$uA@Blp@Z ZZ0 $ @ 8$$ v !x  J!! v!$ $  J%! $ v  J,h # # v JB@'$ 8B@h0l(( JB@<'@A@Bl hZ v !x Clear previous data from form v! z'vh v(hh v'8 8B@'$'@ JB@< 8B@# #l $ JB@h A@Bl Z(Z@' v !x  J!! v!$ $  J%! $'h h # # v# #f XlA@ Read Record P!tr PB@m Fielh`lP 8$alse $ wRecSave Current Record PSave$6 Rr prevA@(hA@Bhhl 8$olType $ ThenSave Current Record PSave$6 Rn ThenA@(hHh@A@Bh0l A@(A@B b( plA@:A@B H(= TrimlA@ (panyCo .rstEmployeeDesc!EmployeeCode = cboEmployeeCode $ v v!cboEmployeeCode $ $P $ $H$9LimitChange Me.txtHireDate, rstEmployeeDesc!HireDate.SizeLVAL ELimitKeyPress Me.txtHireDate, rstEmployeeDesc!HireDate.Size, KeyAsciitieslPH 'hALimitChange Me.cboSalaryHourly, rstEmployeeDesc!SalaryHourly.SizeS'@boSala0 @HaP'<l !V J"`!A@Hl !V J"`! A@l !\ J"f! A@lp !\ J"f!A@HlA@(A@B $ Save Current Record PSave$6 R hh B@BcboE v!cboEmployeeCode v!btnExit v! j v!cboEmployeeCode v!btnExit v! j0Attribute VB_Name = "Form_frmEmployeeDesc" Bas0{BD749E8C-5B7F-47DF-B246-DF814E8ED855} |CreatabBlTrue ]Predecla Id"ExposeFals @$Teatriv%Custom izD$Option Comp@ DTv P%!) rst As RecordsetGlobal LockBBooleanq New&OriginalValues()Varian7Walici-Sub btnCa@ncel_Ck() 7@#r| .EnDHW End  Delete CECExitIf QT%ChaDngXThe@W @ MsgBox("Save C@urrentj"@, vbOKB, ")A GAWriteE3BIfDDoCmd.Cl@J!;G4JCJa (KcboCode_AfterUpds{A, A1 'ReadB%txtLasto," SetFpocusI#ECL6Limit Me. ,n!).Siz@ap#En#AaYNz( ) <> ""OO-_P_PA `P-aaIS$ "P" Then L = "F"@lsePIf 0Hourly}k' FFHFFSm# H#zCityob.cXtFi@NaaY F&=\#C O_ O _b!sWorked s d  {x tLast0itzEOoxtMiddle/,g_olOК/St.atbR_b Zipc\p4OLtoom?ReadRecordsDim ctlAPtrolwField @GlobalLoc`P0FaNew#For EachRIns 'Clear previous data from form P0 .8Ǣp" AbtnExit!4Type!acLabelqCommandButton "Da19 EnabledA NextTrim(laPNz0"١.Se@tFocusCE#'Fithe r% that matchese conw%! . "i='" & L"'A ot=.NoM On Err@(Resume s 1*.qy(ee1ܝ;T|ru98=` 0 Tos@ unt - 1  SԀ`( me, 4), vbUpperCase) = StrConv(rstEmployeeDesc.F@ields().Na tThen ctl@OriginalValueRX8End IfNext i 3/NElseGlobalNewRecordgTru' Add $ B!Codebo.Upda t!c.Reqpuery A  Sub Priv  Lock=() On Error Resume6 AOCKBHim(Read If Nz <> "" Ǫ `&GoT oH._a_FailedGA]k j 6hE[ + RAIH-A2Edits,P a ,3e']gbClearForm#Fv!xit H [_A: MsgBox " current0ly lM`by another@ user"OKOnly, ed"FaxIB(@@aWriteaDim ` As trol a╡Integer}@Str8inggba/ Oxr (? AhTrm)CiLVAL >)d&EO; EachIn Me.sC!R#p= 0 `mMJs unt - 1Gy  v(Mid('d__ݥS$@*`kIva ;}T ,%8);ZC`anceli)xt s5 % o1Ab,EAc11 '' 'R previous oa from fH1%7$/p"2btnEK.Type!acLabelfCommandButton5=`n3"@&q Enabk*# ($"R&SetFocu=o*[o"( &_)Y0։ S%Dele+W? X%% c5al._Functi6Changed()Q^Boo0s^ Q!32CQa f g ? 1 22$Y(PYp_YȠ_Y`/ldkrmp=@A153Q4b  w5" __SRP_erU 33) I2 1 yy 9 Qy2awIa) Qy)@@)y@D)Q@ Havq@L) ~~~  @P)  @TY@X)Q@\ppp@ `a 1@d) Q @h)ALVAL $Dd.`@vk0 "|$ $  $ $P0$$$$$$DJ `6kH W0$$p $ $X$ $$$$ h$$$$$  $$$p0 x$$ $($P0p$$$ $$$$ x wx $0pX@(0pX@(LVAL @ la9@p)  Q @t) @x)1!  @| !1qQ@Y!@ a@1q@) Q@)) Q@)I vvv Q @)qA@)i zzz3???_____ _    _    _    _    _  0 p  0   LVAL 0   0   0 X  0   AH'X%x! 8Qxoh%"$ ,H:8]>(6hXH\8&k&<'('H:NXX:8Nhh^ 6hXH(h$ xhXH(AH'X%x! 8Qxoh%"$ ,H:8]>(6hXH\8&k&<'('H:NXX:8Nhh^ 6hXH(h$ xhXH(0   0   0   hK 8`F: N(:LN<<:lN\\^ 6\<^h$ ` \<@KED'H%'X%h%x"$ x QD4x6XH 8 :8@x x (l@<x`'XH @ xx  ''  l@#,*FH:h 0 /,x6 XH0 =, >,FX%x"$ `x ,x5X@$ 0 ,xDXH0 0 (  0 p   0   0 H  0   0 0   0   0   0 0   0 H LVAL <f7hUe7uhUeh?Ge`Ue8(eGe  <eDePexeeee e$ e< eT et e e e e e$ eL el e e e e e e eH ep e e e e e -e- eM em e e e e e e eE eP ee8ePexeeee e e0 eH eh e e e e e e@ e` e e e e e e eH ep e e e e e -e e@ e` e e e e e e e8 eP e(e(e(e(e(e(e(e(e(e(e(e(e(e e e e e e e e e e e e e e e e e e e )e e e e e e e e e e eeDeheeeee e$ e< eT et e e e e e$ eL el e e e e e e8 e` e e e e e e )e- eM em e e e e e e eE e    2   2   2                                 2               2   2   2   2   2                                2            #CompanyDesc.CompanyCodeCompanyDesc,CompanyDesc.CompanyNameCompanyDesc.Address1Address1CompanyDesc.Address2Address2CompanyDesc.CityCityCompanyDesc.StateStateCompanyDesc.Zipcode5ZipcodeCompanyDesc.PhoneNumberCompanyDesc.FaxNumberCompanyDesc.FedNumberCompanyDesc.PeriodStartDateCompanyDesc.PeriodEndDate#CompanyDesc.GeneralBenefitStatement#BenefitDesc.BenefitCodeBenefitDesc;BenefitDesc.BenefitNameBenefitDesc.BenefitShortDescription"BenefitDesc.BenefitLongDescriptionBenefitDesc.RateMultiplier!BenefitDeLVAL 0   0   0 0  0   0 (  0 p   0 X  0 p  0   0 0   0   0   0   0 0  0   0   0   0   0   0   0 h  0   0   0 @  0 (   Kt Qt[pxlOxWL:\]><xW:,]> 'xWd]>'6L\xWL\h]><5L\:\%x,f\%x xl%:\%! @t! 8t Ht 8 :_4 `t! 8t @t 0 plx0 tL< 0   0   l`H||||   T T LVAL @@DDtt|XX p!p"x#x$%&L'L(d)d*P+P,-./012G__SRP_fWrU $` $)` $i` $` $`$)`$i`$`$$`$) `,i `0&$ ` <$  ` $I `(`@&$`( ` @&$I`$(`(@&$`,( `0@&$I`4(`8@&$`<( `@@&(I`DD&(`HD&(`LD&$ `P(I`T@&$`X(`\@&$  ``(I !`d@&$ "`h( #`l@&$ $`p(I %`t@&$ &`x( '`|@&$ (`CLVALOboSalaryHourly_NotInList?dNewDatax_ResponseacDataErrContinueD Form_frmBenefitDesc)rstBenefitDescj9cboBenefitCode_AfterUpdatetxtBeneditName9txtBenefitNameqcboBenefitCode_Change?cboBenefitCode! BenefitCodeNcboBenefitCode_EntercboBenefitCode_GotFocuscboBenefitCode_KeyPressQtxtBenefitName_Change BenefitNameŃtxtBenefitName_KeyPresstxtRateMultiplier_KeyPress. acCheckBoxq rstBenfitDescvbYesa?MultiplyHoursWithRatehvbNo% Form_frmEmployeeDataOrstEmployeeDataZcboExistingRecords_AfterUpdatecboExistingRecordsStmpCompanyCodeIcboCompanyCodtmpCompanyCodetmpEmployeeCode&txtHoursDcboBenefitNameVtmpBenefitCodeȉ ClearCodekItmpEmplobeeCode FieldMarkerDRecordOKcboExistingRecords_EntercboExistingRecords_GotFocuscboCompanyNamecboEmployeeName Form_frmMainMenubtnBenefit_ClickErr_btnBenefit_ClickA stDocNamezstLinkCriteriaYOpenFormExit_btnBenefit_ClickbtnCompany_ClickErr_btnCompany_Click٤Exit_btnCompany_Click8 btnEmployee_ClickErr_btnEmployee_ClickExit_btnEmployee_Click[btnDataEntry_ClickQErr_btnDataEntry_Click_Exit_btnDataEntry_Click; btnBenefit btnCompany( btnEmployee{  btnDataEntryBenefitName_LabelIBenefitShortDescription_LabelBenefitLongDescription_LabelNfRateMultiplier_Label$MultiplyHoursWithRate_LabelwtxtBenefitShortDescription=txtBenefitLo(I )`@&$ *`( +`@&$ ,`$I -`$ .`$ /`$ 0`$I 1`( 2`#pLVAL 0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(0pX@(LVAL i_VBA_MODULEp VduEx 'qt@gGb 2x mQP {(SLS S<<,< <<<< <$<0<4<8<<<N0{DF40D7C8-67E7-47E5-AE01-6209CCEC8A32}x (om$8` @ 35`xx`t $ $ $0 $$@``` $ $ $8 $*H` @%`x`t`x@  $0X` @6`tX($($($($ $  $P $D `|@ H`x`t $  $PcLVALo<@H=-^A.q=qK D0_u1Hb-Co EMX$Z4K(GvfKXܸaOlGDb, HAW۾B2lJ MIt2 4<scrikDfuAT zVnFIIfI: avM5hT- |[gJtieZeM BLq82*XN  O OC[=jJLf (CompanyCode = ' >>>9 oSELECT DISTINCT CompanyCode, EmployeeCode FROM EmployeeDesc WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='ߗ)@Nv/} r5CϽ[ SELECT EmployeeData.CompanyCode, EmployeeData.EmployeeCode, [CompanyCode] & ',-,' & [EmployeeCode] AS Key FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>='abc,-,123456789' And ([CompanyCode] & ',-,' & [EmployeeCode])<='abc,-,234567890'));F SELECT DISTINCT EmployeeData.CompanyCode, EmployeeData.EmployeeCode FROM EmployeeData WHERE ((([CompanyCode] & ',-,' & [EmployeeCode])>=' '));Mi8I]z-SKT̠A6^`hfoE>I $Report_rptSummaryBenefitStatementSubYBO(y$I"KuuOjw&%Aa eD0`VJ.@I,a eDH`@FVk4+0,)'P!-,(,.P-*@(pp.&0(0%P*+`$0# )(H+LVAL @)) P.&p X% `%h%%`&00,)'P!-,(,.P-*@(pp.&0(0%P*+`$0# )(H+@)) P.&p %%(& 0&'' **83$$$ wx'D p`J( ,p.P* %&h3P(@(@)0P!`$.+P-*0)0-p.p'(&)),(+0,#H& @3H305$ `5$5$$$$$+5 555 6$46666$`8777808$@xB@8x 5@LVAL h @7X @H8H @D @@ 786@80 @, 8996@8 @8 @ xjzL$@@t @ 9p @lO (@= 9 @<\ `Hp7,p.P* %&h3P(@(@)0P!`$.+P-*0)0-p.p'(&)),(+0,#H ,p.P* %&h3P(@(@)0P!`$.+P-*0)0-p.p'(&)),(+0,#Hx8@<H998x8@h<L P66@<< @<, @< @< @< @ @= @(= @  9> >h>>>L$P6R(@x @8>h @P>X @>H @>8 H:@( @& @ =BL$P6R(@x CCk=(??? @P@LVAL KsF<#D^uHg? #D#D#D #D !#D#D#D#D#D#D#D#D     Help.HelpCodeHelp Help.HelpMemo#D#D#D#D #D9u3e@#D#D #Dr #DrHelp #D#D#D #D#DZ\e@ ~sq_ffrmHelp#D #D#D #D#D#D#D #Dr#DrH"rHelp #Dp#D #Dx#D#D#D #D #DP #D #D@#DH#DP#DX#D`#D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D #D#D#D#D(#Dp #D #D #D #D #D $|#D  #D#D #D8r#D#D #D0 #D #D #D0 #D #D#D#D #DHelp  #D  #DPrimaryKeyHelpCode #D n_0x]D#Dv  #D #D#D#D #Ds #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D #D#D #D#D#D#D x#DHelp#D #D #D #D #D@ #D(#DX#D#D #D#D #D#D#D PrimaryKey H#D$#D"MAIN"L#D #D\#D x#D|#DX#D`#Dh#D LVALJPrimaryKey(#D#D #D#D#D#D#D #DXnl?sFsFsFH sF !sFsFsFsFsFsFsFsF     Help.HelpCodeHelp Help.HelpMemosFsFsFsF sF9u3e@sFsFD #DsFrsFr@Help sFsFsFsFZ\e@ ~sq_ffrmHelpsF sFsF sFsFsFsF sFrD ##sFrD ##Help sFpsF sFxsFsFsF sFX sFsF$sF@sFHsFPsFXsF`sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsF sFsFsFsFsF n_0x]DsFv  sF sFsFX sFXs sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFX sFsF sF@sFsF X sFHelpsFH sF sFH sF sF sF  sF sFsFH sF sF  sF sF sF PrimaryKey  sF sF"MAIN" sF sF sF 8 sF< sF sF sF( sF sFH sF sF  sF sF   sFH sF sFH sFsFX sF  sFX sF  sF@sF0sFpsFsF @sF psFLVAL @@?h @@X @8@H @h@8 @( @& @ >B8AKPAhA8AN pA@x @v 8BPBBBL@$B@x @hBh @BX @BH @B8 @( B86 @ `8EC DDPECE E?$@xjzL@Fp @Cl @hEhO ECk@PDX @8DH @hD8 @D( @D @D @D @ @D @D @ ECrC@ @ @E EhE{@O EE{ @E EE~ @  FE~@ 0FEFEF(GGXGFL @Gx (@@Gt @d @pG` @\ @X @V LVAL Benefit Statement Generator The purpose of this program is to make benefit statements for employees. This code distributed under GPL http://www.gnu.org/copyleft/gpl.html You can use sections of code any way you want. If you enhance this product, the resulting product and source code must remain freely available to everybody (Although you can charge for it as well. See GPL License). Lee Lofgren Accounting Enhancements Inc lee@lofgrens.org 2/26/2003 Usage: See section after report information for table information Report: SummaryBenefitStatementReport: -Prints a simple summary benefit statement for a range of employees. The starting Company/Employee to EndingCompany/Employee contains all Company and Employees between these ranges. -This report uses all 4 tables and is based on the EmployeeDataQuery. -It uses the following fields. Current system date: Date above employee name CompanyDesc: CompanyCode, PeriodStartData, GeneralBenefitStatement PeriodStartDate: Year at the top of the report GeneralBenefitStatement: Text just after employee name. EmployeeDesc: EmployeeCode, FirstName, LastName, Social Security Number, Address, City, State,Zip, Date of Hire, Annual Salary, and Job Title Annual Salary: Prints at top of page and bottom of page BenefitDesc: BenefitCode, BenefitName, BenefitShortDescription, RateMultiplier, MultiplyHoursWithRate, IsEarningCode IsEarningCode: Separates Earnings section from Expenses section If no EmployeeData with Earnings then Earnings section is not printed. [RateMultiplier]*[EmployeeData:Rate]: Employee Cost field If MultiplyHoursWithRate is checked then Employee Cost = RateMultiplier*EmployeeData:Rate*EmployeeData:Hours EmployerMatchAmount: Employer Cost field EmployeeData: CompanyCode, EmployeeCode, BenefitCode, EmployerMatchAmount, Hours, and Rate. Total Benefit Cost: Employer Costs addedLVAL together for Earnings and Expenses. Earnings and Expenses are added together since both categories are an expense to the employer. Total Compensation: Total Benefit Code + EmployeeDesc:AnnualSalary Please be aware of this before if entering earnings with Employer Matches Percent of benefits to wage: If benefits not zero then equals BenefitCost/(BenefitCode + AnnualSalary) Table Information: The program has 4 tables. These tables can be filled from Excel spreadsheets with the same layout as the tables. Just highlight the Excel data and copy, then open the Access table, point to the asterisk (*) and paste. CompanyDesc: -Contains general company information and a General Benefit memo field that can be used to preface the statement. -The CompanyCode is used to uniquely identify each entry. -The Period Start Date is used to display the year in the Summary Benefit Statement report. BenefitDesc: -Contains general benefit information. -The Benefit Short Description is intended for summary reports where you wish to have a 1 line description. -The Benefit Long Description is for reports where you want to dedicate a report section to each benefit code -The Rate Multiplier numeric field is used in the EmployeeDataQuerys calculation of field Total Total = [RateMultiplier] * [Rate](From EmployeeData) . The Query is meant to be used as the data source for reports. -The Multiply Hours With Rate causes the EmployeeDataQuerys Total field to equal Rate * Hours * RateMultiplier as opposed to Rate * RateMultiplier. These fields are from the Employee Data table. -The IsEarningCode is used to separate earnings from expenses. Most benefit statements dont list an employees earnings but I am trying to make this fairly generic. The SummaryBenefitStatement report separates the Earning and Expense categories. EmployeeDesc: Contains general employee information. Not all fields are used in the SummaryBenefitReport. EmployeeData: -Benefit amouLVAL     nts for the employees -The EmployeeDataQuery works off of this table and pulls supporting information from the rest of the tables. This means that only records from here show up in reports that are based on the EmployeeDataQuery. If an employee isnt listed there then the employee wont show up on reports based on this query.LVAL i_VBA_MODULE H좂YrD[@g)`S)E(uA@9KvNi\jhVx"@Q9KvNi\jhV좂YrD[@g)>p4z8v<@(SLS S6LLL<,<0<4<8<<<N0{95295360-9481-451A-A5A9-281F7541F340}]>$*\Rffff*123e5d01e1*\R1*#8f*\R1*#8e*\R1*#1c*\R0*#10*\R0*#16*\R0*#11 `(mm$`4k0 ! $d2  $00 $6@x @h h@@d =@(T 9@@D H6@4 2`00LxME "  / 08 @<HX `pxp0` B@B.DLHu@8 !A@6A lUALVAL %XHHHH@HN @pHx @Ht @d @H` @\ @X @V IIHJJINL@Ix @Jt @d @0J` @\ @X @V *KHKKxKKP 8K@0Kx @`Kt @d @K` @\ @X @V xLLML`LP @Lx @Lt @d @L` @\ @X @V ((+MNhN8NMR HO@Mx H@ Nt @d @PN` @\ @X @V HOxOOO OR 0/8O@`Ox @Ot @d LVAL @O` @\ @X @V H+PP8QQPT @Px @Pt @d @ Q` @\ @X @V R8RRhRQT @ Rx @PRt @d @R` @\ @X @V ,hSSSSPSV@Sx @St @d @S` @\ @X @V TTXU(UTVl@Tx @Ut @d (@@U` @\ @X @V p,(VXVVVVX@@Vx @pVt @d @V` X@\ @X @V WW0XXpWXLVALttribute VB_Name = "Form_frmHelp" Bas0{95295360-9481-451A-A5A9-281F7541F340} |CreatabBlTrue Predecla Id"ExposeFals @Template Deriv%Customiz$Option Comp@ DTv  dFh x6hTD4 6%eH$ y $dxhTD48[__SRP_2erU L$` pLVAL W@Wx @Wt (@d eeF@X` @\ @X @V ,Y0YY`YXZ@Yx @HYt @d @xY` @\ @X @V `ZZZZHZZ@xZx @Zt @d @Z` @\ @X @V 0-[[P\ \[\@[x @\t @d @8\` @\ @X @V ]P]]]]\@8]x @h]t @d @]` @\ @X @V -^^_^h^^@^x @^t @d @^` @\ @X @V LVAL _`p`@`_^@_x @(`t @d @X`` @\ @X @V -P.cc(Bb@x `9*h+pfddeeee@fW$@Lx@Xfl @d\ @dL @d< @ e, @8e @Pe @he @e @ @ @e @O fe@ @f 0fe@ ffxd@ @ ffexg`gHg$P6R(2LVAL> $ $ $ $($H($x($    ` P @@  X0 0 , 0@ X@ ( 6cdefgi p tu@`  P R@@ "! X0 , @ @  6P`0 p @` PP P @@  X0  , @ @ 0 P\MEͬ{IVֳB̽@髙CFormHeaderCDetaild CExisting_Records_LabelExisting Records_LabelCFormFooterCCompanyCodeCEmployeeCodeCBenefitCodeCHoursC RateC EmployerMatchAmountC StartDateoCcboKeyStartingd C Label7oC cboKeyEndingmCtxtKeyStartingmCtxtKeyEndingh CcmdPrinth CcmdPreviewh CcmdExitLVAL $$`LpDD``xJw$D$@$Dbx`xJsxD($$D$$`vt$f `xkzh `xJ~ JxPb88@H$$$Dr@ `0o''4xX D$D $4c&e$0$D`$$0$0$0$0$ Jx DH $`Lp0$0$0$0$0$D`o 0$0$0$($`vt`Lpp 0$D 0$ LVAL 0$0$(D D @   `|NGG`x h Dp x ( ` o GGD 0$ 0 D0`h4k[0$ x   @ 0Hxx D(  0$D0$0$@X0$Dpx0$0$ 0$D0$0$D80$h0$x0$x   @ 0Hx@0$Dp 0$0$x   @ 0Hx 0$DP(0$0$$x 0$`8 b x LVAL @gl @g\ @gL @g< @g, @h @ @ G((00,#`66 C:MEb(  " H X `  pP " x     "  2< / " 0   ( " "  x "XYh` " A  2<x       " A0  H2< H P ` X h ( " H\P "p ` :F    x " $E 8 8`( p8`=@"   0 @ 6FO  @  `  p X+`AH h .*H H x p  .<7   3@@@gruo,guoafpfgjwdfvbKgruo,guobros`p}dfvbKgruo,guofosmr}ffd`w`Kgruo,guofosmr}ffdfvbBKgruo,guoifmsKgruo,guoo`jpofpx`Kgruo,guovxoo`u}afpfgjwufsruwKordxwjmjwjfv[Kov}vdaKufsruw,uswvxoo`u}afpfgjwvw`wfofpwvxa4K ofpwvxa4K ruw,uswvxoo`u}afpfgjwvw`wfofpwvxa4K ofpwvxa4K pLe@pLe@modUtilities+++++++++++  pLe@pLe@frmSummaryBenefitReport66666666666  pLe@pLe@frmMainMenu***********  pLe@pLe@frmEmployeeDesc...........  MPLe@MPLe@frmEmployeeData...........  MPLe@MPLe@frmCompanyDesc----------- MPLe@MPLe@frmBenefitDesc-----------  MPLe@MPLe@UserDefined***********  MPLe@MPLe@SummaryInfo***********  MPLe@MPLe@AccessLayout+++++++++++ MPLe@MPLe@SysRel%%%%%%%%%%% MPLe@MPLe@Scripts&&&&&&&&&&& MPLe@MPLe@Reports&&&&&&&&&&& MPLe@MPLe@Modules&&&&&&&&&&& MPLe@MPLe@Forms$$$$$$$$$$$ MPLe@MPLe@MSysRelationships22222222220 MPLe@MPLe@MSysQueries,,,,,,,,,,* MPLe@MPLe@MSysACEs))))))))))' MPLe@MPLe@MSysObjects,,,,,,,,,,* MPLe@MPLe@MSysDb n_0x]D::::::::::% MPLe@MPLe@Relationships.........., MPLe@MPLe@Databases**********( MPLe@MPLe@Tables''''''''''% 2&ȥJZŭevƒe@e@e@Qe@frmHelp((((((((((& hXe@Z\e@Helpe@e@e@e@Qe@frmHelp((((((((((& he@e@e@*6de@frmHelp((((((((((& hXe@Z\e@Help@111%%%%%%%# @:s3e@:s3e@~sq_cfrmBenefitDesc~sq_ccboBenefitCode n_0x]D{*@ rrrfZZZZZZE `"1e@9#1e@~sq_rrptSummaryBenefitStatement n_0x]D@*@kkk_SSSSSS> `Q,e@Q,e@~sq_ffrmSummaryBenefitReport n_0x]D` *@hhh\PPPPPP; `Q,e@Q,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyStarting n_0x]Dc *@{{{occccccN `fJ,e@J,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyEnding n_0x]Db *@yyymaaaaaaL `>c+e@1e@rptSummaryBenefitStatement@LWF000@4eYGG;;;;;;9 ݖ2d@Th-d@EmployeeDataQuery7@@VJJ>2222220 `B 2d@yOMd@CompanyDesc7@888,,,,,,,* @\^e@\^e@AutoExec_@5)))))))))'  C3d@?Ie@AccessLayout n_0x]D*@@4XLL@@@@@@@+ @ѱ1d@ѱ1d@Scripts n_0x]D;;;;;;;;;;& ѱ1d@ѱ1d@Forms n_0x]D9999999999$ b2d@b2d@EmployeeDescEmployeeData n_0x]DLLLLLLLLLL7 ]2d@]2d@CompanyDescEmployeeData n_0x]DKKKKKKKKKK6 `2d@`2d@BenefitDescEmployeeData n_0x]DKKKKKKKKKK6 Nu @ @ @ @ @ @ @((((((((( ( ( ( ( (( ( ( ( ( ((((((((((((( (!("(#($(%(& ('!(("()#*$*%*&*'*(*)***+** * * (* EmployeeDescEmployeeDataEmployeeDataEmployeeCodeEmployeeDescEmployeeCodeUI=1% CompanyDescEmployeeDataEmployeeDataCompanyCodeCompanyDescCompanyCodeQF;0$ BenefitDescEmployeeDataEmployeeDataBenefitCodeBenefitDescBenefitCodeQF;0$ *\:+xiGC!n_P{UF7(m   B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o     n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D LVALȡ @ @ @ʾCompanyDescEmployeeDataQueryfrmSummaryBenefitReportrptSummaryBenefitStatementSubAutoExecmodUtilitiesC)\vEmployeeData itEmployeeDescVxBenefitDesc%v CompanyDesc1fV BenefitDescBenefitDesc xCompanyDescCompanyDescEmployeeDescEmployeeDesc2xEmployeeDataEmployeeData22 frmMainMenu0-10LVAL*9iiiiiiiiiiiiiiiiiiiiiiiiii_____KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1KKD KeKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl DecimalPlaces x BenefitName   $ Benefit name shown on report    mBenefitShortDescription   2 *Short description used for summary reports   mBenefitLongDescription    Long description   MultiplyHoursWithRate   Y QIf Yes EmployeetData Total = Rate * Hours else Total = Rate for EmployeeDataQuery Yes/No   j BenefitCode   0 (Benefit Code used to match imported data    mRateMultiplier   . &Multiplier against EmployeetData->Rate   1   m IsEarningCode   F >If Yes then amount represents income to employee, else expense Yes/No   jKKDTitleAuthorCompany6 benefitstatement . .KKD AccessVersionBuild%  07.53 KKD KeepLocal T`#\:+pN,qbS< vT n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o    n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o     n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o     n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o     n_0x]D -~\E6phY7 |mKG%%%%%%%%% n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  TB)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D 3 3B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o 3 n_0x]D 1 1B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o 1 n_0x]D TB)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D + +B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o + n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D ! !B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ! n_0x]D  B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o LVALuKKKKKKKKKKKKKKKK! @ @ @ @ @ @ KKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl h CompanyName     Company Name    mh CompanyCode     Company Code    mY City     City    m[ State     State    m_ Zipcode    Zipcode    mp PhoneNumber    Company Phone Number    ml FaxNumber    Company Fax Number    ms FedNumber   ! Company Federal ID Number    mmPeriodStartDate   (  Start Date for Benefit Reporting  i PeriodEndDate   & End Date for Benefit Reporting  gAddress1    Address Line 1    mgAddress2    Address Line 2    m|GeneralBenefitStatement   & General Benefit Statement Text   LVAL c99dationRuleValidationTextFilKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayConKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl aHelpCode    HelpCode    mXHelpMemo     Help Memo   KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl DecimalPlaces [ StartDate    Date Benefit Started   BenefitCode   E =Benefit Code, matches BenefitCode in BenefitDesc->Benefitcode    m EmployeeCode   9 1Employee Code, matches EmployeeDesc->EmployeeCode    m CompanyCode   6 .Company Code, matches CompanyDesc->CompanyCode    m Hours   + #Hour or Unit Accumulated or Accrued   0   ms Rate    Rate per Hour or Unit   0   mEmployerMatchAmount   ' Amount of Employer Contribution   0   mLVAL KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLengthDisplayControl DecimalPlaces  EmployeeCode   7 /Employee Code matches BenefitData->EmployeeCode    mkLastName    Employee Last Name    mm FirstName    Employee First Name    mo MiddleName    Employee Middle Name    mY City     City    m[ State     State    m_ Zipcode    Zipcode    mOHireDate     Hire Date  oSSNumber    Social Security Number    m SalaryHourly   ' S=Salary, H or = Hourly  "H"    m FullPartTime   / 'F or = Full time, P = Part Time  "F"    mpAddress1    Employee Address Line 1    mpAddress2    Employee Address Line 2    ms HourlySalary     Hourly salary   0   ms AnnualSalary     Annual Salary   0   m} HoursWorked     Hours worked in the year   0   m'LVAL3pp%k]B 2d@yOMd@CompanyDesc n_0x]D7@KKK???????* @\^e@\^e@AutoExec n_0x]D_@H<<<<<<<<<'  3\4d@/b_e@frmSummaryBenefitReport n_0x]DKKKKKKKKKK6  CjwV3d@-e@frmCompanyDesc n_0x]DBBBBBBBBBB-  C3d@]e@AccessLayout n_0x]D*@@XLL@@@@@@@+ @ѱ1d@ѱ1d@Scripts n_0x]D;;;;;;;;;;& ѱ1d@ѱ1d@Forms n_0x]D9999999999$ b2d@b2d@EmployeeDescEmployeeData n_0x]DLLLLLLLLLL7 ]2d@]2d@bJobTitle     Job Title    mf Comment     General Employee Comment   LVAL  $ $ $ $($H($x($` TX@H08`h8($($h`p `0 , i@ tu@ P R@@ "! X0 , @ @  6P`0 p @` PP P @@  X0  , @ @ 0`$  MEs "  ( 0JH `h p<x "    LVAL  " ( 08 @JX px < "   J  <  ( " 8HPp  Xx ( @"       ("8@ HP Xh   xp0`ZpZfrmBenefitDesc'w   B@ o"u !A@6"plh8&XZxZfrmCompanyDesc'   B@ (u& !A@6t(l@,ZZfrmEmployeeDesc'   B@ .u,x !A@6.`lXH2HZZfrmEmployeeData'   B@ 4u2 !A@64lXl(ZZ   B@ fitStau@PHfrmSummaryBenefitReport' B@u !A@6lxj(Z`ZPfrmHelp'   B@ luj !A@6llAttribute VB_Name = "Form_frmMainMenu" +LVAL7 Bas0{DF40D7C8-67E7-47E5-AE01-6209CCEC8A32} |Cre atablTrue ]PredeclaId"@ExposeFals @TemplateDeriv%Custom izD$Option Comp@ DTv  <licit P/3 Sub btnBene fit_Ck()n Erro@r GoTo_ " Dim stDocAs Sng LinkCritia ߀aEDesc"oCmd.Open6, Astف%Ex2+:C3A= rr5 MsPgBox>."riVResuRC EndC ZgnyZJ A*R?ZZD?Zn+Z/ (ZZEhoyee<-_-1^ZbcZ -eZ+-{- Z-Entr=[.. L7.?_.F. n.˶cmdSummary$Reporh@' O:~_c12DacNalwS%?rpoX B.nn*A* Q^u3tB! P_? o!{c fo e HelpO7|'7!|vNri!~!?7{%W /%>?//\q.(LVAL  x    2  HX "  +HA(    &0 @    `h@  H3 X  "@   ` .n Xx . <8  8  @   X  ( h H " h  x  P X p "   6 FO0 P h    p           ` "       B     .< 0;x P X h  "Y "\ "Y "\ "0Y8 "\ "pY@x " \  "Y "\LVAL  "Y( "\ "` HXh "0 T8 "0 L8 "  X( "Y@ "\ "`Yh "0\@8 "Yp "`\ph xp0l` v! (Find the record that matches the controlhh v.Propea0ha@ZP L:HnC@C@B.lh !f!l v!  v(~ L v(v LB@ C@ ! %. B@yCode= CompanyCode=' L' !fB@h !f!n (n  CompanyDesc  %.`(PH v !xP v!  v((h v acTex LB@/ !fB@h' ' CompanyCode=' L' !fB@h !f!l !f!n (n v !x1 v!  v( vX0a'L LB@ v !x v!  v(hX vHh L$ v !x v!  v(h v B@HlhP L$equery'LX !B@ CompanyDesc  %.XZ@0lZ(Find the record that matches the control !lode= v IfxahZ` v!LVAL  v(Xh vT v(n LB@ CompanyCode=' L' B@h v !x Clear previous data from form L$ L$'L v !x h  !!  %'v pA@ Read Record@ v!$ $  %! $Phh`hxppa cboCompanyCode.Requery)H'@ @L v!cboCompanyCode8@lA@ ( panyCo B@"'$Z@'$'$lh B@p H hx v !xs vcboC'$0u0  !! v!$ $  %! $ v  ,t ctl h  cbo'$ l B@<vbOKOnZ@'@ rstCompanyDesc.AddNew loc +rstCompanyDesc!CompanyCode = cboCompanyCodeA@6 rstCompanyDesc.Update B@h8 LB@ '@ '@A@Bl'v v(0  v !x Clear previous data from formhH v LB@'L '$'@ B@<'L x A@BA@(A@B l A@:A@B 0l $A@(h(h Save Current Record PSave$6 R Micr l Zx hplA@( 'v0 v! zh x!'  A@B v! z( Z*Zh+x Hl L$`$A@(hh A@Bh  l L$A@(h A@Bhp hh h pLVAL lA@P!l $ B@hA@B 0 (0 LB@0 H L$rsthX L$'LX@aA@BSave Current Record PSave$6 RhTi N!am NB@pperCahA@ $ @ L$$ts L )H B@ !x! Z@#  v + x $ f'ZP3Z$ v !xnefits  !! v!$ $  %! $AOh 000000 v#C:\Pr'huA@B  - During Form Load 8Error A@6  ! B@B8phux'Record currently locked by another user 8 Record LockedA@6 $ v v!cboCompanyCodeSave Current Record PSave$6 R $ Z`9 H( b(%l !\ "2!A@es&l  !R "!A@&l !T ""!A@'l !N "!A@nt(l !X "*!A@cr@(l` !P "!A@(l0 !V "&!A@(l) !^ "6!A@ l@)l !Z ".!A@)lp)l@ !N "! A@P*l !P "! A@*l !R "! A@+l !T ""! A@+l !V "&! A@0,lP`k\:#pNJ(bK<-yj[L=.                h  +  !                              !  ! B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o ! n_0x]D      B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o   n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D  n_0x]D B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  h hB)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o h n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D    B)k!N!H&\($_AV#jKV#jKV#jKj*"%Kөw Q@U16V#o  n_0x]D LVAL !X "*! A@,l  !Z ".! A@,l !\ "2! A@ P-l !^ "6! A@-l.l`8p.l.l !L "H!A@ !L "H! A@FLimitChange Me.txtPeriodStartDate, rstCompanyDesc!PeriodStartDate.Size"LRLimitKeyPress Me.txtPeriodStartDate, rstCompanyDesc!PeriodStartDate.Size, KeyAsciiBLimitChange Me.txtPeriodEndDate, rstCompanyDesc!PeriodEndDate.SizeNLimitKeyPress Me.txtPeriodEndDate, rstCompanyDesc!PeriodEndDate.Size, KeyAsciiA@ $ A@(hSave Current Record PSave$6 RA@(hh B@Blh3lSave Current Record PSave$6 Rh B@B v!cboCompanyCode v!btnExit v! jH v!cboCompanyCode v!btnExit v! jH@Attribute VB_Name = "Form_frmCompanyDesc" Bas0{151C923A-6B63-4F75-900E-0AB4DF31CDC5} |Creatabl!True ]Pr@edeclaId"ExposBeFals @TemplateDeriv%Cus`tomizD$O@ption ~re DTv PÀ%) rst As Reco rdsetGlobal LockBBoolean New&OriginalValues()Varian7Vlici-Sub btnCancel_Ck() 7K#r| . EnDWEnd  NDeleteG CC)ExitIf QS$ChaDngWThe@V @ MsgBox("Save C@urrenti"@, vbOKA, ")A GAWrite2!ABIf DoCmd.ClI!G4JCJ` JcboDCode_AfterUpdz+ A1 'ReadB%tx%ZAo,"lSetFocusc "C!7LimitP Me.,n!(.Siz@ $LEn$ @Nz( ) <> ""OOPPA `PaQaa(IS _GoC:$*n$$tt~$!h%#lKeyss(AAsciiIJgerૢXeXX, 6bc4On Errorzsu`Nex Vj6?T*, 0SR yA Load ! GoTo_FailedFGx=^Db.OpefnCOy("BŒ, dbDyn}t@1,0aDz= ReDim z@LControls.Couh- 1: o ;:LVAL t& " - Duri4ng mOnlyP!" &13j ac,*?_& @%adǃctl/@Field81Q"*"l0 @ Each QI&na  ' previous pa from f 1.B^{O" A $TypeacLabelrP(mandButt0815 '"0Y549  A{Trimmp r ;L;.l 'Fithe rr that ma tchese ^cC3#a+.Fi@ e=='. 2' otlC.NoM UU q)>3? 1(y Iu?=8= 0 S9H? U Str,v(Mid(u , 4)UpperCSylds()r70u`&w 9Yp6'4bUϟ_ :q^E3R!'<A ddU;'rbstCompan@yDesc!Code = cb"o 'r .Update F .RequeryHEnd If  Sub Pri vV LockRecord()$On Error Resume Next tTrim( @ReadN If Nz  <> "" ThenPGlobalNew.ueCLGoTo[__Failed( AddͅS PAF AbEdits?+= =WVA edFElsDClearFormÉŏ@xit A_:MsgBox " currently lby another user", vbOK`Only, Aed"-Fa,& &%H6 3`WriteDim ctl As Control FieldAIntegerC@ StringafB`/ Or< (`3 A`gql)#h)c%&EO: EachbIn Me.sCQ= 0. @lIbsunt - 1'x v(Mid('.Name, 4)(6hXH\8&dk&<'('H:NXX:8Nhh^ 6hXH(T\h$ xhXH(AH'X%x! Qxoh%"$ ,H:8]>(6LVAL <& xb ux<g?PH  ,  %88%       KeyEmployeeData.CompanyCode EmployeeDataEmployeeData.EmployeeCodeNamePH @J,e@hx @P 7 7 %7 87 EmployeeDesc @ ,d@ EmployeeData  @tVd@-~sq_cfrmSummaryBenefitReport~sq_ccboKeyEndingxP    88 EmployeeDesc7 %7 EmployeeData 8  %@  (`$@@P`pH  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  H  n_0x]Dv v xX 0,((s((((((((((((((((((((((((((((` H `0 8 EmployeeData  ~LVAL @ @ @ @ @ @ @ @ @ @((((((((( ( ( ( ( (( ( ( ( ( ((((((((((((( (!("(#($(%(& ('!(("()#*$*8 EmployeeDesc PrimaryKey   xH  PrimaryKey  8( PrimaryKey X   0 @ @ @ @-   [CompanyCode]",-,"  x[EmployeeDesc].[EmployeeCode]\ h,  [LastName]", "   [FirstName]4x@( ( ( ( `P 0@ `   2xeR?  lYF3{h<`&["\&v #EmployeeDesc.LastName- g#EmployeeDesc.EmployeeCode1 g# # "BenefitDesc "BenefitDesc.BenefitName/ g"BenefitDesc.BenefitCode/ g" " ! G! EmployeeDesc ![EmployeeDesc].[SSNumber]1 g![EmployeeDesc].[FirstName]2 g![EmployeeDesc].[LastName]1 g![EmployeeDesc].[EmployeeCode]5 g!  !    G CompanyDesc  ompanyDesc].[CompanyName]3 g ompanyDesc].[CompanyCode]3 g    (((Help.HelpCode)="MAIN"))2 'Help  Help.HelpMemo% g Help.HelpCode% g   GBenefitDesc enefitDesc].[BenefitName]3 genefitDesc].[BenefitCode]3 g   GEmployeeData EmployeeData.EmployeeCode1 gEmployeeData.CompanyCode0 g  EmployeeData   G   GEmployeeData EmployeeDesc EmployeeDescEmployeeData5@ )0$ LVAL <' xuc ux<g?uPuH uu ,  uu%u8uuuu8uuuu%u       KeyEmployeeData.CompanyCode EmployeeDataEmployeeData.EmployeeCodeNamePuHuuu @uQ,e@huxu @uPu u7 u7 %u7 8u7 EmployeeDesc uuu@u ,d@ EmployeeData uu u@utVd@8~sq_cfrmSummaryBenefitReport~sq_ccboKeyStartingxuPu uu uu uu 8uuuuu8u EmployeeDescu7 %u7 EmployeeData u8 u %u@ uuu u(u`u$@u@uPu`upuuH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH u uH uuuu n_0x]Duv uuuv xuXu u0,u(u(su(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u(u`u H u`u0u uuu8u EmployeeDatauu uu u}LVAL @ @ @ @ @ @ @ @ @ @ @ @((((((((( ( ( ( ( (( ( ( ( ( ((((((((((((( (!("(#($(%(& ('!(("()#*$*%*&*'*(*)***+** * * u8u EmployeeDesc PrimaryKeyuuu uuu uuu xuHuuuuuuuu uuu PrimaryKey uu 8uuuu(u PrimaryKey Xu u u 0u @ @ @ @- uuuuuuu u [CompanyCode]u",-," u xu[EmployeeDesc].[EmployeeCode]\uuuu uhu,uuuuuuu u [LastName]u", " u u [FirstName]4uuuxuu@uu(u u(u u(u u(u `uPuu uu0uu@u `u u u uLVAL <$ ` ug?H  }Ep8}E                EmployeeData.CompanyCode EmployeeDataEmployeeData.EmployeeCodeEmployeeData.BenefitCodeEmployeeData.HoursEmployeeData.Rate EmployeeData.EmployerMatchAmountEmployeeData.StartDatep PQ,e@0u}7 n7 87 loyet7 7 7  E7 EmployeeDatahXHPtVd@~sq_ffrmSummaryBenefitReport p      8p8 }7 n7 7 7 7 7 E7 u(s(EmployeeData }      Ep8 X P@`                             P(H H H H H H H |LVAL~\E6ㄋ0+#M @Q,e@Q,e@~sq_ffrmSummaryBenefitReport;;;;;;;;;;; Q,e@Q,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyStarting n_0x]Dc *@{{{occccccN `fJ,e@J,e@~sq_cfrmSummaryBenefitReport~sq_ccboKeyEnding n_0x]Db *@yyymaaaaaaL `I+e@I+e@~sq_rrptBenefitsSummaryMasterReport n_0x]D@*@ooocWWWWWWB `>c+e@|$+e@rptBenefitsSummaryMasterReport n_0x]D@ 07  ( XX h x     (  X    Dpx ( X    H EmployeeData 0 @ ` p   PrimaryKeyEmployeeDescEmployeeData EmployeeCode#CompanyDescEmployeeDataCompanyCode#BenefitDescEmployeeDataBenefitCode n_0x]Dv XXsXXXXXXXXXXXXXXXXXXXXXXXXXXXX  0xHEmployeeData PrimaryKeyHX00`HLVAL hXH\8&dk&<'('H:NXX:8Nhh^ 6hXH(T\h$ xhXH(0 p.  hK 8`F: N(:LN<<:lN\\^ 6\<^T h$ ` \<@KED'H%'X%h%x"$ x QD4x6XH 8 :8@x x (l@<x\`'XH @ xx  ''  l@#,*FH:h 0 /,x6 XH0 =, >,FX%x"$ `x ,x5X@$ 0 ,xDXH0 4 8 :p Qp[lxhOxWH:X]>8xW:(]>'xWd]>'6H\xWHXh]>85H\:X%x,fX%x xh2+p! QpoH8 8! 6H8A'8%p! QpoH%"$ ,:X]16H8\Rp! p Hp/H:X Hp! p XH8:(!`#_4 /p6H8_4 \k"Kp Qp[xxWH:X]>85H\ cX%x.vp_4 p "kpcxWH'8H #kvDX%p_4 p 0% ,& $ >F $ 1)p6 H8\7kvDX%p_4 p 0%QoH%x,p5HlxoXkv< vd* x- :48 / lhx8 pH8dK+x! QxohX X! 6hXLAH'X%x! Qxoh%"$ ,H:8]>(6hXH\  :KW _4 &x! Qxoh%:8%_4 (5h_4 dKL_4 TK _4  LVAL 8\3'('H:NXX:8Nhh 6hXH( 8\dd$ W xhXH(@n8:,'<%l! Qlo\L L"$ ,,:]> '6\L<,\Kl Ql[x.vl_4 l "klcxW\'L\< #kvD%l_4 l 0% ,&<, $ ,>F  $ 1)l6 \L< ,\8lxo%kvD%l_4 l 0% H&)l vd x_4 d 8l! l @l4 px4 l\L<, 0    Kt Qt[pxlOxWL:\]><xW:,]> 'xWd]>'6L\xWL\h]><5L\:\%x,f\%x xl%:\%! t! t Ht 8 :_4 `t! t @t 0 plx0 tL< 0 P!  0 `$  `Yx \`:d*%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x \`:d*%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx \`:d+%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x \`:d+%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx \`:d,%t_LVAL 4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x \`:d,%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx \`:d)%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x \`:d)%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx `\`:d0%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x `\`:d0%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx x\`:d1%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x x\`:d1%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X8$ 8$ 8$ 8$ `Yx H\`:d/%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x H\`:d/%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx \`:d-%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ LVAL xt`Xd\x \`:d-%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X`Yx 0\`:d.%t_4 t 0%` 4&l\+Vlx=XX ')t`xX(`$ xt`Xd\x 0\`:d.%t_4 t 0%` 4&l l\+Vlx=XX ( )t`xX(d$ xt`X|DDDDD @ @   XXPPTTLLhhlltt p!p"d#d$\%\&`'`__SRP_9rU $`  $)`$ $i`( $`, $`0$)`4$i`8$`<$(`@D&$) `D<$i `H $ `L$  `P$I `T$`X$`\$ ``(I`d#$`h(`l@&$ `p(I`t@&$`x(`|@&$ `(I`@&$`(`LVAL Ni_VBA_MODULEטcLZCnN5Ōt[GF߁NU<5:KY/x_.Q9<5:KY/cLZCnN54_@DH~LPTXp\`dhlptx|vz@ [LS S8L t><<<< <$<(<,<0<4<8<<LLLLLLLL<<<<<<<<<<<<<<<<<<<<<<<<<<<<<N0{BD749E8C-5B7F-47DF-B246-DF814E8ED855} ]>*\R2*#2d$*\Rffff*2a3e5d0c7d*\R1*#2b*\R0*#2*\R1*#56*\R1*#58*\R1*#6*\R1*#2a*\R1*#1c*\R1*#a*\R0*#11*\R0*#16*\R0*#10*\R0*#1*\R0*#d*\R1*#2e*\R1*#85*\R2*#28*\R1*#8e*\R1*#8f*\R2*#0 W($DD`VJpD@Ca e $ $ @ @ @ @ @ @ @((((((((( ( ( ( ( (( ( ( ( ( ((((((((((((( (!("(#($(%(& ('!(("()#*$*%*&*'*(*)***+** * * (**'*%*&* *!*"*#*$**(***+*,*-*)tyxvwuz~|}{      !!!~~~~~~~~~~~ @ @ @ @ @ @ @ @ @ @ @(**'*%*&* *!*"*#*$**(***+*,*-*)tyxvwuz~|}{      !!!!!!!!"""""##f###f#$f$f $f$f$f$f$f$f%f %f%f%f %f %f 7YC x4<VI"*1 ]8DfLB×L$Text33 &&48<@HpaI)LD> {Bf@txtEmployerContribH1JiۺONC"$txtEmployerMatchAmountReport_EmployeeSummaryStatementGnGH9b!v! ۧ{8O52 !)vuAOvjh3G3!6aC7LVAL < y u<g?Pyy yy @yy5yMyyy(y@yyyyyyy5yMy    2   2     EmployeeDesc.EmployeeCode EmployeeDescEmployeeDesc.LastNameEmployeeDesc.FirstNameEmployeeDesc.SSNumberyxy yHy XyY%e@pyy yqm yqm 5yqm MyqmEmployeeDescyyyyXy ,d@(~sq_cfrmEmployeeDesc~sq_cCboEmployeeCodey y@y Hyhy pyy  yy[EmployeeDesc].[EmployeeCode] y[EmployeeDesc].[LastName]Hy[EmployeeDesc].[FirstName]py[EmployeeDesc].[SSNumber]yyqm yqm 5yqm MyqmEmployeeDesc yy yy 5yy Myy yHypyy yyPy Xy@yPy`ypyy y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y y yyy yyyy yy yy yy  |y yyyptmy@ yp yy y y y0y @ y p y  y  y8yyyy@ yp y y yy EmployeeDesc (y 0y @yZipcodePrimaryKey EmployeeCodeXy n_0x]DyvLVALY `  H S FullPartTime P F HourlySalary AnnualSalary HoursWorked4TN"w%Ka 0Sˑ3VgmNsml` &&48<@HEA.xS2`+'-Ap:hϐuI}F ؗjHIr! 8prmCompanyCode = 'abc' AND prmEmployeeCode = '123456789' 5parameters(0) = 'abc' AND parameters(1) = '123456789'txtKeyStarting_GotFocustxtKeyEnding_EntertxtKeyEnding_GotFocus 2CompanyCode = 'abc' AND EmployeeCode = '123456789'Ì_sF0+DT/VSI;ˠForm_frmSummaryBenefitReporth%]xDV.Yd%o١\I19U{IVֳB̽@ cMaE8# cboKeyEnding FormHeader FormFootertxtKeyStarting txtKeyEndingcboKeyStartingcboKeyEnding_BeforeUpdatecboKeyEnding_ChangecboKeyStarting_ChangetxtKeyStarting_EnterW#2VFg]+G d48 +~~~~~~~~~~~~~~~~~~~~,-,~~~~~~~~~~~~~~~~~~~~ zzzzzzzzzz All Records  tblEmployeeDesc ALL RecordssKR8m4BZGh3iTCN)etm=fFa1ԒcboKeyStarting_AfterUpdate \ ~~~~~~~~~~t]ZJ<|/1KҏMcboKeyEnding_AfterUpdate First Employee Last EmployeeBAҜ KfȐFBM1)cmdPrint h `y@yPyyysyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy yyyyyEmployeeDesc PrimaryKeyyy`y@y`yyyyyyyyLVAL@&$ `(I`@&$`(`@&$  `(I !`@&$ "`( #`@&$ $`(I %`@&$ &`( '`@&pLVAL i_VBA_MODULEY)вǕF 9J9{J>M vB՛ڄuxT'eQvB՛ڄuвǕF 9JCLLG& \t`vdhlptrx|p,[LS S<4< <<L><8<<<N0{7BB039A8-4AC7-4D3E-BDF7-F5E50CA8C3DD}!?V>"*\Rffff*33e567351*\R0*#c*\R1*#8e*\R1*#8f*\R1*#24*\R1*#2d x@($D``HkpT   aV eae$ $ $@ $x8$x$$$@$p$ $ $es$8$h$$$$0$`LVAL i_VBA_PROJECTwMa^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#8.0#0#C:\Program Files\Microsoft Office\Office\MSACC8.OLB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll#Microsoft DAO 3.51 Object Library   ]>Q &Form_frmCompanyDesc e3e5d13d2*D (modUtilities d3e5d138f*D (8HReport_rptSummaryBenefitStatementSub b3e5d138c*DYG&&Form_frmBenefitDesc 23e5d138c*DG(hH(Form_frmEmployeeData c3e5d138c*Dw Form_frmMainMenu 13e5d138c*DP{8Form_frmSummaryBenefitReport 73e5d138c*DEE(d(Form_frmEmployeeDesc 93e5d138c*DHForm_frmHelp 43e5d138c*DeHLVAL sc.MultiplyHoursWithRateBenefitDesc.IsEarningCodeEmployeeDesc.EmployeeCode EmployeeDescEmployeeDesc.LastNameEmployeeDesc.FirstName-EmployeeDesc.MiddleNameEmployeeDesc.Address1Address1EmployeeDesc.Address2Address2EmployeeDesc.CityCityEmployeeDesc.StateStateEmployeeDesc.ZipcodeZipcodeEmployeeDesc.SSNumberEmployeeDesc.HireDateEmployeeDesc.SalaryHourlyEmployeeDesc.FullPartTimeEmployeeDesc.HourlySalaryEmployeeDesc.AnnualSalaryEmployeeDesc.HoursWorkedEmployeeDesc.JobTitleEmployeeDesc.CommentEmployeeData.Hours EmployeeDataEmployeeData.Rate EmployeeData.EmployerMatchAmountEmployeeData.StartDateTotale++pe* eXeX eTh-d@Lee eeGupeeuuHeXeMu ue@QmuNDe@QmNu e@Qm Em y0e@QmPrim K@e@Qm MHe@Qmu Pe@QmMu u e@Qmu$ e@QmHOO< e@QmHu T e@Qm ut e@QmPu  e@Qmmary  e@Qm (  e@QmOud e@QmP$ e@QmPrimKL e@QmfitDl e@QmKey e@QmMu e@Qm e@QmuI e@QmupP e@QmQu e@QmQ e@QmuQ e@Qmr- e@Qm M e@Qm! m e@QmQu"Q e@QmQu # e@QmKey$m e@Qm Pr%^r e@Qm& e@QmJu' e@Qm<(E e@Qm)HP e@Qm*EmployeeDataeee9eX etVd@ EmployeeDesceepe7eX e ,d@ BenefitDesc`#e"eP#e86eX epd@ CompanyDesc%e   $e%eX4eX eyOMd@Address1Address2CityStateZipcodeEmployeeDataQueryeeeXe e8e 8e@e PeHe xePe eXe e`e ehe  epe  exe  0 ee  H ee  LVAL h ee  ee ee ee ee  ee @ ee ` ee ee ee ee ee  ee ee H ee p ee ee ee  e e  e(e   e0e  e8e  @ e@e ` eHe ePe eXe e`e ehe epe  exe 8 ee P eee8ePexeeee e e0 eH eh e e e e e e@ e` e e e e e e eH ep e e e e e e e@ e` e e e e e e e8 eP eL e@QmuF& e@Qmu'u e@QmEk(uE e@Qmu7)EmployeeData ee  ee  ee E ee e e e8 e e@Qm3 e@Qmu e@Qm3u4 e@Qmu8e@Qm?u He@Qm?u?Xe@Qmu`e@Qmtipluhe@Qmte]u e@Qm, e@Qm@u e@Qm@u  - e@Qm M e@Qm 4@u!m e@Qm"[ e@Qm\@u#* e@Qm$u e@Qm@u%Address1Address2CityStateZipcodeEmployeeDesc eP"e eX"e e`"e  eh"e - ep"e U ex"e } e"e e"e e"e e"e e"e e"e - e"e M e"e m e"e e"e e"e e"e e e e e eH ep e e e e e e e@ e` e LVAL e e e{ e@QmCode m e@Qmsc e@Qm u$ e@QmDuZoL e@QmryKeEl e@Qmoden e@Qm DBenefitDesc ex$e e$e e$e $ e$e L e$e l e$e e$e e e e e@ e` e e e@QmuDe@Qm%e@Qm%e@Qm%e@Qm%e@Qm%e@Qm e@Qm$ e@QmsKuJ< e@QmKu T e@QmKu t e@QmKu  e@QmKu Address1Address2CityStateZipcodeCompanyDesc e'e De'e \e'e e'e e'e e'e e(e e(e $ e(e < e(e T e (e t e((e e0(ee8ePexeeee e e0 eH eh e e eKe8;e+ X e@eeePee8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(e e8(ee`epUeH=e.5eX4e eX4e eX4e eX4e eX4e eX4e eX4e eX4e eX4e eX4e  eX4e  eX4e  eX4e  $e86e e86e e86e $e86e $e86e"e86e"e86e e7e e7e e7e e7e e7e e7e LVAL (H(hx(;v%F4My)?AX,cQFb(CENL>zHCu ID̒Qiqh7G"Nz:eq{CSqzh3EDwaQ8)KjY%I_G"n7N AccessAnd as=DimCEachDElseGEndUFor_Goto`IfcIn|MeNotOrPrivateRedimSELECTSetSubThenToTrue VBAWin16~Win32Mac DAO benefitstatement7 Form_frmCompanyDescA _EvaluateForm FormHeader Detail2 CompanyNameCompanyName_LabelAddress1OAddress1_LabeloAddress2PAddress2_LabelCityD City_LabelState State_LabelYJZipcode; Zipcode_Label% PhoneNumberPhoneNumber_Label FaxNumberFaxNumber_Label FedNumberFedNumber_Label'PeriodStartDatePeriodStartDate_Label PeriodEndDate@PeriodEndDate_Labelu=Combo24&Company_Code_Label FormFooterT CompanyCode Form_Load{cboCompanyCodetxtCompanyName7 txtAddress1 txtAddress2txtCitytxtState txtZipcode.txtPhoneNumberX- txtFaxNumber1 txtFedNumbertxtPeriodStartDatetxtPeriodEndDateAxcboCompanyCode_AfterUpdateJRecordsetClone8 FindFirstM= cboDeptNumqNoMatch/3BookmarkC ALVAL fterUpdate _B_var_ForjLControlctlControlsK Properties+Itemzenable  ControlType acTextBox~ _B_var_IfPSetFocusValueK DeptRecordsetAddNewaDeptO txtNewDeptπDscrpB txtNewDscrpUpdateCompDescRecordset/ Recordset _B_var_Set OpenRecordset|_B_var_OpenRecordsetsP Workspace3_B_var_Workspace SecureSpaceNDBEngineQCreateWorkspacek5dbUseJetGSecureDbl: OpenDatabase` CurrentDbSSpace Db\ CompanyDesc]o dbOpenDynaset _B_var_CompanyDesc>QCollect _B_var_Error) ActiveControly Application*ParentEnabled۪RequerycboDeptNum_AfterUpdate~ NulcblCompanyCode|/_B_var_cblCompanyCodeNzu^RefreshRepaintcboCompanyCode_GotFocus2GotFocusK RecordSourceb CurrentRecord@Ri_B_var_R_B_var_BFields7rstCompanyDesc*FormFillF SetControls! ReadRecordcboCompanyDesc 3_B_var_cboCompanyDesc cboCompany^CTrim@ _B_var_TrimmTrecordField3Fiels 4Count0v _B_var_MidpToUpper_B_var_ToUpper1aX_B_var_aStrConvx' vbUpperCasek._B_var_StrConv{strngaNamerstCompanyDescrst _B_var_rst, RecordLockI LockRecord+ LockEditsEdit+GlobalRecordLocked7_B_var_GlobalRecordLockedB WriteRecordȳOnbE _B_var_OnbV| _B_var_On6LockRecord_Lock_Failed#msgQ _B_var_msgbrMsgBoxRvbOKOnly CancelRecord1 CancelUpdate5 NewRecordGlobalNewRecordC ClearFormcmdSave cmdSave_Click LVAL btnCancelIVbtnCancel_Clicke Form_Close[Click vbOKCancelx?vbOK%txtCity_BeforeUpdate/Cancel BeforeUpdate6 _B_var_ctl=ItemData  _B_var_LeftQNameThenbtnSave{ btnSave_ClickRdbLabel_B_var_dbLabel acLabel Label1, _B_var_Label16 Address1Label_B_var_Address1LabelhLabela _B_var_Label%CompanyNameLabel}acCommandButtonMd _B_var_field(DinŃ _B_var_Din@cboCompanyCode_Enter+Enter btnDelete6btnDelete_Click  DeleteRecordHDeletexErroQ[OriginalValues= _B_var_Redim RecordChangedLoclRecord_New_Failed}LockRecord_New_FailedForm_Load_FailedErro _B_var_ExitDoCmdƧacFormFormNameI_B_var_OriginalValues?Number-_B_var_LockRecord_Lock_Failed IIfzModule1b (LimitKeyPressԱiMaxLenKeyAscii#Err_LimitKeyPress5R SelLength vbKeyBack2BeepExit_LimitKeyPress:LogError&' Description  (LimitChangeCErr_LimitChangeF/ vbExclamationSelStartZExit_LimitChangeiG modUtilitieshktxtCompanyName_KeyPress4KeyPressqCZ ompanyNameSize_B_var_LogErrortxtAddress1_Change?txtAddress2_ChangetxtCity_ChangegtxtState_Change6utxtZipcode_ChangetxtPhoneNumber_ChangeDtxtFaxNumber_ChangeU@txtFedNumber_Change}ptxtPeriodStartDate_Change|txtPeriodEndDate_Change+txtCompanyName_ChangeLimitKeyPressedChange_B_var_LimitKeyPressedXtxtAddress1_KeyPressAztxtAddress2_KeyPressstxtCity_KeyPresstxtState_KeyPress)txtZipcode_KeyPresstxtPhoneNumber_KeyPressytxtFaxNumber_KeyPresstxtFedNumber_KeyPress!txtPeriodStartDate_KeyPress5LVAL txtPeriodEndDate_KeyPressBocboCompanyCode_KeyPress*cboCompanyCode_ChangeitxtCompanyCode Form_frmEmployeeDescdLastNameLastName_Label FirstNameFirstName_Label MiddleNameoMiddleName_Label(SSNumber|SSNumber_LabelHireDateHireDate_Label HourlySalaryHourlySalary_LabelH AnnualSalaryAnnualSalary_Label  HoursWorked\lHoursWorked_Label\Employee_Code_LabelXCboEmployeeCodeFull_Part_Time_LabelcboFullPartTime\Salary_Hourly_LabelcboSalaryHourlyn Form_KeyPressɔCboEmployeeCode_KeyPressrstEjDescGPrstEmployeeDesc EmployeeCodeLastName_KeyPressn txtLastNameFirstName_KeyPress: txtFirstNameMiddleName_KeyPress&  txtMiddleName<Address1_KeyPress$6Address2_KeyPress/ City_KeyPressYState_KeyPressZipcode_KeyPresscboSalaryHourly_KeyPresstxtSalaryHourly SalaryHourlyscboFullPartTime_KeyPress'etxtFullPartTime:W FullPartTime`HourlySalary_KeyPress.txtHourlySalary;AnnualSalary_KeyPressswtxtAnnualSalary\HoursWorked_KeyPress)txtHoursWorkedtxtHoursWorked_KeyPressPtxtLastName_KeyPresstxtMiddleName_KeyPress^txtAnnualSalary_KeyPresstxtFirstName_KeyPressftxtHourlySalary_KeyPressDSSNumber_KeyPress txtSSNumberHireDate_KeyPress txtHireDateCboEmployeeCode_ChangetxtLastName_ChangegtxtFirstName_ChangetxtMiddleName_Change^SSNumber_Change!HireDate_ChangeӅcboSalaryHourly_Change5cboFullPartTime_ChangetxtHourlySalary_ChangetxtAnnualSalary_ChangeitxtHoursWorked_ChangetxtSSNumber_Change(txtSSNumber_KeyPressXtxtHireDate_ChangemtxtHireDate_KeyPress=QKey_B_var_rstCompanyDesc^cboEmployeeCode_AfterUpdatetxtEmployeeNamecboEmployeeCode_EntercboEmployeeCode_GotFocustxtEmployeeLastNameAsc!uChrK~ txtLVAL FLastNameJcboSalaryHourly_NotInList?dNewDatax_ResponseacDataErrContinueD Form_frmBenefitDesc)rstBenefitDescj9cboBenefitCode_AfterUpdatetxtBeneditName9txtBenefitNameqcboBenefitCode_Change?cboBenefitCode! BenefitCodeNcboBenefitCode_EntercboBenefitCode_GotFocuscboBenefitCode_KeyPressQtxtBenefitName_Change BenefitNameŃtxtBenefitName_KeyPresstxtRateMultiplier_KeyPress. acCheckBoxq rstBenfitDescvbYesa?MultiplyHoursWithRatehvbNo% Form_frmEmployeeDataOrstEmployeeDataZcboExistingRecords_AfterUpdatecboExistingRecordsStmpCompanyCodeIcboCompanyCodtmpCompanyCodetmpEmployeeCode&txtHoursDcboBenefitNameVtmpBenefitCodeȉ ClearCodekItmpEmplobeeCode FieldMarkerDRecordOKcboExistingRecords_EntercboExistingRecords_GotFocuscboCompanyNamecboEmployeeName Form_frmMainMenubtnBenefit_ClickErr_btnBenefit_ClickA stDocNamezstLinkCriteriaYOpenFormExit_btnBenefit_ClickbtnCompany_ClickErr_btnCompany_Click٤Exit_btnCompany_Click8 btnEmployee_ClickErr_btnEmployee_ClickExit_btnEmployee_Click[btnDataEntry_ClickQErr_btnDataEntry_Click_Exit_btnDataEntry_Click; btnBenefit btnCompany( btnEmployee{  btnDataEntryBenefitName_LabelIBenefitShortDescription_LabelBenefitLongDescription_LabelNfRateMultiplier_Label$MultiplyHoursWithRate_LabelwtxtBenefitShortDescription=txtBenefitLongDescriptionvtxtRateMultiplierh[Benefit_Code_LabelchkMultiplyHoursWithRate-KLabel21fLabel23hchkIsEmployer