Hi Scott, I had a question regarding the sequential numbering Apex example…I am looking to automatically restart the sequence every month, which is not a problem using your example (i.e. changing the year to month in the expression). However, I would also like to add in a condition for year, so that the sequence restarts for each month of each year (i.e. my problem is for example that Feb 2011 last sequence number is 5, and then in Feb 2012 this becomes 6, where I would like it to be 1). I am wondering what the syntax would be. Thanks in advance, Lawn.
you'd need to use a before save macro. Something like the macro at the end - but it would run on every save, which may not be what you want. I use a macro that gets the invoice # and saves (it does several things). I added a button to the ribbon that calls a macro that runs several macros: Sub FinalizeInvoice() CreateInvoiceNumber CopyToExcel FinalCleanup ' this does the save End Sub This is an automated macro - but it will run every time the file is saved. Private WithEvents App As Word.Application Private Sub Document_Open() Set App = Word.Application… Read more »
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 have used batch process to make a whole bunch of photos one size.  I need to create a single 'photo wall' jpg out of them in which they're all tiled, the long way of doing this is to obv open them all and copy, paste into the psd, then flatten, but thats really, really time consuming.  If photoshop had any type of auto import & tile feature?  I may have to do this a 2nd time with 1000's of images.

You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free trial of Office Tab!


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...
A few days ago I updated Lightroom to version 4.3. Since then, the "auto save to xmp" doesn't work. It is checked, but I keep finding files that "have been changed recently". So not only that it's not auto-saving them, but it is also finding "new images" that "have been recently changed" even though I didn't open or edited them in the past several months..
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
A quick search at the top using the term “document numbering” shows 46 different threads, with very good advice, for the most part.  I would first recommend you perform the same search and see what advice may be gleaned from those far older and wiser than myself.  In order to directly answer your question, I would refer you to the following discussion thread.  Many talk about the physical numbering system to use, which is important, and many discuss the frustration that a new person to the position feels when they inherit a mess from someone else and wish to clean it up. 
If you’re a self-taught InDesign user, you may not have been introduced to automatic page numbering, one of the biggest time-saving features in the program. InDesign allows you to set up the page numbering feature in your Master Pages. Then, as you add or shuffle pages, InDesign updates individual page numbers accordingly. You can style the page number any way you like.
I am trying to automatically print sequential numbers on individual cards on 8.5" x 11" business card stock (to create tickets) using MS Publisher and cannot figure out how to get it to do this. Does anyone know the secret? Thanks. Hi Scott (scottmarsh@excite.com), in the newsgroups you posted: || I am trying to automatically print sequential numbers on individual || cards on 8.5" x 11" business card stock (to create tickets) using MS || Publisher and cannot figure out how to get it to do this. Does || anyone know the secret? Thanks. Check out the following tutorial:...
This chapter (web page) takes you through how numbering is supposed to work in Word and the various controls. It is useful, but primarily on SEQ fields and simple numbered lists and also as reference showing the menus, dialogs and controls and going through the concepts for outline numbering. To actually set up outline numbering that works, refer to the Kelly and McGhie articles.
Neither the owners, employees, officers nor directors of Signs 101 shall be held responsible or liable under any legal theory for any loss or injury resulting from any post, information made available, policy, action or lack of an action at Signs 101. Your use of this website is your acceptance of these terms and conditions of use. A Eon Media,LLC Company

RE: “Open your Endnote Options dialog box by clicking Type>Endnote Options. In the Numbering section change the Mode drop-down box from Continuous to Restart Every Story, and in the Positioning Options section change the Scope drop-down box from Document to Story. Next you’ll need to separate your chapters into stories. Assuming that all the text frames in your document are currently linked, you’ll need to unlink them between chapters.”
An invoice number is simply a way to uniquely mark an invoice to help keep track of your business transactions. Consecutive or sequential invoice numbers help to ensure that each invoice is unique and each business transaction can be clearly and comprehensively organized and referenced – for accounting reasons as well as customer support. While a receipt is generally used as proof of payment and therefore documents a finalized sale, an invoice is a request for payment that includes more detailed payment or contact information in addition to pricing information for the goods or services rendered. Having a proper invoice numbering system helps you avoid duplicate payments that can amount to large losses for your company.
Hi Maria, there is a way for your endnote numbering to restart at 1 for each chapter when all your chapters are in a single document. You’re right that they revert to Continuous when imported into InDesign, but you can change your Endnote Options to restart the numbering at the beginning of each Story (a story is a set of linked text frames) and then divide your chapters into stories. Here’s what to do:

OK, First, you need to reread the blog. You should NOT be storing the Transaction_ID. It is a calculated value. Second, your naming is what confused me. Your Passenger table should have an autonumber PassengerID. That PassengerID should be the Foreign Key in your Reservations table. Your servation table should also have an autonumber for ReservationID. I really don’t see why you need sequential numbering in the passenger table. I can understand it in the Reservations table, but not in the passenger table. Also, I don’t see any reason for a transaction date in the passenger table. I can understand a CreateDate for when the passenger signed up.
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.

Layout your ticket in InDesign, one on each page, using the Page Number function to number the tickets. If you have something like Imposer Pro (I know it doesn't work from InDesign CS3) you can, for instance, impose the pages 4up consecutive and get 4 tickets on an A4. Alternatively, make a PDF of the whole document and impose (manually, if you have to), the advantage here is that this can work as a template for other tickets, simply make a new PDF of the same size and update the PDF in the template document every time you have a new raffle ticket to do.

My intention is to use these features to take photos of monuments and have the people who are moving about removed from the final image (I guess it's the auto-align that would do this.) I tried a test and took a number of photos at home but I kept moving one object around (a pen.) The pen appears in all the images but in a different location so it always appears in the final image. When I tried auto-align with a stack that included one image without the pen, the pen was removed from the final image. Given the first scenario (i.e. the object is in all the images but in a different location) is there any way of automatically removing it using auto-align or would this have to be a manual process? In the real world, it would be possible to take a photo of a monument with people in different locations but it would be much harder (or take a long time) to take one where at least one person was not in all the photos (there's always someone loitering.)


Version control is one of the most critical elements of a document management system because it ensure users always have access to the most current version of a company document. This feature alone can cost justify the implementation of a document management system as it eliminates duplication of work and allows users to share the most current information on matters such as company policies or contracts.
All posts and other information available at Signs 101 should be viewed as the opinion only of the poster. No claim is made that any information is accurate. As such, each reader should not rely on any information available here as accurate and should independently verify such accuracy. In addition, no claim is made that posts made here will be free from profanity, obscenity, rude, hurtful, libelous or insulting opinions of the poster. Such posts should, however, be reported to an Administrator for review.
2. Yes, The code should be entered using CodeBuilder. Where you enter it depends on how and when you want to trigger the generation of the next number. If you want to use a button, that works. And no, you don’t use 000 in the NZ() function. If you want to DISPLAY at least 3 digits with leading zeros, then you do that in the Format function. Note, though, you will need to change that when you hit 1000 POs.
I'm really hoping someone might have an answer for me on this one. For the past few months, Photoshop has been auto-adjusting my images. The colors/skin tones look absolutely awful. I have had to adjust every picture to get a non-alien look to them, but they still never look as good as what was in the camera. Has anyone experienced this? If so, were you able to find a fix? I'm a PC user - don't know if that helps. Here are a couple of examples:

In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
×