Products A-Z All Services Can't find what you're looking for? Chat Live!
Products A-Z Can't find what you're looking for? Chat Live!
Can't find what you're looking for? Chat Live!
We're wanting to run a duplicate check on each line of a constituent batch, as the data is being entered, so that at the end of the batch we know that everyone of the records has been checked.
Currently, we have in the user procedure to click on each line, then do a "Duplicate Search For xxxxxx" in the menus, but users being users, this isn't always done to an acceptable standard. So we want to force them to do this, every line.
I have tested out all of the VBA events to see when they are triggered, and these ones I don't think ever fired in my testing:- Batch_BeforeBarCodeLookup- Batch_BeforeValidateRecord2- Batch_BatchException- Batch_AfterPostRecord- BatchVBARecord_HandleExceptionCertainly none fired as each line was being entered....
Does anyone know of an event that we can capture, or a way to automatically run the duplicate check on each line during entry instead of on the entire batch?