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
|
|||
|
|||
Can't see choices in lookup drop-down
I am creating a database that includes two tables of names, one for our
Admins and one for our Inspectors. In the other tables/forms, I am putting text boxes as lookup fields so that the user can select their name from a dropdown as they complete the various forms in the database. Except, when the down arrow is selected for the lookup, you can't see the names. The dropdown acts as if there is text there, the Admin table has 2 names and its dropdown has blank spaces for 2 names. The inspector table has 3 names and its dropdown has blank space for 3 names. When you position the cursor where the name text should be in the drop-down and left-click, the name magically appears in the text box. I used the lookup wizard to create the fields and I can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
#2
|
|||
|
|||
Can't see choices in lookup drop-down
ADDITIONAL INFO: I forgot to mention that the two tables of names consist of
only one field each, the field containing the name of the individual - first initial, last name. This single field is also the key field, if that makes any difference. The Admin table has 2 names and the Inspector's table has 3 names. Thanks. csarjeant wrote: I am creating a database that includes two tables of names, one for our Admins and one for our Inspectors. In the other tables/forms, I am putting text boxes as lookup fields so that the user can select their name from a dropdown as they complete the various forms in the database. Except, when the down arrow is selected for the lookup, you can't see the names. The dropdown acts as if there is text there, the Admin table has 2 names and its dropdown has blank spaces for 2 names. The inspector table has 3 names and its dropdown has blank space for 3 names. When you position the cursor where the name text should be in the drop-down and left-click, the name magically appears in the text box. I used the lookup wizard to create the fields and I can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
#3
|
|||
|
|||
Can't see choices in lookup drop-down
csarjeant,
Sounds like your column count is set for two and you only have one field in each table. On another note, I have to wonder about your table set up that you have two seperate tables where one table with do. tblIndividuals iFirstName iLastName iIndividualTypeID (Admin or Inspectors) -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "csarjeant via AccessMonster.com" u55302@uwe wrote in message news:9df02489808b3@uwe... I am creating a database that includes two tables of names, one for our Admins and one for our Inspectors. In the other tables/forms, I am putting text boxes as lookup fields so that the user can select their name from a dropdown as they complete the various forms in the database. Except, when the down arrow is selected for the lookup, you can't see the names. The dropdown acts as if there is text there, the Admin table has 2 names and its dropdown has blank spaces for 2 names. The inspector table has 3 names and its dropdown has blank space for 3 names. When you position the cursor where the name text should be in the drop-down and left-click, the name magically appears in the text box. I used the lookup wizard to create the fields and I can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
#4
|
|||
|
|||
Can't see choices in lookup drop-down
Forgot to mention... making the individuals name Primary Key is a bad idea.
In a large Company or a Company with a large customer base there will certainly be duplicates. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "csarjeant via AccessMonster.com" u55302@uwe wrote in message news:9df02b1d7e3da@uwe... ADDITIONAL INFO: I forgot to mention that the two tables of names consist of only one field each, the field containing the name of the individual - first initial, last name. This single field is also the key field, if that makes any difference. The Admin table has 2 names and the Inspector's table has 3 names. Thanks. csarjeant wrote: I am creating a database that includes two tables of names, one for our Admins and one for our Inspectors. In the other tables/forms, I am putting text boxes as lookup fields so that the user can select their name from a dropdown as they complete the various forms in the database. Except, when the down arrow is selected for the lookup, you can't see the names. The dropdown acts as if there is text there, the Admin table has 2 names and its dropdown has blank spaces for 2 names. The inspector table has 3 names and its dropdown has blank space for 3 names. When you position the cursor where the name text should be in the drop-down and left-click, the name magically appears in the text box. I used the lookup wizard to create the fields and I can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
#5
|
|||
|
|||
Can't see choices in lookup drop-down
Gina,
Thanks for the help. Here is what I tried: I created a single tabel as you suggested, tblQCStaff Item(Autonumber) - key field FirstName LastName JobTitle(Inspector or Admin) I still have the same problem. I noticed that when the table included the Autonumber as the key field, after the lookup wizard created the combo box, the field data type show as "number", even though I only include the FirstName and LastName in the list. I assume this is because it is storing the number from the autonumber field. When I remove the Autonumber field from the table and make LastName the key field, the field data type changes to "text" but I still can't see anything. I have been playing with this all morning and can't make any progress. Using my original table from yesterday, I changed column count to one, but it still doesn't help. Thanks, Chris Gina Whipp wrote: csarjeant, Sounds like your column count is set for two and you only have one field in each table. On another note, I have to wonder about your table set up that you have two seperate tables where one table with do. tblIndividuals iFirstName iLastName iIndividualTypeID (Admin or Inspectors) I am creating a database that includes two tables of names, one for our Admins and one for our Inspectors. In the other tables/forms, I am putting [quoted text clipped - 13 lines] can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
#6
|
|||
|
|||
Can't see choices in lookup drop-down
Please fill in the below information for your Combo Box
Control Source... Row Source Type... Rwo Source... Column Count... Column Widths... Bound Column... Then what is the name of the table you are storing this information in and the field name. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "csarjeant via AccessMonster.com" u55302@uwe wrote in message news:9dfa6e5e37875@uwe... Gina, Thanks for the help. Here is what I tried: I created a single tabel as you suggested, tblQCStaff Item(Autonumber) - key field FirstName LastName JobTitle(Inspector or Admin) I still have the same problem. I noticed that when the table included the Autonumber as the key field, after the lookup wizard created the combo box, the field data type show as "number", even though I only include the FirstName and LastName in the list. I assume this is because it is storing the number from the autonumber field. When I remove the Autonumber field from the table and make LastName the key field, the field data type changes to "text" but I still can't see anything. I have been playing with this all morning and can't make any progress. Using my original table from yesterday, I changed column count to one, but it still doesn't help. Thanks, Chris Gina Whipp wrote: csarjeant, Sounds like your column count is set for two and you only have one field in each table. On another note, I have to wonder about your table set up that you have two seperate tables where one table with do. tblIndividuals iFirstName iLastName iIndividualTypeID (Admin or Inspectors) I am creating a database that includes two tables of names, one for our Admins and one for our Inspectors. In the other tables/forms, I am putting [quoted text clipped - 13 lines] can't figure out why I can't see the text, but it acts like its there. Any help is appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200910/1 |
Thread Tools | |
Display Modes | |
|
|