office tools(28235) photo & image(21529) system utilities(18725) dvd & video(15897) mp3 & audio(5497) development(3061) pspad editor(2868) home & education(2710) windows(2577) apple “back to the mac” fall 2010 event(2227)
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-.
However, using Styles with Numbering can make this a little less annoying. Once your document is complete, the last step should be to fix http://thedailyrant.net tab and update the style. It will at least prevent you from having to change each paragraph individually.
The benefit to this is that you are not limited in the layout and font used, however the file size can often be too large to upload to our website. If supplying your artwork this way, it must a press-ready PDF file – our prepress team will not be able to make any adjustments to the file.
This tip is great but it doesn’t tell me how to start w/a number other than 1. I need to create a sheet of numbered labels starting w/1702. No matter how I enter it the only number that changes sequentially is the 1st number so my second label is 2702
The cookies cannot identify you individually. If you continue to use this site I will assume that you are okay with this. You may, of course, turn this feature off in your web browser if it makes you uncomfortable.
If you are looking to do paragraph numbering with multiple levels within the same number, please see the Bulletproof Paragraph Numbering series at http://legalofficeguru.com/tag/bulletproof-paragraph-numbering/
If I’m going to do multiples of say a sign, with different numbers, I use Step & Repeat ,which allows me to specify the number of objects horizontally and vertically,then I just edit my numbers. But by putting them on different pages (layers) you can print (engrave) table full after table full. You will of course have to load more material after running each one. But once the file is made your all set.
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 becomes: 2-1050.1 and the second becomes 2-1050.2 and so on.
To create a running list—a list that is interrupted by other paragraphs or that spans multiple stories or documents—create a paragraph style and apply the style to paragraphs that you want to be part of the list. For example, to create a running list of the tables in your document, create a paragraph style called Tables, make a defined list part of the style, and then apply the Tables paragraph style to all paragraphs you want in your Table list.
One other thought. It may not hurt to make option 1 a logical expresssion where it will update the number IF a number other than 0 already exists for it. This will prevent it from giving a new number if you go back, edit it and save it. I accomplished this by adding the following (roughly): If PONo=0 Then My.PONo…. (Expression and save command) Else (Save Command)
It can either be in the normal.dot template or in the template you’re using for the invoice. (It’s obviously better to use it in the invoice template so it works on any computer where the template is used.)
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.
If, when the rule is triggered, the Part Number property is blank or the same as the file name, the user would not be asked if they would like to overwrite the part number. This rule would be triggered manually from a form.