Perhaps your explanation already addresses this, but I can’t see it. Is there any way this script can be used for printing multiple-up in numeric sequence? For example, if I’m running 1000 postcards 4-up (on 250 sheets). I need the 4 cards on page 1 to be numbered 1, 251, 501, 751; then the 4 cards on page 2 numbered 2, 252, 502, 752; etc., so that when the sheets come out of the printer and are cut into 4, I have a stack of 1-250, a stack of 251-500, a stack of 501-750 and a stack of 751-1000.
we have printed AP checks using the check number from 0000000001 to 0000000006, but we havent posted those batches. we have only one checbook. Now can we restart the check number from 000001. Then do we need to delete the previous batches for checks printed. What is the best approach in this regard. Thanks in Advance, Arun. In the Post Payables Checks batch window (Transactions > Purchasing > Post Checks), choose the batch in question, then select Reprint Checks from the drop-down list. Enter 000001 for your starting check number. You will also need to go ...
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 tossed back a rather glib answer about using the AutoNumLgl field code to number the discovery requests, and she threw in this little wrinkle: her attorneys like to play mix-and-match with their discovery. In other words, they may put in a couple of interrogatories, then throw in a related request for production, then another interrogatory, then a request for admission that’s related to that interrogatory.
Determine what kind of numbering you want to use for your document or book. For long documents, you can assign chapter numbers. Each document can be assigned only one chapter number. If you want to use different numbering within a document, you can define ranges of pages as sections; these sections can be numbered differently. For example, the first ten pages of a document (the front matter) might use Roman numerals, and the rest of the document might use Arabic numerals.
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:
Specifically, 8 to 10 times in my career, I have set up a robust set of MS Word “Auto Text Entries.” Some, short phrases as in this article (e.g. “Interrogatory No. __,” “Long Corporate Name of Client, Inc.,” etc.). Some large blocks of text, paragraphs, or formatting chunks (e.g. Memorandum Start (To:, From:, Date:, Subject: etc.); Caption Block for [Local] Court; Signature Block; Certificate of Service, etc.).
This chapter (web page) takes you through how numbering is supposed to work in Word and the various controls. It is useful, but primarily on SEQ fields and simple numbered lists and also as reference showing the menus, dialogs and controls and going through the concepts for outline numbering. To actually set up outline numbering that works, refer to the Kelly and McGhie articles.
One option, of course, is to print the individual copies of the document, making the edits to the copy number between each print. This gets tedious, real fast. You may also want to utilize a sequential numbering field (as discussed in other WordTips) and make the number of copies equal to what you need to print. Thus, if you have to print 25 copies, you could simply copy the entire document (including the sequential numbering field), move to the end of the document, and paste it in another 24 times. This makes for a rather large overall document, however, and there are easier ways to approach the problem.
Tip  Follow the same steps (above) to create Request for Production or Request for Admissions. The only difference would be in Step 3, you would change the "rog" to "rpf" or "rfa". This will keep unique numbering schemes running in the same document. Therefore, you could have an Interrogatory No.1 as well as Request for Production No.1. Keep in mind that if you cut, copy or paste sequence codes, you'll need to select them and press F9 to update the field codes. They do not update automatically.

The expression: Nz(DMax(“[PONum]”,”tblPO”),0)+1 will check if a PONum already exists. If it doesn’t it returns a 1, if it does it returns the number incremented by 1. If the number exists, but is 0 it will return a 1. In my blog I advise that number should NOT be generated until the user is ready to save the record. And to immediately commit the record after generating the number. Therefore, there should be no issue about giving them a new number if they go back to it.
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:

Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
Clicked standard Mac Office upgrade yesterday, now Entourage is disabled because of message the reads This installation of Microsoft Office X exceeds the number of installations permitted by the license agreement. User name is already using this installation of Microsoft Office X. The program will now quit. I have MS Office package with 3 product keys. I'm using my laptop now, but originally it was installed on my primary desktop Mac. What's the solution to this problem? SHould I be concerned about preserving my emails -- on Entourage, if I need to reload software? Please advise....
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.

