screen color picker cq. selector

[noorman56]

I want to make an colorpicker in msacces. So i can pick on the desktop screen any color i want.
like the program jcpicker.
This is what working in VB net:
Dim bmp As New Drawing.Bitmap(1, 1)
Dim gfx As System.Drawing.Graphics = System.Drawing.Graphics.FromImage(bmp)
gfx.CopyFromScreen(New Drawing.Point(MousePosition.X, MousePosition.Y), New Drawing.Point(0, 0), bmp.Size)
Dim pixel As Drawing.Color = bmp.GetPixel(0, 0)
Cpanel.BackColor = pixel
RedTextBox.Text = pixel.R
GreenTextBox.Text = pixel.G
BlueTextBox.Text = pixel.B

But how can i do this in VBA in msacces??

 

[theDBguy]

Have you tried this one?

Solved - Use attachments for html related files, is that possible?

I would like to use the concept for using a browser control to display a color picker as shown on Daniel Pinaeult's excellent article found here: Access Color Picker This requires having separate files in folders as most web projects do. I was thinking maybe all those files could be stored in...

www.access-programmers.co.uk

 

[isladogs]

Or this very similar application which uses some of the same code

Colour Converter

This demonstrates two different methods for selecting and converting colours between the three different formats used by Access: OLE, RGB & HEX

www.isladogs.co.uk

 

[Pat Hartman]

Is the color picker for your design use or for you to expose to the user? I would be leery of anything that doesn't use themes. Themes are still clunky but they are better than manually choosing colors for objects.

 

[noorman56]

Is the color picker for your design use or for you to expose to the user? I would be leery of anything that doesn't use themes. Themes are still clunky but they are better than manually choosing colors for objects.

for me is it important to choose the colors manually of an object. and save the hexcode of the color in the database with project name and name client. So I can see later wich colors is used for various clients and associated projects. And themes are not an issue at all for this project.

 

[Pat Hartman]

Just sayin' I've stopped making manual color choices. They are way too time consuming to change if you end up needing to.

 

[Nixversteher]

I believe that this is already possible. In the simplest case a form timer that reads the pixel under the mouse. Attached is a simple example, based on your sample code above.

 

[arnelgp]

there is a Theme Manager available for download here:
Theme Manager for Forms - Page 2 (accessforums.net)

 

[sonic8]

Attached is a simple example, based on your sample code above.

Congratulations @Nixversteher, well done! It looks like you were the only respondent, who actually read and understood the question.
I don't like the use of the timer in the example, however I can't think of any alternative that could be implemented with reasonable effort.

 

[arnelgp]

well it look like it somewhat same here (complete with timer, only there is no attribution?):
A method to get the pixel color under the mouse pointer | CodeGuru