Special Calendar

[magmike]

I like to have a calendar to show the user which days have records and
it would be nice to give the user the option of how many months show
at a time. For example, they could choose to show the last 12 months
(ie. 2 wide by 6 high, or 3 wide by 4 high) and have days with records
show with a red number or a bold number or have the box around the
days number a different color, or something like that.

Is this possible? It isn't with the standard calendar add-in as far as
I can tell.

Thanks in advance!
magmike

 

[Arvin Meyer [MVP]]

Yes, it's possible, but you'd have to code it yourself since I don't know of
any calendars that would work like that. I do suggest that you limit it to 1
month because you will need to use many controls to show a year's data and
that would slow your performance way down.

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

The first option on the menu shows a calendar control which can be set
to show a day, a week and a month of appointments. If this looks like
something you can use I also have another demo database (not published
anywhere yet) which shows all 12 months of the year with a box for
each day which can be coloured to show which days have appointments,
public holidays, or whatever. If you would like a copy of that one
then email at the address in the documentation and I will send it on.

HTH

Peter Hibbs.

 

[Mark Andrews]

Third party ActiveX controls are an option if you don't mind having extra
files in the mix.
Search for calendar controls (they usually come with some kind of date
picker control that can be expanded to multiple months) or the calendar
control itself is used to diplay the months/year.

HTH,
Mark
RPT Software
http://www.rptsoftware.com