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:...
The new SQL stored procedure lookup rules in Forms 9.1 make doing something like this possible. The example in the online help shows how to use a stored procedure to auto-append an incrementing number from the database to a form when it loads, which might solve some of your problems. However, the number is incremented after the form loads (not when it is submitted), so that might not exactly fit your needs. Here's the link to the correct page of the online help.
Drag the number, which Publisher defaults to “1,” into place on the ticket. To change the sequence, such as to start with “100” instead of “1,” click the “Page Number” button again and choose “Format Page Numbers.” Click the “Start this section with” radio button and type the new number into the field. Click the “OK” button to have Publisher update the ticket number.
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624... sequential numbering in coreldraw