Date Range

  • Thread starter Thread starter appbeg
  • Start date Start date
A

appbeg

I have multiple reports that ask for a Beginning and End date. I have
followed the examples in Help to the letter. One was creating a form and
using the Form as the criteria. The other included creating the Form, and
Macro, and a Module. It never calls up the form it always pops up the
standard parameter box - even though there are no parameters in the design
screen. Long and short I need a Beginning and End date form (with the nice
calendar pop-up) to pass information to my query. The 2 samples I have seen
in Help do not work on 2 different machines running 2007 SP1
 
I have multiple reports that ask for a Beginning and End date. I have
followed the examples in Help to the letter. One was creating a form and
using the Form as the criteria. The other included creating the Form, and
Macro, and a Module. It never calls up the form it always pops up the
standard parameter box - even though there are no parameters in the design
screen. Long and short I need a Beginning and End date form (with the nice
calendar pop-up) to pass information to my query. The 2 samples I have seen
in Help do not work on 2 different machines running 2007 SP1
Click to expand...

Ummm...


Sorry, my clairvoyance is off today. I cannot see what code you actually
*USED*. You're describing how you used it but...


AT A GUESS (since I can't see it), consider opening the form *FIRST*. A Report
will not call a Form for you, and a parameter query won't launch a form
either; if it's not open it will just prompt for the parameters by name.

Open the form to enter the date criteria. Let's say you have a form named
frmCrit with textboxes txtStart and txtEnd, and that your reports are based on
queries with criteria like
= [Forms]![frmCrit]![txtStart] AND < DateAdd("d", 1, [Forms]![frmCrit]![txtEnd])
Click to expand...

to cover the possibility that the date field contains a time component.

Put a command button on the form to launch the report - or a combo box or
listbox to select which report to launch.
 
Back
Top