Newbie to VB need help!
 

Hye guys(N Gals)

I am new in vb programming and I have few queries.

1 Does sql queries work on access?
2 How to add a Database(access) column to vb combobox?
(Eg if dbs file is abc.mdb ; table is student, attribute needed to be added in
combo box is student_name)
3 how to add keypress event (Actually the event may be different, what i want is in an combobox Or text box when i type letters for each letters typed vb should run select query for entire string
or
I want the effect that when a string is being entered similar data existing in dbs files should show up as in google search box when u enter something it shows previous searches those are similar)

ie. in combobox in question 2 if i type "M" it should show all names begining with M
i e sql query will be
select student_name from student where student_name like M%;

please help...

Re: Newbie to VB need help!
 

http://www.dotnetspider.com/qa/Question129239.aspx

Try this link - I found it by googling this phrase:
vb.net combo box bind to access mdb

I'm sure it will get you started.

Re: Newbie to VB need help!
 

1 Does sql queries work on access?

Yes, they do work.

2 How to add a Database(access) column to vb combobox?
(Eg if dbs file is abc.mdb ; table is student, attribute needed to be added in
combo box is student_name)

You need to connect to the database first, then open a recordset that opens the table student, the iterate with a For loop through the table by adding each student name to the combo box with "comboboxName.AddItem"

3 how to add keypress event (Actually the event may be different, what i want is in an combobox Or text box when i type letters for each letters typed vb should run select query for entire string
or
I want the effect that when a string is being entered similar data existing in dbs files should show up as in google search box when u enter something it shows previous searches those are similar)

oh.... you want something like autosuggest, I suggest you check PlanetSourceCode.com under the VB6 category and look for AutoComplete, wait, let me give you a link, look for the code on this address:

http://www.planetsourcecode.com/vb/s...t=Alphabetical