I think this would be fun and Useful

[JimS]

So, I have to develop a form that shows calendar days and a number for each
day. So, I'm thinkin' wouldn't it be nice to have a control that shows a
"calendar", say two months at a time, kinda like the ones on travel web
sites, that show the actual calendar with a place in each cell for a value
which is displayed from a control source and updateable in place.

Anybody seen such a control I can either use directly or learn from? I'm
sure it's been invented. Anybody?

 

[Peter Hibbs]

Jim,

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 including an Outlook style calendar control.

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

HTH

Peter Hibbs.

 

[JimS]

I downloaded the Flex Grid Demo. It failed to compile using A2007 (property
not valid for this object...[redraw]) I subbed in his old version of
MSflxgrd.ocx and registered it and set it in references. No joy. (My existing
MSflxgrd.ocx was Version 6 Service Pack 3)

Thanx anyway.

 

[Peter Hibbs]

Jim,

If you would like to email me at the address in the documentation I
can probably help. I also have another demo which shows all of the
months of the year in the format you described and you are welcome to
have a copy of that if you wish.

Peter Hibbs.

 

[Tony Toews [MVP]]

So, I have to develop a form that shows calendar days and a number for each
day. So, I'm thinkin' wouldn't it be nice to have a control that shows a
"calendar", say two months at a time, kinda like the ones on travel web
sites, that show the actual calendar with a place in each cell for a value
which is displayed from a control source and updateable in place.

There are free calendar forms in Access which you can download and
customize. That would likely be a *lot* easier to work with than a
control.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

Tony

 

[MikeB]

And Jeff Conrad's extensive list (that includes yours as well)
http://www.accessmvp.com/JConrad/accessjunkie/calendars.html