Hi Tara, Thanks for sharing your observations! I agree that breaking your chapters into separate text frames is not the ideal way to go, but is only useful if you must have live endnotes at the end of each chapter rather than at the back of the book. One alternative in this scenario is to create a separate InDesign document for each chapter, then use the Book feature to tie them all together. Whether your chapters are in separate text frames or in separate documents, you’ll still need to be very vigilant with any changes to the flow of text to make sure the pagination is okay.
This will work OK for a small set of data, but the more data there is, the more intensive the subquery becomes, and it must be called repeatedly for each row. This is one of those rare cases where doing it in VBA is faster than doing it in SQL — after all, row numbering is fundamentally iterative, not set-based which just goes against the grain of what SQL was designed to do – solve a problem in a set-based fashion, non-iterative fashion.
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. .
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.
Hello! I already have automatic numbering set up (to change paragraph numbers automatically when paragraphs are moved within a document) but I would also like to have automatic lettering within the same document that is independent from the numbering. Example, paragraph 1 references Exhibit A, paragraph 2 references Exhibit B, so on and so forth. Currently using the above referenced method, the auto numbering lettering then follows as if the letters are a representation of the corresponding number (if that makes sense), ex: 1 B 3 C 5 D. How do I have the number sequencing independent from the letter sequence? Thank you in advance!
Numbers works in a fashion somewhat different from traditional spreadsheets like Microsoft Excel or Lotus 1-2-3. In the traditional model, the table is the first-class citizen of the system, acting as both the primary interface for work, as well as the container for other types of media like charts or digital images. In effect, the spreadsheet and the table are one and the same. In contrast, Numbers uses a separate “canvas” as its basic container object, and tables are among the many objects that can be placed within the canvas.[N 1]
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.
you'd need to use a before save macro. Something like the macro at the end - but it would run on every save, which may not be what you want. I use a macro that gets the invoice # and saves (it does several things). I added a button to the ribbon that calls a macro that runs several macros: Sub FinalizeInvoice() CreateInvoiceNumber CopyToExcel FinalCleanup ' this does the save End Sub This is an automated macro - but it will run every time the file is saved. Private WithEvents App As Word.Application Private Sub Document_Open() Set App = Word.Application… Read more »
It sure is possible! Numbering and Section options are available in the Pages Panel menu. These options allow you to define what page starts a section and how it should be numbered. Insert a Current Page Number marker (Type>Insert Special Character>Markers>Current Page Number) in a text frame on a page or master page (recommended), select the first page of your section, open the Numbering and Section Options dialog, and enter 200 in the Start Page Numbering at: field. Hope this helps!
Defined lists are often used to track paragraphs for numbering purposes. When you create a paragraph style for numbering, you can assign the style to a defined list, and paragraphs are numbered in that style according to where they appear in the defined list. The first paragraph to appear is given number 1 (“Table 1”), for example, and the next paragraph is given number 2 (“Table 2”), even if it appears several pages later. Because both paragraphs belong to the same defined list, they can be numbered consecutively no matter how far apart they are in the document or book.
Hi. Do you know if there is a way for these endnotes to restart at 1 with each new chapter in a single document? I usually work on 400+ page books with hundreds of end notes. The house style is for them to restart at 1 with each chapter. I am able to set this up in Word before importing to ID but they revert to continous in layout. I don’t want to have to set up multiple ID files.
Using the instructions in #5, add an incrementing SEQ field. You can highlight any of them, except the reset field. For step 7, enter n}. n is the default switch that inserts the next number in the sequence, making it easy to remember. You don't have to specify the \n switch, because it's the default, but you can add it if it helps document your choice.
When I want to add page numbers, I only get a number on page One (or on whatever page I'm on) and nowhere else. I tried everything. When I go to Page Number Setting and change it to start at page 2 and want to add page numbers to all pages, nothing happens if I stand on page 1, or I get a number on whatever page I'm on. But only there. Am I supposed to do all pages one by one?
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.
Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
A quick search at the top using the term “document numbering” shows 46 different threads, with very good advice, for the most part. I would first recommend you perform the same search and see what advice may be gleaned from those far older and wiser than myself. In order to directly answer your question, I would refer you to the following discussion thread. Many talk about the physical numbering system to use, which is important, and many discuss the frustration that a new person to the position feels when they inherit a mess from someone else and wish to clean it up.
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.
InDesign allows you to add a page number marker to a master page within the document. The master page functions as a template for every page it's applied to, so the consecutive page numbers appear on every page. InDesign updates the page number automatically as you insert, delete and move pages. To add a page number marker to a master page, create a text box on the master page by going to the Type menu and choosing "Insert Special Character," "Markers" and then "Current Page Number."
Step 4: Go to your coupons, page 1. Select the first text box (Command + Shift + Click to release from master page) and paste. The numbers will populate all of the boxes on that page (0001-0008). Now, here's where I'm not sure if I have a plugin doing this or not. The document should add pages to correspond to all of the numbers you have. If it doesn't (and it's doing it on mine because of a plugin), you can select the little red plus in the bottom right text box, add a page and hold down the shift key when pasting into the top left text box of page 2. That will add pages as needed.
NCR booklets for receipt forms and invoice forms are very handy as a copy of the form can be easily torn from the booklet and given to the customer, while leaving a copy in the booklet for the business. Pages are perforated for easy removal. A sturdy cover wrap maintains the booklet’s integrity and can be inserted between forms to prevent transfer when completing the form.