[mso] Re: Access question

Right. A few pointers. 

Firstly, why not put a condition on the query so that it JUST shows the
ones you haven't read?

Let's say you have a field called [read] which is 'Yes' if you've read
it and 'No' if you haven't. In the criteria line of the [read] field in
query design, type in:

        =No

- and the query will then exclude all the books you've already read.

But if you want to show all entries with the unread ones highlighted,
your best bet is to generate a report form the query and then apply
conditional formatting to the report.

First, make the report - the report wizard will probably get you
started. Then in the design view of the report, right-click on the field
you want to apply the colour to and from the menu that appears, select
'conditional formatting'. You'll find a wealth of options in the dialog,
but it's pretty straightforward.

To turn all the 'no's in the [read] field green, fo instance, you would
right-click on [read] and go to the conditional formatting dialog. When
there, use the pulldowns to show 'Field value is' and 'Equal to' and
then in the big box, simply type 'No' without any quotes. Then go to
preview view and admire the effect!

Ray

_____________

This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.

For more information on the services that we offer please visit us at
our website: - www.grbps.com 



-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of sandylea@xxxxxxxxxxxxx
Sent: 30 November 2003 16:13
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access question


I  tried to change it in the query but... it changed everything not just
the
one word... or can I set it to change the color in table?  I usually
print
the query and take it with me to library.
----- Original Message -----
From: "Ray Blake" <ray@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Sunday, November 30, 2003 8:00 AM
Subject: [mso] Re: Access question


Yes, it's pretty easy to do. But where do you want to change the colour?
In a report, on a form, in a table?

Ray

_____________

This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.

For more information on the services that we offer please visit us at
our website: - www.grbps.com



-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of sandylea@xxxxxxxxxxxxx
Sent: 30 November 2003 14:57
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access question


Is there a way to color code things in Access?  Example I have a data
base
of books, I have read and books I wish to read, I would like to color
code
the ones I would like to read but can't figure out a way to do this, is
this
possible.

Thanks

SandyLea

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: