Is there a way to permanently set the alternate row color in access, so that whenever you create a form it will always be what I want.I know that I can make a template and always use the template, but I would prefer to just change the access settings if that is an option.I checked the access settings but couldn't see an option to do this.Also if you can set sub-form's to always have a transparent border, so that you don't have to change it every time you add a sub-form to a form.
Using Access 10 I am unable to turn off the alternate row color function for my report. The icon is on the toolbar, but is grayed out so I am unable to select it.
Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".
By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?
I have a sub form in datasheet view and need to custom alternate row colors with criteria from the main form. E.g. If the Criteria field in the main form is 4, row colors must alternate after every forth record in the sub form. First 4 rows not shaded, next 4 rows shaded. If the Criteria changes to 6 then first 6 rows not shaded, next 6 shaded etc. I can do this in a Report with the Format Event but in a Form there is no Format Event.
On the Home tab, under Text Formatting group, using the Alternate Row Color drop-down list, changes every row, which is not what I need.
We use access to enter our service tickets in at work.What we have are three date fields.
Call Date Start Date End Date
We are 24/7 operation.Currently all 3 just autopopulate with the current date.What i would like to do is ADD a CHECKBOX next to each Date Field.And make it work like this.
1. let them autopopulate as they are currently 2. if you end the call AFTER MIDNIGHT (the next day). CHECKING the box would automatically populate yesterdays date in each of the fields that has the check box CHECKED
I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white , green etc.
I have 3 unique numbers that can identify a specific customer. I would like to my form to locate a specific customer by using whichever parameter the customer can find. Is putting 3 seperate queries on the form the best way to acomplish this?
I'm new to VBA - Access but just dangerous enough to get in trouble. Is there a way to make a variable with the code below? I've been scouring the net all day and can't find answer. What I would like to do is make all the "cirsize1" be a string. Particularly the "Me.cirsize1.ForeColor". if I use the "cs" string it works fine with the Me.cirsize1 = 0 (ie "If cs = 0") This is just a snippet of the code.
Private Sub cirqty1_AfterUpdate() Dim cs As String cs = Me.cirsize1 If Me.cirqty1 > 0 Then 'if there is a quantity greater than 0 in circle qty and If Me.cirsize1 = 0 Then 'if there is 0 in circle size Me.cirsize1.ForeColor = vbRed 'then make the circle size 0 red Me.txtCirIPM1 = 0 End If End If End Sub
I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.
Heres some example data: 1 M24308/2-2F 2 M24308/4-2F 3 ORD9F0000 4 ORD9M0000 5 D90000VLO 6 D90000JOO
How would I design the table to allow me to define alternatepart numbers and also related parts? For example:
Record 1 is the primary part and record 3 is the alternatepart. Record 2 is the primary part and record 4 is the alternatepart. Records 5 and 6 are related parts to records 1, 2, 3 and 4.
I have a form that allows the user to select a part and displaythe part data. But I also want the alternate parts and related parts displayedon the form, maybe in a subform with tabs. I havent gotten there yet because Icant determine the table design.
I am using the Desktop Project Management template in Access and want to change a Open Project query from displaying the "id" which is a number, to the name column. In the projects table the field is set to number which is in a relationship with the employees table. Without changing any of that is there a way to run a query that will display the name instead of the number?
Not sure if this is can be done: I have a picture and I want to change its color in accordance with values in another textBox. Is that possible? if Yes, then what would be the procedure and the codes?
I can use Conditional Formatting on the text to color code the record data in a report.But, I want the text to be the same color.What I'm trying to do is add a Box control from the Design Tools and color code the box depending on the value of a field in the table. The box will appear next to the record.
The field is called ReminderTypeID and there can be only two values for this field - 1 or 2.If the value is 1 I want the box's BackColor to be red. Otherwise what ever color I assign it to in design view.I've tried the following in the On Current.
Code:
If Me!ReminderTypeID = 1 Then Me.bxCode.BackColor = RGB(186, 20, 25) End If
I get no error messages but in all records bxCode has the same color which isn't the one I'm trying to set.
I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and standard access has a white background. My end goal would be to elimnate the focus for any record in the subform (if it is possible). I know that I could change the color with conditional formatting but the colors in conditional formatting do not match the company color.
I would like to have a conditional formating colour of green if the field contains a value like 10%..If the field has no value and is blank there will not be any background color change
I have several forms that each has a dozen or more checkboxes, true/false. I want to be able to change the background color of the label of each checkbox depending on if the checkbox is true or false. I have used the following code which works great:
If Me.A = True Then Me.lblA.BackColor = vbYellow Me.lblA.BackStyle = 1 Me.lblA.ForeColor = vbRed Else Me.lblA.BackColor = vbWhite Me.lblA.ForeColor = vbBlack End If
Me.A refers to T/F checkbox A and Me.lblA refers to its label. This is repeated for each of the checkbox controls. If the control is [B], then its label is lblB. I have used this in the form OnCurrent event and the checkbox control OnUpdate event. I was wondering if I could use the tag property to this, saving me writing countless lines of code and having the OnCurrent event of each of the forms so long and cumbersome. And I do know that I can use conditional formatting to do this, but I would prefer not to use that method. Is there any way to do this using the tag property and not so many lines of code?
Using Access 2010. I have a form on which I've placed a simple label. I try to set the label border color to black but it shows grey. I can set the border color to #000000 and it's grey. I set it to #000001 and it shows black as expected.
I'm thinking it has something to do with the themes, but shouldn't an exact color code show as expected? As a new member (<10 posts) I can't post an actual link, but here's the text of the location: [URL] ....
I have this code that should change backgroundcolor in multiple items form based on a value of a field:
Private Sub Form_Current() 'check if field on form called somefield is DVD If Me.TYPE.Value = "DVD" Then Detail.BackColor = vbRed 'DVD Else Detail.BackColor = 16777215 'BOOK End If End Sub
Is it possible to display records in different colours in a list? e.g. 2 colours: first line will be colour 1. Second line will be colour 2. third line will be colour 1...etc
What I would like this to do, is if the difference is, for example, 1.4, I want the number rounded down, if its 1.6 I want it rounded up, and if its 1.5, i want to use alternate rounding (1.5 down 2, 2.5 up to 3).
