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
|
|||
|
|||
Custom Autonumber
Hello everyone,
How would I go about creating a "custom autonumber routine"? Any comments would be helpful! Thanks! Evan McCutchen evan AT radiologyonesource DOT com |
#2
|
|||
|
|||
Custom Autonumber
Evan,
If I understand correctly what you are after, the answer depends on how you add records to the table. So, if records are added manually, you can do it on the data entry form; if they are imported from an external source, you can use a calculated field in an append query. More specifically: Form: you can use the Default Value property of the control bound to the PK field, or you can use some code fired by the On Current event of the form, and allowed to run when NewRecord = True. Append Query: you can use Access built-in finctions in a calculated field, or a custom function (written in code). If you post more details on what you are trying to do, you will get more specific help. HTH, Nikos "Evan McCutchen" wrote in message ... Hello everyone, How would I go about creating a "custom autonumber routine"? Any comments would be helpful! Thanks! Evan McCutchen evan AT radiologyonesource DOT com |
#3
|
|||
|
|||
Custom Autonumber
Nikos,
I was actually looking for the information about the form. Thanks for your assistance... that was just what I was looking for! I have problems thinking outside of the box when it comes to access. Again, thanks for your help! Evan McCutchen evan AT radiologyonesource DOT com "Nikos Yannacopoulos" wrote in message ... Evan, If I understand correctly what you are after, the answer depends on how you add records to the table. So, if records are added manually, you can do it on the data entry form; if they are imported from an external source, you can use a calculated field in an append query. More specifically: Form: you can use the Default Value property of the control bound to the PK field, or you can use some code fired by the On Current event of the form, and allowed to run when NewRecord = True. Append Query: you can use Access built-in finctions in a calculated field, or a custom function (written in code). If you post more details on what you are trying to do, you will get more specific help. HTH, Nikos "Evan McCutchen" wrote in message ... Hello everyone, How would I go about creating a "custom autonumber routine"? Any comments would be helpful! Thanks! Evan McCutchen evan AT radiologyonesource DOT com |
Thread Tools | |
Display Modes | |
|
|