Hello,
I want to generate reports between two dates. So i am using two DTPicker to select StartDate and EndDate. So I have written some code for it. But it is not working.
Private Sub cmdgenerate_Click()
Dim X As Variant
Dim Y As Variant
X = DTPickerstartdate.Value
Y = DTPickerenddate.Value
startdate = DateValue(DTPickerstartdate.Value)
enddate = DateValue(DTPickerenddate.Value)
DTPickerstartdate.Value = str(startdate)
DTPickerenddate.Value = str(enddate)
var = (enddate - startdate)
If var < 1 Then
MsgBox "Choose proper dates", vbExclamation
Else
DataEnvironment1.rptrenewal X, Y
rpt_renewal.Show
Unload DataEnvironment1
End If
Exit Sub
End Sub
I an having an error in DataEnvironment1.rptrenewal X, Y
, as Wrong number of argument invalid property assignment. Please help me out.....