472,993 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 software developers and data experts.

Code "Auto-Letters" ?

Greetings:
I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution. I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).

The database I'm working on will generate tens, perhaps hundreds of
thousands of records, each of which need to be identified uniquely.
Using the autonumber would be ideal except that I'll need to use this
unique field to generate barcodes which will have to be printed on
small labels. So - If I get to record 999,999 and generate a barcode
for it, the barcode will be huge - or to big to fit on my label.

I think my solution would be to use letters rather than numbers.
Instead of counting 1, 2, 3, 4... 1,000; I want to count A, B, C, D...
ABCD. I guess my logic can be flawed, but I was thinking that since
there are 26 letters in the alphabet and only 10 numbers, I would be
able to get quite a bit farther in each place value using letters.

Thanks a bunch for any suggestions!

Matt

Nov 13 '05 #1
3 3052
ma**@1320am.com wrote in
news:11**********************@l41g2000cwc.googlegr oups.com:
Greetings: I think my solution would be to use letters rather than
numbers. Instead of counting 1, 2, 3, 4... 1,000; I want to
count A, B, C, D... ABCD. .

Thanks a bunch for any suggestions!

Matt

Use the autonumber in the table and write a function that takes the
modulo 36 (26Letters+ 0-9 digits) of your number and converts it to
a digit or letter and then loops to process the remaining value and
use that on your barcode..Sorta like Hex but with all letters of
the alphabet instead of just 0-9,A-F.

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #2
Matt,
Mathematically all you are doing is counting a series that iterates by one
and has a base of 26. Once you generate the next number in the series it's
a simple matter of using the char(ansivalue) function to return the
character for that number. Now, a 15 digit number will give you a maximum
value of 999,999,999,999,999. That's a quadrillion rows in a single table
before you run out of numbers. Access won't hold a quadrillion rows, as far
as I know. So you'll run out of rows in your table before you run out of
numbers if you used a simple numeric sequence. You could still declare as a
15 character text column that held your sequence numbers. If I were you I'd
just use a numeric sequence of my own design. Even if you interated by ten
you'd still have over 100 billion numbers--plenty.

<ma**@1320am.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
Greetings:
I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution. I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).

Nov 13 '05 #3
Matt,
It also occurs to me that the 2-D bar codes that UPS uses probably can fit
more values in the same small space because it uses a pattern of squares to
hold the data instead of a pattern of bars. This may not be a database
problem as much as it is a choice of bar code software problem.

<ma**@1320am.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
Greetings:
I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution. I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).

The database I'm working on will generate tens, perhaps hundreds of
thousands of records, each of which need to be identified uniquely.
Using the autonumber would be ideal except that I'll need to use this
unique field to generate barcodes which will have to be printed on
small labels. So - If I get to record 999,999 and generate a barcode
for it, the barcode will be huge - or to big to fit on my label.

I think my solution would be to use letters rather than numbers.
Instead of counting 1, 2, 3, 4... 1,000; I want to count A, B, C, D...
ABCD. I guess my logic can be flawed, but I was thinking that since
there are 26 letters in the alphabet and only 10 numbers, I would be
able to get quite a bit farther in each place value using letters.

Thanks a bunch for any suggestions!

Matt

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Smyke | last post by:
Hello I,ve got this "suckerfish menu" from alistapart that doesn't seem to work in Moz/Firebird/Net when you use the "overflow: auto;" css-style on the content below. If you hover over the links...
16
by: John Baker | last post by:
Hi: I know this is a strange question, but I have inherited a system where files are copied and records re auto numbered (as an index field) )frequently, and I am wondering how high the number...
1
by: PL | last post by:
The Culture="auto" UICulture="auto" is a great idea, but how do you handle the situaion where SQL Server always requires a dot "." in numeric values. If I use Culture="auto"so that dates and...
1
by: Jefferds.A | last post by:
Hi, I'm putting together a little database of individuals categorized by family. I have two lists, one that contains family names and one that contains individuals' names. When you click on a link...
1
by: JJ | last post by:
I am trying to stop my layout spoiling when a textbox with a width of 100% has a large amount of text in it. On the master page I have tried using a div with style="overflow:auto", and this work...
9
by: Beowulf | last post by:
I was having this problem: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source with it taking an inordinate amount of time to enumerate the...
22
by: nospam_news | last post by:
I currently get asked about my usage of "auto". What is it for? The keyword is clearly superflous here. In contrast to the huge majority of C/C++ developers I write definitions very explicitly...
2
by: Piotr K | last post by:
Hi, I've encountered a strange problem with Firefox which I don't have any idea how to resolve. To the point: I've <divelement with a style "height: auto" and I want to retrieve this value...
1
by: mattmao | last post by:
I am doing a ASP.NET porject, inside a asp control tag there are some textboxes for users to input data. Later they can take previously entered data out of those textboxes. To provide better UI...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.