by Elias Barbosa (9 Submissions)
Category: Custom Controls/Forms/Menus
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(46 Votes)
Let's say, for example, that you have a database with all your clients. Now, you want to select just a few of them and get all the information stored on the database about them. The ideal interface to solve this problem would be to have a List Box with all your clients on one side and an empty List Box on the other side. You could, then, select the clients that you wanted just by double-clicking on their name. The selected clients would move to the empty List Box. When you finished with the selections, you would be able to access a Recordset with only the clients that you selected!
____________________________________________________ Sounds good? Well, this ActiveX Control does just that!
____________________________________________________ >> If you ever tried to create an interface using two List Boxes you will truly appreciate this Control. Here is a list of the main features:
____________________________________________________ * It will connect to a password protected Database.
____________________________________________________ * The users can navigate on the Control with their keyboard.
____________________________________________________ * It will list the records according to the specified field.
____________________________________________________ * The users can select multiple items.
____________________________________________________ * A Recordset will be generated with the selected clients!
____________________________________________________ >> I worked as hard on the user interface as I did on the programmer interface. The Property Pages are very useful!
____________________________________________________ * You will be able to browse to the folder were your Database is!
____________________________________________________ * As soon as you provide a database name, the Property Page will list all Tables on a Combo Box so you can easily select a Table!
____________________________________________________ * As soon as you select the Table, the Property Page will list all the Fields from this Table on Combo Boxes so you can easily pick one Field according to the situation!
____________________________________________________ >> What you can learn from this submission:
____________________________________________________ * How to connect to a Database, a Recordset, a Table or a Query Definition.
____________________________________________________ * How to create a temporary Query Definition.
____________________________________________________ * How to create a SQL statement.
____________________________________________________ * How to sort a Recordset.
____________________________________________________ * How to list all Tables found on a Database and all Fields found on a Table!
____________________________________________________ * How to find out if a Field is a Primary Key or if it is a numeric Field!
____________________________________________________ * How to sort an array on numeric order using the "bucket sort" algorithm.
____________________________________________________ * How to sort a "two dimensional" array on alphabetical order using the "Bubble" algorithm.
____________________________________________________ * How to find the width of a string in Twips or Pixels!
____________________________________________________ * How to add a horizontal Scroll Bar to a List Box and how to find out if a List Box needs a horizontal Scroll Bar!
____________________________________________________ * This ActiveX Control comes with a nice Common Dialog Box Module!
____________________________________________________ This ActiveX Control does a few tasks that, at first glance, look very simple. However, it took me almost a month to finish it. So, please, give me your vote and post some comments. There are literally dozens of reasons to download this ActiveX Control! Go ahead and do so!!
No comments have been posted about a(UPDATED July 23) A Two List Boxes ActiveX Control It's original, useful and very instructive. Why not be the first to post a comment about a(UPDATED July 23) A Two List Boxes ActiveX Control It's original, useful and very instructive.
VBcoders
