Reading values from a "settings" table for things like form colors and titles

[taholmes160]

HI All:



Is it possible to take values from a table and put them in the properties fields of various forms etc?

My idea is to have a table where thinks like name of company and colors for form backgrounds etc are stored and have them be used on many forms throughout a database. Im pretty sure things like the name of the company can be used -- that shouldnt be too hard, but im more wondering about values to go into properties settings to allow the user to customize the db to their desires

can anyone point me in the right direction?

thanks
TIM

[isladogs]

Settings tables are very commonly used in Access.
If you only want to store a few values, create a single row table with a field for each.
However if there will be a lot of values, use a settings table with three fields:
SID - PK AUTONUMBER
SName text
SValue Text

In either case, I would then use functions such as GetConpanyName to recall the values when needed...or use Tempvars

However, unless you are intending that clients choose their own form colours, I would just set these in the form design

[davegri]

Here's a tool to easily set the colors for all your forms in a consistent fashion. Not for the user, but for the developer.
https://www.accessforums.net/showthread.php?t=58464

Be sure to scroll down to get latest version.

[taholmes160]

Ideally I would like for the customer to be able to change their own theme colors

TIM

[isladogs]

Dave's excellent example may well do exactly what you want


Otherwise my colour converter utility may be helpful http://www.mendipdatasystems.co.uk/c...ter/4594450413
Then store the RGB or OLE values in a table and add code to each form to retrieve those values.