If you make a list of things you need to do, starting with number 1 and continuing until all your tasks are accounted for, then you’ve made a sequential list. Something that is sequential often follows a numerical or alphabetical order, but it can also describe things that aren’t numbered but still need to take place in a logical order, such as the sequential steps you follow for running a program on your computer.
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!
What I actually want to do, is say I go out and shoot 100 images, and I want to number them 1 to 100 so I can send them to the client and they can respond back with the number of the images they like, for instance, "Give me 21, 45, 68, and 77" as an example.  Is there a way to batch process a folder of images to sequentially number them individually, or do I have to painstakingly number them one at a time?
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.
First, you have to use YOUR field and control names. The ones I use are samples. The error you are getting indicated you do not have a control named txtProject. So you have to substitute the correct name of the control. bound to the ProjectID field. By the way it is not a good idea to the octothorpe(#) as part of a field name. A controlname may be different from a fieldname. The name property of a control is on the Other tab in the Properties dialog.

Yes, I have used this system in a multi-user setting. As noted, the key is to commit the record immediately after generating the sequence. However, if the application is one where there is very heavy transaction processing. In other words dozens of users creating records simultaneously, you might want to guard further against duplication. At the speeds computers process, it is not impossible that multiple users will grab the max value before it can be incremented and saved.
Most European countries use sequential numbering schemes. Spain uses distance-based numbering on its Autovias, but not on its Autopistas. Austria and the Czech Republic use distance-based schemes. A number of European countries (including the Netherlands, Belgium and France) do not number motorway intersections, apparently because one cannot "exit" the motorway there. Countries like Germany and Switzerland have attributed numbers to their exit, but instead of the usual exit symbol, they are given a specific interchange symbol.

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.


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.
×