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

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


The best way to do this is to use a primary key. In cases where a query is complex and joins several tables, we may need to use the primary key of the table that’s on the bottom of the relationship hierarchy or possible a concatenation of multiple tables’ unique key so that the expression will be unique and thus we can identify which sequential number we have assigned.

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

There are three settings we need to embed in this field. The first is to tell it what kind of numbering we want to do (in this case, “First, Second, Third”), what case we want to use (upper case, title case, etc.), and a switch to tell Microsoft Word to increment the numbers. Click each of these settings as shown below, being sure to click Add to Field after each one:


An easier way is to setup the table in Excel and use the Excel features to create sequential numbering. The cells making up the whole table can then be selected and copied into a Word document using CTRL/C and CTRL/V which will create a table in Word. Column widths and borders can be set up in Excel and cells can be filled in before copying to the Word document.


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.
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.
Hi, Let's keep the problem simple. I have one cell that uses an exchange rate from the internet. That cell changes every minute. What I want to do: In an other cell, I want to keep the highest exchange rate ever. So for example: 6:00 exchange rate = 5.00 -- highest exchange rate is 5.00 6:01 exchange rate = 4.98 -- highest exchange rate is 5.00 6:02 exchange rate = 5.02 -- highest exchange rate is 5.02 6:03 exchange rate = 5.01 -- highest exchange rate is 5.02 6:04 exchange rate = 5.03 -- highest exchange rate is 5.03 Of course nor for any minute I use a new cell, it just change the n...

There are three settings we need to embed in this field. The first is to tell it what kind of numbering we want to do (in this case, “First, Second, Third”), what case we want to use (upper case, title case, etc.), and a switch to tell Microsoft Word to increment the numbers. Click each of these settings as shown below, being sure to click Add to Field after each one:


Modern businesses today require their products to carry unique numbers printed on them for identification purposes. This is where sequential numbering is important. It involves printing of numbers in an ordered or sequential form on to the products or documents. Sequential number printing can be done either in ascending or descending order on a variety of paper types. They can be either be alphanumerical combination or completely numerical. The numbers can be printed anywhere on the media and the sequencing can start from any number the client prefers.


To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher.
Hi everybody. I am having a problem with a query that I am working on. I have a table containing customer names, trade dates, and dollar amounts. Customers can have multiple trades on the same day, sometimes even the same dollar amount. I want to have the table sorted by name, date, then dollars so the query pulls everything in from lowest/earliest to highest/latest. I was trying to make a query that pulled in the customer name and trade dates, then added a new column called "Row" that had the record number. I want the query to show all names and dates, since there are ...
Using this script… no. While I use the data merge feature of InDesign often, I avoid the “multiple records” feature, but I typically prepare one record on one page, output the resulting file to PDF and then let the imposing software take care of the page imposition. If page imposition software is something that you don’t have, there is an alternate technique that requires preparing one record on a page, and then using the multipageimporter2.5 script to import them onto a larger sheet. Here is the link to that article: http://colecandoo.com/2011/10/28/theres-more-than-one-way-to-cut-and-stack/
Yes, I’m a little confused by your brief too. The script that I describe here will create an array of numbers using any step value that it offers, including by 1 number each time. Whether you put the resulting list directly into InDesign as text, or indirectly using the Data Merge feature is up to you. Perhaps learn more about the Data Merge feature of InDesign itself – David Blatner has a great series on Lynda.com that will explain Data Merge much more than I can on this thread.
I’d like to use this for Exhibits/Appedices. If we refer to the same Exhibit # in a footnote or elsewhere in the document, and then the Exhibit reference is moved, it causes an error in the footnote or reference. Is there a way to cross-reference this, or to have it cross-reference automatically? Lawyers want to use this but I can’t see them bothering to cross-reference the footnotes. Thanks.
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.
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create "Catalogue Pages". This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn't the best graphic design program in the market. But it's certainly adequate for simple ticket designs — for example, for a school social. Let's say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.

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.
I tossed back a rather glib answer about using the AutoNumLgl field code to number the discovery requests, and she threw in this little wrinkle: her attorneys like to play mix-and-match with their discovery. In other words, they may put in a couple of interrogatories, then throw in a related request for production, then another interrogatory, then a request for admission that’s related to that interrogatory.
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.
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 want to a sequential number to fill in automatically each time the form is filled out. Malissa, A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others...

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

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

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.).
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
Hi, this is a great write up. I am very new to InDesign and i print onto a range of products and my first order with sequential numbering came up (serial numbers), I have the template made in illustrator and i also have the numbers added (00001 on all of the art work). A friend told me InDesign has a function for automatically incrasing the numbers by 1 for each art work. I have 105 pieces per template, is there a way to import the design and then sort the number (already text edible) and then save as a pdf then send to print?
There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
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????
First, you have to use YOUR field and control names. The ones I use are samples. The error you are getting indicated you do not have a control named txtProject. So you have to substitute the correct name of the control. bound to the ProjectID field. By the way it is not a good idea to the octothorpe(#) as part of a field name. A controlname may be different from a fieldname. The name property of a control is on the Other tab in the Properties dialog.
×