Ah, that’s the con – this works beautifully when you are in fact exporting data but when you are viewing the query’s output in a datasheet or a form, as you scroll around, Access will be re-evaluating the rows, including a call to the RowNumber(). But when it repeatedly calls RowNumber(), of course it keeps incrementing blindly, without any regards to whether a number was already generated for that row.
Starting an auto-numbered paragraph is deceptively simple. See those buttons on the top row of the Paragraph section of the Home tab? The left-most one is for bullets; the next two to its right are for numbering and multi-level numbering, respectively. Simply click the button to toggle the feature on, or click on the drop-down arrow on each button to select a specific style. If you don’t like any of the delivered choices, you can click Define New to set your own.
Yes, I have used this system in a multi-user setting. As noted, the key is to commit the record immediately after generating the sequence. However, if the application is one where there is very heavy transaction processing. In other words dozens of users creating records simultaneously, you might want to guard further against duplication. At the speeds computers process, it is not impossible that multiple users will grab the max value before it can be incremented and saved.
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.

 Does anybody have an easy way to set up sequential numbering in Coreldraw? Our shop has to lay out unit number plaques for vinyl cutting and sometimes my employee has to manually type in hundreds of numbers. I've read all the print merge suggestions for raffle tickets and such but I need the numbers entered into an object and not during the print process. 
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...

With the numbered paragraphs shown above, there is no extra spacing between the paragraphs. That’s easy to fix. Go ahead and type out at least part of your first numbered paragraph, then go to the Page Layout tab and adjust the value of Spacing After in the Paragraph section. Still no extra space? There’s one more setting to check. Click the launcher arrow in the lower right-hand corner to go to the Paragraph dialog box, uncheck the box next to “Don’t add space between paragraphs of the same style.” Click OK. That paragraph and all the remaining numbered ones will have more breathing room.
If you’re a self-taught InDesign user, you may not have been introduced to automatic page numbering, one of the biggest time-saving features in the program. InDesign allows you to set up the page numbering feature in your Master Pages. Then, as you add or shuffle pages, InDesign updates individual page numbers accordingly. You can style the page number any way you like.
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.

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...
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Thank you for your reply.  It reassured me that I was on the right path. From having read other Help texts, I guessed that I would have to use good ole mail-merge and set up a numbers list in Excel. Luckily my knowledge of Excel was good enough to know about the drag&drop for sequential immediate numbering. When it came to the crunch, it was this particular type of mail merge which gave me a bit of initial difficulty. Despite my having used it happily and often in Word, for labels in Publisher, it was - not surprisingly - different in certain respects; principally the crucial point of the Print stage, which necessitated finding the option Publications & Paper Settings, and selecting 2 specific parameters, namely (1) Multiple pages per sheet,  (2) Single-sided printing (my default double printing had appeared). Once I'd sussed this, it was plain sailing.  Thanks again.
If you want numbered headings to be underlined, but do not want a line under the number, it can be difficult if you don't know how it works. This is because by default, the format of the number follows the format of the text that follows it. For example, let's say you want to underline a paragraph in a Heading 2 style. Chances are it will look like this:
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.
To recap, you use a DMax function to return the highest number in the Sequence and increment it by 1. You assign the incremented number to a control on your form and then immediately save the record. If your identifier includes additional information from the record, you use an expression that concatenates that information with the sequence number to display the full identifier.
    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.
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.
Add specific codes to coupons to track customer responses     Use different codes for your different marketing messages, advertisements, or promotions. These codes will enable you to keep track of how customers learned about your offer. The more you learn about who is drawn to your business and what attracts customers' attention, the better you can focus future marketing efforts.
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!
You may wonder whether typing 1, 2, and 3 would be easier than using the ListNum field. Although doing that may be easier initially, the value of using the ListNum field becomes apparent when you cut and paste. When a paragraph contains multiple numbered items that you move or delete, Word automatically updates the ListNum fields. Using ListNum fields assures you of accurate numbering within a paragraph throughout the document.

