Auto Complete

[Naveed_786]

How can we auto complete a textbox in VB 6 please help

[WaltP]

Try autocomplete textbox vb6

[AndreRet]

HERE is a full on sample with code.

[Naveed_786]

i have saw these examples but it does not meet my requirment please provide my some sample code

[AndreRet]

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?

[Naveed_786]

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

[AndreRet]

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?

[Naveed_786]

Yes it would read records from database

[AndreRet]

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

[Naveed_786]

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 & "%'")

[AndreRet]

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.:)