Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

VBA Event on Batch new line

Last post 08-28-2008 9:30 PM by Shane Dalgleish. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 08-28-2008 9:30 PM

    VBA Event on Batch new line

     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_HandleException
    Certainly 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?

     

    Filed under:
Page 1 of 1 (1 items)