Rocky Smolin
rockysmolin at bchacc.com
Mon Jun 1 16:04:39 CDT 2009
OK, I'm sold. The prospect, if they even they buy my system, may or may not do bar codes anyway. So I'll just wait for them. Just wanted to have my ducks lined up. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Monday, June 01, 2009 2:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Bar Codes ...dl it and play with it ...that way we won't talk around ourselves ...id offers it as a font pack in smaller and larger sizes ...clarity is critical for bar code fonts since they are being machine read ...its one of the reasons some of the freebie barcode fonts work at one size and not in another, they're not as carefully made and tested. ...the idautomation font comes with some sample Access code and you can even get an ocx from them ...but its overkill for most needs. William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Monday, June 01, 2009 4:42 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Bar Codes > "only comes in the one size" meaning you can't size the font for > bigger or smaller bar codes? > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William > Hindman > Sent: Monday, June 01, 2009 12:59 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Bar Codes > > ...I concatenate it with the data in the source as in: =("!" & > [ContactID] & > "!") > ...that works with every scanner we've tried so far. > > ...the only thing about the idautomation freebie is it only comes in > the one size ...it works fine for my needs but if your client needs a > different size then you have to either buy it or experiment with some > of the free bar code fonts ...I tried a few with very mixed results > and finally decided to stop wasting my time and go with idautomation > since it worked no matter what I did ...that's not to suggest that > there are not other very good freebie fonts ...just that I probably > didn't look long enough to find them myself ...like you, a client > needed something to work reliably on short order ...this filled in the > blanks for me ...hth. > > William > > -------------------------------------------------- > From: "Rocky Smolin" <rockysmolin at bchacc.com> > Sent: Monday, June 01, 2009 12:53 PM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] Bar Codes > >> Yeah that looks good. Thanks. Do you print the bar code directly >> from the data or did you have to code for your own Start, Stop, and >> Check zones? >> >> Rocky >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William >> Hindman >> Sent: Monday, June 01, 2009 9:43 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Bar Codes >> >> Rocky >> >> ...I use idautomation's free 39 barcode font to print badges and >> labels for one client ...that site has a ton of free information a >> lot of which is worth reading ...but the long and short of it is >> unless your client is doing something special or sophisticated, the >> 39 freebie font and very little code will almost certainly do what >> she needs ...I've used it in both Access reports and Word without any >> problem for several years now. >> >> William >> >> -------------------------------------------------- >> From: "Jim Dettman" <jimdettman at verizon.net> >> Sent: Monday, June 01, 2009 10:05 AM >> To: "'Access Developers discussion and problem solving'" >> <accessd at databaseadvisors.com> >> Subject: Re: [AccessD] Bar Codes >> >>> >>> I would not say it's the reader that's important (most readers can >>> scan just about anything now a days), but the application. >>> >>> For example, in retail it's always going to be UPC-A, possibly -E. >>> Distribution of goods will use UCC-EAN128. But if your labeling >>> test tubes in a lab, then it's probably going to be 3 of 9, unless >>> you have space restrictions. Then you might end up using Code 128, >>> which is for high-density applications. >>> >>> You need to fully spec out how and where it will be used to >>> determine the Symbology, type of label material, printing process, >>> and the type reader that will be required. >>> >>> Jim. >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky >>> Smolin >>> Sent: Monday, June 01, 2009 9:42 AM >>> To: 'Access Developers discussion and problem solving' >>> Subject: Re: [AccessD] Bar Codes >>> >>> That's a good idea. I'll ask but I don't think she'll know. I'm >>> not sure she wants to read - her requirement was for printing >>> labels. So I'll have to find out who is going to read them and how. >>> What's the most universal format - Code 39? >>> >>> Rocky >>> >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, >>> Jim >>> Sent: Monday, June 01, 2009 5:55 AM >>> To: Access Developers discussion and problem solving >>> Subject: Re: [AccessD] Bar Codes >>> >>> My first inclination is to ask the client what bar-code reader they >>> will use. >>> Start there. Different readers use and can read different codes. >>> Get a list of codes the reader can decipher. >>> >>> Jim >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky >>> Smolin >>> Sent: Sunday, May 31, 2009 3:49 PM >>> To: 'Access Developers discussion and problem solving' >>> Subject: [AccessD] Bar Codes >>> >>> Dear List: >>> >>> I have a client who wants to print bar coded labels. A bit of >>> Googling reveals a lot of different bar code schemes. Is there a >>> preferred bar code symbology? >>> >>> MTIA >>> >>> >>> >>> Rocky Smolin >>> >>> Beach Access Software >>> >>> 858-259-4334 >>> >>> www.e-z-mrp.com <http://www.e-z-mrp.com/> >>> >>> www.bchacc.com <http://www.bchacc.com/> >>> >>> >>> >>> >>> >>> #################################################################### >>> ## >>> ###### >>> #### >>> If you have received this message in error, please contact the >>> sender immediately and be aware that the use, copying, or >>> dissemination of this information is prohibited. This email >>> transmission contains information from NCI Information Systems, Inc. >>> that may be considered privileged or confidential and is intended >>> solely for the named recipient. >>> #################################################################### >>> ## >>> ###### >>> #### >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com