Topics Search

Possible To Set Color Theme On Query ?

Possible To Set Color Theme On Query ?
Views: 0
In Access 2007, is it possible to set a color scheme or a Theme Color to a QUERY
Sponsored Links:

More topics

 

DB Design & Table Setup Help

Preview
I am trying to design a database for tracking Legos, by sets and parts. I am having a hard time getting the relationships right, to make sure that the data cross references itself properly.

Pretty simple right? How I think the relationships should be based on the following information.

A Lego Part can be in many different colors,
And Colors can go to many different parts
(So a 1 x 1 x 1 brick can be in yellow, blue or red- While The color red can goto a 1x1x1 Brick, a 1x2x3 Brick and a 1x12 Wing)
So this would be a many to many relationship

A Lego Part can only be in one partcategory, where a partcategory can have many different parts. One to Many

A Lego Part, along with whatever color it is, can go to a set. And a set can have many different parts in many different colors. Again Many to Many

A Set can only belong to one theme. But a theme can have many different sets. One to Many

Because I think it should work like this:
I want to see what parts are in a set. So I tell the database, here is the SetNum I want to see, and it runs a query to display all the parts in that set, along with the colors of thoseparts and the quantity of each part.
 

Change the appearance of Office programs

Preview
The appearance of the Ribbon, which is part of the Microsoft Office Fluent user interface, in the 2007 Microsoft Office system follows the Office color scheme and the toolbars, buttons, menus, and dialog boxes in Microsoft Office follow the Microsoft Windows desktop theme settings on your computer. You can change the default Office color scheme and Windows desktop theme to customize the appearance of your Office programs.
What do you want to do?
* Change the Office color scheme
* Change the Windows desktop theme
 

Combo box background color different than text box

Preview
On my form, my by using the autoformat theme, I've noticed that my textboxes have a different background color (white) than my combo box (grey). How do I change the text box background color to the same as the combo box?

I've been looking under properties, especially back color but that doesn't seem to work
 

Setting the background color of a subform

Preview
I have a main form which is called in different modes. For each mode I set a background color with Me.detail = a color number.
But on the form are several subforms, and I would like to change the background color of the subforms to match.
This does not work: Me.Mysubform.detail = a color number.
How do I set the color of a subform
 

query group by over another group by?

Preview
I am new to access sql and got a problem with a query:

I got a table like:

theme subtopic

a fish
a fish
a vegetables
b vegetables
c fruits
c fruits
c fish

now I want to get the number of subtopics for each theme.
anyone got an idea how to solve in a query?
 

row color in Query

Preview
1) how to set odd number rows color different from even number rows?
2) how to set the current row color which is different from all others?
 

Change the color of hyperlink text

Preview
Follow one of the procedures below to change the color of hyperlink text or match the color of hyperlink text with the existing text on a slide. If hyperlinks appear in both the title and sub-title placeholders, do not change hyperlink text in the theme.
 

query group by over another group by?

Preview
I am new to access sql and got a problem with a query:

I got a table like:

theme subtopic

a | fish
a | fish
a | vegetables
b | vegetables
c | fruits
c | fruits
c | fish

now I want to get the number of subtopics for each theme.
 

access 2007 some combo's won't keep same color formatting

Preview
I have searched for this, but can't find a solution that works.

I have 3 combo's all of which were created the same way, the 3 were added at a later time. When I added them I used the format painter to copy over the same "Look" of all the colors. well only the first of the 3 keeps the color you see when clicking the drop down.

In the detail section of my form I have it set to alternate color, on the combos that work, the font fore color remains the same as when it is not clicked, but the highlighted line of the selected choice will light up the font to RED. which is good. BUT. on the non working combo the font changes to BLACK for everything in the list, the color of the bar is correct but the selected shoice turns the Font to White! WTF, I have looked very closely at all the properties, there is no conditional formatting set. this is really annoying, I have my combos set to the perfect color
 

Lookup & Autofill

Preview
I have a table with "Color". I want an option group in the form that I can click one of 2 color choices. The option numbers are stored in a separate column called "INTCOLOR". The color choices are stored in a table called "tblINTCOLOR". I want my color field set in design view to look up the number from "INTCOLOR" in "tblINTCOLOR" and automatically put the color NAME into the "COLOR" field automatically. Such a simple query but I'm missing a step somewhere and can't get it to work!