This leads to another often-ignored topic, that of file naming conventions.  What I mean by this is how and where you save the computer file in your computer system.  I know more than one company that has a policy that all documents must be approved by a specific person and the document isn't considered implemented until that person saves it up on the file server.  This is both good and bad, because MANY times I've seen that person receive random phone calls from upper managers within the company that didn't even try to look for a document - they just called that person and interrupted whatever they were doing in order to have them directed to the document.  If a person wants to be the single point of contact (SPOC) on document management, they might receive a few phone calls they didn't anticipate.  It may still be worth it.
OK I found the ControlSource property but it is on the Job No text box, do I enter the code there or am I entering my code on the button I created to save and get new number? If I put it behind the button, when I open the form it goes to the first record so I go to the last record and hit save get new number button and it gives me the number 1……Is it because when I open the form it goes to the first record and not a new record????
You’ll need to decide on a selling price. You don’t want to price them too high so that many people would find it too expensive. The lower the price of each ticket, the more tickets you’ll sell. If you price your tickets at $1 each, expect each buyer to purchase from one to five tickets. If your tickets are $5-10 each, each buyer will likely purchase no more that two.
Ontario has the oldest exit number system, having started posting exit numbers sequentially in the 1960s along Highway 401; it switched to mile-based numbering before Canada went metric. Most short freeways do not have exit numbers, and until about 2000 (with Highways 11 and 69/400), incomplete freeways also did not have exit numbers. Interchanges with multiple exits are lettered A-B.
Ok, generating a random 3 digit number is a whole different thing, so I’m not going to go into that. If you want your numbers to start at 100 (to insure three digits) then change the 0 to 99. The Nz function will return the value listed if the field is Null. So the first time you execute that code, the DMax should return a Null since no numbers have been generated for the PONum field. The Nz will then substitute 99 and then increment that by 1. You can accomplish something similar by just entering 100 as the PONum for one record. .
As I indicated, because you want to only generate this number just before saving, I would put this code behind a Save button or another event that runs just before you save the record. So if you want to prevent duplications, you don’t use the expression as a control source, but put the code behind a button or event. Since you have a Save button, put it there.
Both the United Kingdom and the Republic of Ireland use sequential numbering systems, with the junction number indicated by a white number in a black square in the corner of signs. In the United Kingdom they are frequently referenced in the media as the number with "J" on front of it, with for example Junction 1 being referred to as "J1". If a junction is newly constructed to between two existing junctions, it is normally allocated the number of the lower of the two junctions, with the letter "A" attached (and so on). For example, a new junction opened between junctions 3 and 4 would become Junction 3A.
If you’re producing any kind of numbered items in-house that are multiple-up on a sheet where you need to control all the variables to meet your production needs, the autonumbering feature through numbered lists is the way to go! Just step and repeat away & InDesign will do all the work. No need to fool with a seperate “numbers” file or deal with a data merged document. I think it’s by far the best option for basic numbering.
Our documents are given control numbers based on function category: what part of production they are related to. For example, E for Equipment (forklifts, pallet jacks, etc) or HS for Health & Safety (cleaning and sanitizing procedures and check sheets). They are then assigned a number after that, followed by a dash (-) and second number which represents the revision number.
The main expressway system uses sequential numbering; Metropolitan Expressway systems also use sequential junction numbeing, usually appended with the expressway number expressed thus: 5-1; 5-2, etc. There are multiple toll expressways not operated by the major national syndicates or the Metropolitan Expressway Authorities that have no junction numbering scheme.
Ok, generating a random 3 digit number is a whole different thing, so I’m not going to go into that. If you want your numbers to start at 100 (to insure three digits) then change the 0 to 99. The Nz function will return the value listed if the field is Null. So the first time you execute that code, the DMax should return a Null since no numbers have been generated for the PONum field. The Nz will then substitute 99 and then increment that by 1. You can accomplish something similar by just entering 100 as the PONum for one record. .

What I am trying to do is create sequential numbering in the Reference field that will assign a number based upon Account #.  In other words, if the Account # is 2208, the Reference field will equal 1 for both entries.  The next unique account number will be assigned "2", etc.  This is necessary so that the Reference number in our accounting system matches the Reference Number on the customer's invoice.

