Linking Calendar on Form with Query...

[Axess08]

I am not sure if this can be done properly...

I have a query that calls on a table with calculated fields. The calculated
fields actually are my filters for the query. In the query, I have limited
the 5 Month Follow-up date range to be within 2 weeks of the current date
with the following (where Date of Exam5 = 5 Month Follow-up date):

FllwUp 5: IIf([Date of Exam5]>Date() And [Date of Exam5]<(Date()+14),[Date
of Exam5])

And for the criteria I just placed "Is Not Null" so that it will display
only those dates.

That works fine.

I have linked this query by creating a subform of the report and placing on
the first form that loads when the database first opens up. (which is also
fine for now).

What I want to do instead of just displaying the query results would be to
display a (one month at a time) calendar that actually highlights the days
that the follow-up exams are scheduled based off of the query. Is this even
possible with the ActiveX calendar that comes with Access, or would I have to
create a report that is in the form of a calendar?

 

[Mike Painter]

There are several FORMS available that duplicate the calendar control and
you can modify some of them.
Most are free but this one
http://www.aislebyaisle.com/access/calendartool.htm is certainly worth the
$79.00 asking price.

There may be some REPORTS available also but I've not seen one.