By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,457 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,457 IT Pros & Developers. It's quick & easy.

Changing forecolor of all fields in record and updating related tables in Access 2000

P: n/a
Hi, I'm not a programmer but would appreciate some help with the following.
I've been looking at various sites but cannot find the information I
require.

I have a table of strata plans and if we no longer manage the plan the date
this occurs gets entered into a field. What I would like to happen is for
all the fields in that record to change their forecolor to red as soon as
the DateLost field is no longer null.

I also have several related tables which have a tick box in them to say we
no longer manager the plan. At the same time that the above occurs I would
like to update the related tables by having the tick box field entered and
the forecolors of these records also to change to red.

Is it possible to do this automatically? If yes, how?

Any advice would be greatly appreciated. Thanks,

--
Christa
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This isn't possible in the tables themselves. Tables are basically just
buckets to hold your data. You shouldn't routinely be making entries
directly into the tables. Instead, you should be using forms for data entry.
On a form, you could use Conditional Formatting on the controls to change
the color as desired.

As far as checking the field in the other tables, you could do this
automatically through code. However, the real question is whether or not you
need those fields. Instead, there should be a relationship between those
tables and the table that you enter the date into. Once you have that, you
could use a query to access both tables at once and filter the query on the
records that have a date in the No Longer Managed field.

--
Wayne Morgan
MS Access MVP
"Christa Waggett" <3w****@ispdr.net.au> wrote in message
news:11**************@stitch.ispdr.net.au...
Hi, I'm not a programmer but would appreciate some help with the
following.
I've been looking at various sites but cannot find the information I
require.

I have a table of strata plans and if we no longer manage the plan the
date
this occurs gets entered into a field. What I would like to happen is for
all the fields in that record to change their forecolor to red as soon as
the DateLost field is no longer null.

I also have several related tables which have a tick box in them to say we
no longer manager the plan. At the same time that the above occurs I
would
like to update the related tables by having the tick box field entered and
the forecolors of these records also to change to red.

Is it possible to do this automatically? If yes, how?

Any advice would be greatly appreciated. Thanks,

--
Christa

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.