We use the auto page numbering trick here, the trick is to do it as spreads. You just make your pages the same size as the ticket with crops and bleeds. Then set up the shell on the master page and place your auto page number where you want your numbers. Each pages is the next number. You can also have two sets of numbers for perforated ticket. You then can use the page start options to add to the numbers and keep the same number of total numbers. For example you would do a new page start after number 99. 0001 to 0099 so it doesn't add two "0's" to the front of 100 and you get 00100 when you want 0100. Works great for small quantities, we have done up to 1000+ tickets and once you do it once or twice it is a snap to set up. To avoid having to do 1000 pages just send the tickets in groups. Usually between 25 to 100 at a time works good depending on artwork file size. Just save each time before sending to printer and name the file with what the tickets are. Like "MyTickets-0001-0100.Indd". Makes it easier to go back if you have a problem. You can even do two rolls of tickets if your using 12 x 18 sheets by flipping the sheet and doing one row along the top and one along the bottom on reverse side. That is if your ticket is single Sided. Two sided tickets are a bit trickier. :-)
As more highways were built, states and countries began to experiment with distance-based (mile-based or kilometer-based) exit numbers. The first mile-based system known was implemented on the Garden State Parkway in New Jersey in the late 1950s. Michigan also implemented mile-based junction numbers on Interstate 94 in the 1960s. In this system, the number of miles from the beginning of the highway to the exit is used for the exit number. If two exits would end up with the same number, the numbers are sometimes modified slightly; this is often impossible and exits are given sequential or directional suffixes, just as with sequential numbers.
If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.
In an early planning meeting, someone on a project we’re working on requested a 65 digit number for a document! This code wasn’t just numbers, it included letters and symbols as well. There’s no doubt that this system was super-organized, but is it practical? It’s worth remembering that the doc number has to be understood by everyone, including external suppliers and subcontractors. Plus the longer the number, the greater the risk of human error.

