Hi! I hope you help me with this. I have the almost same problem as #2. I have PassengerTable as table name, then I have the following fields: sequence (to follow what you have in your post), transaction_date, and transaction_ID. Basically I want the to have sequential numbering in the transaction_ID where month and date from transaction_date is shown. i also have a generate (Command27)button as trigger.Tried the code with few modifications, but it sequence doesnt populate, and doesnt show any, except for what i have in control for transaction_ID which is the “Format(transaction_date,”yyyy-mm”) & “-” & Format(sequence,”000″)” and this only shows the year and date, so instead of 2015-08-001 it shows 2015-08-.
If you want to use a bullet found in a specific font (such as the pointing hand from Dingbats), be sure to set the bullet to remember that font. If you use a basic bullet character, it’s probably best not to remember the font, because most fonts have their own version of that bullet character. Depending on whether you select the Remember Font With Bullet option, a bullet you add can reference either a Unicode value and a specific font family and style, or just a Unicode value.
There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
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.
Another issue with the part-numbering format is part number designation. Some systems associate a part number with a particular part type. For example, 10xxx indicates a procedure, 20xxx indicates a drawing, PLxxx indicates a policy-level document, and so on. An alternative approach to part numbering is a “no designation” system, where parts are given sequential unique numbers within a specified format, regardless of their type, material, application or other attributes. After all, isn’t the part title the best designator?
Footnotes, after all, are always numbered sequentially and update when you add or remove one. The problem is that each time you add a footnote you get an extra space down at the bottom of the column. The solution? Make a paragraph style for your footnotes that specifies a .1 pt tall size with a 0 (zero) leading, then choose that paragraph style in the Document Footnote Options dialog box.
There also seems to be a discrepancy how Orientation is described under Metadata for those images which DO auto rotate : sometimes it is -90 (which is how I hold the camera for verticals and which displays on most verticals) and sometimes it is "normal" even when it has auto rotated the image. I do not understand this difference."Normal" is also used to describe the orientation of those images which DO NOT auto rotate for viewing.
"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.
Erica Gamet has been involved in the graphics industry for an unbelievable 30 years! She is a speaker, writer, and trainer, focusing on Adobe InDesign and Illustrator, Apple Keynote and iBooks Author, and other print- and production-related topics. She is a regular presence at CreativePro Week’s PePcon and InDesign Conferences, and has spoken at ebookcraft in Canada and Making Design in Norway. You can find Erica’s online tutorials at CreativeLive and through her YouTube channel. When she isn’t at her computer, she can be found exploring her new homebase of Seattle and the greater Pacific Northwest.
I need a running number from 1001-1200, so after I apply the print merge, it creates 200pgs of the voucher.When I try to save this file, it takes almost half an hour to do so.I think this is due to the heavy file size?In addition, the local print shop knows nothing about print merge and imposition, so I have to prepare the artwork readily in A3 size to print.The imposition creates a 10pgs files.I wanted to save this as PDF to preserve the color, but it turned out to be a nightmare (in daytime) for me that it takes more than2 hours to generate the 10pgs PDF.
You can change the numbers in the list by restarting the sequence or by specifying a new start number. You can change the list's style. You can do anything to this list that you can do to a normal numbered list because it is a numbered list, with one exception: the list, while easy to format, is fixed. If you delete an item, the list updates accordingly, but I haven't found a way to add numbers.
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
Before you complete the merge, preview the merge results to make sure that the tracking numbers will display as you want them to in your publications. You can preview the merge in two ways: While you are refining the layout to review the layout of the individual coupon or gift certificate, or when you are getting ready to print, to preview the arrangement of coupons or gift certificates on the printed sheet.
If you are still reading this then perhaps you are looking for a simple and reliable way to number a couple of lists in a Word document. If you read John's article then you have already been informed that field numbering is simple and robust. If you are like 9 out of 10 Word users in my office then anything more than 1. space space Blah, blah "enter" 2. space space Blah, blah ... defies simple! If that applies to you, then the "SeqField Numbering" Add-In presented later in this page is for you.
Thank you for your reply. It reassured me that I was on the right path. From having read other Help texts, I guessed that I would have to use good ole mail-merge and set up a numbers list in Excel. Luckily my knowledge of Excel was good enough to know about the drag&drop for sequential immediate numbering. When it came to the crunch, it was this particular type of mail merge which gave me a bit of initial difficulty. Despite my having used it happily and often in Word, for labels in Publisher, it was - not surprisingly - different in certain respects; principally the crucial point of the Print stage, which necessitated finding the option Publications & Paper Settings, and selecting 2 specific parameters, namely (1) Multiple pages per sheet, (2) Single-sided printing (my default double printing had appeared). Once I'd sussed this, it was plain sailing. Thanks again.
You can control whether your next paragraph number continues the current sequence or starts again at 1 within that same right-click menu. If one of your numbers gets out of sequence, simply right-click and choose Continue Numbering. If you want to force the number back to the beginning (say, you’re switching from interrogatories to requests for production), choose Set Numbering Value (which will also give you the option of continuing the previous list).
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.
There are three settings we need to embed in this field. The first is to tell it what kind of numbering we want to do (in this case, “First, Second, Third”), what case we want to use (upper case, title case, etc.), and a switch to tell Microsoft Word to increment the numbers. Click each of these settings as shown below, being sure to click Add to Field after each one:
Is there a way to have page numbering span multiple worksheets in a file? I would like to be able to print all the worksheets in a file and have the page numbers in the second worksheet pick up where the page numbers in the first worksheet ended without having to manually adjust the start point in worksheet 2. Please response back to the group. Thanks. JWeinberg I assume the page numbers are set up in your header/footer. If this is correct then all you need to do is select all the sheets you want to print by clicking on each sheet tab while holding down the control key. This will the...
Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...
Ok I guess it is better for me to explain what I am doing. I am in the process of creating an Access Database that an individual has been using an Excel spreadsheet forever and a day. Well the individual has on occasion doubled up numbers, forgot numbers, etc. So on what I have learned from different Access courses and Google searches I am trying to apply my knowledge.
If you start to type in what appears to be a numbered list, Word formats your manually typed "numbers" to an automatic numbered list. The main benefit of this option is that you do not need to click any button to start numbering and you can choose your numbering style as well. For example, if you type "(a) some text" and press Enter, it starts numbering using the "(a)" format.
Hello! I would like to chart varying salaries against specific Low, middle and high numbers. Any suggestions on how to show this? Example: Salary 1 10000 Salary 2 12000 Salary 3 16000 Low 9000 Mid 15000 High 19000 THANK YOU! Do you want the Low-Mid-High values to be like a benchmark to measure salaries against? You could put horizontal lines across your chart, and use markers for the salary data. Here' a few ways to get your lines: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials...
I removed the required setting on the table level. The form does not give me an error message now, but does not close on its on. I closed it via a command then looked at the Design Projects table to see if the new record, #896, shows up. A new record is there, with all the entered data EXCEPT the very important field of the Project ID. That field is blank.
Klaus Nordby, one of our good-natured Norwegian hecklers, has produced a ray of sunshine in the midst of a deep, dark Scandanavian winter by coming up with a wonderful little trick involving adding sequential numbers inside a paragraph. For example, 1. this is the first clause of this sentence; 2. this is the second; and 3. this is the third. That’s not a big deal to type, of course, but if you had dozens of them and you needed to insert or remove numbering frequently, doing it manually would be a hassle.
Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!
When generating invoice numbers based on the customer number, you can choose whether or not to include any date information. Either way, the number will begin with the customer number and then be followed by the date (if desired) and the sequence number. No matter how you decide to structure your invoice number, the sequence number always needs to come at the end. This makes it easiest to find and to differentiate from the others in its sequence.