I have been generating 150-400 page reports with multiple lists in tables. Word's auto numbering would only go so far in applying sequential numbering but then it just stops and I could not use it any more. I had to manually type in the numbered list which was quite annoying and very time consuming. Then I came across your Word Tip. Awesome! It worked. Thanks so very much.
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
Layout your ticket in InDesign, one on each page, using the Page Number function to number the tickets. If you have something like Imposer Pro (I know it doesn't work from InDesign CS3) you can, for instance, impose the pages 4up consecutive and get 4 tickets on an A4. Alternatively, make a PDF of the whole document and impose (manually, if you have to), the advantage here is that this can work as a template for other tickets, simply make a new PDF of the same size and update the PDF in the template document every time you have a new raffle ticket to do.

My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
Using a template to write invoices saves you a fair bit of time. While you still have to enter all of the payment information for each order on your own, sample invoices provide a ready-made design that you just have to fill in using the relevant company and customer data. But how does the perfect invoice template really look? And what should an invoice template consist of?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
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 auto-indenting feature of bullets and lists has always frustrated me. EVERY time you apply a numbered or bulleted list, you've got to set the indents. I want my lists to be indented at the very left of the page, flush with the rest of the paragraphs. But no, Microsoft insists that you want them indented by 0.63cm and hanging at 1.27cm (WHY 0.63? Why not 0.7? Or 1.0cm? But that's a question for a different session.) (I know, it's because MS is American and still uses inches etc...)
I have been generating 150-400 page reports with multiple lists in tables. Word's auto numbering would only go so far in applying sequential numbering but then it just stops and I could not use it any more. I had to manually type in the numbered list which was quite annoying and very time consuming. Then I came across your Word Tip. Awesome! It worked. Thanks so very much.
I am having trouble with this procedure. My situation is almost identical to example #2. I want to populate RecordNumber on my form with a date number like “130001, 130002, etc.” where “13” is the year based on a date automatically generated in the OpenDate field in tblLogRecords. OpenDate is a date/time type field that has a default value of the date the record is created and is not editable. I have added a field called Sequence to tblLogRecords and it is a Number, Long Integer type. I also created a bound control for Sequence on my form. I have a completely separate autonumber field as the PK.
A3 is the result of A1/21 I want to bracket the number in A4 In MSWorks I would type the statement ="["&string(A3,0)&"]" In excel I get in some cells [1.436871259834] I'd like it to read [1] Help please. -- rodney@touch88gum.com.au (Remove gum to reply) Rodney, ="["&ROUND(A3,0)&"]" -- HTH, Bernie MS Excel MVP "Rodney" wrote in message news:OkME4oGVEHA.2564@TK2MSFTNGP11.phx.gbl... > A3 is the result of A1/21 > I want to bracket the number in A4 > In MSWorks I would type th...
For controlname you need to use the name of the control bound to your Project ID# field. However, the # may be complicating things. Type the Me. and Intellisense should give you a list of controls and methods. Press the P key to go to Ps and scroll until you find the controlname. Selecting the name from the Intellisense list will make sure you are using the correct control. That control needs to have a ControlSource of the Project ID# field. If you do this correctly, then pressing the button should populate the control with the next number. It will also save the record.

Note  If TAB and SHIFT+TAB do not work for changing the indents for outline numbering, you probably have the option Tabs and Backspace set left Indent turned off. To change this setting, from the Tools menu, choose Options. Select the Edit tab and check the option Tabs and backspace set left indent. As an alternative to turning this option on, you can instead use ALT+SHIFT+LEFT ARROW or RIGHT ARROW to increase or decrease outline numbering.
One solution is to format the heading with the style and follow it with a hidden paragraph mark. You should format the text in the next paragraph with a style that is not included in the Table of Contents. A hidden paragraph mark keeps the text together on one line when it is printed, even though it is actually two separate paragraphs. The Table of Contents command picks up only those paragraphs with heading styles and places them into the Table of Contents.
Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!
An invoice number is simply a way to uniquely mark an invoice to help keep track of your business transactions. Consecutive or sequential invoice numbers help to ensure that each invoice is unique and each business transaction can be clearly and comprehensively organized and referenced – for accounting reasons as well as customer support. While a receipt is generally used as proof of payment and therefore documents a finalized sale, an invoice is a request for payment that includes more detailed payment or contact information in addition to pricing information for the goods or services rendered. Having a proper invoice numbering system helps you avoid duplicate payments that can amount to large losses for your company.
The best way to do this is to use a primary key. In cases where a query is complex and joins several tables, we may need to use the primary key of the table that’s on the bottom of the relationship hierarchy or possible a concatenation of multiple tables’ unique key so that the expression will be unique and thus we can identify which sequential number we have assigned.
How do I set up the basic template for text numbering in Word 2008 for the Mac? Here is what is driving me nuts: I want to generate numbered lists - lots and lots of them. The first level numbered lines will have second level under them in many cases, also numbered and indented below the first level. The second level will also have third level under them, intended some more and also numbered. This "sort-of" works fine. It USED to work excellently. Here is what I do. I click the Numbering button in the Bullets and Numbering palette. The line indents and a 1) is aut...
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.

