Report records from a calendar entry

[trustsun]

Currently my users type in a beginning date and ending date to see data from a query for reports.
Now they want me to have a pop up calendar to display and they click the range of days to see their data.
Could someone show me step by step how I could do this.

 

[trustsun]

It appears no one could responed, to much information I see. But with a little digging I found the information.
Half way there but still can not find how to email a snapshot view using the examples I have for print and view in reports.

Private Sub PrintReports_Click()
Dim X As Variant
For Each X In ReportList.ItemsSelected
DoCmd.OpenReport ReportList.ItemData(X), acViewNormal
Next
End Sub

Private Sub ViewReports_Click()
Dim X As Variant
For Each X In ReportList.ItemsSelected
DoCmd.OpenReport ReportList.ItemData(X), acViewPreview
Next
1.Could someone also include an example to email the report.
2. At times I get this (Run-time error '2501') what's happening?

 

[dhookom]

There are a couple activeX calendar controls that you can use in Access such as the DatePicker. I prefer to use the calendar form that is on the CD with the Access Developer Handbooks by Getz, Litwin,...

If you are getting an erro 2501 this is coming from a report that is being canceled. You need to add error handling to your code above that ignores this error.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.