Hi
An old IBM S370 systems programmer here, so please go easy on me!
I am building a access application that allows the system administrator and potentially, individual users, to chose a colour scheme for all forms within the application. The scheme ID would be recorded in individual user table entries, or on a global table.
I have 10 color schemes identified and stored within a table, each scheme uses 5 RGB triplets and are assigned to each form as they are loaded by looping around the forms controls and setting their properties depending on their type, so far so good. It all works fine.
My query is what is the best way to graphically present the various schemes, in miniature, to the administrator or users, in order to be able to allow them to select the scheme they like best?
Ideally, I would like to be able to code 10 mini simplified forms, within a form and assign the various RGB values to each in turn directly from the colour scheme table. I really like this idea, but don't know how to do it!
An alternative would be to construct 10 separate graphic images and display them, but I don't like this approach because (1) I lose the ability to directly relate the stored RGB values and the actual images, which would be built outside of access and (2) It's a lot of work
The reason I don't know how to use my preferred approach is that I would presumably have to loop around the forms controls for 10 container objects that relate to my 10 colour schemes and then to have an inner loop to assign the right values according to the property object type within the holding object.
As you experts will understand by now, I am managing to confuse myself!
If anyone has done this and could point me in the right direction I would be very grateful. Better yet, If anyone has any sample code for this type of thing that they could share, I would be extremely grateful.
Thanks in advance
Mike