Turn a whole Record Row a different color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tkosel - 29 Feb 2008 20:17 GMT

I have several users who like the entire row for a record to have a different
background color from adjacent records. I have done it with conditional
formatting by setting a field value to 1 when any field in that record has
the focus. This works pretty good in a single user environment. However,
when multiple users are accessing the same recordset, records other than the
one that user has open will also meet the conditional format and be yellow.
Can anyone think of a way to turn all fields in a single record to a
different background color without affecting records on other computers?

Reply to this Message

Klatuu - 29 Feb 2008 20:35 GMT

If you have mutilpe users sharing the same copy of your application, you are
making a serious mistake. You should split your database. Put the _be.mdb
file (contains alll the tables and relationships) on a shared folder where
all users have read and write permissions. The give each user their own copy
of the front end mdb (cotains forms, macros, modules, queries, etc).

Signature

Dave Hargis, Microsoft Access MVP

> I have several users who like the entire row for a record to have a different
> background color from adjacent records. I have done it with conditional
[quoted text clipped - 4 lines]
> Can anyone think of a way to turn all fields in a single record to a
> different background color without affecting records on other computers?

Reply to this Message

tkosel - 29 Feb 2008 23:12 GMT

I was not specific enough, sorry. I do have a back end front end
configuration. However to cut down on installation issues, (Version control,
etc.) I do have all users sharing the same front end. I think that you have
answered my question in that probably the proper way to do what I want is to
have everyone use their own copy of the front end. Thanks for your input.

> If you have mutilpe users sharing the same copy of your application, you are
> making a serious mistake. You should split your database. Put the _be.mdb
[quoted text clipped - 10 lines]
> > Can anyone think of a way to turn all fields in a single record to a
> > different background color without affecting records on other computers?

Reply to this Message