Just playin' around with one of my older apps for general purps . . . tryin' to spiff it up a bit.
(Now with sliders - Thanks to datAdrenaline for the slider technology! Also thanks to JayNoelOlimpo and tina_t for some bug swattin' )



Added save feature to catch if a Saved Color Group name already exists and offers user the opportunity to over-write the exisiting one or not. Also added Tina_t's tweaks to handle apostrophies in the Color Group save name. (1-27-2013)

The screws come off on this one . . .

This is now updated (Jan 1, 2013) with A97, A2K, A2K3 & A2K7 versions. The previous number of downloads was 1273

Click to view attachment

Hi moo,

Just to report a minor bug ...

Open a save color group - bug on Test 1.

Zero'd out the timer interval - control flickers.

Overall -

Jay, got rid of the bug and reposted the attachment. Good catch and Thanks!

Yeah, the timer needs to be set at 3000 to auto-close the easter egg (hint - it has something to do with the screws . . . )

I just uploaded the modified version of this tool that now has sliders. The original attachment has been upgraded.

hello, CyberCow, i ran the db in A97, running on WinXP Pro. here's the weird thing that is way beyond me: i saved four color groups. the second and third group load and display correctly when chosen from the combo droplist. the first one i saved, and the fourth, when loaded, display different colors - and VBA color codes - than the codes saved in tblColorGroups. i can't figure out why.

i've attached my copy of the db, with the four color group records i added. if you have time to take a look at it, that would be great! :)

tina

Click to view attachment

Tina - I looked it over and I think it's because the 'cmdSkew' command button functions aren;t triggering on the recall of a Saved Color Group. Doing some double-checking and reposting updated versions in the original post above.

hi CyberCow, i downloaded the current db just now. nice addition - catching duplicate group names and asking re overwrite! fyi, the DLookup(), and the "UPDATE..." SQL statement, are posing the same problem with apostrophes that cropped up in the "INSERT..." SQL statement. i tested

DLookup("[cgName]", "tblColorGroups", "[cgName]=""" & cgnm & """")

and

..."WHERE (((tblColorGroups.cgName)=""" & cgnm & """));"

and that seems to fix it.

not sure if you had a chance to work on the reloading-a-saved-group issue that i experienced; so, just fyi, i'm seeing the same issue in the current version.

hth
tina

Tina - thanks for the excellent feedback. I'll get to updating the latest set to include your tweaks and see about positively ID-ing & fixing the odd loading behavior in the next couple of days.

I should probably make the same tweaks in this Color Combination Viewer as well.