#### The expression: Nz(DMax(“[PONum]”,”tblPO”),0)+1 will check if a PONum already exists. If it doesn’t it returns a 1, if it does it returns the number incremented by 1. If the number exists, but is 0 it will return a 1. In my blog I advise that number should NOT be generated until the user is ready to save the record. And to immediately commit the record after generating the number. Therefore, there should be no issue about giving them a new number if they go back to it.

If you are designing and building a Trident-class submarine, a MIG-27 jet fighter or an international space station, you, most likely, will need millions of parts, so a long part number format would be needed and will make sence. Otherwise, save yourself the trouble of reading all those zeros and make your numbering system practical. Our Documentation Management Procedure shown in Chapter 3 prescribes part numeration with a four-digit part number format that allows for 9,999 parts, which is probably enough for majority of companies. If your operation is small, drop it to three digits – you may always change it later if you need to. One of my customers, who won my “the Best Part Number” Grand Prize, numbered their documents as 201, 202, 203, and so on. Short and sweet!
While I haven't read all of the food safety schemes, I've seen enough of them to state that in general, none of them require a specific numbering system - they just require you to have your documentation organized.  How you do it is up to you.  Remember the ISO mantra: "do what you say, say what you do".  This is the standard that all auditors should hold to in the absence of regulatory or other requirements.  If it is written in your SOP that files are to be stored in a certain way or that there will be a notice posted on the bulletin board or a flourish of trumpets over the public address system and a parade when a new policy is written, then follow the rules you have set forth for yourself.
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.
LION carries a wide range of high quality heavy-duty automatic numbering machines from the 5-wheel model to the 13-wheel model. Various specifications are available for your specific individual need. LION numbering machines are precision crafted of one-piece hardened steel frame. All metal interior construction will provide years of reliable use. This self inking numbering machine is ideal for sequential numbering operations to use as a date and number stamp, serial number stamp and inspection stamp, etc. Custom numbering machines are also available so that it can work to your exact need.

# Scott, I was able to try this as I assumed that is what I needed to do. It does not work. First, the current macro for that button is a Save Record, Close Window operation. How could I keep this and also add Code? If I just add a new button to the form and under the On Click Event put the code you suggested, I get a compile error of “method or data member not found” and ” .txtPROJECT” is highlighted. The actual field is “PROJECT ID#” and it is a long integer number. Entry I have is: Private Sub Command88_Click()

The Artifact ID should NOT be your PK. There is no reason for it to be and to try and use it as such will be a headache. A primary key is simply a unique identifier for a record. Many purists will tell you that users should never see the PK and in your case, I would recommend that. Use an Autonumber as you PK and you can use that as your corresponding Foreign Key in related records. To prevent duplication you can make the combination of Collection Point ID and Artifact ID a unique, multi-field index. Then display the combination as I indicated where you need to show the user a record ID. This is all explained int he blog.
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks....
So how to organize them?  Rather than repeat what others have said, let me talk about two other areas other than the previous posts that will help you decide - because I strongly recommend you try to avoid the same mistakes others have made - the real fun is making NEW mistakes!  If your company is of any size, you should be looking at managing change within the company in an orderly fashion through regular meetings.  Yes - Management of Change!  Many of the companies following ISO-based systems call it an "EMM-OH-SEE" meeting, others call it Change Control Meeting.  Bottom line: these are many of the folks that are dealing with the files that you're organizing, so give them a say in how to organize it and what the hierarchy will look like.  In addition, these are also the same people that will likely be involved when a process is changed, so it is logical to be sure they understand where to find the files and how to name them.  I would also recommend that if an IT manager (or decision-maker) doesn't want to be part of the MOC/Change Control Team, that they are available for phone calls during the time the meeting is held, since their input on topics or follow-ups is likely going to be needed a time or two.
There are many users who search for a simple and instant way to add sequential numbering to PDF forms and pages present in the forms. However, they are not able to find the solution as most of the online tools insert serial numbers to single PDF only. Thus, in the above section, we have introduced an automated solution using which users can easily apply page number in PDF forms having different pages.
Hi reader in the U.S., we're interrupting your Wednesday evening because it's important. We need your help. It's a little awkward to ask, because we’re not salespeople. We’re librarians, archivists, and information junkies. We depend on donations averaging $16.36, but fewer than 1% of readers give. If you donate just$3, the price of your Wednesday coffee, Wikipedia could thrive. Thank you.
You don’t have to be a born salesperson to move all your tickets, but the better your sales tactics, the more successful you’ll probably be. Peter Kajanzy teaches how to crush a sale with pro techniques. One bit of advice he offers: When people ask for the price, instead of doing a complex breakdown of one for $2, three for$5, and so on, go straight to “You can buy five tickets for \$8.”


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.

If the sequence of real numbers (an) is such that all the terms are less than some real number M, then the sequence is said to be bounded from above. In other words, this means that there exists M such that for all n, an ≤ M. Any such M is called an upper bound. Likewise, if, for some real m, an ≥ m for all n greater than some N, then the sequence is bounded from below and any such m is called a lower bound. If a sequence is both bounded from above and bounded from below, then the sequence is said to be bounded.
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.

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.
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.
Our documents are given control numbers based on function category: what part of production they are related to. For example, E for Equipment (forklifts, pallet jacks, etc) or HS for Health & Safety (cleaning and sanitizing procedures and check sheets). They are then assigned a number after that, followed by a dash (-) and second number which represents the revision number.

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.
I have screen shots of what I have in my db, where can I send it to you (it is in word format) so that you can take a look at it to see what I am doing wrong. I took a screen shot of what is listed for the button and I took a screen shot of the text box Job No. I don’t know how to bound anything other than put the code behind the button and putting the Job_No in the code as you stated. I understand what you are saying, but I thought if I put the text box name Job No in the code behind the button then it would be bound to my table with the Job No field. Heeeelllllppppp!!!! I am sorry that I can’t seem to grasp this….but appreciate all of your help!
That’s enough tips for now. You’ll be filling your fundraising thermometer template How to Create Your Custom Excel Fundraising Thermometer Template How to Create Your Custom Excel Fundraising Thermometer Template Use an Excel thermometer chart to visually keep track of your financial goals. Whether you're saving for a new gadget or fundraising for a good cause, here's a step by step tutorial. Read More in no time. Let’s get to the tickets.
is defined as the set of all sequences {\displaystyle (x_{i})_{i\in \mathbb {N} }} such that for each i, {\displaystyle x_{i}} is an element of {\displaystyle X_{i}} . The canonical projections are the maps pi : X → Xi defined by the equation {\displaystyle p_{i}((x_{j})_{j\in \mathbb {N} })=x_{i}} . Then the product topology on X is defined to be the coarsest topology (i.e. the topology with the fewest open sets) for which all the projections pi are continuous. The product topology is sometimes called the Tychonoff topology.
Numbered Ticket Printing is possible for digital printing. The ticket can be printed in full or single color for both front and back side, on a 100 lb. paper stock with gloss or matte coating. The perforation on the ticket is optional. Standard sizes available for ticket printing are 1.75" x 5.5", 2 x 7", and 2 x 11". Custom sizes are also offered.
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.