Hello Guys,
I have a form with a text field q_num and it stores the value in access table rqnum when i press the command button,now I want this value to be inserted into oracle sql ,how I can approach.I tried ,i get error it says object required.
strsql = "Insert into lgl_cv_num (cid,vnum,q_num) Values ( '" & rs1.Fields(0).Value & "' , " & rs1.Fields(1).Value & ", '" & Rqnum.q_num & "')"
conn.execute strsql
where cid and vnum are sql database column,and q_num is access database col. of rqnum table.How I can insert the value of q_num into q_num of table lgl_cv_num
Thanks
vsap
I have a form with a text field q_num and it stores the value in access table rqnum when i press the command button,now I want this value to be inserted into oracle sql ,how I can approach.I tried ,i get error it says object required.
strsql = "Insert into lgl_cv_num (cid,vnum,q_num) Values ( '" & rs1.Fields(0).Value & "' , " & rs1.Fields(1).Value & ", '" & Rqnum.q_num & "')"
conn.execute strsql
where cid and vnum are sql database column,and q_num is access database col. of rqnum table.How I can insert the value of q_num into q_num of table lgl_cv_num
Thanks
vsap
