color palette/color selector

[Trevor2007]

I am trying to call the color palette in access, but the only thing I keep coming accross is xldialog.paintpalette for excel but nothing for access.
I would like to do this to allow the end user to customize their UI.
Thanks for helping

[PianoMan64]

I am trying to call the color palette in access, but the only thing I keep coming accross is xldialog.paintpalette for excel but nothing for access.
I would like to do this to allow the end user to customize their UI.
Thanks for helping

If you're wanting the user to be able to customize their own UI, then you have to write that code into your application, unless they go into design themself and have there own MDB file, that they change there own UI to what they want.

That is not recommended because it's to easy for someone to change something, and you'll spend weeks sometimes looking for what they changed.

That is a great deal of coding for a very small effect.

Hope that helps,

Joe P.

[Trevor2007]

Joes, your right that would be a great deal of coding for a very small effect, I've been looking around and I can't figurt out why both excel and word ailow access so a color pallet Diaog but not access, and is it possible to "barrow " the coilor pallet of one of the other programs

[PianoMan64]

Joes, your right that would be a great deal of coding for a very small effect, I've been looking around and I can't figurt out why both excel and word ailow access so a color pallet Diaog but not access, and is it possible to "barrow " the coilor pallet of one of the other programs

You can display it, but there isn't any controls to find out values from it unless, you know how to access the API in Windows for it?

I don't know if there is any documentation on that at Microsoft.
I've never tried that before.

If you're wanting to do that, you're best show would be simply to re-create the same information on a form yourself.

But again, it's going to be alot of programming for a little effect.

Hope that helps,

Joe P.

[Trevor2007]

Yes , I am aware that it will be a s#@t load of work for very little effect, my perpuse in this has 2 reason, 1 end user entertainment, the second one is a more usefull purpose, is for visualy impaired some see certin colors on a screen or in general better then others and perfer various combinations ie: green on black and other "strange" cominations,
Is a a list of all 16,000 colors in one spot someware that you know of
and M$ doen't have anything of any use on their site about this, its very veig and if it appears to be of use, it says about 1/2 way down the page it's for excel.
I have seen vb code that does it but it's in the form of an ocx and vba doesn't handle ocx's that whell(somtimes, I wish vb and vba where more interchangleable , I tried editing the vb code to work in vba but because of the bracketing used and direct dll call's make it a little dificult.

[Trevor2007]

Yes , I am aware that it will be a s#@t load of work for very little effect, my perpuse in this has 2 reason, 1 end user entertainment, the second one is a more usefull purpose, is for visualy impaired some see certin colors on a screen or in general better then others and perfer various combinations ie: green on black and other "strange" cominations,
Is a a list of all 16,000 colors in one spot someware that you know of
and M$ doen't have anything of any use on their site about this, its very veig and if it appears to be of use, it says about 1/2 way down the page it's for excel.
I have seen vb code that does it but it's in the form of an ocx and vba doesn't handle ocx's that whell(somtimes, I wish vb and vba where more interchangleable , I tried editing the vb code to work in vba but because of the bracketing used and direct dll call's make it a little dificult.

just to give you a heads up , I'm designing my own color palett ( I found almost 600 colors and there Ms access value. which will end up looking like 1600 colors to the end user since the rest of the color are about 1/2 shade off or less then the closet color in the 600 I have, so far I have 200 boxes placed and #'d on a form, no code behind them yet. I plan on doing a select case ( this is gonna suck)

[PianoMan64]

just to give you a heads up , I'm designing my own color palett ( I found almost 600 colors and there Ms access value. which will end up looking like 1600 colors to the end user since the rest of the color are about 1/2 shade off or less then the closet color in the 600 I have, so far I have 200 boxes placed and #'d on a form, no code behind them yet. I plan on doing a select case ( this is gonna suck)

If you're planning on doing that, there may be a simplier way to simply figure that part of it out.

If you assign it RGB Values, then you can pass that using the example in MS Access Help,

Dim RED, I, RGBValue, MyObjectRed = RGB(255, 0, 0) ' Return the value for Red.I = 75 ' Initialize offset.RGBValue = RGB(I, 64 + I, 128 + I) ' Same as RGB(75, 139, 203).MyObject.Color = RGB(255, 0, 0) ' Set the Color property of ' MyObject to Red.

Simply look under the RGB, this will come up as an example:

Hope that helps some,

Joe P.