[newbownerton]

Hi everyone,

I shamefully look for an answer to my newbie question

I have created a form that should allow user to communicate with the database. The search criteria are filled withing Textbox. Then the string from the textbox is transferred into the SQL Command string. However, it is not included...

SQLStr = "SELECT * FROM tblMain WHERE ID = " & txtSearchBox.Text & "'"
MsgBox(SQLStr)

And only this part is stored in SQLStr variable = "SELECT * FROM tblMain WHERE ID = " - (pops up in msg box)

Any hints? ;/

[sela007]

you say whenever you pass textbox text to SQLStr string, this string never change?

[newbownerton]

sela007, on 03 March 2012 - 04:13 PM, said:

you say whenever you pass textbox text to SQLStr string, this string never change?

Variable SQLstr is then shown in MsgBox:



So you see where it ends, variable - no matter what string it contains - is not included.

[DimitriV]

newbownerton, on 04 March 2012 - 09:20 AM, said:

sela007, on 03 March 2012 - 04:13 PM, said:

you say whenever you pass textbox text to SQLStr string, this string never change?

Variable SQLstr is then shown in MsgBox:



So you see where it ends, variable - no matter what string it contains - is not included.

Why would you add a msgbox to a string variable? You could use an InputBox for data entry…

[newbownerton]

DimitriV, on 03 March 2012 - 04:24 PM, said:

newbownerton, on 04 March 2012 - 09:20 AM, said:

sela007, on 03 March 2012 - 04:13 PM, said:

you say whenever you pass textbox text to SQLStr string, this string never change?

Variable SQLstr is then shown in MsgBox:



So you see where it ends, variable - no matter what string it contains - is not included.

Why would you add a msgbox to a string variable? You could use an InputBox for data entry…

LoL i just added it to see how does the string look like, IF finally it will work properly - txtSearchBox.text will be included I will delete this line of code xD

[sela007]

can you post the whole code so we can see how SQLStr is declared and from where is passed.

[newbownerton]

sela007, on 03 March 2012 - 04:28 PM, said:

can you post the whole code so we can see how SQLStr is declared and from where is passed.

SQLstri is declared in Module:

Public SQLStr As String

[newbownerton]

sela007, on 03 March 2012 - 04:28 PM, said:

can you post the whole code so we can see how SQLStr is declared and from where is passed.

OMG... FIXED.

It had nothing to do with the string itself.

Thanks for trying to help.