Hi! I hope you help me with this. I have the almost same problem as #2. I have PassengerTable as table name, then I have the following fields: sequence (to follow what you have in your post), transaction_date, and transaction_ID. Basically I want the to have sequential numbering in the transaction_ID where month and date from transaction_date is shown. i also have a generate (Command27)button as trigger.Tried the code with few modifications, but it sequence doesnt populate, and doesnt show any, except for what i have in control for transaction_ID which is the “Format(transaction_date,”yyyy-mm”) & “-” & Format(sequence,”000″)” and this only shows the year and date, so instead of 2015-08-001 it shows 2015-08-.
As I indicated, because you want to only generate this number just before saving, I would put this code behind a Save button or another event that runs just before you save the record. So if you want to prevent duplications, you don’t use the expression as a control source, but put the code behind a button or event. Since you have a Save button, put it there.
Klaus Nordby, one of our good-natured Norwegian hecklers, has produced a ray of sunshine in the midst of a deep, dark Scandanavian winter by coming up with a wonderful little trick involving adding sequential numbers inside a paragraph. For example, 1. this is the first clause of this sentence; 2. this is the second; and 3. this is the third. That’s not a big deal to type, of course, but if you had dozens of them and you needed to insert or remove numbering frequently, doing it manually would be a hassle.
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...

2. In Word 2007 & later, if you put the macro into your 'Capital_Unit_Certificate' document, you'll need to save the document in the docm format and you'll need to enable macros whenever you open the document if you want to print the certificate. Alternatively, if you add the macro to Word's 'Normal' template, the macro will always be available (to you only) an you can keep the document in it's docx format - plus you won't get macro warnings every time you open it.


In summary, paragraph numbering is really just an exercise in logic, and this blog post is showing the numbering styles for a very specific project. Your project may be similar, but not exactly the same. You just need to think though the levels and how you want to restart the numbers. I do my best to think it through correctly the first time, set it up, and then try as hard as I can to break it, so that I can find my errors. The good news is that once you get your numbers working, you shouldn’t ever have to think about it again.

Some drawbacks to this feature are that you lose a little control when you are typing. Word formats for you and some users do not like this. Also, on certain items, you will get a number when you do not expect or need one. For example, you have an attorney whose name begins with an initial (A. George Smith). When you type the name and press ENTER, the first initial "A." converts to an automatic number.
A note about link exchanges. This site does not participate in link exchanges to build web presence. If you have a link that you think would be of use to people reading this page, please send it to the webmaster with the url of the page where you think it should appear and it will be considered. Your placing a link to this site will not affect the decision on whether to add your link, though.
You can also insert a page number inside existing artistic or paragraph text. If the text is located on a local layer, the page number is inserted on the current page only. If the text is located on a master layer, the page number becomes part of the master layer and appears on all pages where the master layer is visible. For more information about artistic and paragraph text, see Adding and manipulating text.
Hello, can anyone help me with making serial numbers in this way: When I purchase 10 chairs, I want to monitor all of it by having serial numbers each of those 10 and those 10 numbers should have the prefix “CHR-” if they are chairs. “TBL” if tables, the codes are associated with the item category. BTW, items have categories predefined by beforehand on the items by relationships. So when I will want to monitor these 10 chairs, I will only have to click the “generate control numbers” button and each of those purchased items get their own control numbers.
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks....
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
In summary, paragraph numbering is really just an exercise in logic, and this blog post is showing the numbering styles for a very specific project. Your project may be similar, but not exactly the same. You just need to think though the levels and how you want to restart the numbers. I do my best to think it through correctly the first time, set it up, and then try as hard as I can to break it, so that I can find my errors. The good news is that once you get your numbers working, you shouldn’t ever have to think about it again.
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Hello, can anyone help me with making serial numbers in this way: When I purchase 10 chairs, I want to monitor all of it by having serial numbers each of those 10 and those 10 numbers should have the prefix “CHR-” if they are chairs. “TBL” if tables, the codes are associated with the item category. BTW, items have categories predefined by beforehand on the items by relationships. So when I will want to monitor these 10 chairs, I will only have to click the “generate control numbers” button and each of those purchased items get their own control numbers.
You can insert page numbers on the current page, all pages, all odd pages, or all even pages. When you insert page numbers on multiple pages, a new master layer is automatically created, and the page number is placed on it. The master layer can be an all-page master layer, an odd-page master layer, or an even-page master layer. For more information about master layers, see Creating layers.
 Does anybody have an easy way to set up sequential numbering in Coreldraw? Our shop has to lay out unit number plaques for vinyl cutting and sometimes my employee has to manually type in hundreds of numbers. I've read all the print merge suggestions for raffle tickets and such but I need the numbers entered into an object and not during the print process. 
Creating a sequential list of numbers, in Word, sounds like an intimidating task. Sure, you can create a numbered list quickly enough, but that feature works with additional text - you're numbering something. If you want a list of just numbers, you have to work a bit harder. Word's SEQ field might come to mind, but that solution is better suited to template-type numbering. In order words, this field works great if you're numbering documents, labels, and so on. It doesn't work so well if you just want to create a list of sequential numbers. You can use it that way, but it'll be more work than it's worth.
×