Users want to be able to set form colors

[mscertified]

My users have requested the ability to customize the colors of certain parts
of a form. This needs to be done in such a way that each user can have
different colors. Each user already has their own front-end. Is there an easy
way to do this?
I do install new versions occasionally and it would be nice if this did not
wipe-out the custom colors. Is there a color-picker tool, I could display for
the users to pick a color and get back the color in a form I could set the
Access backcolor or forecolor properties?

Thanks.

 

[Dale Fye]

Check out the color dialog API call
(http://www.mvps.org/access/api/api0060.htm)

I generally try to discourage this level of customization, but if the
customer wants to pay for it, then he is always right (not always). If my
customer insists on this type of user customization, I generally include a
local_parameters table in the front-end of my application. Then I present
the user with these parameters in an options form.

Then, when the application loads, I get the color info from the
local_parameters table and store them in global variables (actually I store
them in functions but you get the idea). Then, when I open a form, I set
the appropriate colors, generally only for headers, footers, and the detail
section.

I use a Front-end update application I wrote to distribute updates to the
application. This application checks to see whether the users personal copy
is current or not. If not, it renames the old version to something obscure,
copies the new application down from a network server, then copies the
local_Parameters table from the old version into the new version. After all
this is said and done, it deletes the old version, and kicks-off the new
version of the application.

HTH
Dale

 

[Tom van Stiphout]

Wouldn't it be much easier to keep the UserSettings table in the BE?

-Tom.
Microsoft Access MVP

 

[Dale Fye]

Probably.

I don't remember why I did it this way. May have been that at the time, I
didn't know how to get the current users windows logon ID.
--
Dale

email address is invalid
Please reply to newsgroup only.