If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Threaded View

Query a date from database

I am still finding the best solution.. I have join many forums but did not find a best place to answer the question. I attach a sample code

I have planting date, and I use DTpicker. I chose to plant the crop on 12/03/2007 (txtDate = Format(DTPicker1.Value, "dd/mm/yyyy")
And it list me the activities from the datasource (DBMS.MDB). You can see that, it list the activities with date in the listview before the planning date (12/03/2007 ). This activities, I should do before the planting date arrive.

From the list, you can see 26/01/2007 is the starting date for activities 1 and it took 7 days to finish this activities. The date expected to finish is on 1/02/2007

The second activities start on 2/2/2007 and expected to finish on 4/2/2007 (2/02/2007,3/02/2007,4/2/2007) and it take 3 days to finish and so on...

From the list, I want to do a query:-

My Question is, I want to do a query to find what activities I should do for the spesific date base on the list.Let say, I query date 30/01/2007, Then It list the activities in a new listview. From the listview, It show me the result and it support in activities 1.

I have create a new dtpicker and the listview to show the result form the query.Have an idea?I have trouble to do a query by date.