Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-20-2018, 07:51 AM   #1
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,922
Thanks: 92
Thanked 1,701 Times in 1,579 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Colour converter / selector

I have previously posted the original version of this colour converter utility when replying to several questions over the last year. However, as I had trouble finding it, I am now posting an updated version here.

This is a simple application to demonstrate two different methods for selecting and converting colours

1. The colour converter utility can be used to select a colour and view its OLE colour, RGB and HEX values OR to convert colour values between these formats
This is a modified version of a utility by Daniel Pineault which is available at his DevHut website



2. The colour categories utility is intended to assign colours to particular types of event in e.g.a calendar event application.
It also includes the use of the MS colour picker control

To use either of these in your own applications:
1. Colour converter
Copy the form frmColourConverter and module modColourConvert
2. Colour categories
Copy the form frmColourCategories, rptCalendarCategories and module modColorChooser

See this post by The_Doc_Man for a very clear & detailed explanation of how RGB & hex colour values are related

Attached Images
File Type: png ColourConverter2.PNG (14.9 KB, 164 views)
File Type: png ColourCategories.PNG (23.1 KB, 161 views)
Attached Files
File Type: zip ColourConverter v2.zip (80.1 KB, 50 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 10-20-2018 at 09:06 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
riti90 (10-26-2018)
Old 10-26-2018, 12:32 AM   #2
riti90
Newly Registered User
 
Join Date: Dec 2017
Location: Cambridge, United Kingdom
Posts: 24
Thanks: 18
Thanked 2 Times in 2 Posts
riti90 is on a distinguished road
Re: Colour converter / selector

Hi Colin,

That certainly is a great tool.
I've modified it to work on 64 bit access too.
Hope it'll be of help to anyone.

Regards,
Margarit
Attached Files
File Type: zip ColourConverter v2a.zip (161.2 KB, 16 views)

Last edited by isladogs; 10-26-2018 at 08:28 AM. Reason: Removed full quote of original post
riti90 is offline   Reply With Quote
Old 10-26-2018, 08:32 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,922
Thanks: 92
Thanked 1,701 Times in 1,579 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Colour converter / selector

Oops. Thought I'd done that.

Thanks for doing the conversion Margrit
I'll have a look at the updated code later

Just a reminder to report your own posts to moderated areas or these can get overlooked

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
riti90 (10-28-2018)
Old 10-29-2018, 06:54 PM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,922
Thanks: 92
Thanked 1,701 Times in 1,579 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Colour converter / selector

Further minor updates to version 2.0b

a) Added Option Explicit to module modColourConvert (originally from devhut.net) and defined all variables explicitly
b) Removed some superfluous module code

Rechecked in both 32-bit & 64-bit. Thanks again to Margarit
Attached Files
File Type: zip ColourConverter v2b.zip (70.8 KB, 12 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Tags
colour converter selector

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converter me3 General 5 05-04-2015 11:19 AM
VBA field converter JuniorWoodchuck24 Excel 1 02-10-2010 09:06 AM
Access to VB Converter? heman85 Modules & VBA 2 03-09-2009 01:01 AM




All times are GMT -8. The time now is 07:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World