Solved

Use Combo box like MS Access 2000

Posted on 2002-05-24
3
266 Views
Last Modified: 2010-04-04
I am trying to convert from MS Access 2000 and am running into a small problem with the combo boxes in Delphi.  In access if I have an employee maintenance form and on that form is a status field that has a combo box filled with (Active, Inactive, ect.) it is set up by telling the combo box where to get it's list and the column properties and then telling it what data field on the form to be bound to.

However, I haven't found out how to duplicate this behaviour in Delphi yet.  I can get the combo box to bind to the status field correctly, but how do I get it to populate with the valid options (They are in a table) and how do I get it to display multiple columns?
0
Comment
Question by:header
  • 2
3 Comments
 
LVL 2

Expert Comment

by:freshman3k
Comment Utility
Hello!

Use a DBLookupComboBox(included with delphi). ListSource property is data source and set ListField and KeyField to the field you want to display in drop down.

or you can look on this website,they have alot of free DBLookupComboBox's with different features,Just in case the DBLookupComboBox included with delphi dosent have enough features that you want:

http://www.torry.net/db_lbcb.htm

Good Luck :-)
0
 
LVL 2

Accepted Solution

by:
freshman3k earned 100 total points
Comment Utility
Hello!

Use a DBLookupComboBox(included with delphi). ListSource property is data source and set ListField and KeyField to the field you want to display in drop down.

or you can look on this website,they have alot of free DBLookupComboBox's with different features,Just in case the DBLookupComboBox included with delphi dosent have enough features that you want:

http://www.torry.net/db_lbcb.htm

Good Luck :-)
0
 
LVL 2

Author Comment

by:header
Comment Utility
Sorry, I forgot about this question.

Thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now