Syntax error (missing operator) in query expression on vb6

Question

I have been searching for an answer on Stack Overflow and on Google but found nothing. I am doing this as a school project and can not get my head around it. I'm am working with a Access Database and it will not allow me to search for the last name.

Here is my problem: Syntax error (missing operator) in query expression 'Last Name = '(Namethatwastypedwithoutbrackets)"

And this is my code

Private Sub cmdSearch_Click()
Dim sql As String

Call Conn.Connect
Adodc1.ConnectionString = Conn.connstr


Adodc1.CommandType = adCmdText
Adodc1.ConnectionString = connstr
sql = "Select * from Table1 where Last Name  = '" & txtSearch.Text & "'"
Adodc1.RecordSource = sql

Adodc1.Refresh

End Sub

I really appreciate if anyone can tell me what's wrong since i don't have any idea what the error is.

Ken White · Accepted Answer · 2016-06-05 04:36:35Z

2

The error message is telling you that you need brackets around your column name (Last Name) because it has spaces in it.

sql = "Select * from Table1 where [Last Name]  = '" & txtSearch.Text & "'"

answered Jun 5, 2016 at 4:36

Ken White

126k15 gold badges237 silver badges476 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error (missing operator) in query expression on vb6

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related