Recent content by tfoulkes
-
T
Search Form Textbox Adding characters
Hmmm! good question... in my example: .RowSource = "SELECT * FROM data WHERE [Page Path]Like '*" & Me.SearchTextBox & "*' ORDER BY [Page Path];" change it to: .RowSource = "SELECT * FROM data WHERE [Page Path] OR [Date] OR [Name] Like '*" & Me.SearchTextBox & "*' ORDER BY [Page Path];" Just... -
T
Search Form Textbox Adding characters
Re: Confused I'm no longer running the query. I've deleted it and am using the on_click procedure of a button to search the table "data" with the code above. Sorry for the confusion :o It all works fine now... I've upped the column count of the list box so that it shows all the data and... -
T
Search Form Textbox Adding characters
What I've done.... ...is put this code behind the button: Private Sub cmdSearch_Click() If IsNull(Me.SearchTextBox) Then MsgBox "You have not entered any Name to Search.", vbExclamation, "Title" Exit Sub End If With lstResults .RowSource = "SELECT * FROM data WHERE [Page Path]Like '*" &... -
T
Search Form Textbox Adding characters
I've put no code behind it it's just the button wizard... Should I code an event procedure? -
T
Search Form Textbox Adding characters
? Search Form Textbox Adding characters ? Hi, I've got a query that does a search on the text from textbox on a form. The query runs fine when you run it directly, asking for the text field [forms]![search_form]![wordInput].[Text] and finding specific results on what you type, or more if you...