Calendar Question

[Guest]

Hi, Maybe you have some suggestions for me. I am creating a database that
will have one entry for most dates. Is it possible to show which days have
been entered on the Calendar control that comes with Access?

Any suggestions would be greatly appreciated.

Thanks
Harv

 

[PC Datasheet]

This is complicated but will work very slick ---

Create a custom collection to store the dates that have been entered. At
each click on the calendar, iterate through the collection to see if it has
already been selected.

 

[Guest]

Not sure that is what I'm looking for. Is is possible to change how the
calendar looks so the user would know at a glance which dates have been
entered. Any information is appreciated.

Thanks
Harv

 

[PC Datasheet]

No! The days on the calendar control are mutually exclusive. When you click
any day, the previously "marked" day becomes unmarked. Look around for
another calendar control that is not ActiveX. Stephen Lebans at lebans.com
has a Month View Calendar and Getz has one in the Access Developers
Handbook. These are opensource code calendar controls and you can reprogram
them to do what you want.

BTW, with the previously selected dates stored in a collection, you could
have a listbox on your calendar form to see a list of the previously
selected dates.