Theme Manager for Forms

[davegri]

All 70 color schemes are in one table in the database, and the database allows you to customize any of them.
There have been a lot of DB downloads taken from the site here and I'd love to see some of your custom creativity. If you'd like to share your schemes, you can upload a db containing just the table, cctColors for everyone to import and admire. You can PM me for my email address if you'd rather not upload to the site.

[sohankothari]

how to apply theme colour to subforms with datasheetview?

[davegri]

how to apply theme colour to subforms with datasheetview?

Subform datasheets don't have color properties. All the other views do. You can layout a single form view as well as continuous form view to appear similar to a datasheet. The program will color those layout views.

[annadisuza]

Hi,
This is very good thanks for sharing.

[zinfra]

Hi Dave,
are you familiar with Fuchs_ColorPicker?
brilliant

[davegri]

It's obviously a mod to my program, but I couldn't get it to work. There are no useful comments in the new code, and no references to any of the existing forms, only to the added ones.
From where did you find the modded app? Are there instructions there?
Or are you Fuchs and this is your mod? If so, please advise how to integrate it fully with the DB.

[zinfra]

It's obviously a mod to my program, but I couldn't get it to work. There are no useful comments in the new code, and no references to any of the existing forms, only to the added ones.
From where did you find the modded app? Are there instructions there?
Or are you Fuchs and this is your mod? If so, please advise how to integrate it fully with the DB.

Hi Dave
I send you a demo version where I modified the behavior of the fields c11, c21, c31 with a code on double click
it is very simple
Form: ccfColorTuner - ctrls c11, c21, c31
I also added 3 fields txtR, txtG, txtB for RGB values, I found functions (modColourConvert) that translate from OLE to RGB and RGB to Hex)

[davegri]

You must have uploaded the wrong version. None of that is in the one posted.

[zinfra]

Mhhh... from my V4 demo

[davegri]

Not ready for prime time, and I'm not gonna debug it for you.
Also, your double click events happily threw away the essential macro expressions that were there before which updated the color on both forms.
Your mod is a case of "if it ain't broke, don't fix it", because that mod sure broke it.
Did you try running the program after your mod? Surely you would have noticed that it no longer worked properly.

[zinfra]

Not ready for prime time, and I'm not gonna debug it for you.
Also, your double click events happily threw away the essential macro expressions that were there before which updated the color on both forms.
Your mod is a case of "if it ain't broke, don't fix it", because that mod sure broke it.
Did you try running the program after your mod? Surely you would have noticed that it no longer worked properly.

Hi Dave,
there was a misunderstanding ...
I didn't want you to debug my database, I just wanted to give you an idea to load colors directly from a palette generated directly from Access.
In fact, for example, in my color management system I also implemented shades of brown...which in the original Fuchs version did not exist

[davegri]

It just annoys me that someone would post a non-working version on my thread of the most downloaded database in forum history (over 1000). You could have used a simple database of your own design that demonstrated the technique on your own thread.

[Aztecfan63]

Thanks Amazing work. Obviously you are way beyond me. I appreciate the help. John