Color Picker Control/Dialog

[BruceS]

Hi, all!

Have a A2003 database where each employee team is to be represented by a
different background color on forms and reports. On the setup form, I want
to pop up a dialog containing the normal Access "color picker" box like
appears in design mode, let them select a color, then store the color number
in my record for later use.

Is there control out there for the color picker? I looked in the tools and
in the references list and did not see any that had "color" in the name.

Thanks,
Bruce

 

[Dale Fye]

Check this out.

http://www.mvps.org/access/api/api0060.htm

 

[Arvin Meyer [MVP]]

Hi, all!

Have a A2003 database where each employee team is to be represented by a
different background color on forms and reports. On the setup form, I
want
to pop up a dialog containing the normal Access "color picker" box like
appears in design mode, let them select a color, then store the color
number
in my record for later use.

Is there control out there for the color picker? I looked in the tools
and
in the references list and did not see any that had "color" in the name.

Thanks,
Bruce

The color picker is a Windows API which is accessible from VBA code. Stephen
Lebans has done so for you at:

http://www.lebans.com/changemdibackground.htm

The database is in Access 97 format, but converts to Access 2000 format (the
default for 2003) without problems. You can then copy the API and the
calling code into yout application.

 

[BruceS]

Thanks, Dale! Looks like this will work great.
Bruce

 

[BruceS]

Thanks, Arvin! This one will enable me to give the app a little more
character.
Bruce