The above will generate a number similar to this: 17-09-26 13:22:23 where the first two characters are the year, the next two the month, then the day, hour, minute and second. If you look carefully at the expression within the format-date() function I have added some dashes and spaces a separators, but you can get rid of them if you like.
– So when I create the button, I do not want it to be the save button, I want it to be a separate button in the form that populates/generates the number into the PONum field. Is that what your current example does?
Well, you could do it with two lists (using the List feature). Or perhaps you could do it with cross-references, like this: http://indesignsecrets.com/synchronize-text-in-more-than-one-place-in-an-indesign-document.php
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I’m also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
I am a little confused by your finale note paragraph. In my original try, the field in the form, I had used design wizard so it already had the field PONum on it, is this something I am supposed to change?
Excellent choice for ticket printing. Easy to use, great customer support and two day delivery. They printed my tickets the day I ordered them. Pricing was great as well. We will use them anytime we need tickets.
I have a table named Artifact Catalog in which there is a field Collection Point ID and a field Artifact ID. On the form I have created the user will input the Collection Point ID, for example: 2-1050. I need to find a way to have this Collection Point ID automatically generate a corresponding Artifact ID, i.e when you click the save button the first record under Artifact ID 2-1050.1 and the second becomes 2-1050.2 and so on.
Click that, and a placeholder will appear where your cursor was, which will later insert the ticket number at that point. Do that twice for each ticket (once for the counterfoil, once for the main ticket). You should end up with something like this:
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.
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 strongly recommend that you read both of these before doing anything with the contents of this chapter.
Transact-SQL statements that use SELECT * will receive the new column as the last column instead of the first column. If this is not acceptable, then you must create an entirely new table, move the data to it, and then recreate the permissions on the new table.
The feedback system for this content will be changing soon. Old comments will not be carried over. If content within a comment thread is important to you, please save a copy. For more information on the upcoming change, we invite you to read our blog post.
Note this works only because we create a brand new table, add an autonumber column to it as well any other columns we need then insert records into it. It’ll be contiguous – as long we don’t delete any records from the table. Unfortunately, creating a brand new table every time we run this will result in bloat of the Access file – if you can do it in a separate Access file, all the better so that you can compact it when you need to.
Scott, I have “txtProject ID#” in the code but the error message replies with highlight of “txtProject” omitting the ID#. I am aware of the # issue. The table field name is PROJECT ID#. The control is a text box of that field name. Is this not the control to use?
Using the Orders table created in example A, the following example declares a variable named @nextID, and then uses the NEXT VALUE FOR function to set the variable to the next available sequence number. The application is presumed to do some processing of the order, such as providing the customer with the OrderID number of their potential order, and then validates the order. No matter how long this processing might take, or how many other orders are added during the process, the original number is preserved for use by this connection. Finally, the INSERT statement adds the order to the Orders table.
It makes me think there’s an issue with the spaces I have used in my field names but I have been trying every combination of double quotes and square brackets and when writing the code in the Event Procedure I don’t get any error messages.
Creating a sequential list of numbers, in Word, sounds like an intimidating task. Sure, you can create a numbered list quickly enough, but that feature works with additional text – you’re numbering something. If you want a list of just numbers, you have to work a bit harder. Word’s SEQ field might come to mind, but that solution is better suited to template-type numbering. In order words, this field works great if you’re numbering documents, labels, and so on. It doesn’t work so well if you just want to create a list of sequential numbers. You can use it that way, but it’ll be more work than it’s worth.