ADO Problem.

Hi Dear,
I am working with ADO. I have some problem.

Database Problems

1. I want to show some data from a specific date to a specific date.
2. Suppose I have some field in a Table like Name, Occupation etc. In Occupation Field there is Teacher, Student etc. Now I want to show only the students name from the Occupation fields.

VB Problem

1. Suppose I have a Combo box and there is some list like:Anila
David
Dave
Dumb
When I will type Du in the combo box Dumb will be selected. Like a Dictionary Software.

How I can Do this? Could you please help me?

Database :

1. For an Access Database :
SELECT Field1 FROM TABLE WHERE DateField>#1/1/2003# AND DateField<#7/1/2003#
For a SQL Server :
SELECT Field1 FROM TABLE WHERE DateField>'20030101' AND DateField<'20030701'

2. SELECT Name FROM TABLE WHERE Occupation='Student'

VB :

1. Use a combobox and set the style property to 'Dropdown List'. When you enter a letter, the combo automatically jumps to the item where the first letter matches the one you type.
It is possible to do it with multiple letters, but then you will have to use a timer and a remember the letters that are typed. I wouldn't do that unless your list is extremely long.

1.

Code:

---


Select * from tableName WHERE [date] BETWEEN '" & txtBeginDate.Text & "' AND '" & txtEndDate.Text & "'

---

2.
you want to show only the students name?

Code:

---

Select studentName from tableName WHERE Occupation = 'Student'

---

3. run a search on google for "Auto Complete combobox".

Hi RummyVB

Hope the Following link has got the answers to your Question

http://www.listensoftware.com/listbox.html


:)