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

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

Regards

Kevin

"Matt W." <(E-Mail Removed)> wrote in message
news:9F4D5FAA-D5C2-4CF0-9593-(E-Mail Removed)...
> 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

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

"Matt W." <(E-Mail Removed)> wrote in message
news:9F4D5FAA-D5C2-4CF0-9593-(E-Mail Removed)...
> 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

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Matt W." <(E-Mail Removed)> wrote in message
news:9F4D5FAA-D5C2-4CF0-9593-(E-Mail Removed)...
> 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

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?

"kc-mass" wrote:

> The calendar control is used to place a value in a text box. The query
> would then reference the text box.
>
> Regards
>
> Kevin
>
> "Matt W." <(E-Mail Removed)> wrote in message
> news:9F4D5FAA-D5C2-4CF0-9593-(E-Mail Removed)...
> > 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
>
>
> .
>

Hi Matt,

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

http://www.datapigtechnologies.com/f...drcontrol.html

I use this on one of my forms.

HTH
Richard

"Matt W." wrote:

> 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