If Len(txtSalary.Text) = 0 Or Len(txtmCover.Text) = 0 Or Len(txtMember.Text) = 0 Or Len(txtmRate.Text) = 0 Then MsgBox "Enter Values" Else tsql = "INSERT INTO Hpacc4(SalaryBill,Rate,Membership,Cover) " & _ "VALUES('" & txtSalary.Text & "','" & txtmCover & "', '" & txtMember.Text & "', '" & txtmRate.Text & "')" & _ "WHERE Scheme = '99993' AND RunMonth = '200604' AND AccCode = '110'" cnHPtest.Execute (tsql) End If
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)