Format Cell Color

Oct 19, 2004

This is a very stupid question, I'm sure...
I want to get Access to find a cells that have a certain value and make them a particular colour so that they can easily be seen by database users. I could also make the font a different colour. I've tried getting the builder to do this in the query I run (for the column the fields appear in) but nothing seems to work. How and where do I enter formatting for colour / font colour based on data that is already in the cell... and what do I need to type?

Also would it be faster to get Access to do this before I run a query - so that the formatting is appllied to the whole table or would it be faster to do it during the query process?

Any help would be much appreciated.

View Replies


ADVERTISEMENT

Modules & VBA :: Retrieve Datasheet Cell Color?

Sep 29, 2014

I'm using conditional formatting on a datasheet to change the background colour of a cell. Is is possible to retrieve that colour?

View 6 Replies View Related

Queries :: Change Background Color Of A Query Cell If Certain Criteria Met?

Aug 14, 2015

Is it possible to run a query and have the background color of the query field be highlighted if a certain criteria is met?

I'd like to use the expresion builder if possible.

For example if the values in field A and field B do not match, then field C should be a yellow background.

If this is possible, how is it done?

View 1 Replies View Related

Modules & VBA :: Conditional Formatting - Backcolor Determined By Color Value Stored In A Cell

Jul 21, 2015

I would like to know if this is possible using VBA ( or other method)

I want to determine the back color o a cell based on a color value stored in another cell in other word

backcolor of cell A = the value of cell B

So if I change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B.

View 4 Replies View Related

General :: Copy A Format From One Cell In A Subform To Another

Aug 18, 2012

The Format Painter seems not to work in Access 2010.The Format Painter button is not in Home / Text Formatting, where you might expect to find it.I create a New Group and add the Format Painter icon. I cannot then use it. It stays greyed out.I add Format Painter to the Quick Access menu. It stays greyed out.If I view a form in Layout mode, I can sometimes get the Format Painter icon to highlight - but I cannot select just a single cell whose format I wish to copy.

Where use of the Format Painter is documented..How to do a very simple thing: copy a format from one cell in a subform to another.

View 3 Replies View Related

Reports :: Changing Background Color And Text Format Simultaneously

Sep 8, 2013

How do I change the background colors and text formatting in all of the reports in one database at the same time? If this is not possible, is there an easier way to change the report formatting without going through every report?

View 2 Replies View Related

Add Value To Cell According To Another Cell In Same Record

Nov 21, 2006

i have a table of articles. A field in the table is ArticleSubject

the ArticleID is made up of 3 letters then 3 numbers. i want the 3 letters to be something according to the subject
for example i want the first 3 letters of the ArticleID to be MAT*** (* is a number) if the subject is Maths
or ENG*** if the subject is English

the subject is picked from a listbox in the same record

how would i do this in a table . i am reluctant to use append or update queries.
but will do so if its the only way.

View 4 Replies View Related

Forms :: Assign Field With Special Format Based On Date / Time Format

Feb 17, 2014

I wanted to assign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".

So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-

I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.

But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?

View 2 Replies View Related

Forms :: Date Format To Fiscal Week Format

Jul 30, 2013

I have a list of dates in the mm/dd/yyyy format and I am looking to get it into the fiscal format of yyyyww. I am able to do this with the datepart and format functions, but I need to make it so that the fiscal month begins in January but the first week starts if there are three or more days in the week. For instance if Jan 1st is a Friday then this stands as the first fiscal week, if it is a Saturday then it does not count as the first week.

datepart and format functions have the Use the first week in the year that has at least 4 days for the firstweekofyear option but I need it where it has at least three to make it work.

View 2 Replies View Related

General :: How To Format The Text Using Format Function

Jul 7, 2015

I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).

str = Format(Me.word, xxxx)

View 3 Replies View Related

How To Have New Cell With New Values?

Jan 9, 2007

Hello!
I have "ID" column and I want to create new column called "ID_new" where the value of each record should be "1000" plus the value of "ID".
For example:
First record, has "ID"=1, than I want "ID_new" to become = 1001
Second record, has "ID"=3, than I want "ID_new" to become = 1003
etc..


Any tips/hints?

Thank you in advance & best regards
noah

View 4 Replies View Related

Duplicating Cell

Jan 10, 2008

Hi Guys

Not sure what I should do here. I would like to have a cell populate with the value of a specific cell previously.
explain:
in excel, we can use formulas like this:

A1: 00:00 B1: 08:30
A2: 08:30 B2: 13:00
A3: 13:00 B3: 15:00
etc, etc
Notice that each cell in A is the same as the previous B Cell. So the formula for Cell A2 would be something like: =IF(B1>0,B1,"00:00")
and Cell B3 would be =IF(B2>0,B2,"00:00")

The fields I have in Access are:

TimeIn TimeOut

So I would need to get TimeIn to be the same as the previous timeout???
Not sure If I'm making any sense right now :)

View 5 Replies View Related

Copy Cell Above And Add 1

May 2, 2005

I have a subform in Datasheet view. One field contains numbers. When entering data into the datasheet I wish to copy the number from the cell above and add 1. Can anybody help me with the code to do this?

View 5 Replies View Related

Sub Cell Information In A Table

Aug 9, 2005

I am not sure if this has been done in a table before. I have seen it in forms but not in tables.

Here is my problem.
I have created a database for a planespotters club. This database has the tables.
ac_logged
ac_maker
ac_model
country
airport

I am trying to display selected information in the ac_logged tbl that is related to other cells. For example: If someone selects boeing in the maker field they will only boeing models in the model field. Also, if someone enters Ireland in the country field only the airports for that country would be listed.

