omer123456
Registered User.
- Local time
- Today, 15:19
- Joined
- Feb 27, 2014
- Messages
- 10
Hi,
I am using Access 2010
We have 3 plants that use the same access D/B. The plants are 22, 33, 44. We have a generic form that launches where operators from each plant can input their samples daily.
Example:
operator from plant 22 will log in their samples as 22-101, 22-102, 22-103, 22-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
operator from plant 33 will log in their samples as 33-101, 33-102, 33-103, 33-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
operator from plant 22 will log in their samples as 44-101, 44-102, 44-103, 44-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
All this data is currently being saved into a table as text entry.
What I would like when the form loads is to have ACCESS assign the next sequential #, rather than the opertor. Since this table is currently saving all 3 plants records How will access determine next sequential # for plant 22?
We could setup a drop down menu, so when the operator chooses the plant...... Access knows it from that plant and assign the next sequential #
Any help would be appreciated. If you have an example, please load it.
I am using Access 2010
We have 3 plants that use the same access D/B. The plants are 22, 33, 44. We have a generic form that launches where operators from each plant can input their samples daily.
Example:
operator from plant 22 will log in their samples as 22-101, 22-102, 22-103, 22-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
operator from plant 33 will log in their samples as 33-101, 33-102, 33-103, 33-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
operator from plant 22 will log in their samples as 44-101, 44-102, 44-103, 44-104..... and the sequesnce continues for that plant (Notice the operator keeps a track of next sequential #)
All this data is currently being saved into a table as text entry.
What I would like when the form loads is to have ACCESS assign the next sequential #, rather than the opertor. Since this table is currently saving all 3 plants records How will access determine next sequential # for plant 22?
We could setup a drop down menu, so when the operator chooses the plant...... Access knows it from that plant and assign the next sequential #
Any help would be appreciated. If you have an example, please load it.
Last edited by a moderator: