Allen Browne Calendar

[Jim L.]

I am using Allen Browne's calendar, and it is working great. I have used it
in my current database 4 times, and need it for one more set of parameters.
However, when I use one particular query as a record source, nothing is
visible on the form in form view, except the grey background. I can use the
basic "Between [Start] And [End]" criteria in the date field of the query,
and it works fine. I can also change between other queries as a record
source on the calendar control form, and the controls are all visible. What
could it be about this one query that is making all of the form controls
invisible.

 

[George]

As is too often the case, not being able to see the actual query to which
you refer makes it very hard to diagnose the issue, so we'll start with some
general questions. The most obvious of those is to ask whether you are able
to open the query directly and get records back. You seem to be saying that
you do, and that there is a parameter in this query which restricts records
by date. However, there is also an implication in your statement about using
"the basic "Between [Start] And [End]" criteria", which is that you are
trying to substitute in a different criteria in place of that "basic"
version.

So the issue here is whether you are passing the appropriate criteria into
this query when it is being used in the calendar. How are you doing that?

 

[Jim L.]

George,
I am able to open the query/report whether I have "Between [Enter Start
Date] And [Enter End Date]", or with no criteria set for the date range at
all. What I have entered in the Date criteria now is "Between
([Forms]![CalendarControlFrm]![txtStart]) And
([Forms]![CalendarControlFrm]![txtEnd])", which are the names of the unbound
text boxes on the calendar control form. This works well for the other
applications I have used it for in this db. I have checked all the
properties against the ones that are working good, and all is the same.
Checked all spelling as well. The wierd part is, if I use one of the other
queries as a record source, all on the form is visible again. Both the form
text boxes and the query Date field are set to Short Date.

As is too often the case, not being able to see the actual query to which
you refer makes it very hard to diagnose the issue, so we'll start with some
general questions. The most obvious of those is to ask whether you are able
to open the query directly and get records back. You seem to be saying that
you do, and that there is a parameter in this query which restricts records
by date. However, there is also an implication in your statement about using
"the basic "Between [Start] And [End]" criteria", which is that you are
trying to substitute in a different criteria in place of that "basic"
version.

So the issue here is whether you are passing the appropriate criteria into
this query when it is being used in the calendar. How are you doing that?

I am using Allen Browne's calendar, and it is working great. I have used
it
in my current database 4 times, and need it for one more set of
parameters.
However, when I use one particular query as a record source, nothing is
visible on the form in form view, except the grey background. I can use
the
basic "Between [Start] And [End]" criteria in the date field of the query,
and it works fine. I can also change between other queries as a record
source on the calendar control form, and the controls are all visible.
What
could it be about this one query that is making all of the form controls
invisible.

 

[Allen Browne]

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The article explains why the Detail section of a form blanks out when there
are no records to display and the form does not allow new records to be
added.

 

[Jim L.]

Mr. Browne, you are a genious!
I read through your link, and found no problems until right at the end. I
had one field in the query that was linked to another database written in an
earlier version of Access, so the query was unwriteable. I have since broken
the links and created append queries for these tables, and everything is
working perfectly.
Thanks so much for all of your help (and the calendar). I am just a
beginner, and have been working on this database for several months. I hope
to have it in use by the end of this month, which will make my job much
easier. Couldn't have done it without you guys!

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The article explains why the Detail section of a form blanks out when there
are no records to display and the form does not allow new records to be
added.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am using Allen Browne's calendar, and it is working great. I have used
it
in my current database 4 times, and need it for one more set of
parameters.
However, when I use one particular query as a record source, nothing is
visible on the form in form view, except the grey background. I can use
the
basic "Between [Start] And [End]" criteria in the date field of the query,
and it works fine. I can also change between other queries as a record
source on the calendar control form, and the controls are all visible.
What
could it be about this one query that is making all of the form controls
invisible.

 

[Allen Browne]

Great news. All the best for your project.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Mr. Browne, you are a genious!
I read through your link, and found no problems until right at the end. I
had one field in the query that was linked to another database written in
an
earlier version of Access, so the query was unwriteable. I have since
broken
the links and created append queries for these tables, and everything is
working perfectly.
Thanks so much for all of your help (and the calendar). I am just a
beginner, and have been working on this database for several months. I
hope
to have it in use by the end of this month, which will make my job much
easier. Couldn't have done it without you guys!

\