[AccessD] OT VB6 Combo Box Problem

If you are using VB 6, it's help files are the MSDN.  VB 6.0 (service pack
3) comes with a 2 disc MSDN.  I personally have Microsoft Office 2000
Developer's Edition, which comes with a three disc MSDN.  Just a useful tip
(because I found that some developers did not realize this), but when you
are installing the MSDN, be sure to put a check mark on 'Put an Icon on my
desktop'.  You can then drag that icon to your quick launch tray, and you'll
never have to hit the help from within VB again.

Anyhow, I personally don't use 'bound' data objects in VB.  VB is meant to
be a light weight front end, so I try to keep it that way.  Combo boxes in
VB are different from Access combos, especially in how they can be
populated.  In VB, a combos have a .Add (or AddItem....sorry a little slow
today) method, which lets you add items on the fly.  You can also remove
items on the fly.  For quite some time, I was really irked when going back
and forth between Access and VB, because Access doesn't have that method.
(To use that method with a data source, just open the recordset, then run
through each item with a do until rs.EOF=True loop.  Quick and easy...and
then your combo is populated without hanging onto the database too.)  Much
later, I found out about the callback function capability in Access, so now
I like both versions, in fact I like the callback function a little better.

Drew

-----Original Message-----
From: Ryan Smethurst [mailto:RSmethurst at UxbridgeCollege.ac.uk]
Sent: Tuesday, July 15, 2003 6:37 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] OT VB6 Combo Box Problem


Hi Group,

Trying to build a small VB6 app (my first), and am having some trouble
getting the combo boxes I drop on the form to populate with data.  I'm
either getting one entry in the list or an error : Unable to bind to field
or data member ...

Can anyone point me in the right direction, or maybe let me know where I can
get some info re: combo boxes in VB 6.

Thanks in advance.

RyanS




The information or opinions in this message (including
any attachments) are those of the author and are not 
necessarily those of Uxbridge College, which disclaims
responsibility for loss or damage arising from its use to
the maximum extent permitted by law. E-mail messages
sometimes go astray. This message is sent in
confidence for the addressee only. It may contain
confidential or sensitive information. The contents
are not to be disclosed to anyone other than the
addressee. Unauthorised recipients are requested to
preserve this confidentiality and to advise the originator.
immediately and to delete the message without copying,
altering or disclosing its contents. E-mails to or from
Uxbridge College may be monitored by the College in
accordance with its current policy.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com