467,225 Members | 1,364 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,225 developers. It's quick & easy.

Databound Combo Box Not Displaying Entries

I am using VB 6. I have a databound combo box which links to an Oracle
database through an Access .MDB. The Access is version 2003 (11.6566.8122) SP2. The combo box is a Microsoft control - not third party.

When I run the program on my (development) computer the combo box gets
loaded and displays the entries when I click on the down arrow, as it
normally would. It works both in the IDE and when run from the compiled .exe.

When it is run on a user's computer it just displays an
empty dropdown area, no entries. There is only one user. She has the same
version of Access.

What kind of things should I look for? What kinds of things that are different between our two computers?
--
Thanks for all help
Aug 14 '07 #1
  • viewed: 1272
Share:
3 Replies
I am using VB 6. I have a databound combo box which links to an Oracle
database through an Access .MDB. The Access is version 2003 (11.6566.8122) SP2. The combo box is a Microsoft control - not third party.

When I run the program on my (development) computer the combo box gets
loaded and displays the entries when I click on the down arrow, as it
normally would. It works both in the IDE and when run from the compiled .exe.

When it is run on a user's computer it just displays an
empty dropdown area, no entries. There is only one user. She has the same
version of Access.

What kind of things should I look for? What kinds of things that are different between our two computers?
--
Thanks for all help
Hey -

Maybe you should want to read all entries from your database and add those record to you combo box via .addItem method.

You may have bind your combo box to a field, but you really want to add all entries of that field to your combo box. so that, when you click its dropdown, it will list all records of the certain field fetched from your database. However, you just bind it, and that explains why there is only one entry in your combo box.
Aug 15 '07 #2
Hey -

Maybe you should want to read all entries from your database and add those record to you combo box via .addItem method.

You may have bind your combo box to a field, but you really want to add all entries of that field to your combo box. so that, when you click its dropdown, it will list all records of the certain field fetched from your database. However, you just bind it, and that explains why there is only one entry in your combo box.
Thanks for your information, however:

I may ultimately end up using the workaround of using .additem, but that does not explain why it works on my (developer) PC but not on the only user's PC. As I understand it, using a databound control is much faster than using .additem.

Actually, not even one entry shows up.

I am wondering what I should look at as different between my PC and the user's PC.
Aug 15 '07 #3
Thanks for your information, however:

I may ultimately end up using the workaround of using .additem, but that does not explain why it works on my (developer) PC but not on the only user's PC. As I understand it, using a databound control is much faster than using .additem.

Actually, not even one entry shows up.

I am wondering what I should look at as different between my PC and the user's PC.
Oh really? Well, I can't figure out why it happens... Maybe it has something to do with OCX, system files, etc...

Does anybody want to explain this?
Aug 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Stephen Poley | last post: by
3 posts views Thread by boss0021 | last post: by
3 posts views Thread by beconrad | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.