Showing search results in a Listbox while entering text in a textbox - See Desc. for code

[chetansj10]

fine. will you pls give me some more on search like i need to give error if we give wrong data in textbox. how to display error message in label like inputed data is not exits in database

[somePalestinian]

Thank you for the video :) can you please let me know how i can do the following:

1- Search by ID number of a client in Text Field when clicking "Search" button. I want to display results in the same form (DataGridView VB 2010)...once I get the result I wanna double click on it and open the client's form.

thank you very much

[thugs0prince]

how about the code



[thugs0prince]

what the code of that

[SKHANCHANNEL]

can you plzz tell me the code on c# of same thing

[ATnimk]

sir...can i have the source code example on how you do that? thanx if u could help...it important for me..

[learnvb91]

@msaccessdev sir i have problem to link to another form..can i have the example of source code sir?

[poisoneffinivy]

@msaccessdev oh now its working thanks! can you please tell me how to redirect when you double click one info from the list box? it's our project and i couldnot do it. please? :)

[poisoneffinivy]

i got an error messege of invalid character and a highlighted underscore. what does this mean??

[msaccessdev]

@poisoneffinivy, It means you're not copying the code correctly.

[Badshahkhanisb]

Can you make the same in Visual Studio 2010 with VB.NET scrip ?

[msaccessdev]

@Badshahkhanisb , Not at this time.

[heiahnlee]

can i have a copy of the codes for that module ? tnx. :D

[heiahnlee]

why is it an error occured? and says identifier expected? pls. help :(

tnx. :D

[davidsu1970]

@msaccessdev Dude, this is awesome thankyou. In the listbox VB there's a double comma before the stWhereClause at the end. Im getting a missing operator error from this and am guessing this is because a filter name (or similar) needs inserting between the commas. Is this correct and if so, what should i insert to get this to work? Thanks again.

[umair0001]

@davidsu1970 , The double commas are correct.doublecheck what's in the strWhereclause when this code runs.

[davidsu1970]

@umair0001 The stWhereClause is defined as ReferenceNumber in my code, (OrderRowID in the original). The debugger steps through each line until it hits the double commas and then throws up the 'missing operator' error. Can you elaborate on your comment?

[umair0001]

@davidsu1970 , Not available to troubleshoot this for you at this time. Sorry, Umair

[davidsu1970]

@umair0001 No problem if you don't know. welcome to my world.

[r0nces]

Sir can i have the syntax on the listbox please??

it will be a great help in my thesis...thanks..

[OneLife44444]

hi, can this be done without using the "add data source" method as I have connected my project to my database manually..

thanks

[williamscotthill1]

My email is overdhill@yahoo.com. Trying to build program, but don't know anything. Interested in consultation.

[nalydcalma]

Hi Sir,

Why does _ is invalid character? i cant work this out.

[nalydcalma]

Hello msaccessdev!

Why does _ is invalid character? please reply, i cant work this out

[tubewatcher314]

too bad you didnt show how to actually make it, and link the records

[suzetita]

Hi... sorry to bother you... I tried to use this code, but I don't know what I did wrong... Private Sub Texto1_Change() On Error GoTo Err_Texto1_Change Dim strSource As String strSource = "SELECT Área" &_ "FROM INVENTARIO" &_ "Where Área Like'*" & Me.Texto1.Text& "*' " Me.Lista1.RowSource = strSource Exit_Texto1_Change: Exit Sub Err_Texto1_Change: MsgBox Err.Number & " " & Err.Description Resume Exit_Texto1_Change End Sub and how you open the form when double clicking the selected on the list?

[MiguelFreitas12]

msaccessdev, Thank You Very Much !

"This is EXACTLY what I need" too, and it work's( the search part ), but don't work the double click.

In other words, when I click on the line i want, don't open the form.

Can you tell me why ? Please.

Thank you one more time. It was very helpful.

Sorry about my english, but I'm portuguese.

[thugs0prince]

@MiguelFreitas12 pls give to me the source code

[MiguelFreitas12]

msaccessdev, Thank You Very Much !

"This is EXACTLY what I need" too, and it work's the search part, but don't work the double click.

In other words, when I click on the line i want, don't open the form.

Can you tell me why ? Please.

Thank you one more time. It was very helpful.

Sorry about my english, but I'm portuguese.

[msaccessdev]

@MiguelFreitas12 ,

Sent you an email.

[katesrae]

Can you help me figure out what is wrong with my code? This is EXACTLY what I need!!! Does this work for Access 2003??

[umair0001]

@katesrae,

send me the code, I'll take a look, this example was built in 2003.

[MiguelFreitas12]

make a tutorial video! PLEASE

[atoybee]

Hi. I tried the code but failed. can u check my code and tell me whats wrong with it? because im a totally beginner in access.

Private Sub txtProperty_Change()

On Error GoTo Err_txtProperty_Change

Dim strSource As String

strSource = "SELECT Group, Group Coordinator, Laboratory, Period, Time, Date, Number of Students" &_ "From VenueLab" &_ " Where Laboratory Like '*" & Me.txtProperty.Text & "*' " _ & "Or Group Coordinator Like '*" Me.lstSearchResults.RowSource = strSource

[007ThaChief007]

How did you make that kind of Listbox?

[msaccessdev]

@007ThaChief007 , I grabbed it from the toolbox and set it's properties.

[bantex077]

Sir Can You gave me a sample? payabayabjohncarlo@yahoo.com Thx and u do that at VB 6.0 or in Acces 2007?

[bantex077]

Sir were did you that project and can you help me :D

[21khulitzify]

asan po ung code n2???

Pag'aaralan q lng po...tnx:)

[msaccessdev]

@21khulitzify , What?

[caseinpoint1]

Thank you. That is so freaking awesome.

[msaccessdev]

@caseinpoint1, Thanks!!