0

hi... im finding an error in the following statement...
here department is my database name... n deptid n deptname is the name of the fields on the form...

when i run the form it shows "No value given for one or more parameters."

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES(deptid,Text2)"

please help me out as only after this i'll be able to continue!

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by Jx_Man
1
sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"
Votes + Comments
always help
0

thankx a lot! worked great!

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.