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.
Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.

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.

Both the Collection Point ID and Artifact ID fields are bound properly and display those exact names in the property sheet under both control source and name. On the save button I have on the form, when I click on the event tab and the on click option I have event procedure and I click the […] option to open up the code builder and this is what I currently have:


Both the Collection Point ID and Artifact ID fields are bound properly and display those exact names in the property sheet under both control source and name. On the save button I have on the form, when I click on the event tab and the on click option I have event procedure and I click the […] option to open up the code builder and this is what I currently have:

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.
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.
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.
@jhagie the code I posted above in answer to your question, is changed and works perfectly in Autocad 2018LT or at least it does on my machine, if it fails for you then the only way we can help is by seeing what the results are in your command history, which would possibly give a clue as to what is going on, or maybe show up something that would show a need for a further more directed question.
Basically, the only difference is that we now maintain a VBA.Collection, and this time we do make use of the UniqueKeyVariant parameter, using it as a key to locate the previously assigned number. If we don’t find it, we add to the VBA.Collection. The SQL to use those 2 functions remains identical. The downside is that if the query generates millions worth of rows, the memory may run out due to a large VBA.Collection. However, if a form is bound to that large dataset, it will likely have several other problems anyway so VBA.Collection should not be a problem for forms that loads a few hundred rows. The other downside is that VBA.Collection will persist indefinitely even long after the query has “finished.” Back to form example, you might need to remember to call the ResetRowNumber() function on a form’s close to ensure that you dispose of the VBA.Collection and free up the memory.
Using a template to write invoices saves you a fair bit of time. While you still have to enter all of the payment information for each order on your own, sample invoices provide a ready-made design that you just have to fill in using the relevant company and customer data. But how does the perfect invoice template really look? And what should an invoice template consist of?
Hello, can anyone help me with making serial numbers in this way: When I purchase 10 chairs, I want to monitor all of it by having serial numbers each of those 10 and those 10 numbers should have the prefix “CHR-” if they are chairs. “TBL” if tables, the codes are associated with the item category. BTW, items have categories predefined by beforehand on the items by relationships. So when I will want to monitor these 10 chairs, I will only have to click the “generate control numbers” button and each of those purchased items get their own control numbers.
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.
There are also other problems – for one thing, it’s not a very generic solution. You must customize several parts to work for different queries. If the set of tables used in the outermost FROM clause are different, to be the innermost FROM clause, you have to adjust the WHERE clause to reference the correct primary key (or some combination thereof). Then you have to also keep the ORDER BY in sync. That’s a lot of tweaks if you want to use it for different queries. That is why this is the last method listed here but it is one possible solution.
By omitting the dbFailOnError parameter only for the DROP TABLE statement, we won’t get a runtime error about a table not existing but get runtime errors if we can’t create the table or insert data for some reasons. I’m also not a big fan of creating multiple saved queries that are meant to be logically grouped together – it gets quite cluttered when there are several saved queries in a navigation pane like that. Keeping it all in VBA makes it clearer that the intention is to execute those statements together.
Ontario has the oldest exit number system, having started posting exit numbers sequentially in the 1960s along Highway 401; it switched to mile-based numbering before Canada went metric. Most short freeways do not have exit numbers, and until about 2000 (with Highways 11 and 69/400), incomplete freeways also did not have exit numbers. Interchanges with multiple exits are lettered A-B.
An invoice number is simply a way to uniquely mark an invoice to help keep track of your business transactions. Consecutive or sequential invoice numbers help to ensure that each invoice is unique and each business transaction can be clearly and comprehensively organized and referenced – for accounting reasons as well as customer support. While a receipt is generally used as proof of payment and therefore documents a finalized sale, an invoice is a request for payment that includes more detailed payment or contact information in addition to pricing information for the goods or services rendered. Having a proper invoice numbering system helps you avoid duplicate payments that can amount to large losses for your company.

Creating a sequential list of numbers, in Word, sounds like an intimidating task. Sure, you can create a numbered list quickly enough, but that feature works with additional text - you're numbering something. If you want a list of just numbers, you have to work a bit harder. Word's SEQ field might come to mind, but that solution is better suited to template-type numbering. In order words, this field works great if you're numbering documents, labels, and so on. It doesn't work so well if you just want to create a list of sequential numbers. You can use it that way, but it'll be more work than it's worth.
×