Guys i need help i want to add a value in SQL it showing an error 'Conversion from string "' " to type 'Integer' is not valid.' Using visual basic connected to SQL server.
In Access, I think your use of the .Text property is confusing you. From the article:
When you move the focus to another control, the control's data is updated, and the Value property is set to this new value. The Text property setting is then unavailable until the control gets the focus again.
Since only one control at a time can have focus, ONE of those two references to .Text cannot be right. Further, I don't understand the parenthetical expression. Is that an SQL Server thing that I'm missing because I don't use SQL Server stuff? Your query doesn't appear that it is being run as a pass-through, so I would expect to see Access SQL syntax, and the various concatenations you are using don't make sense in Access SQL.
What (in ENGLISH) were you trying to do? If you were trying to enclose something inside the SQL in apostrophes (which I would understand), you omitted the leading apostrophes for each case and that is the wrong syntax for it anyway.