Z
Zetsubo69
Guest
Good day,
I have a simple registration system where i can add, delete, edit and search the user through an access database.
I am kinda stuck on the search part where i would like to have a wild card feature. Example, the user name is Alex Wong.
I have to type in the full name and the exact case to search for that user which is quite a hassle.
Table12BindingSource.Filter = "(Convert(ID, 'System.String') LIKE '" & txtSearch.Text & "')" &
"or (GP_No like '" & txtSearch.Text & "') Or (Employee_Name Like '" & txtSearch.Text & "')" &
"or (Department like '" & txtSearch.Text & "') Or (Section Like '" & txtSearch.Text & "')" &
Continue reading...
I have a simple registration system where i can add, delete, edit and search the user through an access database.
I am kinda stuck on the search part where i would like to have a wild card feature. Example, the user name is Alex Wong.
I have to type in the full name and the exact case to search for that user which is quite a hassle.
Table12BindingSource.Filter = "(Convert(ID, 'System.String') LIKE '" & txtSearch.Text & "')" &
"or (GP_No like '" & txtSearch.Text & "') Or (Employee_Name Like '" & txtSearch.Text & "')" &
"or (Department like '" & txtSearch.Text & "') Or (Section Like '" & txtSearch.Text & "')" &
Continue reading...