I did the modification but got error at this line as runtimeerror 424 .object required
Set rs = cn.Execute("insert into employee (empname,empid,ssn) values('" & txtempname.Text & "'," & txtemplid.Text & "," & txtessn.Text & ") ")
GIVEN below is vbscript to connect to acess database and insert records into the table using forms
Private Sub Command1_Click()
Set rs = cn.Execute("insert into employee values(txtempname.text,txtempid.text,txtssn.text) ")
rs.Close
cn.Close
End Sub
Private Sub Form_Load()
datafile =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.