Calendar Control as a filter

[Guest]

I would like to add a Calendar Control in a Form as a Filter. I tried adding
Filters with Command Buttons but they do not work so I am trying a Calendar
Control. Are any on of these possible?

 

[Guest]

Have a look at the calendar form at:

http://www.datastrat.com/Download/Calendar2K.zip

The sample shows how to use the form. Now add a textbox or 2 and use the
calendar to populate the textboxes. Use a reference to the textboxes to
filter your records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I am still not getting this... I have created a form which shows in Rows
multiple records...the records are each dated as to when it was entered which
could be several daily... General users do not not how to properly use the
"Filter by Form" button; therefore, I am trying to create a Command Button or
Calendar so users can simple filter the records by dates. When I created the
Filter Command Button on the form, it will not allow anyone to choose a date;
instead, it simply automatecally filters by the first record date. what am I
doing wrong here? There has to be a way to create a Filter Command Button
that works or even a Calendar so users can simple choose a date and click on
filter. Am I making sense here? Please help anyone.

 

[Arvin Meyer [MVP]]

The recordsource of you form needs to be a query (a filter is a query) that
is written something like:

Select * From MyTable Where DateField > = [Forms]![MyForm]![MyTexbox]

or even between 2 dates:

Select * From MyTable Where DateField Between [Forms]![MyForm]![MyTexbox]
And [Forms]![MyForm]![MyTexbox2]

Use the calendar to fill 1 or both text boxes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access