Code:
strSQL = "SELECT * FROM SUPPLIER WHERE sName LIKE '%" & inputByName & "%'"
Code:
strSQL = "SELECT * FROM SUPPLIER WHERE City LIKE '%" & inputByName & "%'"
wietmie
Last Activity: Sep 18 '08, 02:33 AM
Joined: Aug 15 '08
Location:
-
I think my problem solve, today, my Access 2003 and VB6.0 act weird. Here what i face today:
i enter word "AM" and my VB return correct result.
i enter word "W" my program say Cannot find Record... -
Windows based application. Is it possible?...Leave a comment:
-
Build A Searching App. Like Google
Hai, i just wanna ask, is it possible to do a searching result like google using VB6.0, but google are too complicated, what i mean just, user put the searching word in the textbox, then it will display all possible result like hyperlink, then user can click the hyperlink and display the detail. Is it possible? What in my mind, the only idea i have is using datagrid, display all possible result in the datagrid, which is i'm working on it, but still... -
Problem solved Yey! I Just put one button, BACK button, and i close the recordset in that button, so it wont touch the datagrid in the datagrid sub function....Leave a comment:
-
SOLVED, Wrong in SQL statementsBut new problem arise which when i'm using rs.close, the data cannot be view in the datagrid, but when i detele the rs.close, then if i want to search twice, error occur that say, "Operation is now allowed when the object is open" and highlite in the rs.Code:"SELECT sName, sAddress, City from SUPPLIER where sName LIKE '%" & txtViewLocat.text & "%'
Is there...Leave a comment:
-
LIKE Statements AND Datagrid
Hai everyone, Can anyone help me with the LIKE statements which is the datagrid will show the data when the user input the search text, and the sql will search the record using the LIKE statements, when using the LIKE statements, there might be more than 1 result, for the first time, i want to bind the possible result to the label, where user can click the label then guide the user to the detail info in another page. But i think it might be complicate,... -
Yes!! It works!, thank u everyone, my problem solved, must use the "%" symbol to make it works
...Code:strSQL = "SELECT * FROM SUPPLIER WHERE sName LIKE '%" & inputName & "%'"
Leave a comment:
-
SQL LIKE statements
Hai, i'm new here, i would like to ask about SQL statements, i'm using VB6.0 and my systems if more on searching record, so the SQL statements is very important to search a record, so back to the question, i do this to search the "company name"...Code:Private Sub cmdNameView_Click() Dim strSQL As String inputName = UCase(txtName.Text) Set rs = New ADODB.Recordset If inputName <> "" Then -
Toolbox - no control for datagrid
Hai, i'm new here, i want to post a question about to bind data to the datagrid and allow user to click on a specific data in the datagrid and display the detail of it. but i'm shock when i want to add datagrid control, i could not find the control. Is it anyway to add the datagrid control? or i have a problem with the installation?
thanks in advance
Edit: After a bit exploration, i found it, Tab Project -> components...
No activity results to display
Leave a comment: