You probably know about Word's mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use the same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I'll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013.
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.

An overwhelming majority of companies use designation-based part-numbering systems. A Design Management Procedure, for example, may be numbered as SOP 4.4-1. With the previous revision of the ISO 9001 standard, it meant that this document related to the element 4.4, design management. Well, it does not mean the same with the new ISO 9001 revision, simply because design management clause now has a different number: 7.3. What is the solution? The solution is simple: no part numbers, and no designators!

I normally use "Data Merge" in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).
Scott, I was able to try this as I assumed that is what I needed to do. It does not work. First, the current macro for that button is a Save Record, Close Window operation. How could I keep this and also add Code? If I just add a new button to the form and under the On Click Event put the code you suggested, I get a compile error of “method or data member not found” and ” .txtPROJECT” is highlighted. The actual field is “PROJECT ID#” and it is a long integer number. Entry I have is: Private Sub Command88_Click()
So, if you wanted to use this idea in a form or datasheet, let me stop and first remind you – if this is going to be non-updatable, you can just embed a report as a subreport within a form and thus use Running Sum. But let’s discuss the case where you need to be able to edit data in the forms, even with sequential numbering generated for the data you are viewing. This means we need to be able to tie a sequential number to a specific row.
Hi Jason! Hard to say when I’m not sure which part isn’t working for you. If the numbering isn’t continuing across separate frames, you need to make sure you’re using a list. If they are in the wrong order, remember it uses the paste/creation order to number them. If neither of those fix it, let me know what specific issue you’re having. Good luck!
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 make the design with as many up as I need on the master page, linking the frames where the numbers will go. Then I make the list using Excel, copy paste to ID and apply a paragraph style with "start in next frame" option. Click the outbox on the pasted text to get a loaded cursor and delete the frame. Then just shift-click over the first textframe on a live page to have as many "tickets" added as needed automatically.
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.
I have been researching using sequential numbers for invoices an purchase orders, but all of them seem to advance the number eithe every time the document is opened or saved. My purchase order is par of a larger file, and since I will be opening and saving the fil without necessarily writing a purchase order I need more control ove its advancement. I was wondering how I could create a button that whe pressed or selected would advance the number by 1? Also, how could make it create a unique number depending on who's creating the purchas order. For example, let's say the user is ...
Numbers has been well received in the press, notably for its text-based formulas, clean looks and ease-of-use.[17][18][19] Macworld has given it high marks, especially newer versions, awarding Numbers ’09 four mice out of five. They did point out a number of common issues, especially problems exporting to Excel and the inability to “lock” cells to prevent them moving when the table is scrolled.[14] Numbers for the iPhone and iPad have received similar favorable reviews.[20]
As you can see, an idea of sequential numbering can be solved many different ways using different domains. This is typical in this field of work and precisely why it pays to not just consider how you can do it in one domain but also whether the domain is the right domain. We saw how we can easily leverage built-in features such as Transact-SQL’s ROW_NUMBER() or Access report’s Running Sum property. We also not only saw how we can craft our custom solutions in either VBA or SQL but we also see how we can use both together to create a solution that is better.
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:
If the second number on your raffle ticket is one higher than the first number, you must have accidentally put the <> tag after the first number (causing the next number, on the same ticket, to increase by one). You only need the <> after the second number on each ticket, so the next ticket gets a new number. (But you don’t need it on the final ticket on the **page**, because the next **page** automatically gets a new number)
I make the design with as many up as I need on the master page, linking the frames where the numbers will go. Then I make the list using Excel, copy paste to ID and apply a paragraph style with "start in next frame" option. Click the outbox on the pasted text to get a loaded cursor and delete the frame. Then just shift-click over the first textframe on a live page to have as many "tickets" added as needed automatically.

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.


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.
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...
You won’t use any of the standard List Number styles for SEQ field numbering. You need to create your own style if you want correct indentation and alignment with the tab position of the first word after the number. In this example, I’ll create a new style called Step Number, but you can call it whatever you want. In this example, I’ve also used the default settings for tab and hanging indent positions — you can change these later if you want.

I have a file that displays the text "Page 1" in the center of the worksheet. I have not been able to find a way to stop the page number from displaying. There is no header/footer, no "background", no other special items that I could find that would force the display of this. It does not appear during the printing so it's not a "watermark". It merely displays in my view when I'm working in the worksheet. Help... Hi you're in page break preview view ... choose view / normal from the menu Cheers JulieD "whalenohana"
2. Yes, The code should be entered using CodeBuilder. Where you enter it depends on how and when you want to trigger the generation of the next number. If you want to use a button, that works. And no, you don’t use 000 in the NZ() function. If you want to DISPLAY at least 3 digits with leading zeros, then you do that in the Format function. Note, though, you will need to change that when you hit 1000 POs.
My issue is trying to create small dot labels or equivalent to make up sequential alpha numeric labels to identify each individual item that I have in my shop, retrospectively. I have possibly 6-8thousand individual items that need coding for stock take purposes yet I can find no outlet that supply such thing. Do you have any suggestions. My line is antiques/collectables, predominantly china with items ranging in size from 2-3cm to 5/600cm. I would be most grateful for any solutions or suggestions. Best regards. Pete.
×