setting colour scheme and logos in all forms/reports through table

Cowboy_BeBa

Registered User.
Local time
Today, 15:06
Joined
Nov 30, 2010
Messages
188
Hi everyone

Im working on commercializing a database ive been developing for quite some time
im already rebuilding the back end and have a lot of ideas for the front end

one such idea is that id like all the companies that buy the DB to be able to pick their own colour scheme and logos throughout every report and form on the database (and i dont wanna change this manually every time i sell to a new client or build a new update, far too time consuming)

im thinking of creating a basic settings table (tbh i already have one, but it just has a few small constant variables in it for reference in other tables/functions) where a customer can pick a colour scheme they like (ideally id like to find a way to get a colour pallet in there, similar to the one you get when you select "more colours" and then "custom" from the back colour field in a form/report designs property sheet, but ill be happy if i can just get an RGB value in there) and have a script that will either cycle through every form and report in the DB and make that change when the user clicks a button, or have every form and report determine that colour when they open (though i believe this option might possibly slow down the every day use of the database considerably)

and i would need to do the same thing for the company logo, id need to get them to select a location where the logo is stored on their server and have a similar script either change the logo on each form/report or look up the logo when the report is opened

anyone know if this is even possible? and if so where do i look? (all i need is someone to point me in the right direction and i should be able to put it together from there)

thanks,
Ben
 
I have a table that contains details about users and includes fields to store specific information set in a settings form. The attached gives you an idea of what settings i have personalised per user such as Audio Feedback, Report Banner Colour, Mug Shot on Report Footer amongst other things. I tend to add things to the table to allow other individual changes as requested.. Hope this helps in some way.
 

Attachments

  • 1.jpg
    1.jpg
    198.1 KB · Views: 97
  • 2.jpg
    2.jpg
    349 KB · Views: 104
  • 3.jpg
    3.jpg
    460.9 KB · Views: 93
you do realise you are responding to a five year old thread?
 

Users who are viewing this thread

Back
Top Bottom