1 Replies - 317 Views - Last Post: 07 February 2013 - 12:50 AM Rate Topic: -----

#1 lightroses  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 06-February 13

Fields in textboxes

Posted 06 February 2013 - 11:25 PM

Hi to all.. I was working for now in vb6.
But I have a problem when i run the save button, the message box appeared and says"no values given in required parameters."

my code is below:

Tsql = "UPDATE Tbl_Tithes SET Label11.Caption = '" & Me.txtTithes.Text & " ' where ID LIKE '%" & txtID.Text & "%'"

Call dbConnect
TConn.Execute Tsql
TConn.Close
Set TConn = Nothing
Unload Me

I knew that the conflict code i have do is in the label11.caption. I use label11.caption because it contains the date that the user will input on the form and save in access. I dont know what to do, someone help me to fixed this problem.

Is This A Good Question/Topic? 0
  • +

Replies To: Fields in textboxes

#2 andrewsw  Icon User is online

  • Fire giant boob nipple gun!
  • member icon

Reputation: 2890
  • View blog
  • Posts: 9,597
  • Joined: 12-December 12

Re: Fields in textboxes

Posted 07 February 2013 - 12:50 AM

UPDATE tableName SET fieldName = value

Label1.Caption is not a field in the database-table.

Me.txtTithes.Text & " ' where

This expression includes an extra quoted space which shouldn't be there.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1