If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I make fields change colors to alert something?
I have been asked to create a database based on a control sheet which tracks
when visits are due, past due or need follow-up. Right now they maintain it on an Excel spreadsheet and use color coding to let them know when visits are due and such. Is there anyway to do this with the database as well? Please be as detailed as possible when replying. Thanks! |
#2
|
|||
|
|||
How do I make fields change colors to alert something?
"artemis1027" wrote in message
: I have been asked to create a database based on a control sheet which tracks when visits are due, past due or need follow-up. Right now they maintain it on an Excel spreadsheet and use color coding to let them know when visits are due and such. Is there anyway to do this with the database as well? Please be as detailed as possible when replying. Thanks! In a continuous form, or datasheet, you can use conditional formatting (format menu), which is quite close to how it is done in Excel. This requires 2000 version or later. You are limited to three conditions, which I think is the same as Excel. For single forms, you can also set backcolor etc on controls programatically (perhaps using the on current event) in stead of conditional formatting. -- Roy-Vidar |
#3
|
|||
|
|||
How do I make fields change colors to alert something?
Have you checked out conditional formatting?
artemis1027 wrote: I have been asked to create a database based on a control sheet which tracks when visits are due, past due or need follow-up. Right now they maintain it on an Excel spreadsheet and use color coding to let them know when visits are due and such. Is there anyway to do this with the database as well? Please be as detailed as possible when replying. Thanks! |
#4
|
|||
|
|||
How do I make fields change colors to alert something?
I have, but unfortunately the training my company sent me to did not cover
conditional formatting. If I have a field that says a monitoring visit was done today, how would I get it to turn blue in 30 days? Can that be done? And then if it goes past 30 days, can it turn red? "Jeff L" wrote: Have you checked out conditional formatting? artemis1027 wrote: I have been asked to create a database based on a control sheet which tracks when visits are due, past due or need follow-up. Right now they maintain it on an Excel spreadsheet and use color coding to let them know when visits are due and such. Is there anyway to do this with the database as well? Please be as detailed as possible when replying. Thanks! |
#5
|
|||
|
|||
How do I make fields change colors to alert something?
You can have up to 3 conditions. Select the field you want to have
conditional formatting on. Click Format, Conditional Formatting in the menu. You will see a window open. The conditions you would use a DateDiff("d", [YourDateField], Date()) = 30 DateDiff("d", [YourDateField], Date()) 30 For each condition, select what you want to do...ie change the background to blue or red. There is an icon that looks like a bucket that you use to chage the background color. Hope that helps! artemis1027 wrote: I have, but unfortunately the training my company sent me to did not cover conditional formatting. If I have a field that says a monitoring visit was done today, how would I get it to turn blue in 30 days? Can that be done? And then if it goes past 30 days, can it turn red? "Jeff L" wrote: Have you checked out conditional formatting? artemis1027 wrote: I have been asked to create a database based on a control sheet which tracks when visits are due, past due or need follow-up. Right now they maintain it on an Excel spreadsheet and use color coding to let them know when visits are due and such. Is there anyway to do this with the database as well? Please be as detailed as possible when replying. Thanks! |
Thread Tools | |
Display Modes | |
|
|