CalendarControl with Parameter Query

[Matt W.]

Access 2002:
I'm trying to develop a query that allows a user to select a date range
using the calendar control.
So far, I've created a form with the calendar control and began to create my
query. The problem that I'm having is when I go to expression builder within
the query, then navigate to my form, there is no field for the calendar
control. Is what I'm attempting even possible? If so, any help is appreciated.

Thanks,
Matt

 

[kc-mass]

The calendar control is used to place a value in a text box. The query
would then reference the text box.

Regards

Kevin

 

[Gina Whipp]

Matt,

Not usre I understand... Are you trying to open your calendar from the
query? If that is what you are trying to do then no you can't do that. You
can open a query from a form but not visa verca. If that's not it please
provide a wee bit more explanation.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Arvin Meyer [MVP]]

Rather than using the calendar control (which is now deprecated) try using
my Access calendar form. As Kevin mentions, you need to put the dates in a
text box, then you can refer to the form and text boxes for your date range.
Here is the calendar control:

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

 

[Matt W.]

That makes sense. However now I'm having trouble referencing the calendar
from the text box. Do I do this in the text box properties, control source?

 

[Richard]

Hi Matt,

Here is a cool technique to capture "between two dates" with the calendar
control.

http://www.datapigtechnologies.com/flashfiles/clndrcontrol.html

I use this on one of my forms.

HTH
Richard