calendar query

[ebiscaro]

I have this query that works, for once properly. it is a date query. it finds records between two dates. I used criteria of:
Between [Type the beginning date:] And [Type the ending date:]
in the criteria field.
Now I have to put in the date manually.
Is there a way to have drop down menu or something more elegant to put in a form to make the query run?
Thank you in advance for any hints

 

[dcx693]

Use the Access ActiveX Calendar Control. Add it to your form by opening the Toolbox and clicking on the "More Contorls" button. Look for Calendar Control 10.0 (in Access 2002 it's version 10.0, in Access 97 it's 8.0).

With this control, users will be able to select dates from the calendar rather than typing them in manually.

The Access help has a Calendar Control reference with all the info you need to use it.

 

[Mile-O]

...or just pop along to this thread as there are a few calendar examples on there.

 

[ebiscaro]

I will bite that TY

Very useful something to explore.
Thank you