I don’t want to do this in a form but I could settle for a query if I have to.

I was just wondering if this could be done in a table as opposed to any other way.

Hope I have made myself clear on this one. :confused:

View 6 Replies View Related

Replacing Cell Value In A Table

Aug 1, 2007

OK, here is my situation. I have an access database which is updated automatically every night with new data. My companies solution to this is each morning, the entire database is downloaded to my computer to be used by another application.

In one of the tables, there is a field that doesn't work for my purposes, so each day I have to manually open the table, and change the contents of that field for every record. For example, lets say I have the following table:

Field1 Field2 Field3 Field4
Rec1 Wigets Faucet Model1A
Rec2 Wigets Faucet Model1B
Rec3 Wigets Sink Model1A
Rec4 Wigets Sink Model1B
Rec5 Wigets Toilet Model1A

Each day I manually change Field2 so it reads "Total" and whatever is in Field2:

Field1 Field2 Field3 Field4
Rec1 Total Faucets Faucet Model1A
Rec2 Total Faucets Faucet Model1B
Rec3 Total Sinks Sink Model1A
Rec4 Total Sinks Sink Model1B
Rec5 Total Toilets Toilet Model1A

Each morning when I receive the new database download, they all go back to widgets.

Is there a macro or module I can create to automatically look at Field3, and then assign a new value to Field2 based on Field3's value?

Any help would be appreciated!!!!

View 3 Replies View Related

Value Of A Specific Cell From A Subform

Nov 4, 2005

Hi experts,

I have a mainform in which there is a subform. Is there any way that I can retreive the value of the selected cell of the subform in the main form?
Currently what I usually do is that using a text box and setting it's control source to that special field in the subform, we have the value. But this is only for a specific field.
To explain my problem more precisely, I have a subform with 7 columns (fields) and 5 or 6 rows (datasheet view). When I click with the mouse on a specific cell ( or navigate within the subform with the arrow keys) I want to have the value of that cell in my main form.
Thanks in advance.

View 3 Replies View Related

Excel Cell Value Not Same As Value Written To It

Feb 14, 2008

Has anyone else had this problem?

I have a program that brings in the upper and lower specs to a excel spreadsheet and then brings in the values from lab tests.

The program then uses the specs to determine if the value is in or out of spec and colors the value if it is out of spec.

My problem is that in one cell the upper spec that is brought in is 2.7 and it shows that on the spreadsheet but when you click the cell the true value stored there is something like "2.66990153". Since a test value of 2.7 is greater than that it colors it when it is in fact in spec.

I have stepped through the code and the spec value pulled from the table is coming in correctly at 2.7.

Why would the excel sheet have a different value?

View 6 Replies View Related

General :: Arrays Within A Cell

Nov 11, 2013

What's the best way of storing arrays of data within a cell? Or should I be creating fields to the size of the array.The size of the arrays are unknown at the moment.

View 7 Replies View Related

How To Highlight Cell In Subtable

Oct 1, 2012

Ok, there is one main form and a subform which is linked directly to a table. A VBA routine checks entries and flags certain rows for errors. We want to highlight specific cells that are out of tolerance.

Been playing around with the Me.ActiveControl.BackColor = vbYellow

But if this can be done to a particular cell on a table, and if this can be done using VBA.

View 14 Replies View Related

Turning A Cell Red In A Query?

Sep 28, 2011

I would like to turn a cell red in a query - is this possible or can this only be done in a form or report. I have created a table with medical information and want the cell to turn red when blood pressure entry is greater than 140. Not sure what and where formula should be entered.

View 3 Replies View Related

Getting Specific Part Out Of A Cell?

Jul 15, 2015

how do I extract the number of dates and number of percentages out of a cell?

I have for example: "within 10 days 5% discount".

In this it is always "days" and "discount". So I would expect something like 4 digits left of "days" and something like: 3 digits left of "discount".

View 6 Replies View Related

Filtering Dropdown By Value In Another Cell

Oct 23, 2013

I have a few tables. One of it is a matching table between a table with people information and a table with event information. Now it want to do something like that:

The first column is filled with the event name (reference to the event table is done so i can choose from the drop down list) ...
The second column should contain the company name of the persons who visited that event. (also done)
The third column now should contain the visitor name. but the drop down should be filter so that only the people working for the company chosen in column two selected.

In my visitorstable the company of the peoples is referenced so i have to check, when the drop down opens, is the company written in column two also found in the column in my visitors table.

View 1 Replies View Related

Export Query To Specific Cell

Nov 14, 2005

Hiya,

At present I am running a database which opens several queries and then I have to manually paste this informaiton into a spreadsheet.

What I want to know is how do i go about pasting this information into a specific spreadsheet and then into the correct cell.

I have had a look around and have not been able to find what I am looking for.

Cheers

Carl :confused:

View 1 Replies View Related

Partially Deleting Text From A Cell

Jun 19, 2007

If I have the following value in a cell:

Joe <100,894> Doe

Is there a function in Access that will clear out the <100,894> leaving me with Joe Doe? To my understanding the Replace function only can replace certain characters. How can I delete everything in between the < > as well?

Thanks,
Paul

View 4 Replies View Related

Changing Total Cell To Expression

Aug 8, 2006

When i use MS Access help to search for my query i get this result:"Note: If you add a calculated field that includes one or more aggregate functions to a query in qhich you're calculating totals on all the records, you muct set the calculated filed's TOTAL cell to EXPRESSIONHow do i do this?????

View 1 Replies View Related

Extracting Data From A Single Cell

Feb 20, 2005

Hi,

Is there any way that i could extract data from a single cell inside the table to the forms, and vice-versa?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved