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
|
|||
|
|||
Alert inputters by colour change or to create an error Message
The users of the database need to know which staff are Restricted and be able
to enter names of nonrestricted staff. The field in the main table is called Filled By and attached as a lookup is tblRestrictedStaff and a Form created. I need the tblRestrictedStaff information to display in the Form in a different colour when the users try to input any name on the list as these staff cannot be utilized. I have tried to change the colour of the tblRestrictedStaff through Format [Red], did not work; through Format Font, does not transfer to Form;created a query in red, again colour did not tranfer to Form; changed Form colour to red hoping that the lookup list would stay black; did not work. Can the colour be changed in the Form? If not, my next solution would be to create a error message that if the user tries to enter a name in the field from the tblRestricedStaff an error message will appear. Unfortunately, I do not have a great deal of experience creating code and may require assistance. Thank you for any assistance that you can provide. |
#2
|
|||
|
|||
If these staff names are not allowed to be used, why do you include them?
"Janice W." wrote: The users of the database need to know which staff are Restricted and be able to enter names of nonrestricted staff. The field in the main table is called Filled By and attached as a lookup is tblRestrictedStaff and a Form created. I need the tblRestrictedStaff information to display in the Form in a different colour when the users try to input any name on the list as these staff cannot be utilized. I have tried to change the colour of the tblRestrictedStaff through Format [Red], did not work; through Format Font, does not transfer to Form;created a query in red, again colour did not tranfer to Form; changed Form colour to red hoping that the lookup list would stay black; did not work. Can the colour be changed in the Form? If not, my next solution would be to create a error message that if the user tries to enter a name in the field from the tblRestricedStaff an error message will appear. Unfortunately, I do not have a great deal of experience creating code and may require assistance. Thank you for any assistance that you can provide. |
#3
|
|||
|
|||
Hi,
The database being used is for a Staffing Office that provides staff to the nursing units with approximately 20 to 50 requests per day. The restricted names are agency (outside) staff that are not allowed to work in our facility. Instead of creating a separate restricted table that the users (staffing clerks) would need to access everytime they get a name from an agency, I want to incorporate the restricted names into the filled by field (where staffing clerks enter the names of the replacement staff) that would notify them immediately. Does this help? Thank you for your assistance "rowiga" wrote: If these staff names are not allowed to be used, why do you include them? "Janice W." wrote: The users of the database need to know which staff are Restricted and be able to enter names of nonrestricted staff. The field in the main table is called Filled By and attached as a lookup is tblRestrictedStaff and a Form created. I need the tblRestrictedStaff information to display in the Form in a different colour when the users try to input any name on the list as these staff cannot be utilized. I have tried to change the colour of the tblRestrictedStaff through Format [Red], did not work; through Format Font, does not transfer to Form;created a query in red, again colour did not tranfer to Form; changed Form colour to red hoping that the lookup list would stay black; did not work. Can the colour be changed in the Form? If not, my next solution would be to create a error message that if the user tries to enter a name in the field from the tblRestricedStaff an error message will appear. Unfortunately, I do not have a great deal of experience creating code and may require assistance. Thank you for any assistance that you can provide. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change the inverted selection colour when selecting a text box | Barney | Powerpoint | 5 | June 16th, 2005 01:18 AM |
Wording's Colour Change for Logic Function | Air Lancer | General Discussion | 1 | May 11th, 2005 03:56 PM |
Change Sheet Tab Colour | Jenai | General Discussion | 1 | April 22nd, 2005 06:12 PM |
Automatically, and independently, change bar colour dependanton result | Andy Pope | Charts and Charting | 0 | May 5th, 2004 09:37 AM |
cell to change colour at given date - how to | Tobit | Worksheet Functions | 2 | September 17th, 2003 12:20 PM |