Hi,
I have a form in VB 6 called frmEMPLOYEE with 3 textboxes namely: First_Name, Last_Name and Employee_Id . I also have a table in access called tblEMPLOYEE. How to I create a button to take whatever that I have on the text boxes and puts in into the database.
"I have already set the connectionstring and set the recordsource and the built process was successful."
I have tried:
Private Sub Command1_Click()
Dim Rs As Recordset
'Set Rs = CurrentDb.OpenRecordset("tblEmployee", dbOpenTable)
Rs.AddNew
Rs("Employee_Id").Value = Text3
Rs("First_Name").Value = Text1
Rs("Last_Name").Value = Text2
Rs.Update
End Sub
But this doen't help. Again how do I link the application with the database. I am using access 2000 and VB 6
Thanks
I have a form in VB 6 called frmEMPLOYEE with 3 textboxes namely: First_Name, Last_Name and Employee_Id . I also have a table in access called tblEMPLOYEE. How to I create a button to take whatever that I have on the text boxes and puts in into the database.
"I have already set the connectionstring and set the recordsource and the built process was successful."
I have tried:
Private Sub Command1_Click()
Dim Rs As Recordset
'Set Rs = CurrentDb.OpenRecordset("tblEmployee", dbOpenTable)
Rs.AddNew
Rs("Employee_Id").Value = Text3
Rs("First_Name").Value = Text1
Rs("Last_Name").Value = Text2
Rs.Update
End Sub
But this doen't help. Again how do I link the application with the database. I am using access 2000 and VB 6
Thanks