How to create list bar like outlook interface in Access 2k/XP?

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I guess I have to use list bar Active X control. However,
it seems most of those Active X controls are created for
VB, not VBA in Access. I don't know how to use them in
Access. I tried Gravity Box List bar and Mabry List bar,
no luck.
 
What are the features of the listbar that you require?
In many cases, a listbox or subform can be made to serve that purpose.

HTH
- Turtle
 
I would like use it to be the main user interface, just
like Microsoft outlook. I think I find a ActiveX that
supports this in Access: Janus GridEX 2000 and Button bar.

http://www.componentsource.com/catalog.asp?
fl=&bc=&sc=CS&PO=510225&option=5389&bhcp=1

That's what I want. It's just too expensive. You
mentioned using listbox and subform. It might be a good
idea. I will give it a try. Do you have more information
or examples about how to do it using list box and
subform? Thanks.

Frank
 
I'm just thinking about the bar on the left of Outlook which has a number of
different options.
Capture the click of the listbox or subform to tell you which item has been
selected, and write appropriate code to do what you want it to.

HTH
- Turtle
 
I don't know how to add a command button or an icon into
a list box for clicking and load content into a subform.
Besides, how can I make the tab to hide and activate
different list box like that in outlook.

Frank
 
Why not just place a few buttons/icons on the left side of the form.

The right side of the screen can be a sub-form. When you select, or click on
one of those nice looking icons/buttons on the left side, then you set what
form will display on the right side.

Remember, a sub-form control is just a control, and not actually a form. You
can thus EASILY set what form will display for the that sub-form control.

So, the click code for each option on the left side would look like:

me.MySubFormContorl.SourceObject = "frmCustomers"

If think about the above design...you will get almost an identical setup to
what outlook has, and you don't need any special controls at all. In fact,
if you make the left side a sub-form, you would even have a nice scroll bar
if you have more then a few icons that fit on a screen.

I see no need at all to use any special controls...but..just use
sub-forms...
 
This is why I started by asking what features you require.

If you just need a vertical column of objects you can click on, either a
listbox or a subform can be used.
I don't think you can load command buttons or icons into a listbox.

You could create a table with the icons you desire, and make a subform to
display them.

Do you really need to change what's in the subform's header and/or footer as
you scroll up and down?
If so, you might want to go looking for funding for the control you'd really
like.
If you want to build your own, you'll find it not too difficult to provide
some of the functionality of the Outlook bar, but probably more and more
challenging as you try to duplicate all of its features.

HTH
- Turtle
 
Back
Top