twgonder
Member
- Local time
- Today, 18:15
- Joined
- Jul 27, 2022
- Messages
- 178
Okay, I've been warned to link to cross posting and here is the one I just made with Richard Rost's site:
Sequential Annual Coding in Microsoft Access (599cd.com)
I don't think it will get answered anytime soon, I was mostly responding to one of his videos.
I won't repeat what I wrote there, it's a good enough explanation, I think.
I'm not sure, but I'm willing to wager that a DMax will cruise the entire table looking for the max of a field if not indexed.
Not optimal and not what I need since users may add text to the sequential number for their purposes.
In this case, I'm adding a sequential number for records that have a random autonumber, so users aren't dependent on the autonumber for reference.
I may decide to add the year to the sequential number.
Users might add an "E" to a sequential number to signify it's an employee, or "C" for customer, etc.
I let them choose how the reference their "Entity" table for reference other than the primary ID (just no dupes).
So, has anyone taken the time to write a real routine for Access to get sequential numbers from a table as described (in the linked article)?
In my old db BASIC it was about fifteen lines of code, but I have no idea where to properly start in VBA.
Sequential Annual Coding in Microsoft Access (599cd.com)
I don't think it will get answered anytime soon, I was mostly responding to one of his videos.
I won't repeat what I wrote there, it's a good enough explanation, I think.
I'm not sure, but I'm willing to wager that a DMax will cruise the entire table looking for the max of a field if not indexed.
Not optimal and not what I need since users may add text to the sequential number for their purposes.
In this case, I'm adding a sequential number for records that have a random autonumber, so users aren't dependent on the autonumber for reference.
I may decide to add the year to the sequential number.
Users might add an "E" to a sequential number to signify it's an employee, or "C" for customer, etc.
I let them choose how the reference their "Entity" table for reference other than the primary ID (just no dupes).
So, has anyone taken the time to write a real routine for Access to get sequential numbers from a table as described (in the linked article)?
In my old db BASIC it was about fifteen lines of code, but I have no idea where to properly start in VBA.