Calenders

[RichieP]

I have a form connected to a query that uses a pop up box for the user to enter two dates DD/MM/YYYY. I have: "Between [Enter first date] and [Enter last date]" typed in the criteria section of the query. The query brings back records I have defined between these two dates.

What I need is a calendar where the user selects (clicks on) the first date and then selects (clicks on) the last date so the query can then bring back the certain fields I need between the selected dates. I'm fed up of typing dates in a pop-up box! Please help. Thanks.

Rich

 

[Jack Cowley]

Create a from with two unbound Text boxes and the ActiveX calender that comes with Access. Use the calendar to fill in the dates and then use code like this in your query:

Between [Forms]![FormName]![StartDate] And [Forms]![FormName]![EndDate]

I have assumed that the unbound controls are named StartDate and EndDate and that you have a command button on the from to run the query.

hth,
Jack

 

[Mile-O]

You'll find my example rather handy on this thread.

 

[RichieP]

That has worked an absolute treat. Thanks guys!

And thanks for the speedy reply's!


Rich


(I should really learn how to spell . . . 'Calender --> Calendar")

 

[Jack Cowley]

You are welcome, but watch out for that duck!

Jack

 

[Mile-O]

Why? What does the duck do?

 

[Jack Cowley]

That is it exactly! We don't KNOW what the duck does...