Drop down list not showing on one machine

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?

--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

I like your first thought and that has been in the back of my mind.
When I have the program open in development mode I can look at the table and
see the data but when I bring up the form that drop down list doesn't show
anything. I don't get any messages if just shows up blank.



"Klatuu" wrote:

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?

--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

the answer it your question is yes. The thing is this is just a simple list
with only a code A B C etc in it, I can have the user type the letter in and
it will take.

"Klatuu" wrote:

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?

--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

Are you using a query, or just the table?
Does this computer have issues with any other objects?
Was this just a working copy that you installed on the computer?
This is a very strange problem, but since you said you already checked the
references, I don't really know.
Have you tried a decompile and a compact and repair?
Last ditch would be to delete the control, and recreate it.
Let me know how it works out.
--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I like your first thought and that has been in the back of my mind.
When I have the program open in development mode I can look at the table and
see the data but when I bring up the form that drop down list doesn't show
anything. I don't get any messages if just shows up blank.



"Klatuu" wrote:

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?

--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

It is a query.
This isn't the only problem but the other problem is happening on other
computers also (but not all). I've reloaded the program from the server but
get the same problem. I've also reloaded the program from one of the
computers that is working fine, but still get the problem.
I have decompiled or compact and repair but I'll try that.

If I find the answer I'll let you know.
My other problem is kind of the same issue except it has to do with a menu
that the program uses. The top menu bar is setup with different options the
user can use and depending on the users login and password some of the
options are set to false so the user doesn't have the option of selecting
that option. All other menu options show up fine except for this one that
again is blank, although I do get an error message ( I don't have it here but
will get it and pass it along). Again this only happens on one of two
machines and the funny thing is that I can get it to work and it will work
for a couple of days and then it stops working again. Now you know why I
don't have any hair left.
I'll post another question when I get the error message captured.



"Klatuu" wrote:

Are you using a query, or just the table?
Does this computer have issues with any other objects?
Was this just a working copy that you installed on the computer?
This is a very strange problem, but since you said you already checked the
references, I don't really know.
Have you tried a decompile and a compact and repair?
Last ditch would be to delete the control, and recreate it.
Let me know how it works out.
--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I like your first thought and that has been in the back of my mind.
When I have the program open in development mode I can look at the table and
see the data but when I bring up the form that drop down list doesn't show
anything. I don't get any messages if just shows up blank.



"Klatuu" wrote:

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?

--
Dave Hargis, Microsoft Access MVP


"CD Tom" wrote:

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.

By any chance are you using Access 2003, and that machine is the only one
that's had SP3 applied to it?

See what Allen Browne has at
http://www.allenbrowne.com/bug-Access2003SP3.html (and follow the link to
the hot fix)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"CD Tom" wrote in message
...
I have a problem with a drop down list. The database is located on a
server
and each machine has the program loaded locally. All machines but one
work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the
program
but still will not show anything in the list, I've tried changing the
font
thinking that maybe it was to large or small, tried opening the list box
but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.