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
|
|||
|
|||
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. |
#2
|
|||
|
|||
Drop down list not showing on one machine
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. |
#3
|
|||
|
|||
Drop down list not showing on one machine
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. |
#4
|
|||
|
|||
Drop down list not showing on one machine
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. |
#5
|
|||
|
|||
Drop down list not showing on one machine
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. |
#6
|
|||
|
|||
Drop down list not showing on one machine
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. |
#7
|
|||
|
|||
Drop down list not showing on one machine
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. |
Thread Tools | |
Display Modes | |
|
|