- [Instructor] In this week's Word tip I'd like to address a question I'm often asked by people working in tables here in Microsoft Word and that is is there a way to quickly have numbers automatically fill up cells in the table much like they might in Microsoft Excel when you have incremental numbers that need to appear by simple clicking and dragging the corner of a cell. Well, yes, it can be done here in the table in Microsoft Word. It's not done the same way but it is just as easy and we're going to do it with this file, LeafAndMortar Inventory 040. If you have the exercise files, open it up. Now, if you don't have the exercise files, just use one of your own tables. All you need is an empty column. You can see here on page one we do have a table for garden tools and inventory and we need to number these and instead going into each cell and typing in a new number that increments by one, we're going to use a trick to have it automatically fill up that way. On page two of this document you can see there's a second table for hardscaping tools, so we want to differentiate these numbers, so we might want, for example, hardscaping tools, their item numbers to start with the letters HT whereas the garden tools up above might need to start with GT and then the number. Keep that in mind as we now go to the column where we want the numbers to appear. All you need to do is select the entire column. In this case we have a header column with a label in there, item number, so we're not going to use the trick of going to the top and clicking when that arrow appears, instead we're going to select the cells where the numbers need to go. With them selected, now we'll go to the ribbon. With the Home tab selected, go to the Paragraph group and just go to the Numbering dropdown arrow. Don't click the numbering button, that's going to add the default number but click the dropdown. You'll see the different numbering options that are already in the numbering library. You can hover over those to see what it's going to look like. You can see the numbers incrementing by one with a period or with brackets. We could use Roman numerals, even lettering here but if we want our own numbers, we go down a little bit further and click Define New Number. Give that a click. You should see the number style one, two, three selected. Click that dropdown and if you wanted to use something other than one, two, three, like Roman numerals or letters, they're there as well but we do want to start with just plain old numbers one, two, three. And you can see what shows up down below. The number format is the number and then a period and we see a sample of what that's going to look like down below. Well, the first thing we can do is click in that field just to the right of the period and hit your backspace key to take it out, we don't need the period. Now, we can move over to the left side of the number by using the left cursor key or you can click if you want just in front of the one and here's where we can add things like letters. GT, for example, then a dash and if that's all we need, we'll see GT-1, two, three etc. all the way down the column. Maybe you'd like to add zeros in there, like 01, 02 etc. You can do that as well. Once you have exactly what you want, simply click OK and it's done and by the way, that number format is there going forward, so the next time you want to use it, it's going to show up in your numbering library in the document as a number format and if it's one you've recently used, it shows up on this list as well, so you can choose it any time you like. Just click in the background and close that up, click outside the table to deselect everything to see how easy that was to get incremental numbers that start with letters and a dash. Now, scroll down to the table on the second page. Now that you know how to do this, you're going to create your own number style that starts with HT, a dash, perhaps a zero and then incremental numbers by following those same steps on this table. That's your homework knowing what you know after this week's Word tip.
Author, trainer, and learning and development expert David Rivers has over 20 years experience helping government, hi-tech, and healthcare businesses increase their efficiency and productivity by integrating technology tools. With deep experience in Microsoft Office, elearning tools, and assorted productivity tools such as FrameMaker and RoboHelp, David is passionate about helping people improve their workflows to recover time in their schedules. His clients include Microsoft, Corel Corporation, Halogen Software, and the City of Ottawa. David is also a published book author on topics ranging from Photoshop to Acrobat and the Microsoft Digital Image Suite.
Specifically, 8 to 10 times in my career, I have set up a robust set of MS Word “Auto Text Entries.” Some, short phrases as in this article (e.g. “Interrogatory No. __,” “Long Corporate Name of Client, Inc.,” etc.). Some large blocks of text, paragraphs, or formatting chunks (e.g. Memorandum Start (To:, From:, Date:, Subject: etc.); Caption Block for [Local] Court; Signature Block; Certificate of Service, etc.).
Hi, In the disaster recovery plan we want to create a leg site and put a DC in it. Here are some questions on how to achieve this smoothly. 1. Should I create the new site/subnet first and then promote a server in that subnet/site to DC, or should I promote a server in existing site/subnet and then move this DC to the new site/subnet? 2. When promoting a server to DC, should the server be a member server (already joined the domain) or just a workgroup member (no domain membership)? 3. The DC will be an AD-integrated DNS server. Should I install the DNS component (but not confi...
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
The second thing you need to do is make sure that Word is configured so that it updates fields when it prints. Now, when you run the macro, you are asked how many copies to print and what starting number to use. The document variable is updated and a single copy of the document is printed. These steps are repeated for the number of times that you chose to print.
I am attempting to write a query joining two linked tables in a query by payroll number (all numeric). When write the query and join by payroll number I get the "Data Type Mismatch in Expression" error. Both tables have the Data Type as "Number", but the only difference I can tell is one has "Field Size" as "Decimal" and the other has "Field Size" as "Double". I have even tried to join on the VAL() of each payroll number field with no luck. Any ideas? "Decimal" and "Double" are actually different dat...
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
Hi All, I am trying to add the 'File" menu and "Window" menu of the Standard Toolbar to a custom toolbar but failing miserably! I think it should look something like: Sub AddMenuTitles() Application.CommandBars("MyCustomMenu").Controls.Add("File) Application.CommandBars("MyCustomMenu").Controls.Add("Window") End Sub Can anybody help please Regards Michael Sub test() AddMenuTitles True ' or false to delete End Sub Sub AddMenuTitles(bAdd As Boolean) Dim cbr As CommandBar Dim cbP As CommandBarPopup ...
Angie, have tried your method; however, I encountered what I surmised was a limit on the amount of characters allowed in that “Enter formatting for number” box: for instance, I can only type as far as “Request for Productio” (excluding quotations)- additional text and codes delete and default back to the incomplete phrase “Request for Productio”. Seems to have a default of 26 characters – anything exceeding that is deleted. The phrase “Request for Admission” completes, but am unable to include anything after that phrase of 26 characters. Not sure why that is, but that’s what I run into when I attempt using the multi-list option.

What is the max number of records that can be put into a table in Microsoft Access? Does it vary from version to version? Thanks in advance. "Mike C" wrote in message news:BC4F1F10-A96C-4EC7-9E33-670828E53A0A@microsoft.com... > What is the max number of records that can be put into a table in > Microsoft > Access? Does it vary from version to version? Thanks in advance. Google or the online help would be your friend on this one. There's no fixed limit, there's only the limit on the overall size of the database file...
Hi, In the disaster recovery plan we want to create a leg site and put a DC in it. Here are some questions on how to achieve this smoothly. 1. Should I create the new site/subnet first and then promote a server in that subnet/site to DC, or should I promote a server in existing site/subnet and then move this DC to the new site/subnet? 2. When promoting a server to DC, should the server be a member server (already joined the domain) or just a workgroup member (no domain membership)? 3. The DC will be an AD-integrated DNS server. Should I install the DNS component (but not confi...

sequential numbering labeller paper rotary sequential numbering machine sequential numbering machine sequential number sequential numbering machines sequential number barcode label printing embossed sequential numbers card sequential number plastic card sequential number adhesive sticker sequential labeling sequentially numbered stickers sequentially barcoded labels sequential labels custom sequential number label printing
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
John, Sorry for the delay, but I was away last week with limited Internet access. I assumed if you had a Save button, you would know how to put code behind it. To see the code behind a button, Select the button in Form Design Mode and open the Properties Dialog (Right click and select properties), on the Events tab there should be something in the On Click event of the button. If you click the Ellipses […] next to the event, it will open Code Builder where you can enter the code.
Scott, I had posted on Microsoft and you sent me to your blog to have the numbering system (similar to APEX example) explained. I am not a programmer and I don’t understand where these codes and expressions are even suppose to go in access. When I do try to implement the little I do know I continue to get errors. I am not sure if I am putting the information in the wrong place or if I am way off. Do you know of any youtube videos that could walk me through it step by step? Or if you have the time could you help walk me through the steps.
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)?.
I am having trouble with this procedure. My situation is almost identical to example #2. I want to populate RecordNumber on my form with a date number like “130001, 130002, etc.” where “13” is the year based on a date automatically generated in the OpenDate field in tblLogRecords. OpenDate is a date/time type field that has a default value of the date the record is created and is not editable. I have added a field called Sequence to tblLogRecords and it is a Number, Long Integer type. I also created a bound control for Sequence on my form. I have a completely separate autonumber field as the PK.
Scott, trying my best to have sequential numbering almost identical to your scenario 1 (bound control on input form which increments last number by 1). Where do I enter this code? I have a form which opens and is ready for entry of new Project Designs. I want to show in the control box the next Project ID (a number) so do I place the code, Me.txtProject ID = Nz(DMax(“[Project ID]”,”DESIGN PROJECTS”),0)+1, under On Load, After Update, or where? And also, the Me.Dirty = False or DoCmd.RunCommand
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
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.
Any code can read the serial number of a mother board? any example? Thanks! Crystal On Fri, 10 Jun 2005 00:07:16 +0800, "Crystal Lin" wrote: >Any code can read the serial number of a mother board? any example? Thanks! > Do all computers have "mother boards" and do all mother boards have serial numbers? > Any code can read the serial number of a mother board? any example? Thanks! You can read the Serial Number of the hard drive using DiskId32 at http://www.winsim.com/diskid32/diskid32.html . Lynn Let me guess: another mis...
Scott, I had posted on Microsoft and you sent me to your blog to have the numbering system (similar to APEX example) explained. I am not a programmer and I don’t understand where these codes and expressions are even suppose to go in access. When I do try to implement the little I do know I continue to get errors. I am not sure if I am putting the information in the wrong place or if I am way off. Do you know of any youtube videos that could walk me through it step by step? Or if you have the time could you help walk me through the steps.
I’ve been searching for the best way to create auto numbering for discovery requests: dare I say in WordPerfect I had the most amazing macros that used “counter” and creating a set of discovery was a snap. I’ve struggled to find something workable in Word. Some people use Discovery Request No. X – Interrogatory; others use Interrogatories No. X, Requests for Production No. X, Requests for Admission No. X throughout a set of discovery. There has to be a way to do this in Word, and I’ve tried several different approaches, none of which worked out that well. Would you please steer me in the right direction? Thanks very, very much.
Every time I open Outlook 2007 I get an error message regarding an add-in 'DCCExtensions' (DCCEXT32.DLL). It says the add-in cannot be loaded and has been disabled by Outlook. I've been getting this message ever since I uninstalled Winfax. How do I make this error stop appearing? Thanks. -- kapibarra Remove the addin from OL by using Trust Center, Addins. http://office.microsoft.com/en-us/outlook/HA100341271033.aspx#14 "kapibarra" wrote: > Every time I open Outlook 2007 I get an error > message regarding an add-in 'DCCExtensions' (DCCEXT32.DLL). ...
You can add a chapter number variable to your document. Like page numbers, chapter numbers can be updated automatically and formatted and styled as text. A chapter number variable is commonly used in documents that are part of a book. A document can have only one chapter number assigned to it; if you want to divide a single document into chapters, you can create sections instead.
One solution is to format the heading with the style and follow it with a hidden paragraph mark. You should format the text in the next paragraph with a style that is not included in the Table of Contents. A hidden paragraph mark keeps the text together on one line when it is printed, even though it is actually two separate paragraphs. The Table of Contents command picks up only those paragraphs with heading styles and places them into the Table of Contents.
There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.

I have now permanently “baked” the Inline Counter system into my InDesign defaults. With no documents open, I made a “Counter” CharStyle and a “Zero Footnote” ParStyle, with those crucial zero-level type size attributes, and selected them in the Document Footnote Options. I also added a blank space as a prefix and a period and a blank space as a suffix. Then I made a keyboard shortcut (Ctrl-Alt-F) for the Footnote/Counter. So now Inline Counters can be inserted anywhere and anytime with close to zero efforts.

Perhaps the easiest solution to this problem (short of using a macro) is to simply use the mail-merge capabilities of Word. You would use a simple data source that contained the numbers you want assigned to each copy. Then, place the merge field at the appropriate place in y our document, and run the merge. Each copy will contain the desired copy number. The added benefit of using this approach is that you can use additional information with your merge, as needs dictate. For instance, if each copy of the document was assigned to a particular person, you could simply add another data field to your data source that contained the name of the person to receive the copy. Then, you could print that person's name in each merged document, as well.


This is how I see it. A person (passenger) makes a reservation. If the person has never made a reservation before, then they are added to the passenger table, But it really makes no sense to assign a sequential number to the passenger. Otherwise, an entry, just needs to be made in the reservations table. The Reservation needs to include the specific train (number and date so there should be a table for train schedules so all you need is a foreign key), the passenger and date of travel. Here I can understand wanting a sequential number to show passengers booked in a day.
I have a problem with Outlook 2007 and the add-in Access Outlook Add-in for Data Collection and Publishing. This add-in worked when I first installed Outlook 2007 when installing Office 2007 Enterprise. The add-in created a sub-folder in my Inbox named Data Collection Replies and worked well until about 6 weeks ago. Now I can’t get the add-in to work at all even though it appears in the list of COM.adds in Outlook 2007. More perplexing is the error message I now receive EVERY time I click on any email message to read it. The message is titled ‘Custom UI Runtime Error in...
Even worse (I found out from bitter experience), is that whenever a computer “glitch” (aka “crash”) or “upgrade” (e.g. to a new/different desktop) came along, and our outside IT vendor had to “fix” the “computer” or “system,” (always, of course, at unexpected and unpredictable times), all of my “Auto Text” blocks got “wiped out” (or, I could not find them, even after a few help desk calls), and I had to “reinvent” and “re-keystroke” or “re-save” each of them again (and several times, again). Obviously, frustrating, and largely defeating the efficiency purpose.
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.

InDesign allows you to add a page number marker to a master page within the document. The master page functions as a template for every page it's applied to, so the consecutive page numbers appear on every page. InDesign updates the page number automatically as you insert, delete and move pages. To add a page number marker to a master page, create a text box on the master page by going to the Type menu and choosing "Insert Special Character," "Markers" and then "Current Page Number."


Moreover, the subscripts and superscripts could have been left off in the third, fourth, and fifth notations, if the indexing set was understood to be the natural numbers. Note that in the second and third bullets, there is a well-defined sequence {\displaystyle (a_{k})_{k=1}^{\infty }} , but it is not the same as the sequence denoted by the expression.
The most important sequences spaces in analysis are the ℓp spaces, consisting of the p-power summable sequences, with the p-norm. These are special cases of Lp spaces for the counting measure on the set of natural numbers. Other important classes of sequences like convergent sequences or null sequences form sequence spaces, respectively denoted c and c0, with the sup norm. Any sequence space can also be equipped with the topology of pointwise convergence, under which it becomes a special kind of Fréchet space called an FK-space.
InDesign allows you to add a page number marker to a master page within the document. The master page functions as a template for every page it's applied to, so the consecutive page numbers appear on every page. InDesign updates the page number automatically as you insert, delete and move pages. To add a page number marker to a master page, create a text box on the master page by going to the Type menu and choosing "Insert Special Character," "Markers" and then "Current Page Number."
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.

Specifically, 8 to 10 times in my career, I have set up a robust set of MS Word “Auto Text Entries.” Some, short phrases as in this article (e.g. “Interrogatory No. __,” “Long Corporate Name of Client, Inc.,” etc.). Some large blocks of text, paragraphs, or formatting chunks (e.g. Memorandum Start (To:, From:, Date:, Subject: etc.); Caption Block for [Local] Court; Signature Block; Certificate of Service, etc.).
Numbering and Section options are available in the Pages Panel menu. These options allow you to define what page starts a section and how it should be numbered. A Current Page Number marker must be set on pages in order to use this feature. The Current Page Number is a special character inserted in a text frame on a page or master page (recommended) where the page number will appear, by selecting Type>Insert Special Character>Markers>Current Page Number.
Clicked standard Mac Office upgrade yesterday, now Entourage is disabled because of message the reads This installation of Microsoft Office X exceeds the number of installations permitted by the license agreement. User name is already using this installation of Microsoft Office X. The program will now quit. I have MS Office package with 3 product keys. I'm using my laptop now, but originally it was installed on my primary desktop Mac. What's the solution to this problem? SHould I be concerned about preserving my emails -- on Entourage, if I need to reload software? Please advise....
This is how I see it. A person (passenger) makes a reservation. If the person has never made a reservation before, then they are added to the passenger table, But it really makes no sense to assign a sequential number to the passenger. Otherwise, an entry, just needs to be made in the reservations table. The Reservation needs to include the specific train (number and date so there should be a table for train schedules so all you need is a foreign key), the passenger and date of travel. Here I can understand wanting a sequential number to show passengers booked in a day.
If you start to type in what appears to be a numbered list, Word formats your manually typed "numbers" to an automatic numbered list. The main benefit of this option is that you do not need to click any button to start numbering and you can choose your numbering style as well. For example, if you type "(a) some text" and press Enter, it starts numbering using the "(a)" format.

i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.


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