Hi All,
In brief I need to press a button that will disable the MsgBox's, then I need the database to run through a large set of test data to check the output.
In normal circumstances the operator would be present, but for testing I just need to run the data and review the results without it stopping at every msgbox .
Manually I'd use the Replace tool in VBA to do MsgBox --> 'Validation'MsgBox. Because we do this several times a year after updates etc.. I need a more robust (non human) method to switch off MsgBox's then run code then switch MsgBox's back on.
All thoughts welcome, a search shows a few options but these relate to excel vba and not access.
Many Thanks
Thicko
In brief I need to press a button that will disable the MsgBox's, then I need the database to run through a large set of test data to check the output.
In normal circumstances the operator would be present, but for testing I just need to run the data and review the results without it stopping at every msgbox .
Manually I'd use the Replace tool in VBA to do MsgBox --> 'Validation'MsgBox. Because we do this several times a year after updates etc.. I need a more robust (non human) method to switch off MsgBox's then run code then switch MsgBox's back on.
All thoughts welcome, a search shows a few options but these relate to excel vba and not access.
Many Thanks
Thicko