Hi guys,
I really need your help!
Im having some trouble in saving data in my system, this was happened about 4 times already. My problem is that every time the user save the files of one patient after the check-up all the previews data of all patient's record was being replaced by the new data inputted. Is there a way to backup all the data every 1 or 2 hours so I can retrieve the previews record, I already have the daily backup.
Thanks in advance!
here is my code in saving data:
SQL = "Insert into tbl_Main (Employee_ID, Employee_Name, Age, Sex, Division_Name, Department_Name, Section_Name, Position_Description, Appointment, CheckupDate, Findings, Recommendation, Illness, Status)" & _
"VALUES ('" + Me.lblEmpID.Text.Trim + "', '" + Me.lblEmpName.Text.Trim + "', " + Me.lblAge.Text.Trim + ", " & _
" '" + Me.lblSex.Text.Trim + "', '" + Me.lblDivision.Text.Trim + "', '" + Me.lblDepartment.Text.Trim + "', " & _
" '" + Me.lblSection.Text.Trim + "', '" + Me.lblPosition.Text.Trim + "', '" + Me.lblAppointment.Text.Trim + "', " & _
" '" + Me.dtCheckup.Text.Trim + "', '" + Me.cmbFindings.Text.Trim + "', '" & Me.txtRecommendations.Text.ToString & "', '" & Me.txtIllness.Text.ToString & "', 1)"