1 AndreRet 362 7 Years Ago HERE is a full on sample with code. Votes + Comments PoisonedHeart: nicely done, Andre, it served also as my reference....Thank you
0 OPDiscussion Starter Naveed_786 10 7 Years Ago i have saw these examples but it does not meet my requirment please provide my some sample code
0 AndreRet 362 7 Years Ago Naveed, after 152 posts I'm sure that you know how to post a proper question. Your question How can we auto complete a textbox in VB 6 please help is answered by my post above. Maybe you should give me more information on exactly what you want before saying the code does not work for you. What do you want to automate in your textbox?
0 OPDiscussion Starter Naveed_786 10 7 Years Ago Sorry when i press 'a' then there should be a drop down list having all records strating from 'a' Sorry if you mind exteamly sorry
0 AndreRet 362 7 Years Ago No problem.:) Question - Will the text box read from a database or normal text file. In other words, if you press "a", will it read from a database all records starting with a, all will it look for all words starting with a from a pre-defined text file?
0 AndreRet 362 7 Years Ago Under your text box change event, open the database and read from it by using the following select statement - SELECT YourFieldNameHere FROM YourTableNameHere WHERE YourFieldNameHere LIKE " & "'" & Textbox.Text & "%'", cn, adOpenStatic, adLockOptimistic
0 OPDiscussion Starter Naveed_786 10 7 Years Ago I am using this peace of code but still no luc please help On Error Resume Next rs1.MoveFirst Set rs1 = db.OpenRecordset("SELECT StudentName FROM Admission WHERE StudentName LIKE '" & txtsname & "%'")
0 AndreRet 362 7 Years Ago Show me all the code you are using for reading the data, not just my peace of code. I'm sure the error lies in there somewhere.:)