Welcome

In Developer 14 we started building the Easy Access POS, a complete Point of Sale system built in Microsoft Access. In order to continue, however, we have to take some time learning List Boxes, especially Multi-Select List Boxes. So, that's where Developer 15 is going to start. We'll also spend some time covering more advanced Debugging.

Resources

Topics Covered

In Lesson 1 we will begin by reviewing some things about list boxes, see how to move items between two different list boxes, and learn how to pass a control as a parameter to a subroutine or function. Instead of just passing values, we can pass entire controls.

In Lesson 2 we are going to cover Debugging in more depth. I've covered things line "on error resume next" in previous lessons, which I'd consider "Level 1" debugging. In this lesson we're going to learn how to trap errors, display custom error messages, use the Immediate window, set watches, breakpoints, create our own Status Box, and more.

In Lesson 3 we are finally getting to multi-select list boxes. We're going to take the two normal list boxes we created in the last two lessons, make them multi-select, and the learn about how to read and set the selected items.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions?

Please feel free to post your questions or comments below. Thanks.

Any Questions? Post them NOW! Upload Images Link
Richard Rost
14 months ago

Anything and everything you ever wanted to know about List Boxes will be in this lesson, so if you have any special requests, post them below! I'm preparing my outline for D15 today.

John Morrissey
14 months ago

Have combo box(es) with a list of items plus the All option update the row source of the list box as an item is selected from the combo box. Have the ability to sort the combo box and also ignore items no longer available. Is it possible to select more than one item in the combo box like it is in a listbox?

Richard Rost
14 months ago

Combo boxes and list boxes are very similar, but they do have some major differences. For example, there is no such thing as a multi-select COMBO box. You can only pick one item. However a combo box does give you the ability to type in your own values (if you choose to allow that). And ALL ALL option might be nice for the food options list box, however if we have things like "cook medium" and "cook well done" on there, it might be pointless. I'll think about that one. List box sorting is easy and we'll cover that. Items no longer available will definitely be covered (I mentioned that in D14). You've got my Search Seminar. Some of this was covered in that.

Show 1 More Reply...