Member Avatar for smile4evr

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
  • 71 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man 
sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"
commented: always help +1
Member Avatar for smile4evr

thankx a lot! worked great!

sql = "INSERT INTO Department(Department_ID,Department_name)VALUES('" & deptid & "','" & Text2.Text & "' )"
Member Avatar for Jx_Man

You're Welcome....
Don't Forget to mark this thread as Solved :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.