Standard ACE DBnb` Ugr@?~1y0̝cßFNf7ٜ(X+` {6߱)?)@)A)B)C)D)E)F)G)H)I)J)K)L)M)N)O11111 1 1 1 1  1! 1" 1# 1$ 1% 1D 1E 1F1M1N1O)))&) )!) )")#) )$)%)))')))()))))))*)))+))),!)!)!)-#)#)#).%) %)%)/') ') ')0+)5+)6+)72121215151519191 91 C1C1C1J1J1J1L1L1L1)))1)2))))3)4)))))))))v1c  @  ? ? ? ? ? ? ? ? ??]?]?]?]?]?K?K?K?K?K?Kv1@   *d _ Z  G q  0 n w*5aĉ<uuuu@@~sq_cfrmInput~sq_cqryOutput subform@@@~sq_cfrmInput~sq_cqryOutput subform+P @4MR2KeepLocal Tthhhhhhf ` @@frmInput+@2*>>>22222220 @ m_ @m_ @Input+b@888,,,,,,,* @ kN@kN@autoexec+22222222220  0@^X}@qryOutput+` @@|@ AXLL@4444442 `LD@D@MSysAccessXML+<<<<<<<<<<: J D@0j`@Input+@t888,,,,,,,* @l=#@l=#@Module1+0000000000. C[@[@ MSysNavPaneObjectIDs+JJJJJJJJJJH 9/@/@ MSysNavPaneGroupToObjects+TTTTTTTTTTR 5/@/@ MSysNavPaneGroups+DDDDDDDDDDB 2/@/@ MSysNavPaneGroupCategories+VVVVVVVVVVT Ĵ@Ĵ@DataAccessPages+@@@@@@@@@@> Ĵ@Ĵ@SysRel+.........., Ĵ@Ĵ@Modules+0000000000. Ĵ@Ĵ@Scripts+0000000000. Ĵ@Ĵ@Reports+0000000000. Ĵ@Ĵ@Forms+,,,,,,,,,,*  Ĵ@Ĵ@UserDefined+@*DDD88888886 @ Ĵ@Ĵ@SummaryInfo+@*DDD88888886 @+Ш@3@ MSysAccessStorage+DDDDDDDDDDB 'l@l@MSysComplexType_AttachmentTTTTTTTTTTT %l@l@MSysComplexType_TextHHHHHHHHHHH #l@l@MSysComplexType_DecimalNNNNNNNNNNN !l@l@MSysComplexType_GUIDHHHHHHHHHHH l@l@MSysComplexType_IEEEDoubleTTTTTTTTTTT l@l@MSysComplexType_IEEESingleTTTTTTTTTTT l@l@MSysComplexType_LongHHHHHHHHHHH l@l@MSysComplexType_ShortJJJJJJJJJJJ l@l@MSysComplexType_UnsignedByteXXXXXXXXXXX l@l@MSysComplexColumnsDDDDDDDDDDD l@l@MSysRelationships)DDDDDDDDDDB l@l@MSysQueries)88888888886 l@l@MSysACEs)22222222220 l@l@MSysObjects)88888888886 l@On=`@MSysDb+5@:::......., @l@l@Relationships)<<<<<<<<<<: l@l@Databases)44444444442 l@l@Tables).........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@    fYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYN  Y  ValuedvfYN""Y  ValuedvfYN$$Y ValuedvfYN&& Y  ValuedvaYN(( Y Y  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1bP{hUB/ q  0 B T feR?, mZ  p]J7`M:'[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + . + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + . + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + . + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + . + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + . + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + + + ++ +[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p ++ + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p '+ %+ #+ !+ + + + + + + + + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p T[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p '[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p %[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p #[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p ![_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p T[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + + + + . + . + + + '+ %+ #+ !+ + + + + + + +  LVAL@PPERuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTagsTextAlignAggregateType  "  UzmB}M~dg M@Inputm-"GD9{8zmB}M~dginputW^SCa/ll;zmB}M~dgraw_macro~XXEwzmB}M~dgformatted_macro   zmB}M~dg           input     . &Not Like "*[!0-9]*"T LPlease enter only numeric values (0-9) m     MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTagsTextAlignAggregateType  "  UzmB}M~dg M@Inputm-"GD9{8zmB}M~dginputW^SCa/ll;zmB}M~dgraw_macro~XXEwzmB}M~dgformatted_macro   zmB}M~dg           input     . &Not Like "*[!0-9]*"T LPlease enter only numeric values (0-9) m     raw_macro      m     $formatted_macro      m     MR2 GUIDNameMap  VDisplayAllViewsOnSharePointSite!  MR20 Title AuthorCompany| azalea$ Megan Willesen8 0Free State Data ServicesV Y>N,,Y 0eY Y  Y  Y ,FY FY DateCreateDateUpdateIdLvNameParentIdTypeF,F,F,-,F,F,F,.,F,F,F,/,FYYYIdParentIdIdParentIdName,,v1b@ @@G @9q2h@9q2 + @ @ @ @ @ @ @ @00000000 0 0  0  0  0 0 0000 0!0 #0"*0)-0,.0-201504605706807908:09;0:<0;=0<>0=C0BS,S-[[[[[[[ _ _0^#H_U.U/U0U1U2V V!V"V#V$V%V&V'V-V.V.V+@@@@@  @@@@ M`OLJik0Mokmd`Uidofk0 OJmJJMMQkkfJUQk0 OJmJLJkQk0 Sdi`k0Y`QukfQMk0`dOo^Qk0`kvkJMMQkkkmdiJUQ+iddm0fidfOJmJ0iQfdimk0kMiYfmk0qLJ0`kvkJMMQkkkmdiJUQ+kMiJmMW06078U.OYiOJmJ0;OYiOJmJMdfvS-fidfOJmJ0BfidfOJmJMdfvS,6[OYiOJmJ[fidfOJmJ[60OYiOJmJ0"fidfOJmJ0)604OYiOJmJ06OYiOJmJMdfv^#fidfOJmJ0=fidfOJmJMdfv_JMQkkqLJOJmJV qLJfid[QMm0 60  OYiOJmJ0 L^dL0 fid[QMmV'fid[QMms`V&qLJ0++kif+801++kif+:0,++kif+<0-++kif+>_++kif+@_+qLJ+fid[QMmV$OYiV%WiQkMvMxUmkkSQqssvuu^^mSMmJUV#bhQJsMSJ^\bJbOLWoS[oOUx`^vJ^V"qxbvfq^xos\hfOSM^vYkW\vuUsb`V! fidfOJmJ0 5L^dL058L^dL088L^dLOQ^mJ0:8fidfOJmJ0<8mvfQYbSd09L^dL[L^dLOQ^mJ[fidfOJmJ[mvfQYbSd[L^dLU/L^dLOQ^mJU1fidfOJmJU2mvfQYbSdU0U2mvfQYbSdU0mvfQYbSdMdfvV.mvfQYbSdMdfvV.VmvfQYbSdMdfvV +@@@@@@@@@@@@@@@@0000000 0 0  0 0 00807<0;C0BS,S-U.[[[ 0#0"*0)504706>0=0^#H_0V   0  0  0 0V&V'-0,.0-201 _ _V!V"V#V$V% !0 560589088:098;0:8=0<[[[[U/U0U1U2V-V.V.V +K@c$ o q ( =   y y ʸ WȗLǴij7EEQEEDKD DÞ]BW 7BlobCopy8R(@R(@..&?TypeInfoCopy?=@=@66.&"?IBlobDeltaCopy?=@=@880($ ?BlobCopy?=@=@..&?TypeInfoCopy?(@(@66.&"?FBlobDeltaCopy?(@(@880($ ?BlobCopy?r@r@..&?yPropData?@@..&?PropData@@..&?BBlobDelta?@.TZ@00( ?wTypeInfo?@@..&?vBlob?@@&&??1@.TZ@  ?PropDatay` @y` @..&?PropData8y` @y` @..&?oDirDatay` @y` @..&?;BlobDelta8m_ @I`@00( ?nTypeInfo8m_ @m_ @..&?mBlob8m_ @m_ @&&?80m_ @I`@  ?DirDatakN@kN@..&?fBlob5kN@kN@&&?50kN@b`@  ?4PROJECT*6\h@*6\h@]@X8,$3PROJECTwm*6\h@*6\h@Module1Module1V0( 2__SRP_1*6\h@t`@@QF8,$1__SRP_0*6\h@$߿@x @8,$0dir*6\h@*6\h@F@X0$ /_VBA_PROJECT*6\h@*6\h@r @YB6.&".__SRP_3*6\h@t`@1@'8,$-__SRP_2*6\h@t`@$ak#8,$,VZNYPVLZUWKQPDFCLYISHKYXGWNM*6\h@*6\h@!U)bVNFB>+AcessVBAData*6\h@_\h@ N6.&"*PropDatab@b@ 0CB0I.&#DirData}=#@}=#@Module1R.&!PropData }=#@}=#@ G.& 0l=#@}=#@  ?VBA8 @M`@$$ ?VBAProject8 @M`@22*"?DirData p@p@MSysDbP.&ImExSpecsĴ@Ĵ@00( ?CustomGroupsĴ@Ĵ@66.&"? Blob Ĵ@Ĵ@&&? 0 Ĵ@Ĵ@  ? DatabasesXQ@p@00( ? DataAccessPagesXQ@XQ@<<4,($? CmdbarsXQ@XQ@,,$?VBAXQ@`@$$ ?ScriptsXQ@L@,,$?ModulesXQ@b@,,$?ReportsXQ@龩@,,$?FormsXQ@s`@(( ?PropDataXQ@!@ @ijP.&MSysAccessStorage_SCRATCHXQ@XQ@PPH@<8?MSysAccessStorage_ROOTXQ@!@ @JJB:62?PP=* y f S ? ,  |  h U B ɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɸɥ .   ~ +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%0 +  +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%0 + + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p  +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p  +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p  +  +  [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p  + L+ L[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p L+ J+ J[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p J+ + [_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p + C+ CT[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p C+ 9+ 9T[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p 9+ 5+ 5T[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p 5+ 2+ 2T[_ij/"5 >.5Zd)2Xzx6+ )zހ$y*}FĞkhw;q%00v'GQ1p 2+ . + >YN33 Y Y eY  Y Y yY Y  Filter FlagsIdNamePosition SelectedObjectIDType,,34,YIdv1 @ @2=== RY N66 Y Y Y  Y Y sY Y  FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition,,67,,,68,YYGroupCategoryIDIdv1@@ 5 @>>>>>>>> > >  >  >  5 @>> >>>>>>>>> >  Y N:: Y Y Y Y ` Y  vY Y  FlagsGroupIDIconIdNameObjectIDPosition,,:;,މ,,:<,ހYYGroupIDIdv1 9 @ BBBBBBBB B B  B  B  B  9 @ BBBB B B B  B B B B B Bq2OOCustomg e] e 5 yLO""  ] } J }  } Custom Group 162.*&" } } } } } } } }. Ϧ`)dALCqryOutpALCqryOutput### LC [qryOutput].[Formatted Output]=LC [qryOutput].[Formatted Output]=LC [qryOutput].[Formatted Output]= gALC  Formatt Formatt Formatted Output Formatted Output Formatted OutputAzale Formatted OutputAzalea_UPC olFormatted Outputj@=11 o olInput.description0 g olInput.supplemental1 g ol Input.Input* g rolInput  ol G ol G l   G LVALrGD=   &?0 x <   8X Hh    input.input inputraw_outputformat_output0@  +Q Qx 0@qryOutput   Input.inputQ input 0 input input input input   8HXhxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx  #4x  "z  0S@  @     4 @  , $P  T `  d  5`Azalea_UPC_A    @ [Input]![input] (   (  $ $H  L X  \  5`Azalea_UPC_A    @ [Input]![input]      x  input8v 8(q xinput#488#4px Z LVALЄ ά)0 Inputά)0 Input 9 yLk>   w  w  w  w  w  wJ w  w  w]  w  wJ  w?  wRY'l@NDDY  Y Y  IdNameTypedvAJ ϮϔH3Ήe345435grty5rt SINANTRAGREATSinatra's Greatest Hits CD- 432434329874Cadillac bicycle" 493827263821Office lamp Testing AZALEA 9781559391979Test item5169597815593919795169592#y123456789010069277100000869277100000869277100000 LVALVЙϙϙϙϙϙϙϙϙ { { rU (`anID="{862A67AB-5422-4C19-9B9B-A7FD48480A8C}" Module=Module1 Name="azalea" HelpContextID="0" VersionCompatible32="393222000" CMG="1614F15731AFD9B3D9B3D9B3D9B3" DPB="C2C0250BD00CD00CD0" GC="6E6C89FF990744084408BB" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 870, 541, Z am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\STDOLE2.TLB#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object LibraryDM8VZNYPVLZUWKQPDFCLYISHKYXGWNM034d44a0dcModule1[M(rU  UPCnumberp UPCnumber     Q (  8ͬ(V9Fߜ0PageHeaderS33 Input0-1033 Input0-10 Notes0-10Module1Module1Form_InputForm_InputForm_NotesForm_NotesrU  ISBNnumberPrice theStringi   Q (  8  H\ͬ(V9Fߜ0PageHeaderSection0Detail0PageFooterSectionm0Text0m0Inputm0 Formatted_OutputFormatted Outputm0 DescriptionrU d$` n LVALrGD/B  `?0/ //x//V < /// /// /8/X/ /H/h/    input.input inputraw_outputformat_output///// 1@ ///#+/@/@///x //0@qryOutput/ // // //Input.input/// /@Ђ input /0// input input input input // / /8/H/X/h/x/x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//x//// / #4/x / "/z  //0//@ / @ /  /  /4 /@ / , /$P / T /` / /d / 5`Azalea_UPC_A / / / @ /[Input]![input] /( / / /( / $ /$H / L /X / /\ / 5`Azalea_UPC_A / / / @ /[Input]![input] / / / / / /x / input8//v 8/(////q///////////////////////////// x/////input#4//8//8/#4///p///x / LVALrGD  ]  7?   H     <@  4 P   ( P    p   4         Input.Input Input input#Input.supplemental!Input.descriptionFormatted Outputx p H X x ^X}@   x 3+  0qZIn4 0qZmayP 0qZ#4 h    x oq@qryOutput   H  P  ( X  P `   ( P  0qZqK8+8  0qZK884 0qZK88input Input  X   `  4 h   ( Input  8 @   x 8 H X h x                                                                 #4   "#4   "#4    z X ( h (tZ P          P          8    P       $    ` $ 5`Azalea_ISBN13 d p  t P  [Input]![input]     ,+[Input]![supplemental]    0  x (     Input  PrimaryKey  v     8 8q 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8    (  x   InputPrimaryKey#4   8  #4 8 (  ( `   LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden.Input.input _ format_output  3}Ja-kn % Draw_output  t0t0  <       paEI'8        UzmB}M~dg0@Inputt0t0raw_output3}Ja-knformat_output/T)b^Me'(zmB}M~dginput <YNKK Y  Y  Y  inputsupplementaldescription%%Kg.&YPrimaryKeyvv1 S YNMMY f Y Y  Y  Y Ƃ Y 6Id LValueObjectGuidObjectNameProperty Value,6,6,MN6,6,6,MO6,6,6,MP6,YYYId$ObjectGuidProperty$ObjectNamePropertyMHv1b@ L L LC"h=}0 k " e  p M *  j 3 m > LMSysAccessXML$ JInputModule1CMSysNavPaneObjectIDs2.9MSysNavPaneGroupToObjects<85MSysNavPaneGroups,(2MSysNavPaneGroupCategories>:DataAccessPages($SysRelModulesScriptsReportsFormsUserDefined SummaryInfo +MSysAccessStorage,('MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables LVALrGD  ] ` 7?   H     <@  4 P   ( P    p   4         Input.Input Input input#Input.supplemental!Input.descriptionFormatted Outputx p H X x ^X}@   x 3+  0qZIn4 0qZmayP 0qZ#4 h   x /`@qryOutput   H  P  ( X  P `   ( P  0qZq 8+8  0qZ 884 0qZ 88input Input  X   `  4 h   ( Input  8 @  x 8 H X h x                                                                #4  "#4  "#4   z X ( h (tZ P     P       8 P   $    ` $ 5`Azalea_ISBN13 d p  t P [Input]![input]    ,+[Input]![supplemental]   0 x (   Input  PrimaryKey  v     8 8 q 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8    (  x   InputPrimaryKey#4   8  #4 8 (  ( `  +8r'ΝR }4̨_ˊIʵt)ɟT 6Ǫa ƌKƷv+ġV ÃC:C¸m$O[BlobCopy8Ib@Ib@..&?BlobDeltaCopy8W=@W=@880($ ?jBlobCopy8W=@W=@..&?pTypeInfoCopy8W4@W4@66.&"?BlobDeltaCopy8W4@W4@880($ ?eBlobCopy8W4@W4@..&?^TypeInfoCopy8ט3@ט3@66.&"?BlobDeltaCopy8t3@t3@880($ ?\BlobCopy8t3@t3@..&?BlobCopy5jltd@jltd@..&?DirDataCopy Hc@ Hc@66.&"?PropDataCopy Hc@ Hc@66.&"?BlobCopy5}da@}da@..&?TypeInfoCopy8^@^@66.&"?BlobDeltaCopy8(^@(^@880($ ?BlobCopy8(^@(^@..&?TypeInfoCopy8^@^@66.&"?BlobDeltaCopy8cE ^@cE ^@880($ ?BlobCopy8cE ^@cE ^@..&?TypeInfoCopy?SZ@SZ@66.&"?}BlobDeltaCopy?SZ@SZ@880($ ?BlobCopy?SZ@SZ@..&?TypeInfoCopy8YX@YX@66.&"?zBlobDeltaCopy8wX@wX@880($ ?BlobCopy8wX@wX@..&?dTypeInfoCopy8AW@AW@66.&"?wBlobDeltaCopy87AW@7AW@880($ ?[BlobCopy87AW@7AW@..&?TypeInfoCopy8mV@mV@66.&"?tBlobDeltaCopy8 lV@ lV@880($ ?BlobCopy8 lV@ lV@..&?{TypeInfoCopy?D,uS@D,uS@66.&"?qBlobDeltaCopy?D,uS@D,uS@880($ ?zBlobCopy?D,uS@D,uS@..&?TypeInfoCopy?N|zR@N|zR@66.&"?nBlobDeltaCopy?zR@zR@880($ ?\BlobCopy?zR@zR@..&?xTypeInfoCopy?PP@PP@66.&"?kBlobDeltaCopy?P@P@880($ ?uBlobCopy?P@P@..&?TypeInfoCopy8 O@ O@66.&"?hBlobDeltaCopy8!; O@!; O@880($ ?BlobCopy8!; O@!; O@..&?}TypeInfoCopy8[uH@[uH@66.&"?eBlobDeltaCopy8&0uH@&0uH@880($ ?|BlobCopy8&0uH@&0uH@..&?rTypeInfoCopy8dhB@dhB@66.&"?bBlobDeltaCopy8GhB@GhB@880($ ?eBlobCopy8GhB@GhB@..&?jTypeInfoCopy8`N@@`N@@66.&"?_BlobDeltaCopy8N@@N@@880($ ?iBlobCopy8N@@N@@..&?bTypeInfoCopy8|A=@|A=@66.&"?\BlobDeltaCopy88=@8=@880($ ?`BlobCopy8=@=@..&?XBlobCopy?XG3@XG3@%Hp6):.& LVALrGD ]  7? H  <@ 4P(Pp 4       Input.Input Input input#Input.supplemental!Input.descriptionFormatted OutputxpHXx^X}@ x3+ 0qZIn40qZmayP0qZ#4h x/`@qryOutput HP (X P`(P 0qZ q 8+8 0qZ 8840qZ 88input Input X ` 4h( Input 8@  x8HXhx #4  "#4  "#4  z X(h(tZP      P      8   P    $  `$ 5`Azalea_ISBN13 dp t P [Input]![input]   ,+[Input]![supplemental] 0 x(   Input PrimaryKeyv 88q8888888888888888888888888888 (x InputPrimaryKey#4 8#48((` %+7h)ΝT6dˡb!ʍLʸw,ȢWǂ9ƭd#ŏNźy.äYBcB AS HRESCYCZGTSSFEVWWYXXLLTFCTAGu5t`@u5t`@VVNFB>?~TypeInfoCopys`@s`@66.&"?BlobDeltaCopys`@s`@880($ ?}BlobCopys`@s`@..&?yPropDataN1jp`@N1jp`@..&?BlobDeltaN1jp`@K&`@00( ?xTypeInfoN1jp`@N1jp`@..&?wBlobN1jp`@N1jp`@&&?1N1jp`@K&`@  ?YTypeInfoCopy8_:`@_:`@66.&"?BlobDeltaCopy8:`@:`@880($ ?WBlobCopy8:`@:`@..&?dTypeInfoCopy81/`@1/`@66.&"?BlobDeltaCopy81/`@1/`@880($ ?\BlobCopy81/`@1/`@..&?\TypeInfoCopy89޳@9޳@66.&"?BlobDeltaCopy8xݳ@xݳ@880($ ?ZBlobCopy8xݳ@xݳ@..&?TypeInfoCopyad@ad@66.&"?}BlobDeltaCopy,d@,d@880($ ?BlobCopy,d@,d@..&?TypeInfoCopyߐ@ߐ@66.&"?zBlobDeltaCopyߐ@ߐ@880($ ?BlobCopyߐ@ߐ@..&?TypeInfoCopy8}'@}'@66.&"?wBlobDeltaCopy8o'@o'@880($ ?BlobCopy8o'@o'@..&? TypeInfoCopy8; @; @66.&"?tBlobDeltaCopy8; @; @880($ ?BlobCopy8; @; @..&?TypeInfoCopy8@@66.&"?qBlobDeltaCopy8Θ@Θ@880($ ?BlobCopy8Θ@Θ@..&?TypeInfoCopy8@@66.&"?nBlobDeltaCopy8X@X@880($ ?BlobCopy8X@X@..&?TypeInfoCopy8>}@>}@66.&"?kBlobDeltaCopy8>}@>}@880($ ?BlobCopy8>}@>}@..&?PROJECTo{@o{@,,$?PROJECTwmo{@o{@00( ?diro{@o{@$$ ?_VBA_PROJECTo{@o{@66.&"?NQEAWCFALKNANDBHUFJUDGZMLYALo{@o{@VVNFB>?VZNYPVLZUWKQPDFCLYISHKYXGWNMo{@o{@VVNFB>?AcessVBADatao{@o{@66.&"?TypeInfoCopy8xf@xf@66.&"?aBlobDeltaCopy8~f@~f@880($ ?BlobCopy8~f@~f@..&?TypeInfoCopy8ɮe@ɮe@66.&"?^BlobDeltaCopy8ɮe@ɮe@880($ ?BlobCopy8ɮe@ɮe@..&?kPROJECTc@c@,,$?jPROJECTwmc@c@00( ?Y_VBA_PROJECTc@c@O @TB6.&"+/"΢_ ͔K Ϳv-[ʚOʽTȂ9ǀAǵl#FEQEDDhD%DCdDTypeInfoCopyK&`@K&`@66.&"?BlobDeltaCopyK&`@K&`@880($ ?BlobCopy`%`@`%`@..&?TypeInfoCopy8I`@I`@66.&"?BlobDeltaCopy8I`@I`@880($ ?BlobCopy8I`@I`@..&?BlobCopy5b`@b`@..&?PROJECTM`@M`@,,$?PROJECTwmM`@M`@00( ?dirM`@M`@$$ ?_VBA_PROJECTM`@M`@66.&"?HRESCYCZGTSSFEVWWYXXLLTFCTAGM`@M`@VVNFB>?NQEAWCFALKNANDBHUFJUDGZMLYALM`@M`@VVNFB>?VZNYPVLZUWKQPDFCLYISHKYXGWNMM`@M`@VVNFB>?AcessVBADataM`@M`@66.&"?TypeInfoCopy@`@@`@66.&"?BlobDeltaCopy@`@@`@880($ ?BlobCopy@`@@`@..&?PROJECTt`@t`@,,$?PROJECTwmt`@t`@00( ?__SRP_0t`@t`@,,$?dirt`@t`@$$ ?_VBA_PROJECTt`@t`@66.&"?HRESCYCZGTSSFEVWWYXXLLTFCTAGt`@t`@VVNFB>?NQEAWCFALKNANDBHUFJUDGZMLYALt`@t`@VVNFB>?VZNYPVLZUWKQPDFCLYISHKYXGWNMt`@t`@VVNFB>?AcessVBADatat`@t`@66.&"?TypeInfoCopyxt`@xt`@66.&"?BlobDeltaCopyxt`@xt`@880($ ?BlobCopyxt`@xt`@..&?idirc@c@$$ ?U_VBA_PROJECTc@c@66.&"?hNQEAWCFALKNANDBHUFJUDGZMLYALc@c@VVNFB>?gVZNYPVLZUWKQPDFCLYISHKYXGWNMYcc@Ycc@VVNFB>?qAcessVBADataYcc@Ycc@66.&"?TypeInfoCopyh\@h\@66.&"?TBlobDeltaCopyh\@h\@880($ ?BlobCopyh\@h\@..&?TypeInfoCopy8RV@RV@66.&"?QBlobDeltaCopy8V@V@880($ ?BlobCopy8V@V@..&?aPROJECTP@P@,,$?`PROJECTwmP@P@00( ?YdirP@P@$$ ?\_VBA_PROJECTP@P@66.&"?XNQEAWCFALKNANDBHUFJUDGZMLYALP@P@VVNFB>?JVZNYPVLZUWKQPDFCLYISHKYXGWNMP@P@zTFbVNFB>+BlobCopy8:`@:`@{5jnb#:.& J9781559391979Test item51695#+TypeInfoCopy8_:`@_:`@J@%B6.&"LVALnb#` ^ _u289 =5B>a)b*c*eHgh6iTj1k %l6@x FGU= NyLE`y  UpaEI'8^X}@+qryOutput(WfB }Tt.Gad@rptBarcodes/T)b^Me'(paEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`1/`@Inputr;@j)paEI'8supplemental  qryOutput Barcode Input @UPCHalfNarrow 8hhhhD\ h rother DCP-9045CDN Printer (CS odLetterPRIV ''''0\KhCFF0EBDAStandard 0 isMy Documents\*.pdf045CDN Printer (C1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'  2+8r'ΝR }4̨_ˊIʵt)ɭ tI3IHnH-ǙXGƃBŮm"ĘMx/£ZDTypeInfoCopy8J@J@66.&"?BlobDeltaCopy8ޤ@ޤ@880($ ?wBlobCopy8ޤ@ޤ@..&?TypeInfoCopy8=@=@66.&"?BlobDeltaCopy8=@=@880($ ?BlobCopy8=@=@..&?TypeInfoCopy8*@@*@@66.&"?BlobDeltaCopy8T?@T?@880($ ?BlobCopy8T?@T?@..&?TypeInfoCopy8t@t@66.&"?BlobDeltaCopy86@6@880($ ?BlobCopy86@6@..&?vTypeInfoCopy8P @P @66.&"?BlobDeltaCopy8J @J @880($ ?lBlobCopy8J @J @..&?TypeInfoCopy8M@M@66.&"?BlobDeltaCopy8@@@@880($ ?BlobCopy8@@@@..&?TypeInfoCopyl@l@66.&"?BlobDeltaCopy7A@7A@880($ ?BlobCopy7A@7A@..&?TypeInfoCopyTi@Ti@66.&"?BlobDeltaCopyTi@Ti@880($ ?BlobCopyTi@Ti@..&?uPropData龩@龩@..&?TypeInfoCopy龩@龩@66.&"?BlobDeltaCopy_龩@龩@880($ ?BlobCopy_龩@_龩@..&?PropData辩@辩@..&?DirData辩@辩@..&?BlobDelta辩@ad@00( ?TypeInfo辩@辩@..&?Blob辩@辩@&&?0辩@ad@  ?iTypeInfoCopy8ھ@ھ@66.&"?BlobDeltaCopy8Fھ@Fھ@880($ ?`BlobCopy8Fھ@Fھ@..&?TypeInfoCopy8Ӿ@Ӿ@66.&"?BlobDeltaCopy8i$Ӿ@i$Ӿ@880($ ?BlobCopy8i$Ӿ@i$Ӿ@..&?TypeInfoCopy8@@66.&"?BlobDeltaCopy8!@!@880($ ?}BlobCopy8!@!@..&?tTypeInfoCopy8]q@]q@66.&"?BlobDeltaCopy8 @ @880($ ?sBlobCopy8 @ @..&?TypeInfoCopy8G;@G;@66.&"?BlobDeltaCopy8p%;@p%;@880($ ?BlobCopy8p%;@p%;@..&?TypeInfoCopy8 n@ n@66.&"?BlobDeltaCopy8in@in@880($ ?BlobCopy8in@in@..&?zTypeInfoCopy8$e@$e@66.&"?BlobDeltaCopy8Xf$e@Xf$e@880($ ?yBlobCopy8Xf$e@Xf$e@..&?BlobCopy8Ib@Ib@{(idIV :.&+BlobCopy81/`@1/`@{5TG`#:.&2׏ m1+7z;ίf%͑H̖_˜Q˿V ɓT6DŽM Ƙ_FŔIŷNÜe"¢W9CBlobDeltaCopy8=@=@880($ ?BlobCopy8=@=@..&?TypeInfoCopy8鿩@鿩@66.&"?@BlobDeltaCopy8`鿩@`鿩@880($ ?BlobCopy8`鿩@`鿩@..&?TypeInfoCopy8&俩@&俩@66.&"?=BlobDeltaCopy8俩@俩@880($ ?BlobCopy8俩@俩@..&?PROJECT$߿@$߿@,,$?PROJECTwm$߿@$߿@00( ?dir$߿@$߿@$$ ?_VBA_PROJECT$߿@$߿@66.&"?NQEAWCFALKNANDBHUFJUDGZMLYAL$߿@$߿@VVNFB>?VZNYPVLZUWKQPDFCLYISHKYXGWNM$߿@$߿@VVNFB>?AcessVBAData$߿@$߿@66.&"?TypeInfoCopy8$߿@$߿@66.&"?3BlobDeltaCopy8|߿@|߿@880($ ?BlobCopy8|߿@|߿@..&?PropData.Lۿ@Lۿ@..&?DirDataCopyLۿ@Lۿ@66.&"?Blob. ٿ@ ٿ@&&?.1 ٿ@Lۿ@  ?PROJECTm@m@,,$?PROJECTwmm@m@00( ?dir4m@4m@$$ ?_VBA_PROJECT4m@4m@66.&"?NQEAWCFALKNANDBHUFJUDGZMLYAL4m@4m@VVNFB>?AcessVBAData4m@4m@66.&"?TypeInfoCopy84m@4m@66.&"?&BlobDeltaCopy8bl@bl@880($ ?BlobCopy8bl@bl@..&?PROJECT/3@/3@,,$?PROJECTwm/3@/3@00( ?dir/3@/3@$$ ?_VBA_PROJECT/3@/3@66.&"?|NQEAWCFALKNANDBHUFJUDGZMLYAL/3@/3@VVNFB>?AcessVBAData/3@/3@66.&"?TypeInfoCopy8@@66.&"?BlobDeltaCopy8Wl@Wl@880($ ?BlobCopy8Wl@Wl@..&?PROJECTHֹ@Hֹ@,,$?PROJECTwmr@r@00( ?~dirr@r@$$ ?_VBA_PROJECTr@r@66.&"?}NQEAWCFALKNANDBHUFJUDGZMLYALr@r@VVNFB>?AcessVBADatar@r@66.&"?TypeInfoCopy8r@r@66.&"?BlobDeltaCopy8<@<@880($ ?BlobCopy8<@<@..&?TypeInfoCopy8xұ@xұ@66.&"?BlobDeltaCopy8Jұ@Jұ@880($ ?BlobCopy8Jұ@Jұ@..&?lPROJECT@@,,$?hPROJECTwm@@00( ? dir@CU@@\0$ t+JΠU Z̗X˃:ʒJSJ ɊIȵlH#ȺVVZNYPVLZUWKQPDFCLYISHKYXGWNMP@P@VVNFB>?bAcessVBADataP@P@66.&"?PropDataCopyL@L@66.&"?TypeInfoCopy8M@M@66.&"?FBlobDeltaCopy8A@A@880($ ?BlobCopy8A@A@..&?TypeInfoCopy8U@U@66.&"?^dir@@$$ ?c_VBA_PROJECT@@66.&"?__SRP_5@@,,$?__SRP_4@@,,$?NQEAWCFALKNANDBHUFJUDGZMLYAL61@61@VVNFB>?AcessVBAData61@61@66.&"?zTypeInfoCopy8@@66.&"?BlobDeltaCopy8L@L@880($ ?yBlobCopy8L@L@..&?PROJECTu@u@,,$?wPROJECTwmu@u@00( ?rdiru@u@$$ ?t_VBA_PROJECTu@u@66.&"?pNQEAWCFALKNANDBHUFJUDGZMLYALu@u@VVNFB>?AcessVBAData@@66.&"?kTypeInfoCopy8@@66.&"?BlobDeltaCopy8贁@贁@880($ ?jBlobCopy8贁@贁@..&?NQEAWCFALKNANDBHUFJUDGZMLYAL=@=@VVNFB>?BRPXBEHVUAVGODMLXUXTFGLOUPV_ a@ a@VVNFB>?BlobCopy8@@n<To :.&LVALa  h4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    m9f:g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    LVALb{2d# " @Calibri    ~278bc,'    .4`, FormHeaderx a!+H@߾h1U`6<a<bc, cmdPrintAll $Print All Barcodesx j1I*33. rptBarcodes20:340!%J<&K<'L$ (M`,x  Detailx K Lx;]v ;m7U;F{`6| axb c,he   Input  Inputx v&5Y@B9/+.J| /Kx0L1Md5U7`6xaxb c,h Input_Label  Inputx r;fsBAI.SSJxKxL@ Mm7U;F{`6| ab c,he k Description descriptionx &_.%F~z@{+.J| /K0L1Md5U7`6xab c,h "Description_Label Descriptionx &9Io^HǴi ƔK ƿv5ġ`Ë@¶k"M BlobCopy8}Fl@}Fl@..&?BlobDeltaCopy8^@^@880($ ?BlobCopy8^@^@..&?TypeInfoCopy8V7Y@V7Y@66.&"?BlobDeltaCopy8ӍY@ӍY@880($ ?BlobCopy8ӍY@ӍY@..&?TypeInfoCopylW@lW@66.&"?BlobDeltaCopy7W@7W@880($ ?BlobCopy7W@7W@..&?TypeInfoCopyES@ES@66.&"?BlobDeltaCopyJS@JS@880($ ?BlobCopyJS@JS@..&?TypeInfoCopy/TS@/TS@66.&"?BlobDeltaCopyPSS@PSS@880($ ?BlobCopyPSS@PSS@..&?TypeInfoCopyC@C@66.&"?BlobDeltaCopyOC@OC@880($ ?BlobCopyOC@OC@..&?TypeInfoCopyW@@W@@66.&"?BlobDeltaCopy 6W@@ 6W@@880($ ?BlobCopy 6W@@ 6W@@..&?TypeInfoCopyCZ6@CZ6@66.&"?BlobDeltaCopyY6@Y6@880($ ?BlobCopyY6@Y6@..&?TypeInfoCopy\aq1@\aq1@66.&"?BlobDeltaCopy'q1@'q1@880($ ?BlobCopy'q1@'q1@..&?TypeInfoCopyCO-@CO-@66.&"?BlobDeltaCopyCO-@CO-@880($ ?BlobCopyCO-@CO-@..&?TypeInfoCopy*@*@66.&"?BlobDeltaCopy*@*@880($ ?BlobCopy*@*@..&?TypeInfoCopy87c)@7c)@66.&"?BlobDeltaCopy8Yc)@Yc)@880($ ?BlobCopy8Yc)@Yc)@..&?BlobCopy5+@+@..&?rTypeInfoCopy8b@b@66.&"?BlobDeltaCopy8Ib@Ib@880($ ?kTypeInfoCopy8=@=@66.&"?TTypeInfoCopy?XG3@XG3@66.&"?YBlobDeltaCopy?XG3@XG3@880($ ?SBlobCopy?XG3@XG3@..&?tTypeInfoCopy?m/@m/@66.&"?VBlobDeltaCopy?m/@m/@880($ ?lBlobCopy?m/@m/@..&?zBlobCopy5*-@*-@..&?TypeInfoCopy8+@+@66.&"?RBlobDeltaCopy8+@+@880($ ?uBlobCopy8+@+@..&?TypeInfoCopy8o@o@66.&"?OBlobDeltaCopy8 @ @880($ ?BlobCopy8 @ @..&?TypeInfoCopy8^)@^)@66.&"?LBlobDeltaCopy8R(@R(@880($ ?6Blob5kN@b`@@UF2& JHDF8@@Ha)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6xa<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*JxK<L!M+BlobN1jp`@K&`@7J'n#2&c+sTypeInfoN1jp`@K&`@@ͬ3zKJᵨ30Detaild 0Label0z.&+PropDataN1jp`@K&`@ G.&-C'h=}0 k " e  p M *  j 3 m >  Notes rptBarcodes  Input autoexec qryOutputLMSysAccessXML$ JInputModule1CMSysNavPaneObjectIDs2.9MSysNavPaneGroupToObjects<85MSysNavPaneGroups,(2MSysNavPaneGroupCategories>:DataAccessPages($SysRelModulesScriptsReportsFormsUserDefined SummaryInfo +MSysAccessStorage,('MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables LVAL ^ _ a/:u029 =5B>a)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*J<K<L!M LVAL:u0=5B>a)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6xa<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*JxK<L!M+BlobCopys`@s`@ @|:.&[+kTypeInfoCopys`@s`@@ͬ3zKJᵨ30Detaild 0Label06.&" LVAL ^ _ a/:u029 =5B>a)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*J<K<L!M+Blob辩@ad@t2&+TypeInfo辩@ad@@PF:.&+BlobCopyxt`@xt`@@:.&[+kTypeInfoCopyxt`@xt`@@ͬ3zKJᵨ30Detaild 0Label06.&" LVAL ^ _ a/:u029 =5B>a)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri~ "[Event Procedure]1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*J<K<L!M+DirData辩@辩@ rptBarcodesZ.&+PropData辩@ad@ G.&+ __SRP_4@m@@8,$+CPropData@s`@ 0CB0 1CB0T.&WLVALgam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\STDOLE2.TLB#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object LibraryMM8VZNYPVLZUWKQPDFCLYISHKYXGWNM0>4d4de9c1Module1[,8NQEAWCFALKNANDBHUFJUDGZMLYAL0?4d4de9c15Form_Input(8HRESCYCZGTSSFEVWWYXXLLTFCTAG0<4d4de9c1Form_NotesdHh(HxG$cGRCRzQ$_ W+iIL@d"(QT0AccesscInputVBAWin16~Win32MacVBA6#Project1 stdole`azaleaDAOModule1b _Evaluate Azalea_UPC_A6g UPCnumbercheckDigitSubtotal1i` checkDigit`tempRChrK~ValRight Str _B_var_LeftQ _B_var_Midp _B_var_Chr\; _B_var_Right9 _B_var_Str Form_InputڮcmdPrintRecordlForm FormHeader  cmdPrintAllDetail2 Input_Label Description Description_LabelFormatted_OutputjFormatted_Output_Label~Label14D FormFooterTcmdPrintRecord_Click CDoCmdƧClickPrintOut. acSelectionw? acSelectio$ acSelecti8acSelectxacSelecUacSelecwacSel)acSeacSrac}\aXPrintOuG OpenReport acViewPreview2_B_var_OpenReport#acWindowNormallRunCmdT _B_var_RunCmd5FormsFoB]MdValueKAzaleaSoftware_EAN8EANOddBarRthe' Azalea_EAN13EvenBar' theString6 Azalea_ISBN13 ISBNnumber<PricegISBNuEvenSJOddSZ Form_NotesaLabel0, Form_Click Label0_Click*`  5  6 JHDF8@@H& ПϟJ 辩@辩@rptBarcodes+@N1jp`@N1jp`@Notes+8N1jp`@N1jp`@Notes+~@?*888,,,,,,,* @ 辩@辩@rptBarcodes+@DDD88888886 @LVALak#rU~| ,)Q1 !!Iq !9 ) A Y q   1 I a y l CtlCp! tMP@@  @`1l5@(@lMP@   t(lM @  t(lM@  t(dlM@T TP t(  lM@@  tlM@   toooooopj2 P 6@ dT lMP@@  @ t( lM0@  t(lM@  t(lM@d dP t(T lMt@  t( lM0@  tkjoooooopj2 P 6@ dT 4,kjD@    `1d6@ 1(@lMP@  : ]36@ j^@ @:P (lM0@  F`1`/6 @ ^@ @:P (lM0@  F`1`/6 @ @l`(@lMP@   #*1`26@ @l`(@lMP@   #*1`26@ l`(@lMP@   #*# *FlM @  ldF: d`1`26@ dpMP@@  @ t( pM0@  tpM@   tooopj26@ z(@pMP@   t(pM @  tkj oopj26@ 0jMP@@ @   `1d6@ ldC l 0iyl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0 yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0J yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0 yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0 yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0+yl`pMP@@  @ #*#*# ( pM0@ LVALP #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0vyl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @   l0 yl`pMP@@  @ #*#*# ( pM0@ P #*1`2 P 6@ l`*#(@pMP@   #*#P*#(pM @  #*#*#pM@   #*1x2P 6 @  @(xdl`ptdP @ dT :; Xl CtltCp lp 0(Cx lp0Q"` ``1x5` lp0iCx lp0Cx lp0Cx lp0Cx lp0Cx lp0Cx lp0 Cx lp0!Cx0@xpt`@l CtltCp lp 0("Cx lp0@#Cx lp0X$Cx lp0p%Cx lp0&Cx lp0'Cx lp0(Cx lp0)Cx lp0*Cx lp0+Cx 0xpt p4l Ct'lt t\Ao\d d`1x5d 4,xtdp4l Ct'lt t\Ko\d d`1x5d 4,xtdW{+NQEAWCFALKNANDBHUFJUDGZMLYALt`@t`@@(bVNFB> LVALdDp]ayAIlu(3zKJᵨ3^}GNŵORx^}GNŵORp]ayAIlu(ME(SLSS6N0{7A0533EB-FF9C-4B80-B84A-1DFFE1B5A833} (% `|eD i 0 % %00HH D IM$*\Rffff*084d4de94dr4p8< "  8xp0o` PB@BHAttribute VB_Name = "Form_Notes"D Bas0{7A0533EB-FF9C-4B80-B84A-1DFFE1B@5A833} |G lobalSpacFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  +dirt`@t`@>@0$  LVALam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\STDOLE2.TLB#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object LibraryIM8VZNYPVLZUWKQPDFCLYISHKYXGWNM014d4de66dModule1[w,8NQEAWCFALKNANDBHUFJUDGZMLYAL024d4de6b75Form_Input(8HRESCYCZGTSSFEVWWYXXLLTFCTAG084d4de94dForm_NotesdHh(HxG$cGRCRzQ$_ W+iIL@d"(PS/ AccesscInput VBAWin16~Win32MacVBA6#Project1  stdole` azalea DAO Module1b _Evaluate Azalea_UPC_A6g UPCnumbercheckDigitSubtotal1i` checkDigit`tempRChrK~ValRight Str _B_var_LeftQ _B_var_Midp _B_var_Chr\; _B_var_Right9 _B_var_Str Form_InputڮcmdPrintRecordlForm FormHeader  cmdPrintAllDetail2 Input_Label Description Description_LabelFormatted_OutputjFormatted_Output_Label~Label14D FormFooterTcmdPrintRecord_Click CDoCmdƧClickPrintOut. acSelectionw? acSelectio$ acSelecti8acSelectxacSelecUacSelecwacSel)acSeacSrac}\aXPrintOuG OpenReport acViewPreview2_B_var_OpenReport#acWindowNormallRunCmdT _B_var_RunCmd5FormsFoB]MdValueKAzaleaSoftware_EAN8EANOddBarRthe' Azalea_EAN13EvenBar' theString6 (Azalea_ISBN13 ISBNnumber<PricegISBNuEvenSJOddSZ Form_NotesaLabel0, Form_Click`  5  6+_VBA_PROJECTt`@t`@@B6.&"+ __SRP_5@m@g@FF8,$+__SRP_0t`@t`@@8,$+PROJECTwmt`@t`@\@RF<0( +PROJECTt`@t`@@8,$+=PropData8y` @I`@P.&+PropDataCopy Hc@ Hc@ 1CB0 0CB0\6.&"o+DirDataCopy Hc@ Hc@,frmInputOutputn6.&"+AcessVBADatat`@t`@ N6.&" LVAL ^ _ a/:u029 =5B>a)b*c!e giXj)k 'lN1jp`@x j`!Ky . U  @Calibri~ "[Event Procedure]1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPCx qYiCOT*J<K<L!M+BlobCopy@`@@`@S@:.&[+kTypeInfoCopy@`@@`@@ͬ3zKJᵨ30Detaild 0Label06.&" LVAL ^ _ a/:u029 =5B>a)b*c!e gh6 i j\+k "lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPC~ "[Event Procedure]x qYiCOT*J<K<L!MLVAL@m# +[xME(< <<< 0%+0`@xPPi i8`l`j`d` `(U`+``@pPi +0`pl`t`ti `\@pi `\@`ti (h000hx`t`t80d X`t 8P8\ @@0x h(`t`t(0d \  0x`t0`p0  X$&(" @P @ @0 ( 0 @ @ x@ @  @ @ @ @  @ @t h @d @T P @@ @0 @ @   @ (  @ @ @ @ @ @ @ (p @ @ @ @  h 0 0x  0 `t 8h p (` p 8 8 P 0x`  `t0p 8 8 LVALB   P( 0x p d T ,&&0&X ! 2:;48 X 2x12^2^H"@P"@H 6P0Fz0 @  (@y@j@yjH@yj  @y j H @y` j  @y( jh  @y j0  @y j h @y j 0@yHj X "X L  B   P h x          ( 8 H X h x   B   P  ( 8 H X h x           ( 8 H Xhp B x  P' B   P@' 8 UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.com* Creating an ISBN-13 barcode in Excel 2003j ISBNnumber is a 13-digit ISBN number and Price is the retail price used in the 5-digit supplemental code.] ISBNnumber has no hyphens or spaces. Strip them out if necessary to make an 11-digit string.fcoN Note: this routine requires the EvenS, OddS, EvenBar, & OddBar functions too.]& a bucket for the ISBN string ]& a check digit subtotal]& a check digit throwaway]& a temporary placeholder drop the ISBN check digit  $', Let's do the EAN-13 check digit calculation$ $$$ $$$ $$$ $$$  $$$ $&$$ 'ars &  $$$ $$$ $$$ $$$  $$$  $$$ ',  $($&' Build the output string., Does the ISBN number begin with 978 or 979?$ $8$"|xHS $$ '  'dh$"|xHT $$ ' k(  $$ ' x  $$ ' ar(Mid  $$ y $&  zv ' / Calculate the 5-digit supplemental check digit $$$ $$$ $&$$ '  $$$ $$$  ' $($&': The rest of the output depends upon the checkDigit value. 0KT  EEEOO'  $$ : $$ '  : $$ : $$ : $&$ '1KT  EOEOO  $$ : $$ '  : $$ : $$ :LVAL $&$ '$2KT  EOOEO  $$ : $$ '  : $$ : $$ : $&$ ' EvenB3KT  EOOOE$  $$ : $$ '  : $$ : $$ : $&$ '4KT  OEEOO  $$ : $$ '  : $$ : $$ : $&$ ' '5KT  OOEEO  $$ : $$ '  : $$ : $$ : $&$ '  6KT  OOOEE'  $$ : $$ '  : $$ : $$ : $&$ '$7KT  OEOEO  $$ : $$ '  : $$ : $$ : $&$ ' half 8KT  OEOOE(0  $$ : $$ '  : $$ : $$ : $&$ 'recomm9KT  OOEOEpo  $$ : $$ '  : $$ : $$ : $&$ 'hitingnR The output, Azalea_ISBN13, is formatted using one of Azalea Software's UPC fonts. Excel: B1=Azalea_ISBN13(A1)F Or put another way, yourContainer.text=Azalea_ISBN13(yourInputString)ts ri80 UPCTools 16mar09 jwhiting 'I Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.com0KT ' OOE!'temp =1KTdS(Lef"$"' "2KTMid(Pr#') 3KTISBN134KT":" + %'Price,5KT":" + &'rice, 6KT:" + E''(Price7KTnd Sel(' The o8KTlea_IS)'ormatt9KTne of *'tware'ni UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.com 0KTtion O+'theStr1KTing) A,'' UPCT2KT09 jwh-'opyrig3KTalea S.'nc. Al4KTeserve/'lea.co5KTt Case;' 6KT <' 7KT ='(34) 8KT2" >' "#" 9KT3" ^' "" n i 0 UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.comA $$ $"'ase i  UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.comK $$ $"'ht 200ix p ϵAttribute VB_Name = "Module1" Function Azalea_ISBN13(ByVal 0number As S!ng, 6Pr(ice,) ' UPCTools 16mar09 jwhitingCopyright 20y Software, Inc@. All $s reserved. www.a.com MreaY an-13 barcode in Excel43his a 13-digit u0and othe@tail payused, 5supplemXent<. 6has no hyphens or spaces. p &m out if ne sary to makel115€/0Note:KSrinUq ui) EvenS, Odd@Bar, &@ fs@o Dim+CC| 'Nbucket f2BAV s'EcheckDWSubtoFIntegY@ A `sD "thr@owawaytxemporA[pl@dholderA'drofD*AB<= L0eft(C, 12)Let's docANI"=DxHAc>El4seTIfA$+h3CO_ ;"yN5! K "zv ס ' C LVAL $he4Ca0UlUbG el Vcitf+ (9i{{#=MpYO YC &tt of,depends up`\g value.Selectse3 C"0"0EEEOOS,t$!S(":)SB&z@4m6c$sCa"1 O R1? Ph k+  * S( o 2 q =#H+ ]+ | ~  3 |OE (e  d(_^804 O?6 /6$u -6(Q=5  >( C;(?64 6 p` $ 9/6n((,60 7 EOE^1 n EKHS(( ' ` CC/[T t Cɲ Case "9" ' OOEOE  t emp =+ OddS(Left(Price, 1)) + ":" 8Mid62<Azalea_ISBN13tEvenS(5;3Z4 >Ri gh yEnd Select ' The output, , is formatted using onf Software's UPBCnts.+Excel: B1B= *(A1)D^DDStaticBar(Eng߉߉߉ĉͧ@@65(r(&)) $㧿M7 {+VZNYPVLZUWKQPDFCLYISHKYXGWNMM`@M`@4@m#bVNFB>i LVALy <Cu/@0);swB LVAL  d}-]VK,)3zKJᵨ3SkzN):::xME (SLSS<N0{7A0533EB-FF9C-4B80-B84A-1DFFE1B5A833} 8h(%0|eD i  % % ei HH D 0MM "  (  @xpHo( PB@B0Attribute VB_Name = "Form_Notes"D Bas0{7A0533EB-FF9C-4B80-B84A-1DFFE1B@5A833} |G lobalSpacFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  +dirM`@`@>@0$ i+y7DirDatakN@L@autoexecT.& LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " #+AcessVBADataM`@`@ N6.&"+BlobCopy5b`@b`@f@TF:.& LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \ I  <       paEI'8     j b UzmB}M~dg0j`@xȎInput3}Ja-knpaEI'8Formatted OutputPNL(XzmB}M~dgInputč&M zmB}M~dgsupplementalA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental +>PropDatay` @L@ 0CB0I.&i+y0DirDataCopyLۿ@Lۿ@2autoexecTempMacrot6.&" LVALrGD 4_  7?4 4H44 4 a)b*c*eHgh6iTj1k %l6@x FGU= NyLE`y  UpaEI'8^X}@+qryOutput(WfB }Tt.Gad@rptBarcodes/T)b^Me'(paEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`1/`@Inputr;@j)paEI'8supplemental  qryOutput Barcode Input @UPCHalfNarrow 8hhhhD\ h rother DCP-9045CDN Printer (CS odLetterPRIV ''''0\KhCFF0EBDAStandard 0 isMy Documents\*.pdf045CDN Printer (C1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'  LVAL  h4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    m9f:g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    LVAL{2d# " @Calibri    ~278bc,'    .4`, FormHeaderx a!+H@߾h1U`6<a<bc, cmdPrintAll $Print All Barcodesx j1I*33. rptBarcodes20:340!%J<&K<'L$ (M`,x  Detailx K Lx;]v ;m7U;F{`6| axb c,he   Input  Inputx v&5Y@B9/+.J| /Kx0L1Md5U7`6xaxb c,h Input_Label  Inputx r;fsBAI.SSJxKxL@ Mm7U;F{`6| ab c,he k Description descriptionx &_.%F~z@{+.J| /K0L1Md5U7`6xab c,h "Description_Label Descriptionx &9Io^H >>>Ѳ0* pHdazalea$@T=j KGM J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOEѲ0* pHdazalea$@T=j KGM J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOE Module1Gdu1 VZNYPVLZUWKQPDFCLYISHKYXGWNM28AZNYPVLUWKQ DFCY ISH@YXGNMB&@1TXB,*$[!+B Form_InputGA-rm_np@0tD/NQEAWCFALKNANDBHUFJUDGZMLYALC/N@*E@sW@**FL@)NN(DB@'U0JU@G6MB3A@FK/M/"'(B0<Cu/@0);sw9{EA{~/Bstdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOE Module1Gdu1 VZNYPVLZUWKQPDFCLYISHKYXGWNM28AZNYPVLUWKQ DFCY ISH@YXGNMB&@1TXB,*$[!+B Form_InputGA-rm_np@0tD/NQEAWCFALKNANDBHUFJUDGZMLYALC/N@*E@sW@**FL@)NN(DB@'U0JU@G6MB3A@FK/M/"'(B0rU H iA i Q 1 Y 4  zzz8  ~~~<  vvv@ 9 DQ y  H  ` 5L PQ )ppp T IrrrXQ ittthhahx P x '%:X hH%'$%:4%D$ `D )xD6hHrhh$  xDhHHX+BlobCopy8I`@I`@37pm#:.&+TypeInfoCopy8I`@I`@q@B6.&"LVALpm# ^ _u289 =5B>a)b*c*eHgh6iTj1k %l6@x FGU= NyLE`y  UpaEI'8^X}@ qryOutput(WfB }Tt.Gad@rptBarcodesPNL(XpaEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`X:`@Inputč&M paEI'8supplemental  qryOutput Barcode Input @UPCHalfNarrow 8hhhhD\ h rother DCP-9045CDN Printer (CS odLetterPRIV ''''0\KhCFF0EBDAStandard 0 isMy Documents\*.pdf045CDN Printer (C1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'  LVAL  h4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    m9f:g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    LVAL{2d# " @Calibri    ~278bc,'    .4`, FormHeaderx a!+H@߾h1U`6<a<bc, cmdPrintAll $Print All Barcodesx j1I*33. rptBarcodes20:340!%J<&K<'L$ (M`,x  Detailx K Lx;]v ;m7U;F{`6| axb c,he   Input  Inputx v&5Y@B9/+.J| /Kx0L1Md5U7`6xaxb c,h Input_Label  Inputx r;fsBAI.SSJxKxL@ Mm7U;F{`6| ab c,he k Description descriptionx &_.%F~z@{+.J| /K0L1Md5U7`6xab c,h "Description_Label Descriptionx &9Io^Ha)b*c!e gh6 i j\+k "lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 Creating ISBN-13 barcodes in Excel The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPC~ "[Event Procedure]x qYiCOT*J<K<L!M+BlobCopy`%`@`%`@g@:.&[+kTypeInfoCopyK&`@K&`@@ͬ3zKJᵨ30Detaild 0Label06.&"LVALJ'n# ^ _ a/:u029 =5B>a)b*c!e gh6 i j2k (lN1jp`@x j`!Ky . U  @Calibri1D/1<FPd2d# " @Calibri    `,   Detailx  mlA*{Pd5U`6<a<bH!c,  Label0 | Creating ISBN-13 barcodes in Excel (click to close) The macro in this spreadsheet creates ISBN-13 barcodes when used with Azalea Software's UPCTools font package. Because this spreadsheet is built around a macro, you *must* enable macros for this spreadsheet to work! The macro accepts 13-digit ISBN-13 numbers and 5-digit supplemental code input as a string. The ISBN-13 must not have hyphens or spaces in it. The macro calculates the check digit and maps the output into the UPCTools character set. Format the returned value in a UPCTools font and a barcode will be displayed and printed. Press ALT-F11 to view the macro in the Visual Basic Editor. To add the macro to your own spreadsheet: Tools/Macro/Visual Basic Editor Insert/Module Paste in the macro code Close the Visual Basic Editor When you return to your spreadsheet, a new User Defined function is available: Azalea_ISBN13 UPCTools prints UPC, ISBN-13, EAN, JAN, and ISSN barcodes. Available for Windows, OS X, Linux/UNIX, et al. Free sample code and free tech support. Buy online and download immediately. www.azalea.com/UPC~ "[Event Procedure]x qYiCOT*J<K<L!M LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " #NC&h=}0 k " e  p M *  j 3 m >   rptBarcodes  Input autoexec qryOutputLMSysAccessXML$ JInputModule1CMSysNavPaneObjectIDs2.9MSysNavPaneGroupToObjects<85MSysNavPaneGroups,(2MSysNavPaneGroupCategories>:DataAccessPages($SysRelModulesScriptsReportsFormsUserDefined SummaryInfo +MSysAccessStorage,('MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " # LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " # LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " # LVALMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " # LVAL MR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " #2׏  mLVALJ ^ _u289 =5B>a)b*c*eHgh6Iijzk wl6@x FGU= NyLE`y  UpaEI'8^X}@ qryOutput(WfB }Tt.Gh\@rptBarcodes/T)b^Me'(paEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`@Input  qryOutput Barcode Input @UPCHalfNarrow 8hhhhD\ h rother DCP-9045CDN Printer (CS odLetterPRIV ''''0\KhCFF0EBDAStandard 0 isMy Documents\*.pdf045CDN Printer (C1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'     LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  LVALMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \   <       paEI'8     (   UzmB}M~dgoq@Input3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental  :LVAL\egateTypeGUIDRecordLocksODBCTimeoutMaMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTagsTextAlignAggregateTypeP    UzmB}M~dg 㩱@82Input/T)b^Me'(zmB}M~dginputA"(RJnɪwzmB}M~dgdescription   zmB}M~dg           input      m      /T)b^MMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUID8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTagsTextAlignAggregateType     UzmB}M~dgKo@Input/T)b^Me'(zmB}M~dginputA"(RJnɪwzmB}M~dgdescription_yNN@W}zmB}M~dgsupplemental   zmB}M~dg           input      m      /T)b^Me'(description      m      A"(RJnɪwsupplemental      m      r;@j) LVALMR2AggregateTypeGUIDMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " #MR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordMR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " #LVAL9<C3$[xME(< <<<0%+0xPii8```` (U`+pi+0`t`tipi`ti(X @\ `xh`t80( d `t x@@X\ x@@X0x h(`tH(&("X 8 B   P( 0x p d T ,&&0&X  28 X 2x22H"P"H 6P0F @ (@@j@jH@j  @ j H @` j  @( jh  @ j0  @ j h @ j 0@Hj X "X L  B   P h x          ( 8 H X h x   B   P  ( 8 H X h x           ( 8 H Xhp B x  P B   P@ 8 UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.cLVALom* Creating an ISBN-13 barcode in Excel 2003j ISBNnumber is a 13-digit ISBN number and Price is the retail price used in the 5-digit supplemental code.] ISBNnumber has no hyphens or spaces. Strip them out if necessary to make an 11-digit string.fcoN Note: this routine requires the EvenS, OddS, EvenBar, & OddBar functions too.]& a bucket for the ISBN string ]& a check digit subtotal]& a check digit throwaway]& a temporary placeholder drop the ISBN check digit  $', Let's do the EAN-13 check digit calculation$ $$$ $$$ $$$ $$$  $$$ $&$$ 'ars &  $$$ $$$ $$$ $$$  $$$  $$$ ',  $($&' Build the output string., Does the ISBN number begin with 978 or 979?$ $8$"|xHS $$ '  'dh$"|xHT $$ ' k(  $$ ' x  $$ ' ar(Mid  $$ y $&  zv ' / Calculate the 5-digit supplemental check digit $$$ $$$ $&$$ '  $$$ $$$  ' $($&': The rest of the output depends upon the checkDigit value. 0KT  EEEOO'  $$ : $$ '  : $$ : $$ : $&$ '1KT  EOEOO  $$ : $$ '  : $$ : $$ : $&$ '$2KT  EOOEO  $$ : $$ '  : $$ : $$ : $&$ ' EvenB3KT  EOOOE$  $$ : $$ '  : $$ : $$ : $&$ '4KT  OEEOO  $$ : $$ '  : $$ : $$ : $&$ ' '5KT  OOEEO  $$ : $$ '  : $$ : $$ : $&$ '  6KT  OOOEE'  $$ : $$ '  : $$ : $$ : $&$ '$7KT  OEOEO  $$ : $$ '  : $$ : $$ : $&$ ' half 8KT  OEOOE(0  $$ : $$ '  : $$ : $$ : $&$ 'recomm9KT  OOEOEpo  $$ : $$ '  : $$ : $$ : $&$ 'hitingnR The output, Azalea_ISBN13, is formatted using one of Azalea Software's UPC fonts. Excel: B1=Azalea_ISBN13(A1)F Or put another way, yourContainer.text=Azalea_ISBN13(yourInputString)ts ri80 UPCTools 16mar09 jwhiting 'I Copyright 2009 Azalea Software, Inc. All rights reserved. www.LVALazalea.com0KT ' OOE!'temp =1KTdS(Lef"$"' "2KTMid(Pr#') 3KTISBN134KT":" + %'Price,5KT":" + &'rice, 6KT:" + E''(Price7KTnd Sel(' The o8KTlea_IS)'ormatt9KTne of *'tware'ni UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.com 0KTtion O+'theStr1KTing) A,'' UPCT2KT09 jwh-'opyrig3KTalea S.'nc. Al4KTeserve/'lea.co5KTt Case;' 6KT <' 7KT ='(34) 8KT2" >' "#" 9KT3" ^' "" n i 0 UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.comA $$ $"'ase i  UPCTools 16mar09 jwhitingI Copyright 2009 Azalea Software, Inc. All rights reserved. www.azalea.comK $$ $"'ht 200ix p ϵAttribute VB_Name = "Module1" Function Azalea_ISBN13(ByVal 0number As S!ng, 6Pr(ice,) ' UPCTools 16mar09 jwhitingCopyright 20y Software, Inc@. All $s reserved. www.a.com MreaY an-13 barcode in Excel43his a 13-digit u0and othe@tail payused, 5supplemXent<. 6has no hyphens or spaces. p &m out if ne sary to makel115€/0Note:KSrinUq ui) EvenS, Odd@Bar, &@ fs@o Dim+CC| 'Nbucket f2BAV s'EcheckDWSubtoFIntegY@ A `sD "thr@owawaytxemporA[pl@dholderA'drofD*AB<= L0eft(C, 12)Let's docANI"=DxHAc>El4seTIfA$+h3CO_ ;"yN5! K "zv ס ' C$he4Ca0UlUbG el Vcitf+ (9i{{#=MpYO YC &tt of,depends up`\g value.Selectse3 C"0"0EEEOOS,t$!S(":)SB&z@4m6c$sCa"1 O R1? Ph k+  * S( o 2 q =#H+ ]+ | ~  3 |OE (e  d(_^804 O?6 /6$u -6(Q=5  >( C;(?64 6 p` $ 9/6n((,60 7 EOE^1 n EKHS(( ' ` CC/[T t Cɲ Case "9" ' OOEOE  t emp =+ OddS(Left(Price, 1)) + ":" 8Mid62<Azalea_ISBN13tEvenS(5;3Z4 >Ri gh yEnd Select ' The output, , is formatted using onf Software's UPBCnts.+Excel: B1B= *(A1)D^DDStaticBar(Eng߉߉߉ĉͧ@@65(r(&)) $㧿M7 {+dVZNYPVLZUWKQPDFCLYISHKYXGWNMo{@o{@,9bVNFB>oLVAL)Ѳ0* pHdazalea$@T=j IM J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOE Module1Gdu1 VZNYPVLZUWKQPDFCLYISHKYXGWNM28AZNYPVLUWKQ DFCY ISH@YXGNMB&@1XB,*$[!+B Form_InputGA-rm_np@0tD/NQEAWCFALKNANDBHUFJUDGZMLYALC/N@*E@sW@**FL@)NN(DB@'Uͬ 9{EA{~/0FormHeaderh 0cmdPrintAll0Detailm0Inputd 0Input_Labelm0Descriptiond 0Description_Labelm0Formatted_OutputFormatted Outputd 0Formatted_Output_LabelFormatted Output_Labelh 0 cmdPrintRecordd 0 Label140 FormFooterѲ0* pHdazaleͬ9{EA<Cu/@0);swB+gdiro{@o{@@0$ Y LVAL y ID="{862A67AB-5422-4C19-9B9B-A7FD48480A8C}" Module=Module1 DocClass=Form_Input/&H00000000 Name="azalea" HelpContextID="0" VersionCompatible32="393222000" CMG="FDFF1A1BEA1CEE1CEE1CEE1CEE" DPB="FAF81D221B231B231B" GC="F7F51021F0E3ECE4ECE413" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 870, 541, Z Form_Input=66, 66, 892, 616, C am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\P:0* pHdazalea$@T=j MM J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOE Module1Gdu1 VZNYPVLZUWKQPDFCLYISHKYXGWNM28AZNYPVLUWKQ DFCY ISH@YXGNMB&@1,XB,*$[!+B Form_InputGA-rm_np@0tD/NQEAWCFALKNANDBHUFJUDGZMLYALC/N@*E@sW@**FL@)NN(DB@'U0JU@G6MB3A@FK/M/"1'(B0Notes0N@3ts0HRESCYCZGTSSFEVWWYXXLL@TFCTAG0HPRE@XC@aCQ@)GT@S@.EdW[]X@-L@UdT@8GP`0d 0ID="{862A67AB-5422-4C19-9B9B-A7FD48480A8C}" Module=Module1 DocClass=Form_Input/&H00000000 DocClass=Form_Notes/&H00000000 Name="azalea" HelpContextID="0" VersionCompatible32="393222000" CMG="0604E1EDE1F5E3F9E3F9E3F9E3F9" DPB="0C0EEBF3F7F8F8F8F8F8" GC="1210F5F1FAF2FAF205" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 870, 541, Form_Input=66, 66, 892, 616, C Form_Notes=44, 44, 884, 555, Z K*mͬ9{EA{~/0FormHeaderh 0cmdPrintAll0Detailm0Inputd 0Input_Labelm0Descriptiond 0Description_Labelm0Formatted_OutputFormatted Outputd 0Formatted_Output_LabelFormatted Output_Labelh 0 cmdPrintRecordd 0 Label140 FormFooterm0 supplementald 0 Label15ID="{862A67AB-5422-4C19-9B9B-A7FD48480A8C}" Module=Module1 DocClass=Form_Input/&H00000000 DocClass=Form_Notes/&H00000000 Name="azalea" HelpContextID="0" VersionCompatible32="393222000" CMG="5250B577F17BF17BF17BF17B" DPB="92907537B438B438B4" GC="D2D035F774F874F88B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 870, 541, Form_Input=66, 66, 892, 616, C Form_Notes=44, 44, 884, 555, Z :0* pHdazalea$@T=j MM J < stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\STDOLE2 .TLB# AutomatioFn`DAO>JDAjOA A4AC9E1DA- 5BAD-7-86E3-24F4CDCECA28}#cAPROGRA~1\COMMONMICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOE Module1Gdu1 VZNYPVLZUWKQPDFCLYISHKYXGWNM28AZNYPVLUWKQ DFCY ISH@YXGNMB&@1,XB,*$[!+B Form_InputGA-rm_np@0tD/NQEAWCFALKNANDBHUFJUDGZMLYALC/N@*E@sW@**FL@)NN(DB@'U0JU@G6MB3A@FK/M/"1'(B0Notes0N@3ts0HRESCYCZGTSSFEVWWYXXLL@TFCTAG0HPRE@XC@aCQ@)GT@S@.EdW[]X@-L@UdT@8GP`0d 0+f_VBA_PROJECTo{@o{@ @B6.&"f+vhPROJECTwmo{@o{@;Module1Module1Form_InputForm_Inputw0( +iPROJECTo{@o{@@8,$+cAcessVBADatao{@o{@ N6.&"LVALAzalea_ISBN13([Input]![input],[Input]![supplemental]) NLVALReGUIDRecordLocksODBCTimeoutMaxRecordMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \ I  <       paEI'8     j b UzmB}M~dg/`@pInput3}Ja-knpaEI'8Formatted Output/T)b^Me'(zmB}M~dgInputr;@j)zmB}M~dgsupplementalA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental MR2ANSI Query Mode(Themed Form ControlsAccessVersion NavPane CategoryUseMDIMode ShowDocumentTabs BuildHasOfflineLists>Picture Property Storage Format.CheckTruncatedNumFieldsProjVerNavPane ClosedNavPane Width*NavPane Category NameNavPane View ByNavPane Sort ByAppTitle&StartUpShowDBWindow(StartUpShowStatusBarStartUpMenuBar$AllowShortcutMenusAllowFullMenus(AllowBuiltInToolbars&AllowToolbarChanges AllowSpecialKeysAppIcon,StartupShortcutMenuBar&UseAppIconForFrmRpt(AllowDatasheetSchemaCustomRibbonIDStartUpForm"Show Values Limit,Show Values in Indexed4Show Values in Non-Indexed*Show Values in RemoteAuto CompactK    09.50     F     W                   ! " # LVALrGD $O  7?$ $H$$ $ <@$ $4$P$$$($P$$$$p$$ $4$$       Input.Input Input input#Input.supplemental!Input.descriptionFormatted Outputx$p$H$X$x$W}@ $$x$ + $8[ 4$8[ P$8[$h$$ $x$oq@qryOutput$ $H$$P$ ($X$ P$`$$$($P$$8[  $8[ 4$8[ input Input $X$ $`$ 4$h$$$($ Input $8$@ $ x$8$H$X$h$x$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $#4$ $ "#4$ $ "#4$ $ $z X$($h$0[$P $ $ $ $ $ P $  $  $ $8 $ $ $P $ $ $ $$$ $ $`$$$ 5`Azalea_ISBN13 d$p$$ t$ P $[Input]![input]$$ $  $,+[Input]![supplemental]$ $$0 $x$($ $ $ Input $PrimaryKey$$v $$$$8$8q$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$8$$ $($$x$ $InputPrimaryKey#4$ $$8$$#4$8$($$($`$ $+HPropDataCopyL@L@ 0CB0 1CB1\6.&"LVALh4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    m9f:g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    {2d# LVAL" @Calibri    ~278bc,'    .4`, FormHeaderx a!+H@߾h1U`6<a<bc, cmdPrintAll $Print All Barcodesx j1I*33. rptBarcodes20:340!%J<&K<'L$ (M`,~  Detailx K Lx;]v ;m7U;F{`6| axb c,Je   Input  Inputx v&5Y@B9/+.J| /Kx0L1Md5U7`6xaxb c,J Input_Label  Inputx r;fsBAI.SSJxKxL@ Mm7U;F{`6| a b c,Je k Description descriptionx &_.%F~z@{+.J| /K 0L1MWd5U7`6xa b c,J "Description_Label Descriptionx &9Io^H}@>}@k5e:.&+lTypeInfoCopy8>}@>}@J@B6.&"+vBlobCopy8o'@o'@{5J:.&+xTypeInfoCopy8}'@}'@J@B6.&"LVALJ ^ _u289 =5B>a)b*c*eHgh6Iijzk wl6@x FGU= NyLE`y  UpaEI'8^X}@74qryOutput(WfB }Tt.Gh\@rptBarcodes/T)b^Me'(paEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE` @Input  qryOutput Barcode Input @UPCHalfNarrow 8hhhhD\ h rother DCP-9045CDN Printer (CS odLetterPRIV ''''0\KhCFF0EBDAStandard 0 isMy Documents\*.pdf045CDN Printer (C1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'    LVALh4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    m9f:g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    {2d# LVAL" @Calibri    ~278bc,'    .4`, FormHeaderx a!+H@߾h1U`6<a<bc, cmdPrintAll $Print All Barcodesx j1I*33. rptBarcodes20:340!%J<&K<'L$ (M`,~  Detailx K Lx;]v ;m7U;F{`6| axb c,Je   Input  Inputx v&5Y@B9/+.J| /Kx0L1Md5U7`6xaxb c,J Input_Label  Inputx r;fsBAI.SSJxKxL@ Mm7U;F{`6| a b c,Je k Description descriptionx &_.%F~z@{+.J| /K 0L1MWd5U7`6xa b c,J "Description_Label Descriptionx &9Io^Ha)b*ce gj=k - 2[Input]=Forms!Input!InputlTi@x (WfB }Tt.Gy ( UpaEI'8;S@0) qryOutput/T)b^Me'(paEI'8input3}Ja-knpaEI'8Formatted OutputA"(RJnɪwpaEI'8description  qryOutput *Barcode Output Report @Calibri 8hhhh$ h P  dXLetter PRIV,8BObt"2?KXkx  (-4=DJ(3AM\m| #1a)b*ce gj=k - 2[Input]=Forms!Input!InputlTi@x (WfB }Tt.Gy  UpaEI'8^X}@@ėqryOutput)GBT=cԴp(WfB }Tt.GinputFGU= NyLE`F'@Inputv&5Y@B9/FGU= NyLE`Input/T)b^Me'(paEI'8input3}Ja-knpaEI'8Formatted OutputA"(RJnɪwpaEI'8description  qryOutput *Barcode Output Report @Calibri 8hhhh$ h P  dXLetter PRIV,8BObt"2?KXkx  (-4=DJ(3AM\m| #1 FGU= NyLE`  UpaEI'8^X}@ qryOutput(WfB }Tt.Gad@rptBarcodesPNL(XpaEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`X:`@Inputč&M paEI'8supplemental MR2 GUIDNameMap> FGU= NyLE`  UpaEI'8^X}@ qryOutput(WfB }Tt.Gad@rptBarcodesPNL(XpaEI'8InputA"(RJnɪwpaEI'8description3}Ja-knpaEI'8Formatted Outputv&5Y@B9/FGU= NyLE`InputFGU= NyLE`X:`@Inputč&M paEI'8supplemental MR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColor(DatasheetForeColor12CInput.input  \ I  <       paEI'8     j b UzmB}M~dg0j`@xȎInput3}Ja-knpaEI'8Formatted OutputPNL(XzmB}M~dgInputč&M zmB}M~dgsupplementalA"(RJnɪwzmB}M~dgdescription   Arial      "  Q*$[Formatted Output]   e& Formatted Output    3}Ja-knO("Input.description   <*$Input.supplemental MR2 GUIDNameMap (WfB }Tt.G  UpaEI'8^X}@3qryOutput)GBT=cԴp(WfB }Tt.GinputFGU= NyLE`F'@Inputv&5Y@B9/FGU= NyLE`Input/T)b^Me'(paEI'8input3}Ja-knpaEI'8Formatted OutputA"(RJnɪwpaEI'8description LVALt:u:<=5B>a)b*ce gj=k - 2[Input]=Forms!Input!InputlTi@x (WfB }Tt.Gy  UpaEI'8^X}@@ėqryOutput)GBT=cԴp(WfB }Tt.GinputFGU= NyLE`F'@Inputv&5Y@B9/FGU= NyLE`Input/T)b^Me'(paEI'8input3}Ja-knpaEI'8Formatted OutputA"(RJnɪwpaEI'8description  qryOutput *Barcode Output Report @Calibri 8hhhh$ h P  dXLetter PRIV,8BObt"2?KXkx  (-4=DJ(3AM\m| #1