Senin, 26 September 2011

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@yahoo.com
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@hotmail.com>
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@yahoo.com
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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar