Click here to Skip to main content
15,912,400 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: object reference not set to instance of an object Pin
Steve Pullan30-May-06 21:25
Steve Pullan30-May-06 21:25 
QuestionHelp Pin
zenithmaximus30-May-06 18:00
zenithmaximus30-May-06 18:00 
AnswerRe: Help Pin
Christian Graus30-May-06 18:19
protectorChristian Graus30-May-06 18:19 
QuestionHow to create batch file Pin
andylimjp30-May-06 17:15
andylimjp30-May-06 17:15 
AnswerRe: How to create batch file Pin
Christian Graus30-May-06 18:20
protectorChristian Graus30-May-06 18:20 
AnswerRe: How to create batch file Pin
Chatura Dilan30-May-06 18:36
Chatura Dilan30-May-06 18:36 
QuestionUnicode characters Pin
Chatura Dilan30-May-06 15:23
Chatura Dilan30-May-06 15:23 
GeneralSearch or filter records on a form [modified] Pin
penguin500030-May-06 11:42
penguin500030-May-06 11:42 
Wonder if any of you guys could point me in the right direction? Everywhere I've searched on Google always shows me how to do this with a datagrid - but not a form - and it just doesn't seem to want to work how I want it work.
I've created a form which correctly displays all my fields in a recordset. I can scroll through them, add new records, delete records, etc. etc. and everything is fine.
I now want to add a Search field to the form so that when the user enters a search string, it automatically searches through the dataset for EITHER the CompanyName OR the CompanyID - and refreshes the display to display the appropriate search result (ie. populates the currently open form with the appropriate record).

-- modified at 18:21 Wednesday 31st May, 2006

I partly figured it out - but can't get it to work with an OR part of the SQL. Any advice would be appreciated. The CompanyID is an Autonumber field.

Dim strSearch As String = "SELECT * FROM tblCustomersParent WHERE CustomerName Like '%" & txtSearchString.Text & "%'"<br />
<br />
Me.OleDbSelectCommand1.CommandText = strSearch<br />
Me.LoadDataSet()

GeneralRe: Search or filter records on a form [modified] Pin
mr_1234531-May-06 13:44
mr_1234531-May-06 13:44 
GeneralRe: Search or filter records on a form [modified] Pin
penguin500031-May-06 19:36
penguin500031-May-06 19:36 
Questionhow to find record in datagrid Pin
Syed Ali Raza30-May-06 10:28
Syed Ali Raza30-May-06 10:28 
AnswerRe: how to find record in datagrid Pin
Leeland30-May-06 11:01
Leeland30-May-06 11:01 
GeneralRe: how to find record in datagrid Pin
Syed Ali Raza30-May-06 12:06
Syed Ali Raza30-May-06 12:06 
AnswerRe: how to find record in datagrid [modified] Pin
mr_1234530-May-06 16:26
mr_1234530-May-06 16:26 
QuestionListing Local Users and Groups Pin
JCParker30-May-06 10:18
JCParker30-May-06 10:18 
Questionhelppppppppppppppppppppppppp Pin
bawades30-May-06 7:31
bawades30-May-06 7:31 
AnswerRe: helppppppppppppppppppppppppp Pin
Leeland30-May-06 10:45
Leeland30-May-06 10:45 
AnswerRe: helppppppppppppppppppppppppp Pin
Steve Pullan30-May-06 13:20
Steve Pullan30-May-06 13:20 
AnswerRe: helppppppppppppppppppppppppp Pin
Eytukan30-May-06 18:42
Eytukan30-May-06 18:42 
QuestionCopy file to diferent domain Pin
Kosta Pereira30-May-06 7:11
Kosta Pereira30-May-06 7:11 
AnswerRe: Copy file to diferent domain Pin
Leeland30-May-06 7:31
Leeland30-May-06 7:31 
Questionhelp me Pin
bawades30-May-06 6:49
bawades30-May-06 6:49 
AnswerRe: help me Pin
Leeland30-May-06 7:05
Leeland30-May-06 7:05 
GeneralRe: help me Pin
bawades30-May-06 7:28
bawades30-May-06 7:28 
QuestionVb .NET Async Socket problem with data Pin
baja one30-May-06 6:25
baja one30-May-06 6:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.