By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Picklist w/Snaking Columns? (Access 2k)

P: n/a
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....ideally, 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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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....fields as needed?
--
PeteCresswell
Nov 13 '05 #2

P: n/a
(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....fields 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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
(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
Nov 13 '05 #5

P: n/a
Per (Pete Cresswell):
I'll give it a try right now.


Bingo!....

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

Thanks.
--
PeteCresswell
Nov 13 '05 #6

P: n/a
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
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.