The Renumber/Refresh List toolbar command is used to renumber an existing numbered list or to refresh a list after editing. For example if item 3. is deleted from a list by editing then you can use this tool to refresh the list. You can also use the Renumber/Refresh command to number or renumber a selection of list paragraphs with any chosen starting number.
i have used batch process to make a whole bunch of photos one size.  I need to create a single 'photo wall' jpg out of them in which they're all tiled, the long way of doing this is to obv open them all and copy, paste into the psd, then flatten, but thats really, really time consuming.  If photoshop had any type of auto import & tile feature?  I may have to do this a 2nd time with 1000's of images.
By omitting the dbFailOnError parameter only for the DROP TABLE statement, we won’t get a runtime error about a table not existing but get runtime errors if we can’t create the table or insert data for some reasons. I’m also not a big fan of creating multiple saved queries that are meant to be logically grouped together – it gets quite cluttered when there are several saved queries in a navigation pane like that. Keeping it all in VBA makes it clearer that the intention is to execute those statements together.
No matter how light the file might be, if you need 1000 units, that means you send a 1000-page file to the printer if you use Data Merge, that is not as efficient as sending one page and 1000 numbers to insert in the print stream, but to do that you need a plugin, which is what that page Bob directed you is leading up to. I've never used the program Harbs has mentioned, but he's a pretty smart guy and if he says it works well, I'd take a look.
You can control whether your next paragraph number continues the current sequence or starts again at 1 within that same right-click menu. If one of your numbers gets out of sequence, simply right-click and choose Continue Numbering. If you want to force the number back to the beginning (say, you’re switching from interrogatories to requests for production), choose Set Numbering Value (which will also give you the option of continuing the previous list).
It's also possible to consecutively number list items in InDesign. Create a text frame for your list and click the numbered list button to insert a list. Type your list items, pressing your "Enter" key between items. InDesign consecutively numbers the list automatically; you can change the number it begins with and the style of the numerals. Press your "Alt" key (Windows) or "Option" key (Mac OS) while clicking on the numbered list button to open a dialog where you can modify those options.

Word's numbering feature is easy to use, but it doesn't work in all situations. For instance, it can't handle an inline number sequence. By inline, I mean a sequence of numbers positioned within regular text. Fortunately, the SEQ field code handles these situations. I'll start by showing you how to insert the SEQ field code manually, for those one-time occurrences. If you use this feature often, you'll want to add AutoCorrect items for quick insertion into your text. So we'll look at that, too.
When typesetting a book, it’s often necessary to insert a forced line break in a chapter title. Let’s say your chapter title runs to two lines, and it isn’t breaking in a great place. What do you do to fix it? You add a forced line break (soft return). But later, when you automatically generate your TOC, the TOC will have forced line breaks where they aren’t needed. In the past, those forced line breaks had to be removed manually every time the TOC was generated.
Ok I guess it is better for me to explain what I am doing. I am in the process of creating an Access Database that an individual has been using an Excel spreadsheet forever and a day. Well the individual has on occasion doubled up numbers, forgot numbers, etc. So on what I have learned from different Access courses and Google searches I am trying to apply my knowledge.

I answer readers' questions about Microsoft Office when I can, but there's no guarantee. When contacting me, be as specific as possible. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results?" might. Please mention the app and version that you're using. I'm not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at susansalesharkins@gmail.com.

The blog is pretty much step by step. Where it may not be that specific is, because, these are decisions the developer needs to make. For example, where to put the DMax expression is a matter of your workflow so I can’t tell you where to put it. I’ve given tips in the blog to help you decide. If you are having issues, then please give me more info about your application and I can suggest things.
Rhonda, Thank you for your amazingly quick and thorough reply! You are correct, Word does the Table and Figure numbering splendidly. I was trying to reference those numbers in the text, which I see is a function done quite well in Word using Cross Reference: ‘In Word 2007 and 2010: Display the References tab. In the Captions group, click on the Cross-reference button.’ Thanks again, Joshua.
Each document in your book can be numbered, and these numbers can be used as automatic chapter numbers. Automatic will increment from the previous document’s number, or you can choose “Same as Previous in Book” if it’s still the same chapter but broken into two or more parts, or you can arbitrarily number it anything you want to. This can save time if you have a large number of chapters that change order frequently, since the numbers will update automatically.
    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.
To create a running list—a list that is interrupted by other paragraphs or that spans multiple stories or documents—create a paragraph style and apply the style to paragraphs that you want to be part of the list. For example, to create a running list of the tables in your document, create a paragraph style called Tables, make a defined list part of the style, and then apply the Tables paragraph style to all paragraphs you want in your Table list.
So I spent some time trying to figure it out, playing with Normal.dotm and the various styles (List paragraph, List Number, List Bullet etc etc). And finally, when I've got Normal.dotm open (i.e. I'm editing that template file), I get my result: I apply a standard numbered list, and it comes up flush left (i.e. not indented) and hanging at 1.0cm (cos I don't use inches...) and with a tab stop applied at 1.0cm as well - funky stuff!

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:
By omitting the dbFailOnError parameter only for the DROP TABLE statement, we won’t get a runtime error about a table not existing but get runtime errors if we can’t create the table or insert data for some reasons. I’m also not a big fan of creating multiple saved queries that are meant to be logically grouped together – it gets quite cluttered when there are several saved queries in a navigation pane like that. Keeping it all in VBA makes it clearer that the intention is to execute those statements together.
Auto-Number is a very easy to use software program developed by a printer (35+ years in the industry) to eliminate manual or letterpress numbering. The program will print up to sixteen numbers in any location, increment and duplicate. No Experience Necessary! Any person with basic computer skills is able to master this software within minutes. We’ve included set-up templates for the most common jobs. Use as is or modify them to your specs.
While InDesign veterans may assume everyone already knows this, I can assure you I have worked with very sophisticated documents from designers who did not take advantage of this basic feature. A good rule of thumb to keep in mind as you tackle InDesign challenges is this: If it’s repetitious, tedious, or time-consuming, there’s probably a built-in solution right there in the program. You just need to go look for it.
In this situation I would suggest using an Alternate Layout. Once the content is final, choose Create Alternate Layout from the Pages panel menu. Make sure to create the new layout the same size and orientation as the original and then use the Numbering and Section Options dialog to specify the numbering required for the second catalog. The Print dialog will then let you select which layout to print.
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.
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.
This difference is not simply a case of syntax. In order to provide a large workspace, conventional spreadsheets extend a table in X and Y to form a very large grid – ideally infinite, but normally limited to some smaller dimension.[N 2] Some of these cells, selected by the user, hold data. Data is manipulated using formulas, which are placed in other cells in the same sheet and output their results back into the formula cell’s display. The rest of the sheet is “sparse”, currently unused.[5] Sheets often grow very complex with input data, intermediate values from formulas and output areas, separated by blank areas. In order to manage this complexity, Excel allows one to hide data that is not of interest,[6] often intermediate values. Quattro Pro commonly introduced the idea of multiple sheets in a single book, allowing further subdivision of the data.
Now, what’s the deal with the UniqueKeyVariant parameter for the RowNumber() function? We are not even using it all! True, but if we didn’t, Access will call RowNumber() only once for an entire query and thus we get “1” for the entire dataset. That is a good way to save on CPU processing – why call Now() for each row? In this case, we want to go against this CPU-saving measure and ensure that the RowNumber() is in fact called once per row to generate a new number for that row. Thus, we pass in a parameter — a primary key of a table is a good choice for this purpose. So we get a nice sequential number generated all in the query with VBA function.
You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free trial of Office Tab!
If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.
×