Picklist w/Snaking Columns? (Access 2k)

[(Pete Cresswell)]

I've got a situation where the user is expanding nodes in a TreeView and below a
certain level, the child nodes become too numerous for them to deal with easily
on a straight-up sequential list.

What I'd like to do is populate a subform next to the tree view with the child
items presented in a denser format.

One essential feature of that presentation would be that individual items have
to be clickable - i.e. the user doubleclicks on an item and I make something
happen....

I'm thinking a series of snaking columns....idea lly, responsive to window size -
more columns if the user has the window sized wide, fewer columns if the window
is narrow.

Any way to do this in Access 2000? A report masquerading as a picklist, maybe?
--
PeteCresswell

[(Pete Cresswell)]

Per (Pete Cresswell):

Any way to do this in Access 2000? A report masquerading as a picklist, maybe?

I retract the "report" comment....dumb idea, since reports don't have click
events.

How about a subform whose text boxes are dynamically populated - or even
dynamically created....or maybe a compromise move where the off-the-shelf
subform has txtGeneric001 thru txtGeneric100 already in place and the calling
routine creates more txtGeneric....f ields as needed?
--
PeteCresswell

[Rick Brandt]

(Pete Cresswell) wrote:

Per (Pete Cresswell):

Any way to do this in Access 2000? A report masquerading as a
picklist, maybe?

I retract the "report" comment....dumb idea, since reports don't have
click events.

How about a subform whose text boxes are dynamically populated - or
even dynamically created....or maybe a compromise move where the
off-the-shelf subform has txtGeneric001 thru txtGeneric100 already in
place and the calling routine creates more txtGeneric....f ields as
needed?

Wouldn't a ListView provide this? I prefer not to use ActiveX controls myself,
but I believe that is the only control that supports what you're looking for.
This is essentially what the db window uses I believe.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[(Pete Cresswell)]

Per Rick Brandt:

Wouldn't a ListView provide this? I prefer not to use ActiveX controls myself,
but I believe that is the only control that supports what you're looking for.
This is essentially what the db window uses I believe.

Hadn't heard of such a control. I'll give it a try right now.
The dynamic textbox idea seems tb flawed in that I'd have to also dynamically
add event coding - and that doesn't sound like something doable w/in Access to
me.
--
PeteCresswell

[Bas Cost Budde]

(Pete Cresswell) wrote:

The dynamic textbox idea seems tb flawed in that I'd have to also dynamically
add event coding - and that doesn't sound like something doable w/in Access to
me.

It is possible to add controls to a form (when it is in design view, but
you can hide that fact from the user using docmd.echo false) and you can
have any property to those controls, including event coding. I did it,
(if I understand your statement).

If you can't get satisfactory results with the ListView (which I'm going
to examine again too), you can check whether MultiList and LiveAdd from
my site can help you in the direction of dynamic controls.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[(Pete Cresswell)]

Per (Pete Cresswell):

I'll give it a try right now.

Bingo!....

..View=2 does the trick and .SelectedItem.T ext/.Tag returns the data.

Thanks.
--
PeteCresswell

[(Pete Cresswell)]

Per Bas Cost Budde:

If you can't get satisfactory results with the ListView ...

It's working pretty well so far. I've got my initial requirment met: i.e. a
clickable list that'll give me a recordID and a record type.

Next thing will be a multi-select picklist with checkboxes as the selection
vehicle. Haven't seen anything explicit yet, but I'm pretty sure I remember
reading a reference to checkboxes in the context of a ListView.

--
PeteCresswell