Calling the color pallete when program is running 2

[zevw]

Is there a way through code, that the user clicks on a certain button and has the option to select the colors they want by calling the color pallete, for instance to change the colors of the startup form. Naturally I do not want the user to be in design view, so I would like to give them a second form where they select the color they want and based on those values the startup form will be formatted. Thanks in advance for you help.

 

[CautionMP]

zevw,
Check out Microsoft: Help and Support ACC: Sample Function to Use the COMMDLG Color Dialog Box for information on how to package the Common Dialog Color Dialog Box in your Access (or any Office) application.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[abaldwin]

As Caution states you need to use the COMMDLG color dialog box. You have more considerations for what you want to do though. For the user to "customize" his experience with your software, you will need to devise a data storage method (db or registry if you are brave) and will need to apply these colors at form load.

Just a matter of saving the choice and loading at runtime.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[Remou]

Why not add the CommonDialog control to the relevant form, if your version allows?

Then you can have, for example:

Private Sub cmdPick_Click()
Me.ActiveXCtl0.ShowColor
Me.txtX.BackColor = Me.ActiveXCtl0.Color
End Sub

More Info:

http://www.manifold.net/doc/700/control_common_dialog_control.htm

 

[zevw]

Remou

I tried adding the ActiveX CommonDialog Control to the form but it is telling me that I do not have the required license. I wonder isn't the CommonDialog control part of microsoft office 2003. Now what is my next how do I aquire a license and what is then.

I will just review the steps:

1. I will insert the activex control into the form.
2. name it for example as you wrote ActiveXCt10.
3. click on my command button which should then open the color pallete and assign the text box the color I chose.

Am I on the right track here?

Thanks in advance for your help!

 

[Remou]

zevw
Sorry, I forgot about the problem with licensing. This may help:
"ActiveX component can't create object" error message when you run code that calls the Common Dialog Control (Comdlg32.ocx)

http://support.microsoft.com/default.aspx?scid=kb;en-us;281848

You can, as you say, add a command button and click it to pick a colour.

 

[zevw]

Remou!

This is the exact error I"m getting.

"You don't have the license required to use this ActiveX control.

You tried to open a form containing an OLE object or an ActiveX control or you tried to create an ActiveX control.

To obtain the appropriate license, contact the company that provides the licensed OLE object or ActiveX control."

I read the support topic from microsoft but do not understand what they mean by creating a userform. I am in a form and have a control. Is there something called a userform?

Sorry maybe I am asking very stupid questions!

 

[Remou]

I am afraid that I should not have suggested the common dialog control. Apparently, using an API is the better option. Have a look at this:
API: Calling Windows Choose Color Dialog

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

 

[zevw]

Thanks Remou!

This API works like a snap!!