Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In other words, if someone creates a record then later deletes it, there will be a gap in the sequence. So, what are our options? There are actually several ways, each with its pros and cons.
The process described in this tip works best if you have a single list in your document. Note that the sequence field starts at the beginning of the document and numbers through the whole document, based on the identifier you use. If you are going to have multiple lists in your document, then you can add a second AutoText entry to help with this. The only difference in the above steps is that the SEQ field you define would look like this:
If you want numbered headings to be underlined, but do not want a line under the number, it can be difficult if you don't know how it works. This is because by default, the format of the number follows the format of the text that follows it. For example, let's say you want to underline a paragraph in a Heading 2 style. Chances are it will look like this:
The system that you choose for numbering your invoices should correspond to your most prominent needs to make it as easy as possible for invoices to be located for referencing, and the sequence number must always be last to help you keep track and avoid duplication. Lots of accounting software provides an invoice number generator to help with this task.
* The solution assumes that there is only one stack to cut, but really there could be dozens of stacks. Take a run of the numbers 1-10000 for example. Let’s say you get 4-up on a sheet and the biggest stack that will fit in the guillotine is 500 sheets. A true cut and stack solution will print on the first stack 1-500, 501-1000, 1001-1500, 1501-2000. Ideal because the numbers can be guillotined and placed back onto a pallet for its next process. It also means I can provide these numbers first to the client and then they can wait for the other numbers (in case they had run out of stock and were in a hurry for replenishment stock). The solution doesn’t do that – instead, the first 500 stack will have the numbers 1-500, 2501-3000, 5001-5500, 7501-8000. That means not only is placement back onto the pallet confusing, but the customer has to wait for the artwork to be completely printed before even getting the first half of numbers. True, I could run the script several times to get the appropriate stacks, but why should I if the script did what I wanted? Especially if there are hundreds of stacks to print?
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks.
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?
I want to have textbox with 2 columns with footnotes running across the bottom of those columns in one column. ID CS3 footnotes can’t handle this. So I have added fake footnote refs in the doc. using this idea. Now the footnotes themselves I can create in another text frame and use this idea again to create them and then manually place them at the bottom of the page. The only problem however with this is the FN options carrry across the whole doc. right? So even if I create a second doc for the footnotes themselves with different options and then later paste it into the main doc it’ll get messed up right?
There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
Running captions number figures, tables, and other items consecutively in a document. For example, the first figure caption starts with the words “Figure 1,” the second with “Figure 2,” and so on. To make sure that figures, tables, or similar items are numbered consecutively, define a list for the item, and then create a paragraph style that includes the list definition. You can also add descriptive words such as “Figure” or “Table” to the numbering scheme of the paragraph style.
Starting an auto-numbered paragraph is deceptively simple. See those buttons on the top row of the Paragraph section of the Home tab? The left-most one is for bullets; the next two to its right are for numbering and multi-level numbering, respectively. Simply click the button to toggle the feature on, or click on the drop-down arrow on each button to select a specific style. If you don’t like any of the delivered choices, you can click Define New to set your own.
The values for Number position (here called Aligned at), Text indent and Follow number with are in the Position section at the bottom. With multi-level numbering, you also have easy access to settings that control the type of numbering at each level, the characters before and after each level’s numbers (period versus parenthesis), and the list number style (1, a, I, etc.).
I need a way for the priority level to automatically adjust when I add or change an item with a new priority level. I might have 6 tasks, each will have a different priority. If I add one and set it to 1, the others need to increment + by one digit. Adding one to the above the highest would see no change in the others. Adding one in the middle would spread the rest apart (e.g. I have a 3, I put a new record and put it at 3, the old 3 becomes 4, and so on (everything below it would increment one digit).
And of course, it’s not only when you add or delete counters that the numbering auto-updates, but also when you copy or move the text, as when you’re rearranging your listed points. This InDesign inline counter now works exactly like the counters in my old, beloved XyWrite word processors — except I cannot have several counters with separate numbering in the same text story. In XyWrite I could have nine, using only the codes c1, c2,…c9. But for 95% of one’s counter needs, one counter per story is quite ample — as compared to none.
When you are ready to restart numbering, you can use the technique above, or you can place your cursor inside a numbered paragraph above, click the Format Painter (the paintbrush icon on the Home tab under Clipboard), then click on the line where you want to restart numbering. Using Format Painter this way solves several paragraph numbering problems (the number sequence, indents, and inter-paragraph spacing) simultaneously.
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.