Some freeways' exit number starts from a advanced number (i.e. higher than 1). Some reason of starting a number higher than 1 is due to the expectation that the highway will extend on both ends. For example, Ontario Highway 400 starts at 20 because it was expected that the south end of the highway would extend to downtown Toronto (which was never built). Another reason to use a higher number is that the freeway is branching off from another freeway. An example is British Columbia Highway 5, which branches off British Columbia Highway 1 and starts at 170.

Scott, I had posted on Microsoft and you sent me to your blog to have the numbering system (similar to APEX example) explained. I am not a programmer and I don’t understand where these codes and expressions are even suppose to go in access. When I do try to implement the little I do know I continue to get errors. I am not sure if I am putting the information in the wrong place or if I am way off. Do you know of any youtube videos that could walk me through it step by step? Or if you have the time could you help walk me through the steps.

My experience with a number of medical device manufacturers has convinced me in the benefits of a “no designation” system. Three designation systems I have worked with have failed. Just recently, one of my customers reported that they ran out of range in their part-numbering format. The system allowed for assigning materials through a two-digit designator within the part number. When the system was designed, needing more than 99 materials was not considered possible. Unfortunately, things changed, and just a few years later, the company needed more than 99 materials causing the existing part number format to fail.
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.

i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.

    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.
So how long should a doc number be? There’s no hard & fast rule, but a document number can be as short as 5 digits, with a simple discipline descriptor and a sequential number assigned to certain project elements. Most projects can benefit from a numbering protocol that is under 15 digits in length. When broken down, it only needs to hold Author-Discipline-Project Location-Sequence. This is far easier to understand for everyone on the project and, most importantly, its simplicity means there’s less chance of someone, somewhere, making a mistake.
If you are designing and building a Trident-class submarine, a MIG-27 jet fighter or an international space station, you, most likely, will need millions of parts, so a long part number format would be needed and will make sence. Otherwise, save yourself the trouble of reading all those zeros and make your numbering system practical. Our Documentation Management Procedure shown in Chapter 3 prescribes part numeration with a four-digit part number format that allows for 9,999 parts, which is probably enough for majority of companies. If your operation is small, drop it to three digits – you may always change it later if you need to. One of my customers, who won my “the Best Part Number” Grand Prize, numbered their documents as 201, 202, 203, and so on. Short and sweet!

Hi - are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app ( then you can't change the font size ... you'll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!

I have a table named Artifact Catalog in which there is a field Collection Point ID and a field Artifact ID. On the form I have created the user will input the Collection Point ID, for example: 2-1050. I need to find a way to have this Collection Point ID automatically generate a corresponding Artifact ID, i.e when you click the save button the first record under Artifact ID becomes: 2-1050.1 and the second becomes 2-1050.2 and so on.
Document Numbering is a module that helps set numbering for required transactions as per our requirements. This module auto assigns document number based on the segment structures defined in the masters. We have seen in detail about the use and also about the configuration part in our previous blogs related to Document numbering Module. What… Read More »
In a management system standard like 9K or 14K all you have to do is make sure that folks can tell the difference between documents and that current revision status be identified....Not one word about history, or numbers, or anything else. All the other fluff and garbage winds up contributing to the self inflicted wounds organizations cry and sling snot about when the audit goes "tsk-tsk-tsk, naughty-naughty".
Another issue with the part-numbering format is part number designation. Some systems associate a part number with a particular part type. For example, 10xxx indicates a procedure, 20xxx indicates a drawing, PLxxx indicates a policy-level document, and so on. An alternative approach to part numbering is a “no designation” system, where parts are given sequential unique numbers within a specified format, regardless of their type, material, application or other attributes. After all, isn’t the part title the best designator?
Scott, I was able to try this as I assumed that is what I needed to do. It does not work. First, the current macro for that button is a Save Record, Close Window operation. How could I keep this and also add Code? If I just add a new button to the form and under the On Click Event put the code you suggested, I get a compile error of “method or data member not found” and ” .txtPROJECT” is highlighted. The actual field is “PROJECT ID#” and it is a long integer number. Entry I have is: Private Sub Command88_Click()
This database is being built because the Excel version is not handling the amount of data properly and reports are taking too much time to run. Back in the development day of the Excel version I managed this issue by applying a function called UniqueRandomLongs that I got from CPerson ( and it worked like a charm after a couple of tweaks since a random number would be fired off everytime Excel ran a calculation (Almost all the time!) and I managed to get it to be triggered only when the SAVE button was clicked.
It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
Number Pro does not create your raffle ticket or document it just allows an easy way to  number them. Check out Number Pro, take a look at the demo videos and even try the demo of Number Pro to see how it works. Number Pro is a cloud based application meaning there is no download of the application. We access the application online in the members area. They offer a three year membership with unlimited use.
Instead of working harder than you need to, insert a one-column table with as many rows as necessary to accommodate your list. Then, using Word's numbering feature, number that column. Finally, convert the table to text. The resulting list is a fixed numbered list, so you'll have to live with its limitations; when you can do so, this method definitely beats most alternative solutions. sequential numbering