LION carries a wide range of high quality heavy-duty automatic numbering machines from the 5-wheel model to the 13-wheel model. Various specifications are available for your specific individual need. LION numbering machines are precision crafted of one-piece hardened steel frame. All metal interior construction will provide years of reliable use. This self inking numbering machine is ideal for sequential numbering operations to use as a date and number stamp, serial number stamp and inspection stamp, etc. Custom numbering machines are also available so that it can work to your exact need.


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!
In mathematics, a sequence is an enumerated collection of objects in which repetitions are allowed. Like a set, it contains members (also called elements, or terms). The number of elements (possibly infinite) is called the length of the sequence. Unlike a set, the same elements can appear multiple times at different positions in a sequence, and order matters. Formally, a sequence can be defined as a function whose domain is either the set of the natural numbers (for infinite sequences) or the set of the first n natural numbers (for a sequence of finite length n). The position of an element in a sequence is its rank or index; it is the natural number from which the element is the image. It depends on the context or a specific convention, if the first element has index 0 or 1. When a symbol has been chosen for denoting a sequence, the nth element of the sequence is denoted by this symbol with n as subscript; for example, the nth element of the Fibonacci sequence is generally denoted Fn.
First, you have to use YOUR field and control names. The ones I use are samples. The error you are getting indicated you do not have a control named txtProject. So you have to substitute the correct name of the control. bound to the ProjectID field. By the way it is not a good idea to the octothorpe(#) as part of a field name. A controlname may be different from a fieldname. The name property of a control is on the Other tab in the Properties dialog.

Yes, I have used this system in a multi-user setting. As noted, the key is to commit the record immediately after generating the sequence. However, if the application is one where there is very heavy transaction processing. In other words dozens of users creating records simultaneously, you might want to guard further against duplication. At the speeds computers process, it is not impossible that multiple users will grab the max value before it can be incremented and saved.
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.
Paper-based registers are hard work – each time you update a document you must also update the register – often striking out the old line and adding a new line. Spreadsheet based registers are not much easier to maintain but at least they allow sorting and searching. Online database document systems are easier, since updating the information stored with the document itself should flow through to the register, and sorting documents, searching and creating custom lists (e.g. show all ‘forms’) are usually possible.
For the purposes of this article, we define a sequence to be a function whose domain is an interval of integers. This definition covers several different uses of the word "sequence", including one-sided infinite sequences, bi-infinite sequences, and finite sequences (see below for definitions). However, many authors use a narrower definition by requiring the domain of a sequence to be the set of natural numbers. The narrower definition has the disadvantage that it rules out finite sequences and bi-infinite sequences, both of which are usually called sequences in standard mathematical practice. In some contexts, to shorten exposition, the codomain of the sequence is fixed by context, for example by requiring it to be the set R of real numbers,[2] the set C of complex numbers,[3] or a topological space.[4]
If you are thinking of using sequential numbering, please give our printing experts a call for helpful advice on how to best set up your artwork. We offer ready to use templates for the most common types of forms including invoice templates, statement templates, work order templates and purchase order templates. Just upload your logo and contact information and let us know how you would like to number your forms.
There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
If you make a list of things you need to do, starting with number 1 and continuing until all your tasks are accounted for, then you’ve made a sequential list. Something that is sequential often follows a numerical or alphabetical order, but it can also describe things that aren’t numbered but still need to take place in a logical order, such as the sequential steps you follow for running a program on your computer.
The main expressway system uses sequential numbering; Metropolitan Expressway systems also use sequential junction numbeing, usually appended with the expressway number expressed thus: 5-1; 5-2, etc. There are multiple toll expressways not operated by the major national syndicates or the Metropolitan Expressway Authorities that have no junction numbering scheme.

Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much again.

Sequential numbers can be printed almost anywhere on a sheet or form and can be positioned horizontally or vertically. Numbers can also be repeated in another position on the form. When developing your artwork, consider putting a box for numbering, making it easier for your customers or employees to find and reference a specific job or transaction. You may also differentiate your number by color. Most printers allow a choice of colors, typically black or red, to make your number stand out. Start your sequencing at any point you like, to pick up where you left off on your last print order.
OK, First, you need to reread the blog. You should NOT be storing the Transaction_ID. It is a calculated value. Second, your naming is what confused me. Your Passenger table should have an autonumber PassengerID. That PassengerID should be the Foreign Key in your Reservations table. Your servation table should also have an autonumber for ReservationID. I really don’t see why you need sequential numbering in the passenger table. I can understand it in the Reservations table, but not in the passenger table. Also, I don’t see any reason for a transaction date in the passenger table. I can understand a CreateDate for when the passenger signed up.
Infinite sequences of digits (or characters) drawn from a finite alphabet are of particular interest in theoretical computer science. They are often referred to simply as sequences or streams, as opposed to finite strings. Infinite binary sequences, for instance, are infinite sequences of bits (characters drawn from the alphabet {0, 1}). The set C = {0, 1}∞ of all infinite binary sequences is sometimes called the Cantor space.

I removed the required setting on the table level. The form does not give me an error message now, but does not close on its on. I closed it via a command then looked at the Design Projects table to see if the new record, #896, shows up. A new record is there, with all the entered data EXCEPT the very important field of the Project ID. That field is blank.


So how to organize them?  Rather than repeat what others have said, let me talk about two other areas other than the previous posts that will help you decide - because I strongly recommend you try to avoid the same mistakes others have made - the real fun is making NEW mistakes!  If your company is of any size, you should be looking at managing change within the company in an orderly fashion through regular meetings.  Yes - Management of Change!  Many of the companies following ISO-based systems call it an "EMM-OH-SEE" meeting, others call it Change Control Meeting.  Bottom line: these are many of the folks that are dealing with the files that you're organizing, so give them a say in how to organize it and what the hierarchy will look like.  In addition, these are also the same people that will likely be involved when a process is changed, so it is logical to be sure they understand where to find the files and how to name them.  I would also recommend that if an IT manager (or decision-maker) doesn't want to be part of the MOC/Change Control Team, that they are available for phone calls during the time the meeting is held, since their input on topics or follow-ups is likely going to be needed a time or two.
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
is defined as the set of all sequences {\displaystyle (x_{i})_{i\in \mathbb {N} }} such that for each i, {\displaystyle x_{i}} is an element of {\displaystyle X_{i}} . The canonical projections are the maps pi : X → Xi defined by the equation {\displaystyle p_{i}((x_{j})_{j\in \mathbb {N} })=x_{i}} . Then the product topology on X is defined to be the coarsest topology (i.e. the topology with the fewest open sets) for which all the projections pi are continuous. The product topology is sometimes called the Tychonoff topology.
You can change the numbers in the list by restarting the sequence or by specifying a new start number. You can change the list's style. You can do anything to this list that you can do to a normal numbered list because it is a numbered list, with one exception: the list, while easy to format, is fixed. If you delete an item, the list updates accordingly, but I haven't found a way to add numbers.
I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person's name, etc
×