Allow users to change Back Ground Color in Access

[iheartvba]

Hi How can I make a user panel where they can choose a color for all the forms in an Access database.

I have made a table with all the user names and it has a field for color which can store their desired color.

I don't however know how to allow them to choose a color themselves.

Thanks

[nico5038]

When you have a limited number of colors you could place a button (or label) for each color on a form and store the value of that button when pressed.
Personally I wouldn't allow users to select a color as it's sometimes blurring the text and makes the overall color design rather "hard'
Every windows system allows you to chose a color scheme for all applications and why not advise them to use that and use the "standard" template colors in your application?

Nic;o)

[NeoPa]

As a part of the form design is (should be) determining which colours work well together and make the form readable and easy to work with, I cannot imagine that allowing users (unless themselves trained in design - in which case the question becomes about a colour scheme instead) the ability to change form colours is good design in any sense.

I'm sorry to sound negative but this is a serious point.

[iheartvba]

I understand what you are saying, the only reason I want to do this is so each user has a different color associated with their forms. This will ensure that when they log on to the database they haven't accidently logged on with the wrong username, as they will see a different color if they log in with another user name (I don't like to use passwords because people forget the password). Probably simpler for me to choose schemes for each user.

[wizardry]

have you thought about using vba create a module with the functions listed for each hex or ascii language set for that color then create a macro for on click on the users panel which you just created. that panel will list the available options that you have just defined from within your custom color palette. and store that color lang. set in their users profile tbl for profile session setting or what ever and call that when the user logs in. hope this helps.

schemes are ok but just a templete / outline.

i would recomend using vba(visual basic access) you can grab everything from network address, etc... and store that into the users schema as well.

----- per previous post ----

why give users access to the color schema?

answer 1. all color schematics are not the same on every system. unless its all duplicate from the developers which i highly doubt. i.e. tower has differant graphics chip set. monitor has differant graphics chip set.

answer 2. think like the CEO " If my users could change their system to the way they are comfortable using it; with out damaging the system or systems or their self or others; which means more productivity. then yes give then access to that custom schema which allows them to change font, and color setting to their users profile.

answer 3. this is a database your building right? lol..... just joking! do you have an audit trial setup? history tables? i would just in case, also you can derive your reporting from that.