Databound Combo Box Not Displaying Entries

[Marvin B]

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

[fplesco]

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.

[Marvin B]

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.

[fplesco]

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?