Solved

Access forms: user controlled colors

Posted on 2013-06-10
2
218 Views
Last Modified: 2013-06-11
Is there a way in access 2010 to set up a customer presence for the color on forms - back cool, forecolor , header, footer,etc?
 I was thinking it could be stored in a table, but the only way I could think of doing it would be to loop through all the forms and physically set all the colors based on a customer preference table.
Any ideas?
0
Comment
Question by:GNOVAK
2 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 150 total points
Comment Utility
2010 can use Themes:

http://blogs.office.com/b/microsoft-access/archive/2009/09/25/access-2010-custom-themes.aspx

I'm not sure how much end-user configuration is available, however.
0
 
LVL 20

Accepted Solution

by:
clarkscott earned 350 total points
Comment Utility
Create a public variable to identify the user.

Public glbUserID as long (or string, or whatever your variable type).

During startup  determine your user and assign the glbUserID.


Create a procedure that determines the color this user likes.

sub WhatColors(byref c1 as long, byref c2 as long, byref c3 as long)
select case glbUserID
      CASE 1
                C1= 255
                C2 = 0
                C3 = pick a color, and so on
end select
end sub

Now, on the open (or load) of each form, call the sub and assign the colors to the form properties you want to control.

It's busy... but it works.

Scott C
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now