Step 2: Create a new doc for your numbers. Using Paragraph/Bullets and Numbering choose Numbering and set the Format to the 4 digits you've indicated in your sample. In the box below Format, remove the ".^t". This will remove the period & tab after the style. With that style set, hit return to create a number. Repeat for as many numbers of coupons you'll have. You can create 10 and copy & paste for however many numbers you need. You could possibly create your numbers in Xcel, but I'm instructing in ID only.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
You will occasionally want to place an unnumbered paragraph in the middle of a sequence, but the moment you hit Enter, another paragraph number pops up. To fix this, toggle paragraph numbering off by pressing the paragraph numbering button you used for the previous paragraph. (If you use the button’s drop-down, choose None as the numbering scheme.) Unfortunately, the paragraph settings won’t revert to Normal here; it’ll usually have the paragraph indented 0.25. Use the keyboard shortcut CTRL+Q to strip paragraph settings out, then revise the formatting as you wish.
Is there a way to have page numbering span multiple worksheets in a file? I would like to be able to print all the worksheets in a file and have the page numbers in the second worksheet pick up where the page numbers in the first worksheet ended without having to manually adjust the start point in worksheet 2. Please response back to the group. Thanks. JWeinberg I assume the page numbers are set up in your header/footer. If this is correct then all you need to do is select all the sheets you want to print by clicking on each sheet tab while holding down the control key. This will the...

All of this happens in the Bullets & Numbering dialog box, shown below. You will definitely want to use paragraph styles for this. My first one is called Chapter title. You will need to begin by changing the List Type to Numbers for all of the levels, and you must both name the List and use the same named list for all Levels. You do this by selecting the List > New List.


So if you encountered this problem, then you didn’t follow the instructions completely (which is OK) and appear to be automatically generating the number whenever the record is accessed. If that’s the case, then you are risking duplication because you are not saving the generated number immediately. Rather then try to test if a number already exists as you seem to be doing, you should not automatically generate the number, but trigger the generation from some action in the form.
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
I’d like to use this for Exhibits/Appedices. If we refer to the same Exhibit # in a footnote or elsewhere in the document, and then the Exhibit reference is moved, it causes an error in the footnote or reference. Is there a way to cross-reference this, or to have it cross-reference automatically? Lawyers want to use this but I can’t see them bothering to cross-reference the footnotes. Thanks.
Design your ticket, use excel or libre's version and create the numbers. Save those numbers as text, I always make the first one xxx then 001 and so on, xxx will be the master page. Use data merge from Indesign to create the master ticket, you will need to make a text box for the number. Once it looks good to you draw a text box around the whole ticket. At the bottom of the data merge tab is a button that gives you the options how you want your layout, columns or rows, etc. even has a preview. once you click create it will create another file with all your tickets sequentially numbered. It'll be a couple of hours before I'm at work but can post the link I used to create these for the first couple of times.

Although sequences are a type of function, they are usually distinguished notationally from functions in that the input is written as a subscript rather than in parentheses, i.e. an rather than f(n). There are terminological differences as well: the value of a sequence at the input 1 is called the "first element" of the sequence, the value at 2 is called the "second element", etc. Also, while a function abstracted from its input is usually denoted by a single letter, e.g. f, a sequence abstracted from its input is usually written by a notation such as {\displaystyle (a_{n})_{n\in A}} , or just as {\displaystyle (a_{n})} . Here A is the domain, or index set, of the sequence.


There are a number of ways to denote a sequence, some of which are more useful for specific types of sequences. One way to specify a sequence is to list the elements. For example, the first four odd numbers form the sequence (1, 3, 5, 7). This notation can be used for infinite sequences as well. For instance, the infinite sequence of positive odd integers can be written (1, 3, 5, 7, ...). Listing is most useful for infinite sequences with a pattern that can be easily discerned from the first few elements. Other ways to denote a sequence are discussed after the examples.
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.
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.
Here is my problem. i have a series of 3 digit numbers that need to be cinverted to a series of 4 digit numbers using this following 722 needs to read as 5622 and in the next collum SV-7822 in the collum's to the right. what type of formula is this and how can i do it? The above is an example, i have a whole range of 3 digit numbers that need the exact. rules applied to all numbers. which is why i need a formula to do it. Help someone please!!!! I'm not completely clear on what your looking for but if 722 was in A1 in B1: = A1 + 4900 in B2: = ="SV-" & A1 + 7100...
Is there a way to code the special interrogatory numbers wherein the identify of documents is requested such that those specific special interrogatories (and only those specific special interrogatories) are automatically generated in a separate demand for production of documents? In other words if Special Interrogatory numbers 3, 6, 9, 12 request identification of documents, is there a way to code those special interrogatories so that within the demand for production of documents, those specific but individual special interrogatory numbers can be referenced?
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.
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. .
Hi Scott, I had a question regarding the sequential numbering Apex example…I am looking to automatically restart the sequence every month, which is not a problem using your example (i.e. changing the year to month in the expression). However, I would also like to add in a condition for year, so that the sequence restarts for each month of each year (i.e. my problem is for example that Feb 2011 last sequence number is 5, and then in Feb 2012 this becomes 6, where I would like it to be 1). I am wondering what the syntax would be. Thanks in advance, Lawn.
×