[Jovel Mark]

Hello Guys.. I need Your Help.. To generate the report of the daily weekly monthly and yearly report of my database.

Can You Give me Example or Idea to Solve my Problem,

Thanks Guys

[modi123_1]

There are hundreds of ways to generate reports, but it all depends on how you want to proceed. So more explanation on your part and also some effort on what you have looked into.

[Jovel Mark]

i want to generate the report in weekly, monthly, and annually.

the for mat of the date is mm/dd/2013. this is what i have done before but the error is always popup The Date you Select Does Not Exist!" .. even though the date already in db.

Dim listx As ListItem
Dim rs As New ADODB.Recordset

If DTPicker1.Value = "" Then
    MsgBox "The Date Field is Empty.", vbExclamation, "Details"
      Else
    rs.Open "Select * from Dailyrecord where purchase_date = " & DTPicker1.Value & "", acd, adOpenForwardOnly
If rs.RecordCount = 0 Then
        MsgBox "The Date you Select Does Not Exist!", vbExclamation, "Details"

Else
ListView1.ListItems.clear
While rs.EOF <> True
Set listx = ListView1.ListItems.Add(, , rs.Fields("Receipt"))

listx.SubItems(1) = rs.Fields("BarCode")
listx.SubItems(2) = rs.Fields("ProductName")
listx.SubItems(3) = rs.Fields("Quantity")
listx.SubItems(4) = rs.Fields("Price")
listx.SubItems(5) = rs.Fields("TotalPrice")
listx.SubItems(6) = rs.Fields("purchase_date")
rs.MoveNext

Wend
End If
ListView1.Enabled = True
End If

[BobRodes]

Probably because DTPicker1.value doesn't match the value in your purchase_date field. You might try using the CDate function on both of them and comparing the result.

[Jovel Mark]

BobRodes, on 12 March 2013 - 09:37 PM, said:

Probably because DTPicker1.value doesn't match the value in your purchase_date field. You might try using the CDate function on both of them and comparing the result.

sir.
I didn't know how to use CDate Function. Can U give me an example of it..

[maj3091]

Google VB6 CDate for an example, please don't expect people to do everything for you.

We're not here to your work, please at least put a little effort in yourself.

[BobRodes]

Also, I have a post pinned up top that gives a link to the VB6 reference. You can easily find it there.