Yes, it is certainly possible to do it without VBA at all. One possible method is to write a subquery that counts all rows up to this row. This also assumes there is a primary key that you can use and you can define a sort order. Here’s a sample SQL:
See how easy it is to add sequential numbering to Avery products using Avery Design & Print Online at avery.com/print. Great for adding tracking numbers to items like Avery Tickets with Tear-Away Stubs.
4. Define Document Categories: You define one document category for each bank account for which you want to use sequential numbering. In the Code field you enter the bank account name. In the Table Name field you enter CE_STATEMENT_HEADERS.
A particular report must have pages numbered consecutively from 1-12. In addition, it must have 4 un-numbered pages inserted after page 8. In the past these 4 pages have been produced as a separate file but it would be easier to combine the two documents into a single file. How can this be done?
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I’m also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
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 http://mywebspider.com only those paragraphs with heading styles and places them into the Table of Contents.
The application requires sequence values to be sorted by another field. The NEXT VALUE FOR function can apply the OVER clause to the function call. The OVER clause guarantees that the values returned are generated in the order of the OVER clause’s ORDER BY clause.
I would suggest you look to see that Automatic Page Numbering is selected in the Document Numbering Options dialog, which can be accessed from the Books Panel menu. You can then set the Book Numbering Options if you want the first page of your chapters to start on even or odd pages, etc.
Imagine a book that has typical numbering, but then has three collections of supplemental materials labeled Appendices A, B, and C. Pages in these appendices are to be numbered A-1, A-2, A-3, etc. and restart at 1 for each Appendix.
Press Ctrl+V for each additional row of labels you want. You want enough rows of labels to meet your entire needs. Thus, if you need a total of 125 labels, and you can get 3 labels per line, you should end up with 42 rows of labels.
One other caveat here; the number generated in these scenarios is NOT a primary key. These tables should use an Autonumber as the PK. The possible exception would be scenario 1, but I would still tend to use an Autonumber as the PK.
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. 🙂
Thank you very much. I learnt number seq from here and applied it on my transport booking pad and this save me hours of work. Now can you please show me how to do something like 120/12, then 120/13, 120/14 and so on with seq.
simple programme for consecutive numbering of forms while digitally printing? e.g. adding consecutive numbers to a batch of pre-printed invoice sets. One original, but numbers on it increasing or decreasing as they are printed.
Now I have another problem. This code worked perfectly up to ten records. When I tried to add the eleventh record, the Sequence field won’t add any more numbers. It’s stuck at 10. This of course causes my RecordNumber field, which displays as
Yes, the controlsource of Sequence is Sequence. I’m not getting any errors, just isn’t populating Sequence at all. I also tried making the controlsource the Sequence field in tblLogRecords, but that didn’t work either and gave me “#Name?” in the form.
The ticket merges perfectly, prints multiple tickets per page and numbers them sequentially. The only problem is that Publisher won’t print the 3 digit number format. It prints 1, 2, 3, 4, etc. on the tickets.
I’m producing gift certificates for a restaurant and they need to be numbered sequentially from 0001 to 0250. Is there any way to do this easily as opposed to numbering each manually? I’m sure I could probably work it out with a print shop, but the job was thrust on me last minute and my options are limited by the short turn around time.
I’ve even tried adding the procedure to the OpenDate_AfterUpdate field instead of with the save record control, but I can’t seem to get it to work either. The only thing that shows up in the RecordNumber field is “13” unless I manually populate the Sequence field (which misses the whole point).
Still having difficulties with automatic table numbering in word. Please see attached example of what I am currently doing manually but want to do automatically. More tables continue in the document and are numbered 2, 3, 4 and so on with numbering in accompanying table following the same sequence (i.e. 2.1, 2.1.1.; 2.2; 3.1, 3.1.1 and so on).