Calendar Conditional Formatting

[BarryC]

Does anyone know how to do this;
Have days on a calendar change colors or go bold when certial criteria is
met, i.e. have a date change color based on query results. Thanks...

 

[Danny J. Lesandrini]

Are you talking about the calendar active x control, or would you
be interested in custom code that builds a calendar form?

On my calendar form, I do some fancy resizing, etc, and I have
code that colors fields, adds text and an OnClick event which
allows clicking a calendar day to take some action.

It's a little clunky, but very useful. If interested, I could clean up
the code and post it at my FTP site.

 

[zay]

LOOK WHAT IS IE NOT SAYING DO NOT KNOW WHAT IT IS

 

[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

HTH

Peter Hibbs.

 

[Klaus-Dieter Gundermann]

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

Hi Peter,

I downloaded your Flex Grid Demo and I really love it !
But when I try tu use the FlexGrid Control in my own application
Access only tells me that I have not the necessary license to use this
control ?

Do you have any hint for me?

Regards

Klaus

 

[Peter Hibbs]

Klaus,

I do,

1. You could purchase Visual Studio 6 from Microsoft. This includes
Visual Basic 6, Visual C++ 6, Visual Fox Pro 6, Visual J++ 6, etc. The
Flex Grid control comes with this software and you automatically get
the license to use it included.

2. If money is no object, there are other Flex Grid controls available
from other software houses. They are more comprehensive than the MS
version but they are also fairly expensive. I have not tried them
myself but have a look at the VS Flex Grid Pro control at :-
http://www.componentsource.com/products/componentone-vsflexgrid-pro/index-gbp.html

3. For a one-off project you can just import one of the forms with a
Flex Grid control from the demo program and then change the properties
and VBA code to suit your project.

4. You can download the free Visual Basic 2008 Express Edition from
Microsoft at http://www.microsoft.com/express/vb/
which includes the Flex Grid license. Just download the file (it's
about 80MB) and install it on the PC. You don't even have to run it,
the Flex Grid control can then be inserted into your forms. To use the
VB program you have to register it within 30 days (not sure if the
Flex Grid will also stop working after that time if you don't
register), it is probably worth registering anyway, it is free.

HTH

Peter Hibbs.