Tiffany-
I highly recommend Access 2010 Inside Out. Although my name is still on the
cover, Jeff Conrad wrote most of this one, and it's very very good. (I wouldn't
have turned the book over to him if I didn't think he would be a great technical
author!)
http://www.amazon.com/dp/0735626855?tag=viescaconsulinc
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 4:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Change color of record based on event???
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@hotmail.com>
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@yahoo.com
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@hotmail.com>
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@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
[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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar