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.

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.

Or, assuming you have a standard page number field in the header or footer, you could create a macro that goes to the end of the document, prints the current page, then goes to the top of the document, inserts a hard page break and repeats another 99 times. Would leave things a bit messy though. Don't save changes! laugh


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.
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.

Hello! I already have automatic numbering set up (to change paragraph numbers automatically when paragraphs are moved within a document) but I would also like to have automatic lettering within the same document that is independent from the numbering. Example, paragraph 1 references Exhibit A, paragraph 2 references Exhibit B, so on and so forth. Currently using the above referenced method, the auto numbering lettering then follows as if the letters are a representation of the corresponding number (if that makes sense), ex: 1 B 3 C 5 D. How do I have the number sequencing independent from the letter sequence? Thank you in advance!
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.
Joshua, I described this problem in my post #5 — the footnote settings are doc-global. I know no present solution to your problem — which is why we still need Adobe to code a counter! And we also need to be able to set up footnotes which are frame-wide, not just column-wide. And, natch, we need headings which are frame-wide, spanning multiple columns — so the ID engineers can’t retire quite yet. :-)
A sequence is said to be monotonically increasing, if each term is greater than or equal to the one before it. For example, the sequence {\displaystyle (a_{n})_{n=1}^{\infty }} is monotonically increasing if and only if an+1 {\displaystyle \geq } an for all n ∈ N. If each consecutive term is strictly greater than (>) the previous term then the sequence is called strictly monotonically increasing. A sequence is monotonically decreasing, if each consecutive term is less than or equal to the previous one, and strictly monotonically decreasing, if each is strictly less than the previous. If a sequence is either increasing or decreasing it is called a monotone sequence. This is a special case of the more general notion of a monotonic function.
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.
I need a way for the priority level to automatically adjust when I add or change an item with a new priority level. I might have 6 tasks, each will have a different priority. If I add one and set it to 1, the others need to increment + by one digit. Adding one to the above the highest would see no change in the others. Adding one in the middle would spread the rest apart (e.g. I have a 3, I put a new record and put it at 3, the old 3 becomes 4, and so on (everything below it would increment one digit).
Here, you’ll be given the chance to name your AutoText entry. Name it carefully — for AutoText to work correctly, the first four letters of each of your AutoText entry names will need to be distinct, since these first four letters will be the prompt for Word to offer to complete the phrase for you. My suggestion is to use Interrogatories, Production and Admission as your names, but use whatever is convenient and memorable for you.

 I'm looking for a script for Laserfiche Forms that will query a database and pull the next number in sequence and display it as the unique identifier for this document.  Once this number has been used, the number should not be used again.  This is similar to what the Submission ID is, but from what I can gather, this number is assigned after the submission takes place.  


OK I found the ControlSource property but it is on the Job No text box, do I enter the code there or am I entering my code on the button I created to save and get new number? If I put it behind the button, when I open the form it goes to the first record so I go to the last record and hit save get new number button and it gives me the number 1……Is it because when I open the form it goes to the first record and not a new record????


Adobe Amazon apostrophes attachments Audacity blog scraping christmas cards citations color contractors converters corporate gifts cross references digital archives donations eBooks ergonomic chairs error messages Excel Facebook fields figures file extensions find and replace fonts formatting freeware graphics HTML entities image capture images jet keyboard shortcuts litigation macros mail merge malware matrix mcse msde newsletter online libraries pixels plagiarism plain language podcasts PowerPoint QAT reference material references royal flying doctor service RSS scams screen capture screenshots search results SharePoint shareware signs SnagIt SQL Express star symbol table of contents tables Telstra toc track changes utilities Visio warnings web design Web development wildcards Wordpress themes YouTube
It will ask for the number of copies that you want to make and sequentially number each copy.The first time this macro runs, the first copy will be numbered 1 and when it finishes running, it will store in aSettings.Txt file the number that is one more that the number on the last copy.The next time the macro is run, it will start numbering the copies from that number. If when you first start, you want the numbers to start at some number other than 1, run the macro, entering 1 as the number of copies and then open Settings.Txt file and replace the number in the file with the number that you want as the first in the series.At any time thereafter, if you want the series to start at a particular number, you can open that file and replace the number in it with the number that you want to be the first in the series.
Add numbers by inserting the same identifier at another location. Alternatively, copy the first one, select it and press “F9” to update the display. As a third option, you can use the keyboard shortcut “Ctrl-F9” and type “SEQ” and your identifier between the braces that appear. For instance, insert “{SEQ mynum}.” Press “F9” to update the field and enable the number to display.
If you are still reading this then perhaps you are looking for a simple and reliable way to number a couple of lists in a Word document. If you read John's article then you have already been informed that field numbering is simple and robust. If you are like 9 out of 10 Word users in my office then anything more than 1. space space Blah, blah "enter" 2. space space Blah, blah ... defies simple! If that applies to you, then the "SeqField Numbering" Add-In presented later in this page is for you.
I have Office 2003 installed to Windows 2003 terminal servers but I have a problem with on of our users and excel. The issue is that when the user is trying to have multiple spreadsheets opened he keeps getting the message "This operations has been cancelled due to system restrictions- Contact your system Administrator" I can find no setting in excel to enforce a limit on the number of speadsheets a user can have open. Thanks in advance fo any advise Michael Not an expert in these matters, but; Is it possible that the user is trying to initiate another session of Excel vs....
All I want to know is, how do you link fields, like {SEQ}, to a style – so that if I select/apply style “Figure Caption” (my style, I also have “Table Caption”), I get not just the attributes of the style (what it looks like, where it is on the page etc.) but I get a chapter (or section) number + a sequence number added, (e.g. “2-3”). I know about STYLEREF and SEQ Figure # and/or calling a section number (if required) – but I can’t find out how to take the simple and to me obvious step to have sequential numbering (prefixed with either “Figure” or “Table”) attached to my Figure Caption style. It all seems to be a two-step process: (i) select the style, (ii) select the numbering. I want to do both at style level. I want to see/get (e.g.) “Figure 2-3: Linking figure numbering to styles” just by applying my “Figure Caption” style to my figure caption text “Linking figure numbering to styles”. Please, only tell me how to do that, how to link chapter/sequence numbering via a style – i.e. in just one step – applying the style.
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:
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.

Footnotes, after all, are always numbered sequentially and update when you add or remove one. The problem is that each time you add a footnote you get an extra space down at the bottom of the column. The solution? Make a paragraph style for your footnotes that specifies a .1 pt tall size with a 0 (zero) leading, then choose that paragraph style in the Document Footnote Options dialog box.
You can define a section prefix to label section pages automatically. For example, if you specify A– for Section Prefix on page 16 of a document and include the section prefix, the page will appear in the table of contents or index as A–16. Text you type for a section marker appears when you choose Type > Insert Special Character > Markers > Section Marker.
OK, First, you need to reread the blog. You should NOT be storing the Transaction_ID. It is a calculated value. Second, your naming is what confused me. Your Passenger table should have an autonumber PassengerID. That PassengerID should be the Foreign Key in your Reservations table. Your servation table should also have an autonumber for ReservationID. I really don’t see why you need sequential numbering in the passenger table. I can understand it in the Reservations table, but not in the passenger table. Also, I don’t see any reason for a transaction date in the passenger table. I can understand a CreateDate for when the passenger signed up.
If you use the Form Wizard, controls will be named with the field name the control is bound to. But that name can be changed. This trips up a lot of people because my code samples use a naming convention that is not what is automatically generated. So you just need to make sure you use the correct name for the object. The name is shown in the Name property on the Other tab (Not the Caption property). To determine what field in your table the control is bound to check the ControlSource property. It should be bound to the PONum field.
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).

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.
Become a Microsoft Word power user in just a few minutes a week. This tips-based series helps you deepen your proficiency with Word, covering a variety of tools and techniques you can use. Learn how to work with templates, format documents, customize built-in styles and themes, master Track Changes, and more. Check back each week for a new pro tip from expert David Rivers.
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much 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:

Other examples of sequences include ones made up of rational numbers, real numbers, and complex numbers. The sequence (.9, .99, .999, .9999, ...) approaches the number 1. In fact, every real number can be written as the limit of a sequence of rational numbers, e.g. via its decimal expansion. For instance, π is the limit of the sequence (3, 3.1, 3.14, 3.141, 3.1415, ...). A related sequence is the sequence of decimal digits of π, i.e. (3, 1, 4, 1, 5, 9, ...). This sequence does not have any pattern that is easily discernible by eye, unlike the preceding sequence, which is increasing.
i have gone through the intersting discussions on this site. I am having a problem with foot notes in Adobe in design cs 4. when i pasted a fresh set of pages in a doc in- in design, the fn numbering starts from 1 all over again in the fresh set of pages. i am not able to insert foot notes manually, as it does not creat the space below the text. I am stuck for help
Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...
So, as an example, I’ll start with the style linked to the interrogatory in my multi-level list, type my question, hit return and I’ve got the answer space. Return again, another interrogatory ready to go. Wanted request for production instead of interrogatory? Hit the tab key and it switches to the next list level, which is request for production. (I hope I’ve explained this well enough.)
Can anyone tell me what the maximum no. of worksheets is in Excel? Ton From Help...Limited by available memory (default is 3) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Ton" wrote in message news:EB5EE739-9250-4D83-AA7C-EE82C02C0AA3@microsoft.com... > Can anyone tell me what the maximum no. of worksheets is in Excel? The maximum number only depends on the amount of memory available. -- Best Regards Leo Heuser Followup to newsgroup only please. "Ton"
A3 is the result of A1/21 I want to bracket the number in A4 In MSWorks I would type the statement ="["&string(A3,0)&"]" In excel I get in some cells [1.436871259834] I'd like it to read [1] Help please. -- rodney@touch88gum.com.au (Remove gum to reply) Rodney, ="["&ROUND(A3,0)&"]" -- HTH, Bernie MS Excel MVP "Rodney" wrote in message news:OkME4oGVEHA.2564@TK2MSFTNGP11.phx.gbl... > A3 is the result of A1/21 > I want to bracket the number in A4 > In MSWorks I would type th...
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.

