ACCESS FEED: RE: [MS_AccessPros] Re: Change color of record based on event???

Tiffany-

That's what happens when you think in "spreadsheet" mode! Design your table properly to include all sold and unsold properties and just set an indicator. All will be well.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Tuesday, September 27, 2011 7:18 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Change color of record based on event???

Okay, so I should add this field to the form and incluse all the sold in the table. My boss had this data originally set up in excel spreadsheets and she would move the line item when she sold the vehicle.

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 27, 2011 11:08 AM
Subject: [MS_AccessPros] Re: Change color of record based on event???

Tiffany

If you are moving a record to a different table just because it is sold, you are not designing your database correctly. Just add a Yes/No field named Sold to your table. When a record is sold update that field to Yes (-1). If you want to omit it from displays set up your queries to show only if Sold = No (0).

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, cc0623 <cc0623@...> wrote:
>
>
>
> Hi Duane,
>
> I am working in 2010. Can anyone recommend a great Access book that a dummy can understand? I tend to over think a problem and it is usually the simplest answer.
>
> I have one more question/problem: I have two tables current and sold. I want to create a control that moves the record from current to sold when needed.
>
> Can someone help me with this?
>
>
> Thank you very much,
>
> Tiffany
>
>
>
>
>
> ________________________________
> From: Duane Hookom <duanehookom@...>
> To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
> Sent: Monday, September 26, 2011 6:37 PM
> Subject: RE: [MS_AccessPros] Re: Change color of record based on event???
>
>
> Tiffany,I'm not sure you have ever told us what version of Access you are using or replied with the data type of "202". There are reasons why we ask questions and expect answers. It saves lots of time and bandwidth if you read replies and either respond to questions or ask for clarification. In design view, select all of the text boxes in the form. Then find the Conditional Formatting dialog and select "Expression Is" from the drop down.Then enter either:[Acc Code]=202or[Acc Code]="202" Then make the formatting selections for fore and/or back colors. Save your work. Duane HookomMS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: cc0623@...
> Date: Mon, 26 Sep 2011 16:07:14 -0700
> Subject: Re: [MS_AccessPros] Re: Change color of record based on event???
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Please write the formula out for me.
>
>
>
> I want it to say: Expression is, if Acc Code = "202" then back color purple. this works on acc code but it keeps telling me syntax is wrong for other fields. Please remember I have never done this before so I am out of my depth. I appreciate you trying to teach me this.
>
>
>
>
>
>
>
> From: Duane Hookom <duanehookom@...>
>
> To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
>
> Sent: Monday, September 26, 2011 4:49 PM
>
> Subject: RE: [MS_AccessPros] Re: Change color of record based on event???
>
>
>
> Tiffany,
>
> I just created a simple datasheet form and set the conditional formatting of every text box based on "Expression Is" as suggested by John Viescas. My table has a field named TotalFreight and I set the background color based on this expression:
>
>
>
> [TotalFreight]>500
>
>
>
> Set the default view of the form to datasheet and your done. It took me less than 5 minutes (less time then it took to create and send this email). The datasheet view of a form is very similar to that of a table but you have much more flexibility.
>
>
>
> If you have any questions regarding the steps to reproduce this, please let us help you.
>
>
>
> Duane Hookom
>
> MS Access MVP
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
>
> From: cc0623@...
>
> Date: Mon, 26 Sep 2011 14:57:24 -0700
>
> Subject: Re: [MS_AccessPros] Re: Change color of record based on event???
>
>
>
>
>
>
>
> Well, I created the form and indicated 202 and it did change all the fields with 202 purple, but I needed it to change the entire record purple not just one field. And, I wanted to see this change in the datasheet view under the table not just the form, but it doesn't show the effect under datasheet view. Very frustrating... my boss did not want a form she is stuck on excel and with all the data we have to manage I am trying desperately to get her to use access. Any suggestions?
>
>
>
> From: Duane Hookom <duanehookom@...>
>
> To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
>
> Sent: Monday, September 26, 2011 3:51 PM
>
> Subject: RE: [MS_AccessPros] Re: Change color of record based on event???
>
>
>
> Greetings Tiffany,
>
>
>
> Table and query datasheets don't support conditional formatting. Creating a datasheet form takes less time than creating and sending an email.
>
>
>
> Duane Hookom
>
> MS Access MVP
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
>
> From: cc0623@...
>
> Date: Mon, 26 Sep 2011 20:52:50 +0000
>
> Subject: [MS_AccessPros] Re: Change color of record based on event???
>
>
>
>
>
>
>
> Hi John,
>
>
>
> My name is Tiffany. Thank you for responding to my question. I am assuming this is to be done under forms? Since only two people are using this database the primary party does not wish to add a form to it. Can this be done under datasheet view or design view?
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
>
> >
>
> > Dear cc0623, (name?)
>
> >
>
> > Use Conditional Formatting. Select all the controls that you want to be purple,
>
> > then click on Conditional Formatting. In 2003 and earlier, it's on the Format
>
> > menu. In 2007 and later, it's on the Design tab under Font. Choose Expression
>
> > Is, then enter your field name in brackets, an equals sign, and "202", then
>
> > select either the Fill/Back Color or Font/Fore Color to set the color you want.
>
> >
>
> > John Viescas, author
>
> > Microsoft Office Access 2010 Inside Out
>
> > Microsoft Office Access 2007 Inside Out
>
> > Building Microsoft Access Applications
>
> > Microsoft Office Access 2003 Inside Out
>
> > SQL Queries for Mere Mortals
>
> > http://www.viescas.com/
>
> > (Paris, France)
>
> >
>
> >
>
> >
>
> > -----Original Message-----
>
> > From: MS_Access_Professionals@yahoogroups.com
>
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
>
> > Sent: Monday, September 26, 2011 8:30 PM
>
> > To: MS_Access_Professionals@yahoogroups.com
>
> > Subject: [MS_AccessPros] Change color of record based on event???
>
> >
>
> > I would like to change the color of the record based on data.
>
> >
>
> > I want to change the color of the record to purple if the data in a specific
>
> > field says "202". So in datasheet view I will see specific records are purple
>
> > and someone else can followup with that record.
>
> >
>
> > I am a newbies to access and I am having difficulty with this. Can anyone
>
> > adivise me please?
>
> >
>
> >
>
> >
>
> > ------------------------------------
>
> >
>
> > Yahoo! Groups Links
>
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links