Can I change the following code?

[sreekandan]

Hi everybody, I want to retrieve the details from the database by the date from (MM/DD/YYYY) to (MM/DD/YYYY). For that I have to change the following code as follows

rs.Open "select * from Table where empid='" & Text1.Text & "'", con

So kindly anyone reply me.

[Killer42]

Hi everybody, I want to retrieve the details from the database by the date from (MM/DD/YYYY) to (MM/DD/YYYY). For that I have to change the following code as follows

rs.Open "select * from Table where empid='" & Text1.Text & "'", con

Do you need to do this instead of the empid, or the two together? Here are some ideas...

• Just the date range

  rs.Open "select * from Table where DateField Between #" & _
          strStartDate & "# AND #" & strEndDate & "#", con

• Both

  rs.Open "select * from Table where empid = '" & Text1.Text & _
          "' AND DateField Between #" & strStartDate & "# AND #" & _
          strEndDate & "#", con

I'm assuming here that your dates are in string variables, already formatted as MM/DD/YYYY.

[willakawill]

And you are assuming it is an Access database

[Killer42]

And you are assuming it is an Access database

Guilty.

I do tend to think in terms of VB6 and Access, and if people aren't specific, I figure they'll just have to make do with what they get. :)

[sreekandan]

Do you need to do this instead of the empid, or the two together? Here are some ideas...

• Just the date range

  rs.Open "select * from Table where DateField Between #" & _
          strStartDate & "# AND #" & strEndDate & "#", con

• Both

  rs.Open "select * from Table where empid = '" & Text1.Text & _
          "' AND DateField Between #" & strStartDate & "# AND #" & _
          strEndDate & "#", con

I'm assuming here that your dates are in string variables, already formatted as MM/DD/YYYY.

I tried with that codigs.But run time error has occured as "Too few parameters required".So kindly give me the suggestion for that.

[sukeshchand]

i thing there is no error in the above query

replace the code with this one

rs.Open "select * from Table where empid = '" & Text1.Text & _
        "' AND DateField Between #" & strStartDate & "# AND #" & _
        strEndDate & "#", con,adOpenForwardOnly ,adLockReadOnly

[sreekandan]

i thing there is no error in the above query

replace the code with this one

rs.Open "select * from Table where empid = '" & Text1.Text & _
        "' AND DateField Between #" & strStartDate & "# AND #" & _
        strEndDate & "#", con,adOpenForwardOnly ,adLockReadOnly

I used two text boxes to get the date from the MonthView control.
So i have written the code is

rs.Open "select * from tbl where empid = '" & Text1.Text & "' AND DateField Between #" & Text2.Text & "# AND #" & Text3.Text & "#", con, adOpenForwardOnly, adLockReadOnly

Eventhough the same error has occured.So kindly reply me

[Killer42]

It may be that you have not adjusted our field names to match your own. For example, I used the name DateField because I don't know what yours is called. If your field name is not DateField then you will need to change this.

If that's not the problem, we'll have to investigate further.

Note, if you're going to post an error message, make sure you copy it precisely. I suspect that "Too few parameters required" is not quite the wording Access used (though as always, I could be wrong).

[sreekandan]

It may be that you have not adjusted our field names to match your own. For example, I used the name DateField because I don't know what yours is called. If your field name is not DateField then you will need to change this.

If that's not the problem, we'll have to investigate further.

Note, if you're going to post an error message, make sure you copy it precisely. I suspect that "Too few parameters required" is not quite the wording Access used (though as always, I could be wrong).

I have written the following code to retrieve and display the details into the ListView control.

rs3.Open "select * from tbl where empid = '" & Text1.Text & "' AND dat Between #" & Text2.Text & "# AND #" & Text3.Text & "#", con, adOpenForwardOnly, adLockReadOnly
rs.MoveFirst
Do Until rs.EOF
   j = j + 1
   lv.ListItems.Add j, , j
   lv.ListItems(j).SubItems(1) = rs!empid
   lv.ListItems(j).SubItems(2) = rs1!firstname & rs1!lastname
   lv.ListItems(j).SubItems(3) = rs3!dat
   lv.ListItems(j).SubItems(4) = rs3!intime
   lv.ListItems(j).SubItems(5) = rs3!outtime   
   rs.MoveNext
Loop

But I couldnt retrieve all the details from the database table.
I could retrieve only the same data repeatedly until the EOF.For that how can I retrieve the full details from the table.So kindly reply me

[willakawill]

When you are posting code please use code tags. Clearly you are highlighting your code and clicking on the center justify and bold buttons. Please don't do that. Click on the '#' button instead. This is the third time I have added code tags to your posts
Thanks