Hi Kevin and Penta,

Just to avoid any confusion, Penta is working with the DataCombo ocx control in the Microsoft DataList Controls dll and the ADO Data Control in the Microsoft ADO Data Control dll. I’m just working with the plain old, vanilla, intrinsic combo box control (no data-binding included).

Also, there is no way to increase the default 8 item drop-down display, and VB6 has no concept of a “continuous form”. Standard alternative is a list box control (which I prefer even in Access anyway).

HTH,

Bob

Bob,
I think I see what you're saying. Instead of having a continuous form, set up a listbox that is preloaded with possible selections, and making it a multi-select list, so after they choose their entries, you programatically go through the selected items.

Am I on the right track?

Thanks again,

Kevin

dartcoach

Hi Kevin,

That's the idea, though the Multi-Select functionality is optional.

I generally display lists of data (search results, etc.) in read-only list boxes (ListViews and ArrayLists in .NET). Don't like the idea of displaying multiple, editable records. Double-clicking a record in the list box opens a second form with the records data displayed in editable controls. This is one spot where object-oriented programming is really handy. Double-clicking a record in the list control instantiates, say, a Cutomer object from a Customer class, and the record's field values are stored in the Customer objects "fields" (i.e., property variables). Then just pass the Customer object to the data editing form, and read the object's property values back into the form's editable controls. When your done editing the record, pass the updated object to a data access routine, assign the object property values to an ADO Command objects parameters collection, and update your database. The tried and true 3-tier app. Only way to go.

You can do the exact same thing with Access and VBA.

HTH,

Bob

Hi all,
John Connell, "Beginning Visual Basic 6 Database Programming", wrox, is the book
that will learn u to work with VB6.
My combobox is not limited to 8 item drop down list.
Rgds
P

Bob & Penta,

Thanks for your help. I've got the listbox working for multi-select. I've also got the buttons working to open a new form.

One more question though - once the user has selected 1 or more from the listbox, how do I identify, programmatically, which ones were selected? I'm trying to use a loop through the list, that works fine, but I can't find the identifier that says that particular item was selected.

All your help is appreciated. (I will be buying the book, next payday)

Thanks again,

Kevin

dartcoach

Bob & Penta,

Figured it out. I was having problems with the syntax.

Just to let you know what I'm trying to do:

I've got an application that I wrote completely in Access and VBA. I'm trying to convert it to VB6 with Access as the backend.

Problem:
One of the things I do in the Access app is to dynamically create a form based on user input, then open it for more user input. Since VB is compiled, is there a way to do this? The reason is that Access limits the form size to 22", and I need more space.

Why, you ask? I run a dart tournament every week. The form I'm creating is the tournament bracket. Since each week I might have anywhere from 16 players to 50 players (maybe even more), I need the bracket to be dynamic, and if there are a lot of players, 22" isn't big enough.

Does this all make sense to you?

Thanks again for all your help.

Kevin

dartcoach

Hi Kevin,

The height and width properties of VB6 forms are system dependent. I'm not positive about this, but I've never seen a VB6 form that you can scroll beyond the bounds of its parent container, like you can in Access applications. Access is an MDI (multi-document interface) app that allows you to create child MDI forms that are slightly larger than the parent MDI container. So the child form can "scroll off the screen" a bit. I created a simple VB6 MDI parent form and opened a child form in it, but the child form’s max width seems constrained to the max width of the parent container form, which in turn is system dependent.

VB6 form width and height properties are given in twips, and the widest form I can generate on my system is 14.5” (21000 twips/1440 twips).

‘Bout the best I have to offer,

Bob

Bob,
Thanks for the response (on Sunday, no less!).

Can I create a form that has vertical scroll bars? I've added a scroll bar, but don't know how to make it work.

Thanks again,

Kevin

dartcoach

Kevin,

This looks like some really promising unexplored territory for me. I'm going to throw the project together just for sport, and we can compare notes:

http://www.vbexplorer.com/VBExplorer/tips/src26.asp

Bob

Cool...no need to throw it together. There is a VB6 download at the bottom of the link. Works perfectly and looks like its exactly what you need.

Bob