Calendars

[paultri]

I have a query that queries between 2 dates, what i would like to happen is have a calendar popup instead of having to manually enter the dates in.

I have been trying to do this for weeks and have been unsuccessful. any help is GREATLY appreciated!!!!


Paul

 

[Rich]

Download the Developer Solutions db from MS, there's an example in it

 

[Mile-O]

I have a calendar range solution here.

 

[paultri]

Rich, do you possibly have the URL where i could download that, i am having problems finding it. If you do that would be great, if not i will continue searching anyhow. Thanks Again


Mile-O-Phile , I have a calendar to use, what i cant figure out is how to bring it up from the query, How can you pull up the form instead of the box coming up to manually type in the date. thanks again!!!!!!!

Paul

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=173231#post173231

 

[Mile-O]

I have a calendar to use, what i cant figure out is how to bring it up from the query, How can you pull up the form instead of the box coming up to manually type in the date. thanks again!!!!!!!

A query doesn't have that functionality.

What you want to do is allow the user to select the dates on the form and directly reference these dates in your query

i.e

To return records based on a date range where you have two dates on your form you can set the criteria as:

Between [Forms]![frmYourForm]![ctlStartDate] And [Forms]![frmYourForm]![ctlEndDate]