Calendar Control as a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
Back
Top