Datasheet Change Single Row Colour Based On Attribute
Jan 16, 2007
Hi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform, viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU
Thanks heaps for your help
View Replies
ADVERTISEMENT
Jan 14, 2007
Hi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU
I have read you can do this quiet easy in access 2007 but was wondering if possible in 97
Thanks heaps for your help
Thanks
View 2 Replies
View Related
Jun 27, 2006
Well, I got asked to do this with a datasheet view today, and I found after searching the forum that I'm not sure how to do it, and no one else seems to have done this either.
Basically I need to flag a row in a datasheet subform dependant on if a date field is more than 1 month ago and if the status field is set to pending. I looked at conditional formatting, but that only seems to let me set a condition on a single field at a time.
Any help would be appreciated :)
View 4 Replies
View Related
Jan 24, 2007
Hi,
I'm currently using MS Access 2002.
I use forms to display client info and i would like to know if the following is possible, and if so, how ?
When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.
eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.
Kinds Regards
Chris
View 4 Replies
View Related
Apr 25, 2005
page colour name change
View 3 Replies
View Related
Nov 3, 2006
Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.
Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!
This is to enable multiple users to see at a glance the status of various jobs.
If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.
Thanks in advance
http://img101.imageshack.us/img101/223/switchsamplert7.jpg
View 4 Replies
View Related
Feb 8, 2006
Friends,
I would like some help with my form.
I would like the following:
If txtname is null (without data), then txtdob font is changed to colour white.
Any help?
Thanks.
View 1 Replies
View Related
Apr 14, 2005
...but I'v got a picture and I want to put a red box behind it so the picture looks like it has red borders, the problem is that the box always appears above the picture, I'm sure there must be a way to prioritize them or something but I can't find it!
View 3 Replies
View Related
Jan 17, 2006
I've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.
I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??
I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.
Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..
Regards
Darren.
View 4 Replies
View Related
Feb 6, 2006
Hi
I have a problem where the user has certain contraints in colour.
I am trying to change all the colours of labels in the database to purple.
Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also there are other users who want to use the database with black.
???:rolleyes:
View 2 Replies
View Related
Jun 28, 2006
Hello,
First please accept my apologies if this has been done before. In the attached database I am going to have a form which is continous what I am looking to do is change the colour of the box which is in the background to the associated colour from the quote table for example
if they choose water then it will look at the TBLQuoteType and change the box colour to the colour which has been assigned to that value.
Hope this explains it ok I will continue to try and figure it out but I thought I could also use your expert knowledge.
14030
Thanks again
View 5 Replies
View Related
Aug 26, 2004
Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information.
Any help that you can provide would be great!
View 4 Replies
View Related
Apr 17, 2005
Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.
View 1 Replies
View Related
May 30, 2007
I have a report which i am trying to format, I want every other row's details to alternate colour which i have done (See below)
I also have on my report, a checkbox and a text feild (not sure if i could use a rectangle and format that instead , it doesn't do anything i just need it to change colour)
chkbox name = "chkClean"
Text box name = "txtclean"
I just want the back colour to go red if the check box is true and white if the check box is false
Please help
ANdy
Code:Option Compare DatabaseOption ExplicitPrivate m_RowCount As LongPrivate Sub Detail_Format(Cancel As Integer, FormatCount As Integer)m_RowCount = m_RowCount + 1 If m_RowCount / 2 = CLng(m_RowCount / 2) Then Me.Detail.BackColor = 15263976 'Change value to the color you desire Else Me.Detail.BackColor = 14811135 'Change value to the color you desire End IfIf Me.chkClean = True Then txtclean.BackColor = 255Else txtclean.BackColor = 16777215End IfEnd Sub
View 2 Replies
View Related
Jan 30, 2015
I have a bar graph on a report in ms access that represents 4 different risks ie count on the y axis and risk type on the x axis (low, moderate high and extreme)
Question: How do i get the each bar to automatically represent the colour based on the risk colours below?
Low: Green
Moderate : Blue
High : Yellow
Extreme: Red
View 5 Replies
View Related
Jun 7, 2006
Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it called: Zone - (which has a 3 digit number it it). I want the colour of the text box to change depending on the Zone number, in the continuous Form view. So all the customers living in Zone=111, will have a Red background colour (color), all living in Zone=222 will have a Green background colour. I know conditional formatting through the properties of the Form can be used, but it only allows me to select 3 different situations. I have many more than 3 colours that I want to assign. I am working on a VB module to define what colour numbers from the MS Access Colour Map will be assigned to each Zone number. How can I now apply this module to the form, so when it opens, all the customers who live in Zone=111 will have a Red coloured background, those living in Zone=222 will have a green colour background, etc?
View 9 Replies
View Related
Jan 12, 2013
I have a keys table and a keysctivity table. I need keys to not be available if they are currently signed out (return_date is null) or if they have been marked as lost (lost_key = true)
This is my activity table. URL....If for example signin_id 1 was not returned or was lost, key_id 1 should no longer be available. Is this something that can be done?This is the access file I am working on: URL....
create two new tables "lostKeys" "unreturned_keys" and have records moved to their respective tables based on whether they are indicated to be lost or currently not returned.
View 4 Replies
View Related
Oct 9, 2007
Hi All,
If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.
Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).
I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.
Many thanks
View 1 Replies
View Related
May 5, 2005
:) Hello
Is it possible to change the colour of the text in a table. For example the word "URGENT" is selected from a combo box, and when viewed in the table it appears red.
Thanks inancipiation
Woozie
View 1 Replies
View Related
Feb 27, 2014
Is it possible to use a toggle button to change the colour of a label?
I assume the code should be something like this:
Code:
If Me.ToggleButton = 1 Then
Label.BackColor = RGB(0, 255, 0)
ElseIf Me.ToggleButton = 0 Then
Label.BackColor = RGB(255, 255, 255)
End If
But I've tried it in the "On Click" sections and it doesn't work.
View 6 Replies
View Related
Oct 7, 2011
I have a large database of students and parents which charts their weight, waist circ., lifestyle etc. When I then create reports, is it possible to change the colour of the entry so that I can differentiate between students and parents results? In other words, can I have all student entries in red and all parents in black, for example? At the moment, when I try to change the colour of one of these, the entire column changes to that colour and I don't know how to amend my reports to do this. Please see attached.
View 2 Replies
View Related
Jul 9, 2013
I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.
View 4 Replies
View Related
Apr 15, 2015
I have a form in datasheet view that has a user directory with a list of each person. On each row you can click to open another form that contains the users details using the below VBA:
DoCmd.OpenForm "User Details", , , "[ID] = " & Me.ID
But once you open to that specific record, no other records are available to navigate to.
I want to be able to stay on that detail form that was opened and go to another record.
How do I continue to pull up that specific user in my detail form, but also load the others so I can navigate to them from the detail form without having to go back out to the datasheet form?
View 7 Replies
View Related
Apr 3, 2014
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I need for them to be able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID.
Ideally, it would also work for new entries in the StockArtProduction_Subform, but the StockArtProduction form would have to "auto populate" (did I use it right?) with the ID of the currently open Project form.
View 14 Replies
View Related
Oct 24, 2005
I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties.
Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?
View 1 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 2 Replies
View Related
