Now my question is, when inserting a record from an Access FE, how can I get this error message, instead of getting "The transaction ended in the trigger. The batch has been aborted."?
After Insert SELECT @title = title,@licNum = licensenum, @resume = resume,@lastname=lastname,@firstname=firstname,@ssn=socialsecuritynumber FROM inserted i IF @title is null or ltrim(rtrim(@title)) ='' BEGIN RAISERROR ('Please enter Title', 0, 1) ROLLBACK TRANSACTION END
strSql = "Insert into EmployeesTbl (EmployeesID, Title)" strSql = strSql & " Values (" & rs2(0) & ",'" & Obj & "')" 'On Error GoTo 0 CurrentProject.Connection.Execute strSql
From novice to tech pro — start learning today.