WesParkinson
New member
- Local time
- Today, 06:41
- Joined
- Jun 8, 2012
- Messages
- 9
Hi All
I have put together a form that allows the user to highlight parts of a Value and state which parts are a prefix, which is a batch and which is a serial. (These are my companies terms for it) They can also state how each part incremements. See attachment.
I wrote a few queries to sequence check them which work fine on my initial test data, however once I import a full job to trial, the queries take for ever to fully process. This is naturally therefore an inacceptable solution, I therefore need help in completing this in code.
Under the value to parse you can see how it breaks out the field and shows the start and end or MID() points needed to pull the relevant part of the value.
What I want to acheive is this:
Once filled out the user clicks Check
The Module will check that the Value increments as per user input
Produces a report to state how many records where in the recordset and where if any, sequence "jumps" or "anomolies occur
Can any please write something for me so I can adapt and learn how it was done. I am not a pro-programmer but as I have more knowledge than my colleagues this has landed on my lap and I really need help.
Thank you to all who have helped me thus far and those who try to help me with this.
Thanks
Wes
I have put together a form that allows the user to highlight parts of a Value and state which parts are a prefix, which is a batch and which is a serial. (These are my companies terms for it) They can also state how each part incremements. See attachment.
I wrote a few queries to sequence check them which work fine on my initial test data, however once I import a full job to trial, the queries take for ever to fully process. This is naturally therefore an inacceptable solution, I therefore need help in completing this in code.
Under the value to parse you can see how it breaks out the field and shows the start and end or MID() points needed to pull the relevant part of the value.
What I want to acheive is this:
Once filled out the user clicks Check
The Module will check that the Value increments as per user input
Produces a report to state how many records where in the recordset and where if any, sequence "jumps" or "anomolies occur
Can any please write something for me so I can adapt and learn how it was done. I am not a pro-programmer but as I have more knowledge than my colleagues this has landed on my lap and I really need help.
Thank you to all who have helped me thus far and those who try to help me with this.
Thanks
Wes
