Hello, can anyone help me with making serial numbers in this way: When I purchase 10 chairs, I want to monitor all of it by having serial numbers each of those 10 and those 10 numbers should have the prefix “CHR-” if they are chairs. “TBL” if tables, the codes are associated with the item category. BTW, items have categories predefined by beforehand on the items by relationships. So when I will want to monitor these 10 chairs, I will only have to click the “generate control numbers” button and each of those purchased items get their own control numbers.
If you have a SQL Server backend, you could just use the windows function ROW_NUMBER() and define it as a part of a SQL Server view. This is probably the simplest, no-nonsense method that works well for any purposes. This was introduced in SQL Server 2005 so chances are high you can use it if you can create views.
Hi Scott, you directed me here from the experts blog for this topic. Thanks again for all your assistance. I want to build a test example of your Acme example before creating it in my donations database, as I mentioned this is all very new to me so please bear with me:
CK Note: Word 2007 – 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly’s step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with “spaghetti numbering,” fixing it will be a very large chore!
WordTemplatesBundle.com currently has 6 different templates available for free. Two of them are run-of-the-mill tickets that would be great for things like an office or classroom draw. The other four are the ones that are most helpful as they do automatic serial numbering.
See how easy it is to add sequential numbering to Avery products using Avery Design & Print Online at avery.com/print. Great for adding tracking numbers to items like Avery Tickets with Tear-Away Stubs.
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 on the page. Hope that helps!
It would be great if we had some sort of magic auto-incrementing function that would give us unique numbers sequentially. This would allow us to start with an easy number like 0000 and then increase it to 0001, 0002…. easy to remember! Unfortunately, this is not that easy when working disconnected because there is no way for an offline device to know what is the next sequential number available. Even if we were able to create sequential numbers within a device, we cannot guarantee that other devices will not create the same sequential numbers.
hammer stamps, how to metal stamp, mark metal, marking equipment, marking machine, marking products, metal alphabet stamps, metal blanks for stamping, metal hand stamp, metal label maker, metal letter stamp set, metal letter stamping kit, metal marking machine, metal number stamps, metal stamp, metal stamp holder, metal stamp set, metal stamper, metal stamping, metal stamping equipment, metal stamping kit, metal stamping machine, metal stamping press, metal stamping set, metal stamping supplies, metal stamping tools, metal stamps, number press, serial number labels, stamping machine, stamping metal, steel punch, steel stamp, steel stamping set, steel stamps, marking tools
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I’d have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I’ve used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also “Single-sided” cos my default of duplex printing had come up). But TA-DA! All is fine now. Thanks very much again.