pop up calendar on a report

[Guest]

I have a report based off of a select query that asks to enter the start and
end dates. Is there a way to have a pop up calendar appear rather than the
dialog boxes so the end user can just click on the start and end date?

 

[Guest]

oops, I meant parameter query, not select query.

 

[Crystal]

Hi Patti,

use a form to collect the start and end dates.

Here is a link to a popup calendar (to download it, you will
have to sign up for the forum... it is a great resource and
free to join)

Date Picker Popup
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=377434

Warm Regards,
Crystal

 

[Crystal]

Patti,

If you want to use the controls on a form for your query
parameters...

formname: ReportMenu

make two textboxes:
NAME of beginning date control --> Date1
NAME of ending date control --> Date2

criteria in your query under the date:

criteria --> between cDate(forms!ReportMenu!Date1) and
cDate(forms!ReportMenu!Date2)

I used the cDate function since unbound TEXTboxes on forms
think everything is a string

Warm Regards,
Crystal