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
|
|||
|
|||
Lookup fields suddenly not visible
I have been using an Access 2002-3 accounting ledger database that I set up 3
years ago. It has always worked great, with pull down menus for Vendors, accounts, sub accounts, etc. In the last month I have suddenly been unable to see or use the pull down (Lookup) fields for Vendors. They are there, because you can drag down a list, however, I cannot see the text until I have chosen one, and I can no longer start typing names for it to jump to that name on the list. Anyone else have this problem or have any clue as to why this might suddenly happen? Is a security upgrade conflict? Something else? Any and all help will be appreciated, because I have even tried to rebuild from scratch and it will work right for a minute, then it will go away again. Rich Uhrick |
#2
|
|||
|
|||
Lookup fields suddenly not visible
Not that I'll know the answer either way, but there is a big piece of
informaiton that you left out. Are you using the embedded-in-table-design dropdowns or are you creating them yourself from tables? Fred "Rich Uhrick" wrote: I have been using an Access 2002-3 accounting ledger database that I set up 3 years ago. It has always worked great, with pull down menus for Vendors, accounts, sub accounts, etc. In the last month I have suddenly been unable to see or use the pull down (Lookup) fields for Vendors. They are there, because you can drag down a list, however, I cannot see the text until I have chosen one, and I can no longer start typing names for it to jump to that name on the list. Anyone else have this problem or have any clue as to why this might suddenly happen? Is a security upgrade conflict? Something else? Any and all help will be appreciated, because I have even tried to rebuild from scratch and it will work right for a minute, then it will go away again. Rich Uhrick |
#3
|
|||
|
|||
Lookup fields suddenly not visible
Well, I put them in the primary "Transactions" table to pull up info from
other tables. The really odd part is it only seems to affect the Vendors table. (naturally the one that gets edited most often and has the most information). Rich "Fred" wrote: Not that I'll know the answer either way, but there is a big piece of informaiton that you left out. Are you using the embedded-in-table-design dropdowns or are you creating them yourself from tables? Fred "Rich Uhrick" wrote: I have been using an Access 2002-3 accounting ledger database that I set up 3 years ago. It has always worked great, with pull down menus for Vendors, accounts, sub accounts, etc. In the last month I have suddenly been unable to see or use the pull down (Lookup) fields for Vendors. They are there, because you can drag down a list, however, I cannot see the text until I have chosen one, and I can no longer start typing names for it to jump to that name on the list. Anyone else have this problem or have any clue as to why this might suddenly happen? Is a security upgrade conflict? Something else? Any and all help will be appreciated, because I have even tried to rebuild from scratch and it will work right for a minute, then it will go away again. Rich Uhrick |
#4
|
|||
|
|||
Lookup fields suddenly not visible
Rich,
I do 90% of my dropdowns the way you do them....in the table structure itself. The experts say to not do it that way, that there are too many too many problems / pitfalls with this method, and to use combo boxes etc. in the forms to create dropdown functionality. That might be their answer on your problem. If your problem only shows up on a form, you might try deleting and recreating the box. "Rich Uhrick" wrote: Well, I put them in the primary "Transactions" table to pull up info from other tables. The really odd part is it only seems to affect the Vendors table. (naturally the one that gets edited most often and has the most information). Rich "Fred" wrote: Not that I'll know the answer either way, but there is a big piece of informaiton that you left out. Are you using the embedded-in-table-design dropdowns or are you creating them yourself from tables? Fred "Rich Uhrick" wrote: I have been using an Access 2002-3 accounting ledger database that I set up 3 years ago. It has always worked great, with pull down menus for Vendors, accounts, sub accounts, etc. In the last month I have suddenly been unable to see or use the pull down (Lookup) fields for Vendors. They are there, because you can drag down a list, however, I cannot see the text until I have chosen one, and I can no longer start typing names for it to jump to that name on the list. Anyone else have this problem or have any clue as to why this might suddenly happen? Is a security upgrade conflict? Something else? Any and all help will be appreciated, because I have even tried to rebuild from scratch and it will work right for a minute, then it will go away again. Rich Uhrick |
#5
|
|||
|
|||
Lookup fields suddenly not visible
Did you by any chance recently install Office 2003 SP3?
It has caused some problems with combo boxes, but I don't remember exactly what they were. If you did install SP3, you also need to install the hotfix that fixes what SP3 broke. The link is http://support.microsoft.com/kb/945674 If this is not the problem, you may be having some corruption issues and need to take care of those. -- Dave Hargis, Microsoft Access MVP "Rich Uhrick" wrote: I have been using an Access 2002-3 accounting ledger database that I set up 3 years ago. It has always worked great, with pull down menus for Vendors, accounts, sub accounts, etc. In the last month I have suddenly been unable to see or use the pull down (Lookup) fields for Vendors. They are there, because you can drag down a list, however, I cannot see the text until I have chosen one, and I can no longer start typing names for it to jump to that name on the list. Anyone else have this problem or have any clue as to why this might suddenly happen? Is a security upgrade conflict? Something else? Any and all help will be appreciated, because I have even tried to rebuild from scratch and it will work right for a minute, then it will go away again. Rich Uhrick |
Thread Tools | |
Display Modes | |
|
|