Private Sub command1_Click()
On Error Resume Next
If Len(text1.Text) = 0 Then
Call MsgBox("......... .........", vbExclamation, " ... ... ")
text1.SetFocus
Exit Sub
End If
If Len(Text2.Text) = 0 Then
Call MsgBox("............. .....................", vbExclamation, " ... ... ")
Text2.SetFocus
Exit Sub
End If
If Len(Text3.Text) = 0 Then
Call MsgBox("..............................", vbExclamation, " ... ... ")
Text3.SetFocus
Exit Sub
End If
If Len(Text4.Text) = 0 Then
Call MsgBox(".................................", vbExclamation, " ... ... ")
Text4.SetFocus
Exit Sub
End If
If Len(Text5.Text) = 0 Then
Call MsgBox("..................................", vbExclamation, " ... ... ")
Text5.SetFocus
Exit Sub
End If
Adodc4.Recordset.AddNew
Adodc4.Recordset.Fields!Name = Trim(Text1.Text)
Adodc4.Recordset.Fields!Nomberone = Trim(Text2.Text)
Adodc4.Recordset.Fields!Nombertwo = Trim(text3.Text)
Adodc4.Recordset.Fields!Date1 = Trim(date1.Value)
Adodc4.Recordset.Fields!Name2 = Trim(text4.Text)
Adodc4.Recordset.Fields!Nomberthree = Trim(text5.Text)
Adodc4.Recordset.Fields!Date2 = Trim(date2.Value)
Adodc4.Recordset.Update
Adodc4.Refresh
MsgBox Text1.Text & ", success.", vbInformation, " ... ........... ... "
Form1.Adodc1.Recordset.Update
Form1.Adodc3.Recordset.Update
Form1.Adodc1.Refresh
Form1.Adodc3.Refresh
Form1.DataGrid1.Refresh
Form1.DataGrid2.Refresh
Text1.SetFocus