hi! i'm using a ms access 2003 and vb6. I have a textbox and a datagrid controlled by an adodc. can anyone tell me how can i display the data that I need in the datagrid. example: i entered a lastname "cruz". I want the datagrid to display customers that has cruz surnames? can that be possible. please help me. :)
Is this a command button or in the form_load? well it may kinda twisting but my code is something like this
Private Sub Search_Click()
Set RS = New Recordset
RS.Open " select * from records where firstname or lastname = '" & txtsearch.text & "'", cn, adOpenDynamic, adLockOptimistic
If RS.EOF Then
MsgBox "Record not found"
(this is my problem, I need the datagrid to display the lastnames that ends with cruz)
then I also need to display on the datagrid the lastnames and firstnames that would match in the txtsearch
it's really twisting my head out. thanks for the help. :)
I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but ...