Set Colors On Specific Rows In Continuous Form

Sep 5, 2006

Can we set different colors on specific rows in a continuous form?
Suppose the following data entry form (continuous) is to fill in spouse name, while name and marital status is already prepared in a different table. If the marital status is Married, then the spouse name textbox's background color will be Yellow. The standard background color is white.

Name Marital Status Spouse Name
-------------------------------------
xxxx Married (Yellow)
xxxx Unknown (White)
xxxx Not married (White)
xxxx Married (Yellow)

View Replies


ADVERTISEMENT

Modules & VBA :: Continuous Form - Display Alternating Colors

Jul 23, 2013

Access 2007: I have a continuous form which, when it opens, uses code to display alternating colors... I need to set a default 'alternate' colour, and I want to find the code to use for Light Grey - on the design of a form, the color to use on a control would be #903C39 but when I try to set that as my default colour in the code it doesn't like it! I can use vbRed, vbBlue, vbYellow, etc, and that works perfectly but I can't find a vbLightGrey

View 6 Replies View Related

Color Alternate Rows In A Continuous Form

Oct 25, 2005

Hello,

Does anyone know how to color alternate rows in two different colors in a continuous form?
:(

View 1 Replies View Related

Use Specific Record In Continuous Form For Event?

Oct 10, 2006

Hello,

I have a continuous subform that shows 2 records consisting of a text field and a yes/no field.
I was wondering if it was possible to take the state of one particular of the yes/no fields to trigger an event. Specifically, when one of the questions is checked [true] then I would like to make visible another subform on the main form.

Can this be done, and if so, how, or should I just leave my subform visible at all times?

Thank you.

View 12 Replies View Related

Forms :: Refer To Specific Record In Continuous Form

Apr 15, 2013

I have a main form with a continuous sub-form. On the main form I have a series of text boxes that I want to use as a makeshift status bar. The text boxes would be filled in if a value was entered into certain records on my sub-form.The problem I have is since the sub-form is continuous, how would I refer to the specific record on the sub-form that I want to check for a value?

View 6 Replies View Related

How To Return Specific Rows In A Query To A Form

Dec 31, 2012

I have a Query of dates and I need to have those dates return onto a from horizontally?

View 1 Replies View Related

Forms :: Filter Down To Specific Categories In Inventory - Scroll Bar In Continuous Form

Sep 9, 2014

I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I filter down to one of the categories that has 5 items, because there is no scroll bar.

What I've tried using is:

Code:
If Me.RecordsetClone.RecordCount < 10 Then
Me.Scrollbars = 2 'vertical only
Else
Me.Scrollbars = 2
End If

But it still doesn't display correctly (nobar.png). This is probably my biggest headache right now, and every "solution" I've found, doesn't work.

View 11 Replies View Related

Forms :: Control Button Linked To Specific Record In A Continuous Form

Apr 3, 2014

Access 2010. I have a form pulling from a query to create a "To Do' list of sorts. On this form is a button to open an input form for the corresponding record (I hope). When this button is used I want it to pull certain data for that specific line from the query and input it into the new record opened by the button. I know this is possible as I use another db that does this but I have not been able to figure out how to make it work in the new db.

View 14 Replies View Related

Forms :: How To Get A Specific Record To Be First Record Of Continuous Form

Nov 8, 2013

I have a continuous form for which the recordsource is a query that retrieves dates from 10 days in the past to 10 days in the present. I want the record with today's date to be at the top of the form. The record with the oldest date is always on top. Is this a scrolling issue? How can I get the record with today's date to appear on top?

View 5 Replies View Related

Locking Specific Rows Within A Query

Oct 12, 2007

Hey guys,

I have a query on a form in which I want to lock the first two rows to prevent the user from manipulating the data. The user will input information in the third column.

How would I go about this

Thanks

View 5 Replies View Related

Reports :: How To Get Sum Of Values For Specific Rows

Nov 5, 2013

I have a report being generated that pulls in a bunch of data. The processed column is a boolean value.

I want to be able to set the text of a label to be equal to the "material cost" for all the rows where is processed is set to false.

Picture of the report: [URL] ....

View 3 Replies View Related

Dressing Up A Form - Colors

Jan 13, 2006

I built a really good database and now I want to dress it up a bit. Does anyone know how to change the color of a command button ? (access 2003)
Thanks:rolleyes:

View 2 Replies View Related

Alternating Colors In Form

Oct 6, 2004

Hi
Is there a way to have alternating colors in a form?

I would like every record to alternate between Grey and White.

Thanks!

View 1 Replies View Related

How To Get First Form To Change Colors

May 22, 2013

A couple of days ago I was looking to change a form button color in a new database I was working on, I could not. I changed the Back Color to #22B14C but it stayed the same grey color. I could not make the change in that form in that database.

Then I went into a different database that I built and I noticed that the Command Buttons within the form was blue, I changed it to #22B14C and it turned green. What the difference is. I copied the button to the first stated database and in that form and the color stayed to grey even though the Back Color was set at #22B14C. I noticed that the database that the form that I could change the color had Hover and Press color options whereas the first database does not. I copied the form that I could change the button colors to the first database and I could change the colors but they had changed from the second database to the first, I could change the colors but the Hover and Press options were gone.

how I get the first form to change colors and what is the difference between the two databases?

View 1 Replies View Related

Forms :: Count Only Rows In Specific Field With Date

Dec 12, 2014

I have an access forum that I need to have a textbox count how many rows have dates in my "Ship_To_Date_HP_" field

View 6 Replies View Related

Forms :: Hide Number Fields Of Specific Record On Continuous Subforms

Mar 8, 2014

I have a continuous subform recording the information of various wireless products for an employee embedded in an employee main form. Please see screen shot enclosed.

There is a check box "BYOD/Personal" on the subform. I want to hide a number fields when this check box on independent record is checked. However, if I use the following codes, the changes apply to all records under that employee.

Private Sub BYOD/Personal_AfterUpdate()

If BYOD/Personal.Value = True then
Me.Provider.Enabled = False
Me.XXX.Enabled = False....etc.
Else
Me.Provider.Enabled = True
Me.XXX.Enabled = True....etc.
End If
End Sub

How can I just disable those fields on the subform of a specific record when the BYOD/Personal field for that record is checked?

View 8 Replies View Related

Changing Colors For Each Line In Form

Sep 3, 2004

Is there any way to change the color of a field based on the value of a field.

I know how to do this for a single form but I need to do it for a Continuous Form
(each line may be a different value and have a different color.)

Is there some event that happens before each line displays???

Thanks

View 4 Replies View Related

Forms :: Defining Colors On Form Control

Mar 30, 2014

I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors.

I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the values for it that will give me the exact colors that I need!

I also saw a possibility of using a the hex equivalent for the color but I couldn't make that work?

View 2 Replies View Related

Reports :: Conditional Formatting - Rows To Be Of Specific Color Based On Value In 1 Field

Jul 24, 2014

I have a report that I would like to have the rows be a specific color based on the value in 1 field on the row.

I have attempted to use conditional formatting but it will not work (IE, I can get font color to change, but not field boxes to have color).

The field is labeled [text144] based on the value in the field (1,2, or 3) I would like the field to be a different color.
i.e.
3 = green
2 = yellow
1 = red

View 4 Replies View Related

Forms :: Possible To Store Colors In A Form Or Table And Then Reference Them While In VBA

Dec 5, 2014

I am trying to see if it is possible to store colors in a form or table and then reference them while in VBA. What I am hoping to do is when I write all my code for command buttons to change On Got Focus, instead of writing xxx.backcolor = RGB (255,255,255) i could do something like xxx.backcolor = Forms!HiddenColors!Command That way if i want to ever change the color scheme of the db, I can change it in one place rather than hunt lines of code.

I have played around but with no success. Technewonline is a website that specializes in introducing the latest technologies such as Best Tablet Android Have Price Under $200 and Best tablet of Apple in 2014 and The Best Midrange Smart Phone In 2014 and Top Best Ultrabook Of 2014 and The Best Phones 4G Valued At Under 300 USD is also a website for sharing your tips about computers, mobile phones and tablets, products are available from leading supermarkets will surely satisfy you.

View 1 Replies View Related

A Continuous Form And Continuous Subform, Possible?

Aug 9, 2005

What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.

when I put the subform within a subform, access comes up with the following message:

************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.

You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************

which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.

does anyone know of a way around this?

what about Access2003 does it allow this?

help much appreciated.

Steve Ferry

View 8 Replies View Related

Forms :: How To Hyperlink From Query To Specific Record In A Specific Form

Jul 23, 2013

I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?

View 3 Replies View Related

Where Did All The Colors Come From?

Nov 24, 2005

When I opened my database today, all the tables had turned blue??

Does that signafies anything? How can I reset the table in plain white??

Any help is appreciated!

bboschker
an absolsute access beginner!

View 2 Replies View Related

Colors

Feb 15, 2005

Anyone know how to convert a color code from something like:

#E1E1E2

To something that Access will recognize?

Thanks,
Ken

View 2 Replies View Related

Row Background Colors

Feb 13, 2007

I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings?

I have found examples of how to change the color of alternate rows, but I can't find anything that would tell me if what I want to do is possible.

View 1 Replies View Related

List Box With Colors

Aug 8, 2005

How I can do a form whit a list box whit different colors for each record ?

Thank you

View 5 Replies View Related







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