calendar in query/report

A

alexasha

Hi, I have created a query to pull data between certain dates
Between[start date]and[end date].
I also already have installed calendar control in one of the forms, like
described here
http://www.allenbrowne.com/ser-51.html

I would like to be able to use the same calendar control for inputing start
and end date instead on typing it. I am open to any other solutions.
Thanks
 
A

alexasha

Perfect as always. works great. Thanks

Allen Browne said:
You can create the form described in Method 2 of this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
and use the pop-up calendar to enter the dates on that form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

alexasha said:
Hi, I have created a query to pull data between certain dates
Between[start date]and[end date].
I also already have installed calendar control in one of the forms, like
described here
http://www.allenbrowne.com/ser-51.html

I would like to be able to use the same calendar control for inputing
start
and end date instead on typing it. I am open to any other solutions.
Thanks
Click to expand...
Click to expand...
 
A

alexasha

Is it possible to do the same for the form (to filter form by date). I tried
to chage report to form in command, but it did not work. thanks

alexasha said:
Perfect as always. works great. Thanks

Allen Browne said:
You can create the form described in Method 2 of this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
and use the pop-up calendar to enter the dates on that form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

alexasha said:
Hi, I have created a query to pull data between certain dates
Between[start date]and[end date].
I also already have installed calendar control in one of the forms, like
described here
http://www.allenbrowne.com/ser-51.html

I would like to be able to use the same calendar control for inputing
start
and end date instead on typing it. I am open to any other solutions.
Thanks
Click to expand...
Click to expand...
Click to expand...
 
A

Allen Browne

Sure. You could open another form filtered by replacing OpenReport with
OpenForm.

Or you could filter the current form by setting its Filter and FilterOn
properties:
Me.Filter = strWhere
Me.FilterOn = True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

alexasha said:
Is it possible to do the same for the form (to filter form by date). I
tried
to chage report to form in command, but it did not work. thanks

alexasha said:
Perfect as always. works great. Thanks

Allen Browne said:
You can create the form described in Method 2 of this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
and use the pop-up calendar to enter the dates on that form.

Hi, I have created a query to pull data between certain dates
Between[start date]and[end date].
I also already have installed calendar control in one of the forms,
like
described here
http://www.allenbrowne.com/ser-51.html

I would like to be able to use the same calendar control for inputing
start
and end date instead on typing it. I am open to any other solutions.
Click to expand...
Click to expand...
Click to expand...
 
Top