I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I'm also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.

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


A variety of printing products use sequential numbering printing. Carbonless forms, invoices, receipts, business forms, contracts, purchase orders, office documents, event tickets, packaging and more all use sequential numbering.  The numbers can also be printed twice on the media if required. They can be printed in any color, but are often printed in black or red to make them stand out.
Bottom Line – So, is there: (1) any way to “save” “Auto Text” entries (or similar) so that several people in the office (i.e. attorney, paralegal, secretary, etc.) can “share” and have access to the same set, and thus work better as a “team”?; and (2) if/when a set of “Auto Text” entries is so saved and created, is there any way to keep it “alive” and “safe” so it “survives” the (inevitable) series of computer updates, fixes, server crashes, etc., that will happen over time in a law office (and even several times during the life a litigation case that may last two years or more in an office)?.
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.

That’s enough tips for now. You’ll be filling your fundraising thermometer template How to Create Your Custom Excel Fundraising Thermometer Template How to Create Your Custom Excel Fundraising Thermometer Template Use an Excel thermometer chart to visually keep track of your financial goals. Whether you're saving for a new gadget or fundraising for a good cause, here's a step by step tutorial. Read More in no time. Let’s get to the tickets.
An InDesign document can only have one chapter, and these chapters are typically combined in an InDesign book. To insert a chapter number, create a text frame where you want the chapter number to appear on either a document or master page. Click on the "Type" menu, then "Text Variables," "Insert Text Variable" and then "Chapter Number." Update the chapter number if necessary to keep your chapter numbers consecutive by clicking on "Numbering & Section Options" in the Layout menu.
This one is EASY. In InDesign, with a one-sided NCR form, cut the all elements from the first page. Go to your Master page and place. Where you are going to number the forms, draw a text box and insert a page number marker there. Format it to your liking, then insert as many pages as SETS are going to be made. When you go to print, enter 2 or 3 in the copies box, depending if it's 2-part or 3-part and under the properties button, select GROUPED or UNCOLLATED, turn off OFFSET. Violá!
Since Word 2000 applies outline numbering by default, as you press TAB or SHIFT+TAB in a numbered list, you are moved to the next or previous outline level. If you are in a numbered list that has outline numbering generated by the method described in the previous exercise, when you choose Bullets and Numbering from the Format menu (or alternate-click a portion of the numbered list), the Numbered tab appears on the Bullets and Numbering dialog box. However, if you first select the entire list and choose Bullets and Numbering from the Format menu, the Outline Numbered tab from the Bullets and Numbering dialog box is selected.
With this expression we check only for records that are in the same year as the Inquiry date to increment the sequence. Again, the NZ function will automatically restart the sequence with each year. Cleary, though, we cannot generate this number until the InquiryDate has been entered. Is this value is a user entry, then you may want to check that it’s filled in before generating the number. Something like:
×