If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Confirmation Number
I am working on a form where a user would enter data about a product
discrepancy from the sales field organization (cost, price, date of discrepancy, comments, etc.) and I would like to append the data to a log table that will have an autonumber field generate a unique confirmation number. I would then want to give the user this confirmation number within the form after they click a "submit" button. My question, is how to have it return the confirmation number just created by the append? My first thought was to link back from the form to the table on the key fields and pull the confirmation number that was auto-created. Since I have not dealt much with auto number fields in the past I wanted to see if there is some established way of optimizing this type of task. Any help would be greatly appreciated. c- |
#2
|
|||
|
|||
Confirmation Number
If you are going to use Autonumber to generate numbers that will have
meaning to the user, you need to consider whether or not it matters if any numbers get skipped. For instance, if you generate a discrepancy entry into the log table and then delete that entry for any reason, will it matter to you that the number that was assigned to the now deleted entry is no longer available for you to use? If you care about gaps in the numbering, don't use Autonumber for this task. Instead you can generate the number yourself using something like dmax to figure out what the next number in the sequence should be. Sorry not to answer your question, but thought you should think about this, too. Betsy |
#3
|
|||
|
|||
Confirmation Number
Not concerned about the autonumber so much. Will only be entering about 500
records per year and do not expect to delete records but could flag as inactive with a checkbox (to exclude from reporting). wrote in message oups.com... If you are going to use Autonumber to generate numbers that will have meaning to the user, you need to consider whether or not it matters if any numbers get skipped. For instance, if you generate a discrepancy entry into the log table and then delete that entry for any reason, will it matter to you that the number that was assigned to the now deleted entry is no longer available for you to use? If you care about gaps in the numbering, don't use Autonumber for this task. Instead you can generate the number yourself using something like dmax to figure out what the next number in the sequence should be. Sorry not to answer your question, but thought you should think about this, too. Betsy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
Invoice Numbering | Optomyst | Using Forms | 9 | November 19th, 2005 04:37 AM |
Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |