Calendar select date to create a report instead of typing beginning and end date

[coffeeman]

I was wondering if I could use a calendar to run a report. Currently, I click on the report and it asks beginning date and end date. Is there a way to use a calendar pop up to select the beginning and end dates instead of typing it in?

Thanks for the help!

 

[NigelShaw]

Hi,

if you use a date field, there is a pop up calendar built in. otherwise, there is module floating around the forum with just what you are looking for.


nigel

 

[pbaldy]

I use this one (not sure where the latest one is in the thread):

http://www.mdbmakers.com/forums/showthread.php?t=235

I think the built-in one is only in 2007.

 

[coffeeman]

Thanks for the replies. Sorry about this, but how do I actually get the report to use this for the beginning and ending date selections to generate the report?

Basically, it is a report that generates from a query I built with a Production Date Field that is pulling from a Daily Production Table. In this table, I enter in materials used on specific dates. I then run the query that creates the report that lets me know the material usages from the Beginning Date and Ending Date.

Thanks again.

 

[pbaldy]

If you're currently using something like this in your query:

Between [Enter start date] And [Enter end date]

then you'll need to switch to using a form for the users to enter the dates into and point the query there:

Between Forms!FormName.txtFmDate And Forms!FormName.txtToDate

 

[coffeeman]

How do I get the calendar to pop up when I run that query. All it is saying is Forms!frmCalendar.txtFmdate for the beginning date and Forms!frmCalendar.txtFmdate for the end date. If I type the dates in, it will still work, but I want to use the calendar pop up to select the dates.

thanks

 

[pbaldy]

Like I said, you would create a form for the user to input dates into. That form would still need to be open when the query ran. Should you choose to go that way, the link I gave should have instruction on how to use that particular method. There are other methods, including ActiveX calendars.

 

[coffeeman]

Thank you for your help on this. It took me a while to get exactly what to do, but now I understand that the Query goes to the calendar form which then I can preview the report after I select the date ranges.

I have a new question. Is there a way to get the start date and end date selected to appear on your report so you can print out the report to show the date range that was selected?

Thanks again.

 

[pbaldy]

I typically put a textbox on the report that refers to the form:

="From " & [Forms]![FormName]![txtFromDate] & " to " & [Forms]![FormName]![txtToDate]

 

[coffeeman]

Again, you have helped me. Thank you for the quick responses and feedback. You sure know what you are doing in Access.

Thanks

 

[pbaldy]

No problem, glad it helped you out.