query parameter using input box

[JohnE]

Hello. I have a report that is fed by a query with a parameter asking for a
date. When the user runs the report, the input box appears to fill in the
date. Since using A2007, the datepicker button is available and the users
like it. They are now asking for the datepicker button available on the
input box as well.

I don't think it is possible but would ask anyway. Is there a way to get
the datepicker button to appear (and be useable) on the input box?

Thanks... John

 

[Allen Browne]

You can't do that with the parameter dialog in previous versions, but you
can use a form to supply the dates like this:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Then you can put a button on your form to pop up another form that looks
like a calendar, like this:
http://allenbrowne.com/ser-51.html

 

[JohnE]

Thanks Mr Browne. I thought it couldn't be done but had to ask anyway. Like
your ideas from the links and will go with using those instead.
.... John