KAyers
Registered User.
- Local time
- Today, 05:32
- Joined
- Oct 30, 2007
- Messages
- 23
Hello!
Sorry for the repost but I wanted to refine what I was asking for and the ideas I was tossing about to officemates that don't use Access! I have searched the forums, help, and books for a nudge in the right direction but I haven't found anything applicable.
I have a request to make the records that had been controlled in a textbox into an automatically generated number.
We assign alpha-numeric identifiers to unique diagrams for wires. There are eight prefixes to describe the wires' intended use (W1-W8). The following three digits are the unique identifiers. The diagram numbers the users had been inputting would look like W1027.
Previously, the three digit number was assigned by the user after looking at the numbers and finding the next available one. The users have requested that they be able to select the prefix and the next available three digit number be automatically assigned.
The prefix is chosen by a drop-down box but the entire alpha-numeric is displayed as the "cable number." My goal would be to generate the 3-digit number and concatenate it to the prefix before displaying it in a locked textbox called "cable number"
Ideas I have come up with:
1. An array generating the number after the prefix is selected out of a drop-down box (but it needs to be able to check the existing numbers first).
2. An autonumber concatenated with a selected prefix (but if someone decides to delete the record, the autonumber will skip the used number).
3. Use the prefix as a filter and sort by ascending numbers bringing the user to the last used number (still requires input by the user) take the 3-digit number they put in and then concatenate them.
Thanks in advance for any advice!
K
Sorry for the repost but I wanted to refine what I was asking for and the ideas I was tossing about to officemates that don't use Access! I have searched the forums, help, and books for a nudge in the right direction but I haven't found anything applicable.
I have a request to make the records that had been controlled in a textbox into an automatically generated number.
We assign alpha-numeric identifiers to unique diagrams for wires. There are eight prefixes to describe the wires' intended use (W1-W8). The following three digits are the unique identifiers. The diagram numbers the users had been inputting would look like W1027.
Previously, the three digit number was assigned by the user after looking at the numbers and finding the next available one. The users have requested that they be able to select the prefix and the next available three digit number be automatically assigned.
The prefix is chosen by a drop-down box but the entire alpha-numeric is displayed as the "cable number." My goal would be to generate the 3-digit number and concatenate it to the prefix before displaying it in a locked textbox called "cable number"
Ideas I have come up with:
1. An array generating the number after the prefix is selected out of a drop-down box (but it needs to be able to check the existing numbers first).
2. An autonumber concatenated with a selected prefix (but if someone decides to delete the record, the autonumber will skip the used number).
3. Use the prefix as a filter and sort by ascending numbers bringing the user to the last used number (still requires input by the user) take the 3-digit number they put in and then concatenate them.
Thanks in advance for any advice!
K