This requires no pre-knowledge of a primary key and only assumes that when you load the form initially, it is already sorted. Any records newly inserted will get the next bigger number. However, if you requery and it causes the newly inserted rows to be re-sorted, they will be now given a new number that relates to their actual position within the set, which can be either good or bad, depending on your specific requirements.
Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:
My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
See Word's Numbering Explained by John McGhie, MVP - comprehensive and not pretty (Downloadable pdf file in letter size) - Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering.
Hi! I hope you help me with this. I have the almost same problem as #2. I have PassengerTable as table name, then I have the following fields: sequence (to follow what you have in your post), transaction_date, and transaction_ID. Basically I want the to have sequential numbering in the transaction_ID where month and date from transaction_date is shown. i also have a generate (Command27)button as trigger.Tried the code with few modifications, but it sequence doesnt populate, and doesnt show any, except for what i have in control for transaction_ID which is the “Format(transaction_date,”yyyy-mm”) & “-” & Format(sequence,”000″)” and this only shows the year and date, so instead of 2015-08-001 it shows 2015-08-.
As an example of surprising version number ordering implementation behavior, in Debian, leading zeroes are ignored in chunks, so that 5.0005 and 5.5 are considered as equal, and 5.5<5.0006. This can confuse users; string-matching tools may fail to find a given version number; and this can cause subtle bugs in package management if the programmers use string-indexed data structures such as version-number indexed hash tables. Once you are happy with your basic layout, copy everything three times so you have a page of four tickets. At this point, they won't be numbered tickets just yet, you will add the numbers in a moment: Manually, you can obtain what is called a Bates stamper that automatically increases the number on the stamper each time it is stamped on a document. This will assist you in not having to either write the increasing numbers on the document or manually changing a stamper each time you place a number on a document. Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!! In the 21st century, more programmers started to use a formalised version policy, such as the Semantic Versioning policy.[1] The purpose of such policies is to make it easier for other programmers to know when code changes are likely to break things they have written. Such policies are especially important for software libraries and frameworks, but may also be very useful to follow for command-line applications (which may be called from other applications) and indeed any other applications (which may be scripted and/or extended by third parties). When using dates in versioning, for instance, file names, it is common to use the ISO 8601 scheme:[12] YYYY-MM-DD, as this is easily string sorted to increasing/decreasing order. The hyphens are sometimes omitted. ^ Excel has changed its maximum size many times, originally 16,365 rows by 128 columns, while other programs of the era often compared themselves by increasing this - WingZ was 32,768 by 32,768 for instance. Modern spreadsheets have much larger limits, Excel from Office 2010 on are 1,048,576 by 16,384. Duplicating Function. Some programs enable you to press one key in a specific field to duplicate the information contained in the same field in a prior record. For example, if you typed in ABC Purchase Contract in the TYPE field of your prior document record, then, when you are at the TYPE field in a subsequent record, press the appropriate key and the TYPE will be duplicated in the second record automatically. This is used most effectively while objectively coding documents. Often packet headers and file format include a version number – sometimes the same as the version number of the software that wrote it; other times a "protocol version number" independent of the software version number. The code to handle old deprecated protocols and file formats is often seen as cruft. Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday! If the document control field is auto-generated, the value is not displayed when adding the document. To avoid the possibility that two users might be creating a new document control number at the same time the number is only created and viewed after the document has been added to the library. The original form in pdf format was read and printed by the Adobe Reader to the numberED provided numberED printer - creating a Windows spool file used by numberED as a background page on which the numbers and text were added. numberED then printed the combined numbers and text with background form to a printer in one pass. Some of the output (the last 5 sets of the 1800 sets) is captured here as a pdf file for your viewing convenience. Step 3: Configure Auto numbering – Here you will be presented with “Sequence Name” and “Start Number”. Add your unique value for “Sequence Name” and “Starting number”.  Click “Add” when done.  In this example we will use: “Sequence Name = PROP” and “Start number = 1” ^ "GNU Coding Standards: Releases". GNU Project. 2014-05-13. Retrieved 2014-05-25. You should identify each release with a pair of version numbers, a major version and a minor. We have no objection to using more than two numbers, but it is very unlikely that you really need them. Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number. Apple had their own twist on this habit during the era of the classic Mac OS. Unlike traditional version numbering (where 1.5 is not half-way between 1.0 and 2.0, given there could be any number of minor releases, e.g. 1.22). Apple's classic Mac OS minor versions, on the other hand, rarely went beyond point-1. When they did, they twice jumped straight to point-5, suggesting the release was "more significant". The complete sequence of classic Mac OS versions (not including patches) is: 1.0, 1.1, 2.0, 2.1, 3.0, 3.2 (skipping 3.1), 4.0, 4.1, 5.0, 5.1, 6.0, 7.0, 7.1, 7.5, 7.6, 8.0, 8.1, 8.5 (jumped), 8.6, 9.0, 9.1, 9.2. Thus, "8.5" became its own marketed release to mean "eight and a half", and 8.6 effectively "8.5.1". [otp_overlay] [redirect url='http://thedailyrant.net/raffle-ticket-numbering/bump' sec='7']
Both the Collection Point ID and Artifact ID fields are bound properly and display those exact names in the property sheet under both control source and name. On the save button I have on the form, when I click on the event tab and the on click option I have event procedure and I click the […] option to open up the code builder and this is what I currently have:
Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!

Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:

