[srisubha]

Private Sub MNUPROSAVE_Click()
str = "insert into profile(rollno,fathername,foccupation,mothername,moccupation,contactno,residentialno,mcontactno,annualincome,permanentaddress,tempaddress,pincode,pemailid,religion,caste,state,city,noofbrothers,noofsisters,schoolorclgstudied)values(' " & rno.Text & " ',' " & fname.Text & " ','" & focc.Text & " ',' " & mname.Text & " ',' " & mocc.Text & " '," & cno.Text & "," & resno.Text & "," & mcno.Text & ", " & ain.Text & " ,' " & pa.Text & " ',' " & ta.Text & " '," & pin.Text & ",' " & pemail.Text & " ',' " & reli.Text & " ',' " & cas.Text & " ',' " & stat.Text & " ',' " & cit.Text & " ', " & nob.Text & " , " & nos.Text & ",' " & sch.Text & "')"
cn.Execute (str)
MsgBox ("DETAILS ADDED ")
End Sub

while executing the above code i got an
run time error'-2147217900(80040e14)'
syntax error in insert into statement

[tlhIn`toq]

So break it down until you find something that doesn't look right

Private Sub MNUPROSAVE_Click()
str = 

"insert into profile(rollno,fathername,foccupation,mothername,moccupation,contactno,residentialno,mcontactno,annualincome,permanentaddress,tempaddress,pincode,pemailid,religion,caste,state,city,noofbrothers,noofsisters,schoolorclgstudied)values(' "
 & rno.Text & 
" ',' "
 & fname.Text & 
" ','"
 & focc.Text & 
" ',' "
 & mname.Text & 
" ',' "
 & mocc.Text & 
" ',"           <- where's the other apostrophe?


 & cno.Text & 
","
 & resno.Text & 
"," 
& mcno.Text & 
", " 
& ain.Text & 
" ,' "        <-- Oh, there it is

 & pa.Text & 
" ',' "
 & ta.Text & 
" '," &          <-- opening apostophe
pin.Text & 
",' "            <--- closing apostrophe
 & pemail.Text & 
" ',' "
 & reli.Text & 
" ',' "
 & cas.Text & 
" ',' " 
& stat.Text & 
" ',' " 
& cit.Text & 
" ', "
 & nob.Text & 
" , " & nos.Text & 
",' " & sch.Text & 
"')"
cn.Execute (str)
MsgBox ("DETAILS ADDED ")
End Sub

This isn't my normal thing but... Damn this looks like a mess. Ever think of parameterizing your stuff?

Also, it looked like you had a steady pattern in apostrophy useage - but then it goes wonky. My first guess would be that your final query has the ' and , mixed or mismatched once it is all assembled.

http://www.dreaminco...ery-a-database/

[BobRodes]

I can't see any mismatched quotes. it looks, however, like you don't have spaces on both sides of the word "values". That would be a syntax error. If you do, I would check your field names and make sure that you didn't type one in wrong.