Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.
A note about link exchanges. This site does not participate in link exchanges to build web presence. If you have a link that you think would be of use to people reading this page, please send it to the webmaster with the url of the page where you think it should appear and it will be considered. Your placing a link to this site will not affect the decision on whether to add your link, though.
The Artifact ID should NOT be your PK. There is no reason for it to be and to try and use it as such will be a headache. A primary key is simply a unique identifier for a record. Many purists will tell you that users should never see the PK and in your case, I would recommend that. Use an Autonumber as you PK and you can use that as your corresponding Foreign Key in related records. To prevent duplication you can make the combination of Collection Point ID and Artifact ID a unique, multi-field index. Then display the combination as I indicated where you need to show the user a record ID. This is all explained int he blog.

The Artifact ID should NOT be your PK. There is no reason for it to be and to try and use it as such will be a headache. A primary key is simply a unique identifier for a record. Many purists will tell you that users should never see the PK and in your case, I would recommend that. Use an Autonumber as you PK and you can use that as your corresponding Foreign Key in related records. To prevent duplication you can make the combination of Collection Point ID and Artifact ID a unique, multi-field index. Then display the combination as I indicated where you need to show the user a record ID. This is all explained int he blog.
@Andy: I’m sorry that I sounded dismissive. That wasn’t my intent. Rather, I was just admitting that I had no idea why someone using CS3 would not see the dialog boxes as they are shown above. If you’re using CS2, they would be significantly different. But the second part of the tip (where I show the numbering dialog boxes) relies on CS3 or later. If you are using CS3 or CS4 and you don’t see that dialog box, feel free to email me at david [at] indesignsecrets [dot] com and send me a screen shot of what you are seeing.
Running captions number figures, tables, and other items consecutively in a document. For example, the first figure caption starts with the words “Figure 1,” the second with “Figure 2,” and so on. To make sure that figures, tables, or similar items are numbered consecutively, define a list for the item, and then create a paragraph style that includes the list definition. You can also add descriptive words such as “Figure” or “Table” to the numbering scheme of the paragraph style.
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...
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks....
Hi Silver, Try going to File/Page Setup/Header-Footer/Custom Header/Should be the button shown in the header box with the # sign in it. Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287 View this thread: http://www.excelforum.com/showthread.php?threadid=498476 ...
Hi, is there any limit on the number of E-Mails ? I created an archive of 270000 E-Mails (IMAP) and it caused trouble. Can I have that amount in a local folder ? Are there any recommended number ? It locked that 50000 starts being a problem on IMAP already. How else would you handle an archive that you need frequently ? Thanks for your help Stephan If it were me... exporting them(selectively) to user created properly named Windows Explorer blank folders on the hard drive and backing up to a different drive(internal/external/cd/dvd) outside of Windows Live Mail woul...
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:
Other examples of sequences include ones made up of rational numbers, real numbers, and complex numbers. The sequence (.9, .99, .999, .9999, ...) approaches the number 1. In fact, every real number can be written as the limit of a sequence of rational numbers, e.g. via its decimal expansion. For instance, π is the limit of the sequence (3, 3.1, 3.14, 3.141, 3.1415, ...). A related sequence is the sequence of decimal digits of π, i.e. (3, 1, 4, 1, 5, 9, ...). This sequence does not have any pattern that is easily discernible by eye, unlike the preceding sequence, which is increasing.

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.
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.
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.

Numbers has been well received in the press, notably for its text-based formulas, clean looks and ease-of-use.[17][18][19] Macworld has given it high marks, especially newer versions, awarding Numbers ’09 four mice out of five. They did point out a number of common issues, especially problems exporting to Excel and the inability to “lock” cells to prevent them moving when the table is scrolled.[14] Numbers for the iPhone and iPad have received similar favorable reviews.[20]
I'm producing gift certificates for a restaurant and they need to be numbered sequentially from 0001 to 0250. Is there any way to do this easily as opposed to numbering each manually? I'm sure I could probably work it out with a print shop, but the job was thrust on me last minute and my options are limited by the short turn around time. Any help would be appreciated. Thanks!...
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
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.

Hi Silver, Try going to File/Page Setup/Header-Footer/Custom Header/Should be the button shown in the header box with the # sign in it. Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287 View this thread: http://www.excelforum.com/showthread.php?threadid=498476 ...


Step 2: Create a new doc for your numbers. Using Paragraph/Bullets and Numbering choose Numbering and set the Format to the 4 digits you've indicated in your sample. In the box below Format, remove the ".^t". This will remove the period & tab after the style. With that style set, hit return to create a number. Repeat for as many numbers of coupons you'll have. You can create 10 and copy & paste for however many numbers you need. You could possibly create your numbers in Xcel, but I'm instructing in ID only.
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.

With this expression we check only for records that are in the same year as the Inquiry date to increment the sequence. Again, the NZ function will automatically restart the sequence with each year. Cleary, though, we cannot generate this number until the InquiryDate has been entered. Is this value is a user entry, then you may want to check that it’s filled in before generating the number. Something like:
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.

Sequential numbers can be printed almost anywhere on a sheet or form and can be positioned horizontally or vertically. Numbers can also be repeated in another position on the form. When developing your artwork, consider putting a box for numbering, making it easier for your customers or employees to find and reference a specific job or transaction. You may also differentiate your number by color. Most printers allow a choice of colors, typically black or red, to make your number stand out. Start your sequencing at any point you like, to pick up where you left off on your last print order.
×