Similar to Improv, formulas can be represented as icons in Numbers, allowing them to be dragged about the sheets. One noteworthy example of this is a sidebar which contains the sum, average and other basic calculations for the current selection in the active table. These serve a function similar to the sum that appears at the bottom of the window in Excel. However, the user can drag one of the function icons from the sidebar into the sheet to make the calculation appear in that location.[11] In another nod to Improv, the Formula List shows all of the formulas in the spreadsheet in a separate area, and allows edits in place or easy navigation to their use in the sheets.
I have been researching using sequential numbers for invoices an purchase orders, but all of them seem to advance the number eithe every time the document is opened or saved. My purchase order is par of a larger file, and since I will be opening and saving the fil without necessarily writing a purchase order I need more control ove its advancement. I was wondering how I could create a button that whe pressed or selected would advance the number by 1? Also, how could make it create a unique number depending on who's creating the purchas order. For example, let's say the user is ...
The best way to do this is to use a primary key. In cases where a query is complex and joins several tables, we may need to use the primary key of the table that’s on the bottom of the relationship hierarchy or possible a concatenation of multiple tables’ unique key so that the expression will be unique and thus we can identify which sequential number we have assigned.
I thought I'd try and just create one decal and use the print merge feature but I don't print from my workstation. I create the design in X7 then export it to a RIP Station for print. I thought I'd just do the print merge and print as pdf just to get the numbers without typing them. That gets me all the numbers in sequence but all on 500 separate pages.
Set up a matrix in Excel, one column for each ticket position (stack) and one row for each sheet, plus one for field names. Fill the first column down in consecutive order, then the second, starting where the first column leaves off, and so on. Afet a couple of columns are filled, you can auto fill across the rows, too, so the whole thing takes only a couple of minutes. Name the stacks and use a different field for each position on the page when you do the merge. The trick is to set up using a custom file for the total number of tickets or whatever, divided into the correct number of stacks and sheets.

I use a template for all my drawings that includes a page number in the lower right hand corner (usually says "Page 1 of 4" for example). I usually edit this number manually, which is fine for documents with a small amount of pages, but if I'm working on a large document (50+ pages) and need to re-order some pages it means editing the page number on every page manually.


John, Sorry for the delay, but I was away last week with limited Internet access. I assumed if you had a Save button, you would know how to put code behind it. To see the code behind a button, Select the button in Form Design Mode and open the Properties Dialog (Right click and select properties), on the Events tab there should be something in the On Click event of the button. If you click the Ellipses […] next to the event, it will open Code Builder where you can enter the code.
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
I am curently working on a larger projekt, where we have aprox. 4500 pcs.of furnituer designed in 4 different kind of families, generic, furnituer, furnituer systems and specialty equipment. We need to be able to asign every  pcs.of funituer a seqventual serial number, we have tried to do this using an extension with a funktion called element positionerning, but we have had no success with this tool, apparently it is taking up to much memory.
This one is EASY. In InDesign, with a one-sided NCR form, cut the all elements from the first page. Go to your Master page and place. Where you are going to number the forms, draw a text box and insert a page number marker there. Format it to your liking, then insert as many pages as SETS are going to be made. When you go to print, enter 2 or 3 in the copies box, depending if it's 2-part or 3-part and under the properties button, select GROUPED or UNCOLLATED, turn off OFFSET. Violá!

I've also been using NumberPress for about a year and it is awesome. You can easily position numbers as many up per form and as many up on a sheet as you will ever need. Easily change font, color, point size, angle, number of digits and can even customize prefix-ex: instead of No. you can print ABC or a form number. It also does variable data (I've only used a couple of times).Took a little while to learn but is now a piece of cake.
 Does anybody have an easy way to set up sequential numbering in Coreldraw? Our shop has to lay out unit number plaques for vinyl cutting and sometimes my employee has to manually type in hundreds of numbers. I've read all the print merge suggestions for raffle tickets and such but I need the numbers entered into an object and not during the print process. 
Note this works only because we create a brand new table, add an autonumber column to it as well any other columns we need then insert records into it. It’ll be contiguous – as long we don’t delete any records from the table. Unfortunately, creating a brand new table every time we run this will result in bloat of the Access file – if you can do it in a separate Access file, all the better so that you can compact it when you need to.
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.

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.

×