(Msg. 1) Posted: Wed Jul 23, 2008 8:12 am
Post subject: Lookup fields suddenly not visible Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Wed Jul 23, 2008 9:27 am
Post subject: RE: Lookup fields suddenly not visible [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Wed Jul 23, 2008 11:12 am
Post subject: RE: Lookup fields suddenly not visible [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 4) Posted: Wed Jul 23, 2008 12:19 pm
Post subject: RE: Lookup fields suddenly not visible [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 5) Posted: Wed Jul 23, 2008 1:09 pm
Post subject: RE: Lookup fields suddenly not visible [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other