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
|
|||
|
|||
Colors for Field/
I need suggestions. I have created several tables. Some of my tables were
used to create forms. Some of my tables are just reference data for the forms. For instance, I have a table called the City table, which lists Cities and gives me a unique CityID. I use this CityID in my forms to indicate what City is served. I have several of these type of these reference tables. I have people helping me enter data and i want to make it easy for them to read and know where to put what. I would like to color coordinate the field from the reference table with the field in the data entry form. However, I know that you cannot color tables so, is there any other way that I could accomplish this? Also, how do I change the alignment of my cells in the tables? I would like them to be centered. Thank you |
#2
|
|||
|
|||
Colors for Field/
On Wed, 28 Jan 2009 15:10:02 -0800, Marlita
wrote: I need suggestions. I have created several tables. Some of my tables were used to create forms. Some of my tables are just reference data for the forms. For instance, I have a table called the City table, which lists Cities and gives me a unique CityID. I use this CityID in my forms to indicate what City is served. I have several of these type of these reference tables. I have people helping me enter data and i want to make it easy for them to read and know where to put what. I would like to color coordinate the field from the reference table with the field in the data entry form. However, I know that you cannot color tables so, is there any other way that I could accomplish this? Also, how do I change the alignment of my cells in the tables? I would like them to be centered. Thank you The users surely aren't opening the table in order to put in reference data, are they!? Create a very simple (forms wizard is fine) maintenance Form to enter data into your reference tables. The user need not know any tablenames, and certainly should not need to open any tables at all. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Colors for Field/
Hi John. Thank you for responding. I have created the form and they are
entering data into the form. They don't touch the tables. I printed the tables out so they could look up the cityID number for Los Angeles and enter that number into the form, if that makes sense. "John W. Vinson" wrote: On Wed, 28 Jan 2009 15:10:02 -0800, Marlita wrote: I need suggestions. I have created several tables. Some of my tables were used to create forms. Some of my tables are just reference data for the forms. For instance, I have a table called the City table, which lists Cities and gives me a unique CityID. I use this CityID in my forms to indicate what City is served. I have several of these type of these reference tables. I have people helping me enter data and i want to make it easy for them to read and know where to put what. I would like to color coordinate the field from the reference table with the field in the data entry form. However, I know that you cannot color tables so, is there any other way that I could accomplish this? Also, how do I change the alignment of my cells in the tables? I would like them to be centered. Thank you The users surely aren't opening the table in order to put in reference data, are they!? Create a very simple (forms wizard is fine) maintenance Form to enter data into your reference tables. The user need not know any tablenames, and certainly should not need to open any tables at all. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Colors for Field/
Marlita,
Why not make a combo box (CityID, CityName), hide the first column so they could just type the name but in your table would be the CityID? I guess I do't understand the color coding thing because I have about 100,000 cities in my talbe and that's alot of color coding! To center data in a field, in design mode, highlight and celect center from the toolbar. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index.htm "Marlita" wrote in message ... Hi John. Thank you for responding. I have created the form and they are entering data into the form. They don't touch the tables. I printed the tables out so they could look up the cityID number for Los Angeles and enter that number into the form, if that makes sense. "John W. Vinson" wrote: On Wed, 28 Jan 2009 15:10:02 -0800, Marlita wrote: I need suggestions. I have created several tables. Some of my tables were used to create forms. Some of my tables are just reference data for the forms. For instance, I have a table called the City table, which lists Cities and gives me a unique CityID. I use this CityID in my forms to indicate what City is served. I have several of these type of these reference tables. I have people helping me enter data and i want to make it easy for them to read and know where to put what. I would like to color coordinate the field from the reference table with the field in the data entry form. However, I know that you cannot color tables so, is there any other way that I could accomplish this? Also, how do I change the alignment of my cells in the tables? I would like them to be centered. Thank you The users surely aren't opening the table in order to put in reference data, are they!? Create a very simple (forms wizard is fine) maintenance Form to enter data into your reference tables. The user need not know any tablenames, and certainly should not need to open any tables at all. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Colors for Field/
On Wed, 28 Jan 2009 16:12:10 -0800, Marlita
wrote: I printed the tables out so they could look up the cityID number for Los Angeles and enter that number into the form, if that makes sense. Ummm... No. It doesn't. Don't make people do work that a computer can do much better! The user should never even KNOW the cityID, much less have to look it up or type it! Use the tools Access provides. You can put a "Combo Box" control on the form, bound to the CityID field in the table. This combo would be based on the City table, with the CityID as its bound column, and the city and state name as the visible columns (you do want to distinguish Las Vegas, NM from Las Vegas, NV, not to mention the forty or more Springfields). The user can simply select Los Angeles from the combo box, *by name*, and it will store the ID. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|