473,570 Members | 2,840 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Databound Combo Box Not Displaying Entries

2 New Member
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
3 1428
fplesco
82 New Member
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
Marvin B
2 New Member
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
fplesco
82 New Member
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

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

Similar topics

2
2059
by: Stephen Poley | last post by:
I have added a combo-box to a form but it frequently fails to display all entries in the table it is based on. There are 43 entries in the table; the control initially displayed only the first 12. I inserted a query between the table and combo-box; it then displayed the first 17 entries. By selecting the first few letters of the last entry I...
3
1478
by: boss0021 | last post by:
Does anyone know how to: Populate a ComboBox with all the days of the year for 2005 with out doing it manually
14
1553
by: Rowland Shaw | last post by:
I've got a databound combo (databound to a System.Data.DataTable), but some rather unpredicatable behaviour -- even though I have 8 rows in the source table, only the first 6 are showing up in the items collection. I've been scratching my head over this for a while now, but can't fathom what could be to blame for this oddity. Has anyone...
0
1004
by: Steph | last post by:
Hello, First, i'm french.... so my english isn't very good. I use the propertygrid control to edit an object that I have created (class) which represents a record of table in a database.Some properties of the object are in fact values of foreign key of other tables. I would like, instead of having an integer (key value) for value of the...
3
4142
by: beconrad | last post by:
Hi all, I am not sure if what I want to do is possible, and if it is I have not been able to figure out how to do it. This is what I would like: 1. I have a data entry form with a field called Insurance. That field uses a combo box which takes its information from query on the Insurance table. At the moment the drop down list is sorted...
0
1042
by: aaryan | last post by:
hi guys, i have got a problem while trying to use databoundcombo in my application. i have got 2 ado controls each connected to two separate tables (linked by a common column). the problem is the databound combo control is not recognising the second ado control while i try to set the data bound combo control's rowsource(after setting ...
3
3643
by: sparks | last post by:
I have a combo box that when you go to the next combo box it is filtered based on the value in the previous one. so if combo box 1 has fred as its value then combo box 2 has 1 2 3 for values. this works fine the first time thru. but later if I change combo box 1 combo box 2 list is still displaying the list form the previous value...
4
2789
by: trips | last post by:
iam reading a xml file and adding these value into combo box.The combo box now has duplicate values ,when displaying in combo box i should not display duplicate values .how do i do it?
5
2256
by: JohnRou | last post by:
I'm having a really weird problem with a combo box (drop down list) on a databound form. I load 3 values programmatically into the combo box "MALE" "FEMALE" and "UNKNOWN". When I run the app, if I tab to the combo box and type 'm' on the keyboard "MALE" shows up in the combo box, but it doesn't save when I execute my .update statement. ...
0
8151
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7702
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5523
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5247
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3684
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3671
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1238
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
974
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.