Recent content by kc2npu

@cheekybuddha for example Public Sub StudentTestNeeds_Controller() If blnUseError Then On Error GoTo Error_Handler Dim SYS_MY_PROC As String SYS_MY_PROC = "StudentTestNeeds_Controller()" Debug.Print SYS_MY_PROC sys_STN_Continue = True Dim myWorkSpace As DAO.WorkSpace...

@ebs17 - what I did was break up each step of the process. The VBA procedures serve three purposes A) building long SQL strings and passing them to the Execute statement B) Allowing for iteration over records C) Encapsulating into sub steps and allowing for me to easily catch fails.

I am a little confused. I have a set of processes that I am running. i have encapsulated them all in a transaction Dim myWorkSpace As DAO.WorkSpace Set myWorkSpace = DBEngine.Workspaces(0) myWorkSpace.BeginTrans {.... my code and work ] (Each function/sub that runs if it encounters an...