Calendar control

  • Thread starter Thread starter Stub932
  • Start date Start date
S

Stub932

I need a code to be able to:

Without having to create a query and prompt boxes to appear for the user to
enter "start date" and "end date" for a report to be produced - I would
instead like the user to click on the Calendar date buttons to produce a
report.
ie. Clicking one button on the calendar then another date so that the
database code will then produce the desired report.

And another code:
Where the user enters comments in a "comments" text box of a form, then use
a field called "InspectionDate" to enter a date for the same record.
When the user then opens the calendar ActiveX control, he/she can see that
certain date buttons on the calendar panel are bold. The bold numbered
dates represent the existence of comments all based the the particular date
populated in the InspectionDate field. So basically the user simply clicks
the date buttons where the numbers are bold and then the comments field
appears (pop up box) showing the comment.

any help appreciated. Thanks
 
You can use the ActiveX Calendar control and put it on a form where it can
run the additional code required to do what you want. I believe there may be
an example of this in the Access Developer's Handbook:

http://www.amazon.com/exec/obidos/t...102-8588108-5324903?v=glance&s=books&n=507846

or you can use a calendar form and alter it to do what you want:

http://www.datastrat.com/Download/Calendar2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top