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 ... sequentially numbering in indesign
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.

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


A single InDesign document can contain up to 9,999 pages, but page numbers can be as large as 999,999. (For example, you can correctly number a 100‑page document that starts on page 9,949.) By default, the first page is a recto (right) page numbered 1. Odd-numbered pages always appear on the right; if you use the Section Options command to change the first page number to an even number, the first page becomes a verso (left) page.
Version numbers allow people providing support to ascertain exactly which code a user is running, so that they can rule out bugs that have already been fixed as a cause of an issue, and the like. This is especially important when a program has a substantial user community, especially when that community is large enough that the people providing technical support are not the people who wrote the code. The semantic meaning[1] of version.revision.change style numbering is also important to information technology staff, who often use it to determine how much attention and research they need to pay to a new release before deploying it in their facility. As a rule of thumb, the bigger the changes, the larger the chances that something might break (although examining the Changelog, if any, may reveal only superficial or irrelevant changes). This is one reason for some of the distaste expressed in the “drop the major release” approach taken by Asterisk et alia: now, staff must (or at least should) do a full regression test for every update.
Developing Document Control and Image Numbering Systems. The document and imaging numbering or coding system for your application gives you control over the documents. If you are going to image documents, the document database record number and the image record or file number may be the same number. A document and imaging numbering or coding system can be very simple or sophisticated, depending upon your desires and the needs of a particular case. Below are three possible methods of coding your documents and images:
If your document has one page to start with, InDesign will place the endnotes text frame on a new page 2; if your document starts with three pages (following our example on page 34, BDMS), then InDesign will place the endnotes text frame on a new page 4. Before flowing the rest of your manuscript into your pages, drag your endnotes text frame onto the pasteboard for now. You’ll be able to position it appropriately in your book later on.
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:
The values for Number position (here called Aligned at), Text indent and Follow number with are in the Position section at the bottom. With multi-level numbering, you also have easy access to settings that control the type of numbering at each level, the characters before and after each level’s numbers (period versus parenthesis), and the list number style (1, a, I, etc.).
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.
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.
It sure is possible! 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. Insert a Current Page Number marker (Type>Insert Special Character>Markers>Current Page Number) in a text frame on a page or master page (recommended), select the first page of your section, open the Numbering and Section Options dialog, and enter 200 in the Start Page Numbering at: field. Hope this helps!
Perhaps your explanation already addresses this, but I can’t see it. Is there any way this script can be used for printing multiple-up in numeric sequence? For example, if I’m running 1000 postcards 4-up (on 250 sheets). I need the 4 cards on page 1 to be numbered 1, 251, 501, 751; then the 4 cards on page 2 numbered 2, 252, 502, 752; etc., so that when the sheets come out of the printer and are cut into 4, I have a stack of 1-250, a stack of 251-500, a stack of 501-750 and a stack of 751-1000.
I want to have textbox with 2 columns with footnotes running across the bottom of those columns in one column. ID CS3 footnotes can’t handle this. So I have added fake footnote refs in the doc. using this idea. Now the footnotes themselves I can create in another text frame and use this idea again to create them and then manually place them at the bottom of the page. The only problem however with this is the FN options carrry across the whole doc. right? So even if I create a second doc for the footnotes themselves with different options and then later paste it into the main doc it’ll get messed up right?
Place the insertion point in the paragraph and choose Restart Numbering from the context menu or choose Type > Bulleted And Numbered Lists > Restart Numbering. In normal lists, this command assigns the number 1 (or letter A) to a paragraph and makes it the first paragraph in a list. In multi-level lists, this command assigns the first lower-level number to a nested paragraph.

Let’s look at why we have this setup. It seems strange to put a ResetRowNumber() call in a WHERE clause, doesn’t it? However, the WHERE clause is actually resolved prior to the SELECT clause. (For those who wants to geek out on SQL internals, Itzik Ben-Gan, a SQL Server MVP has a great post that outlines the logical query processing. Though this is specific to SQL Server, the Access database engine as well the majority of RBMS engines generally follow the same outline). This gives us a convenient point to ensure that the module level variable lngRowNumber is always correctly reset at the right time (e.g. before we start returning records from a query).


When you’ve finished typesetting your book, you’ll create an appropriate page or pages in the back matter for your endnotes. When you have a spot ready to go, find your endnotes text frame (it might still be on the pasteboard of page 2 or 4), and cut-and-paste it to the appropriate page in your back matter. Note that the endnotes text frame can be copied- or cut-and-pasted without losing any live links. Isn’t technology grand?
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
* 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...
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.

Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.


See Word's Numbering Explained by John McGhie, MVP - comprehensive and not pretty (Downloadable pdf file in letter size) - Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering.

A defined list can be interrupted by other paragraphs and lists, and can span different stories and different documents in a book. For example, use defined lists to create a multi-level outline, or to create a running list of numbered table names throughout your document. You can also define lists for separately numbered or bulleted items that are mixed together. For example, in a list of questions and answers, define one list for numbering the questions and another for numbering the answers.
You won’t use any of the standard List Number styles for SEQ field numbering. You need to create your own style if you want correct indentation and alignment with the tab position of the first word after the number. In this example, I’ll create a new style called Step Number, but you can call it whatever you want. In this example, I’ve also used the default settings for tab and hanging indent positions — you can change these later if you want.
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.

The blog is pretty much step by step. Where it may not be that specific is, because, these are decisions the developer needs to make. For example, where to put the DMax expression is a matter of your workflow so I can’t tell you where to put it. I’ve given tips in the blog to help you decide. If you are having issues, then please give me more info about your application and I can suggest things.


Version numbers are used in practical terms by the consumer, or client, to identify or compare their copy of the software product against another copy, such as the newest version released by the developer. For the programmer or company, versioning is often used on a revision-by-revision basis, where individual parts of the software are compared and contrasted with newer or older revisions of those same parts, often in a collaborative version control system.
Klaus Nordby, one of our good-natured Norwegian hecklers, has produced a ray of sunshine in the midst of a deep, dark Scandanavian winter by coming up with a wonderful little trick involving adding sequential numbers inside a paragraph. For example, 1. this is the first clause of this sentence; 2. this is the second; and 3. this is the third. That’s not a big deal to type, of course, but if you had dozens of them and you needed to insert or remove numbering frequently, doing it manually would be a hassle.
Regarding exporting to EPUB, I have very limited experience in that department! I understood that InDesign compiles the EPUB using text and image frames in the order they appear in the document? So that chapter 2 would naturally follow chapter 1, and so on? If each chapter is in a separate document and all chapters are linked together using the Book feature, I think you can export to EPUB in a similar way that you can export to PDF?
I have a large job for a client who uses antique computers. They are so old that he can't run Lightroom. As a workaround, I posted the images I wanted him to look at on SmugMug and we had a disaster. Their sequencing on screen does not match my "as shot" sorting on my Lightroom (4). Is there a way I can print sequential serial numbers/ids on my images before I upload them to SmugMug so we are always talking about the same image?
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.
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.
×