Calender to Select Records

[Jchristensen]

I was wondering if anyone has seen a easy way to use a calender to select records rather than having to type in a "between such and such a date".

Because what i have now is a qry that pulls data from a table between two dates. And i would like to make it more GUI rather than typing to prevent user imput error if you understand what i mean.

I tried searching but didnt know what to search for.

Thanks for anyone that has any input!

Regards,
Jon

 

[Rickster57]

Calendar

Open a form in design view. Click on Insert in your menu. Choose ActiveX Control and then choose Calendar Control. You can use that for your GUI. I'm sure there have been several examples of this in the forum so try searching on calendar control

Good luck....

 

[jeremypaule]

make a form with two text boxes and in your query make this the criteria for the date.

Between CDate([Forms]![FRM MAIN]![date1]) And CDate([Forms]![FRM MAIN]![date2])