Conditional Format

[Chris Wagner]

I have 2 different databases. A and B
In each database I have a field named Updated.
Both fields in each, are set to time/date format.
Each database has a form.
On each forms, the field 'Updated' is set to a conditional format
with the following expression

Expression Is [updated]+365<Date() which will Change
background color

On one form, in Database A, it works fine. A date such as
05/14/2001 or 01/21/2004 has a colored background whereas 06/30/2004
does not. This is what I want to happen.

On the other form, in Database B, there is no change to a colored
background regardless of date entered.

The table that does not work properly, Database B, is on a file server
Thinking that might be the problem I copied Database B from the server
to the machine I am working with still without luck.


Any Ideas.

Chris Wagner

 

[Wayne Morgan]

On the one that doesn't work, try changing Date() to #5/30/2005#. If that
works, then there is probably a References problem. To get to the References
dialog, open the code editor (Alt+F11) and to go Tools|References. For
information on how to fix these problems, see this link.

http://www.allenbrowne.com/ser-38.html

 

[Chris Wagner]

Tried changing the Date() to #5/30/2005# and it didn't seem to make a difference
with the change. Does the reference move with the database? I have tried the
database on 3 other machines here and none of them show the conditional format
correctly. ( background changing color) So I am guessing the above question
is yes, yes?.

After looking at the link sent and reading some other messages I see "If a
library is marked MISSING,.... " How is that determined. After doing the
alt-f11 Tools|References I see checks in front of some of the names in the
table shown (4) Does the check mean missing?

Should there be a check in front of Microsoft DAO3.6 Object Library? There is
not one now.

BTW I'm Running Access 2000 on a Win 98 machine.

Chris

On the one that doesn't work, try If that
works, then there is probably a References problem. To get to the References
dialog, open the code editor (Alt+F11) and to go Tools|References. For
information on how to fix these problems, see this link.

http://www.allenbrowne.com/ser-38.html

--
Wayne Morgan
MS Access MVP

I have 2 different databases. A and B
In each database I have a field named Updated.
Both fields in each, are set to time/date format.
Each database has a form.
On each forms, the field 'Updated' is set to a conditional format
with the following expression

Expression Is [updated]+365<Date() which will Change
background color

On one form, in Database A, it works fine. A date such as
05/14/2001 or 01/21/2004 has a colored background whereas 06/30/2004
does not. This is what I want to happen.

On the other form, in Database B, there is no change to a colored
background regardless of date entered.

The table that does not work properly, Database B, is on a file server
Thinking that might be the problem I copied Database B from the server
to the machine I am working with still without luck.


Any Ideas.

Chris Wagner

 

[Wayne Morgan]

I'm trying to remember where the "Missing" shows up, I don't have any to
see. I believe it shows up at the end of the name of the reference. It is
either there or in the location string in the small box under the list
window. If the latter, you have to highlight each one you want to check to
get its location string to appear in the box.

As to whether or not you need a check in front of DAO, it depends. Access 97
and earlier used DAO by default. Access 2000 and later use ADO by default.
If you want to use DAO, and there are still some good reasons to use it, you
need to check the box..

Yes, the References move with the file, but they are also based on the
library files being on the computer. The check in front of the name of the
references means that those have been selected to be used in that database.
You only want the ones checked that you need or are likely to use.

How much of a color difference have you set? If it is just two shades of the
same color, the hardware you are using on those computers may not be
accurate enough to show the difference or the color depth in the display
settings may be too low to see the difference.

--
Wayne Morgan
MS Access MVP

Tried changing the Date() to #5/30/2005# and it didn't seem to make a
difference
with the change. Does the reference move with the database? I have
tried the
database on 3 other machines here and none of them show the conditional
format
correctly. ( background changing color) So I am guessing the above
question
is yes, yes?.

After looking at the link sent and reading some other messages I see "If a
library is marked MISSING,.... " How is that determined. After doing
the
alt-f11 Tools|References I see checks in front of some of the names in
the
table shown (4) Does the check mean missing?

Should there be a check in front of Microsoft DAO3.6 Object Library?
There is
not one now.

BTW I'm Running Access 2000 on a Win 98 machine.

Chris

On the one that doesn't work, try If that
works, then there is probably a References problem. To get to the
References
dialog, open the code editor (Alt+F11) and to go Tools|References. For
information on how to fix these problems, see this link.

http://www.allenbrowne.com/ser-38.html

--
Wayne Morgan
MS Access MVP

I have 2 different databases. A and B
In each database I have a field named Updated.
Both fields in each, are set to time/date format.
Each database has a form.
On each forms, the field 'Updated' is set to a conditional format
with the following expression

Expression Is [updated]+365<Date() which will Change
background color

On one form, in Database A, it works fine. A date such as
05/14/2001 or 01/21/2004 has a colored background whereas 06/30/2004
does not. This is what I want to happen.

On the other form, in Database B, there is no change to a colored
background regardless of date entered.

The table that does not work properly, Database B, is on a file server
Thinking that might be the problem I copied Database B from the server
to the machine I am working with still without luck.


Any Ideas.

Chris Wagner

 

[Ken Snell [MVP]]

I'm trying to remember where the "Missing" shows up,

I believe it is displayed to the left of the library name in the list.