Re: Conditional Format logic
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 Apr 2007 17:27:49 -0600
On Wed, 11 Apr 2007 15:30:01 -0700, Iram <Iram@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hello.
I have a subform with the following fields:
Date (tied to the parent table and Form)
Name
LoginTime
LogoutTime
I would like to create conditional formatting on the login and logout fields
that will show folks how many people are logged in. The logic would be
something like: if the current time is between the LoginTime and LogoutTime
then make these fields Blue.
What I need to do is regulate the amount of concurrent users to 4 that are
accessing a resource. They are supposed to go into this Database, put there
name and login/logout times. The problem is when you have 20 records with
many Login and Logout times, things can get really confusing.
I would like only the records that currently have a login and logout time
that is active, i.e. if it is 11am then I want all records that have
something like 10am-12pm or 7am-2pm to show up as Blue.
Sure. Use "Expression Is" as the condition, and
Time() >= [LoginTime] AND Time() <= [LogoutTime]
Note that if you're storing pure time values in these fields, then it's
ambiguous whether 11:00 am means 11:00am today, or yesterday, or eight years
ago; all Time() values are times on December 30, 1899, the base of date/time
fields. You may want to store the current DATE AND TIME using Now() in the
Logintime and Logouttime fields, and use Now() instead of Time() in the
expression.
John W. Vinson [MVP]
.
- Prev by Date: Re: can't edit text in text boxes
- Next by Date: Re: Update--Re: auto fill form based on combo-box selection
- Previous by thread: Problem with UDF to fill list box
- Next by thread: Re: VBA Code for Maximize
- Index(es):
Relevant Pages
|
