I wanted to do a select on
strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"(This code work fine)
which display only all the Name = to userid.
But how to combine this
strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"
with this
strSQL = "SELECT * FROM Info WHERE INSTR(Info.Name,'" & strSearch & "')"
so i can search the database within the Name = userid only
strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"(This code work fine)
which display only all the Name = to userid.
But how to combine this
strSQL = "SELECT * FROM Info WHERE Name = '" & userid & "'"
with this
strSQL = "SELECT * FROM Info WHERE INSTR(Info.Name,'" & strSearch & "')"
so i can search the database within the Name = userid only