Michelle Castle began writing professionally in 2005. She has written technology news and tutorials for consumers, brochure and web copy for the Ehlers-Danlos National Foundation, and promotional materials for religious nonprofits including the International Pentecostal Holiness Church. Michelle has a Bachelor of Arts in English from Oklahoma State University.
Next we will look at scenario 2. The variation here is that Apex wants to start each year with anew sequence of numbers. Also, they want to include the year when displaying this number. We still use a DMax, but we need to add criteria to determine the year. So Apex needs to have a field in their table that indicates the date. Generally, such inquiries will have a date/time stamp to indicate when received or the user will input the date and time. So we will assume there is a field in record called InquiryDate. We will also add an Integer field named Sequence. On the form we will add a control bound to Sequence, but set its Visible property to No. The line of code will look like this:
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?
Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.
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.
Because invoices are not actually required under U.S. law, the creation of an invoice is only done at the discretion of the business. If you are dealing only with domestic clients and have an alternative method of tracking your business transactions, then a properly numbered invoice is not a necessity. However, as mentioned before, invoice regulation is very common in other countries – particularly those in the EU. Be sure to check the laws and regulations of any other country that you may be doing business with in order to stay compliant and avoid any trouble for you or your customers.
I need a running number from 1001-1200, so after I apply the print merge, it creates 200pgs of the voucher.When I try to save this file, it takes almost half an hour to do so.I think this is due to the heavy file size?In addition, the local print shop knows nothing about print merge and imposition, so I have to prepare the artwork readily in A3 size to print.The imposition creates a 10pgs files.I wanted to save this as PDF to preserve the color, but it turned out to be a nightmare (in daytime) for me that it takes more than2 hours to generate the 10pgs PDF.
Endnote numbering is sequential through the entirety of the linked text frames, treating them as one frame. When you add a new text frame that isn’t linked containing an endnote (such as a break-out or call-out box), InDesign will use an endnote number following the last number in the linked text frames. So if the endnotes in your linked text frames are numbered 1 to 50 and you add a break-out box on page 6, any endnotes in the break-out box will begin with number 51 (and appear totally out of sequence!).
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.

Typically the second option of saving as a CSV file is the one to choose for use with Data Merge. Click the create button to choose a file name and location, make sure that a header has been assigned and click OK. This creates the CSV file that contains the sequential numbers that can then be used in a Data Merge by opening the Data Merge palette, clicking the flyout and clicking Select Data Source…
If a manuscript has been compiled in Word, utilizing footnotes as opposed to Endnotes and . . . if a decision is belatedly made to switch from the footnotes format to Endnotes, can those footnotes be imported into InDesign as Endnotes (albeit with sub-headings manually applied) or does that conversion have to be made, first, in Word and then transferred, later, into InDesign?
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.
The heading here could be anything: affirmative defenses in an answer, articles in a contract, etc. It doesn’t matter; the technique is the same with only slight variations. The result is that you’ll have a heading saved in your Quick Parts that will be numbered correctly, no matter how many items you add or delete. This makes this technique particularly useful in building templates for common documents; because it’s always easier to delete than add, they’ll re-number themselves after editing.
Hi everybody. I am having a problem with a query that I am working on. I have a table containing customer names, trade dates, and dollar amounts. Customers can have multiple trades on the same day, sometimes even the same dollar amount. I want to have the table sorted by name, date, then dollars so the query pulls everything in from lowest/earliest to highest/latest. I was trying to make a query that pulled in the customer name and trade dates, then added a new column called "Row" that had the record number. I want the query to show all names and dates, since there are ...
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
I'm using Column A of a spreadsheet to number some items in Column B. I've been using Excel's automatic series-filling function, where you drag down from the lower right corner of a cell. However, since some of the rows in Column B are empty, and I don't want them numbered, I have to stop numbering and manually "jump" over the blanks in Column A. Is there a way to automatically number down in Column A, while skipping over the blanks and continuing where I left off? I.e. 1 2 3 4 5 ? Thanks much. Try this in A1: =IF(B1<>"",COUNTA($B$1:B1),"...
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.
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),"000-000") in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
If you work in a business where you need to sequentially number items, you might be wondering if there is a way you can use Word to create the labels for you. Word has many ways you can implement some type of numbering in your documents. For instance, you can use different fields for numbering, or use numbered lists, the captioning feature, or you can use mail merging. While all of these features (and more) use some type of numbering in them, they are not all well suited to creating labels.
×