User-Sequencable List Control?

[PeteCresswell]

Anybody seen such a thing?

My guys want to build a list of mutual funds to drive a report, but
they want to be able to sequence the funds on the list so that I can
determine what sequence they should appear on the report in.

I'm thinking something like the many drag/drop lists already out there
in various applications. I'm getting a little glimmer than maybe the
plain-vanilla heirarchical tree view supports something like that...

Anybody know of anything?

[Tom van Stiphout]

On Tue, 04 Oct 2005 13:33:51 -0400, PeteCresswell <[e-mail]>
wrote:

I don't know of a control that can do this, but you could simulate one
using a listbox or subform, with an Up and Down button next to it to
"move" the selected item.

-Tom.

Anybody seen such a thing?

My guys want to build a list of mutual funds to drive a report, but
they want to be able to sequence the funds on the list so that I can
determine what sequence they should appear on the report in.

I'm thinking something like the many drag/drop lists already out there
in various applications. I'm getting a little glimmer than maybe the
plain-vanilla heirarchical tree view supports something like that...

Anybody know of anything?

[(PeteCresswell)]

Per Tom van Stiphout:

I don't know of a control that can do this, but you could simulate one
using a listbox or subform, with an Up and Down button next to it to
"move" the selected item.

Time's running out, and I think that is what I will do. Native MS Access
controls seem really weak on Drag/Drop events.
--
PeteCresswell

[(PeteCresswell)]

Per Tom van Stiphout:

Up and Down button next to it to
"move" the selected item.

Anybody have any thoughts on the nuts and bolts behind something like this?

My knee jerk is to add a sequence field to the work table behind the list.

I would increment the sequence numbers by 2. Then, when moving a record, find
the previous rec's sequence number and add 1 to it. That would let me re-sort
the records, after which I would renumber them by 2 again and requery the list.

We're talking a subset of less than 100 records here (out of a selectable
population of about 3,200) - less than 20, in fact 95% of the time.

Given the work table is in a DB on C:\Temp, I would hope that it would run fast
enough to work UI-wise.

Any comments/suggestions before I commit the man hours finding out for sure?
--
PeteCresswell

[(PeteCresswell)]

Per (PeteCresswell):

I would increment the sequence numbers by 2. Then, when moving a record, find
the previous rec's sequence number and add 1 to it.

Oops, that was kind of dumb.... What I should have said was subtract 3 from the
target record's sequence number.
--
PeteCresswell

[Stephen Lebans]

Pete it's not easy to program but there is a native Access ListBox control
that supports Drag and Drop. See:
http://www.lebans.com/vb_listbox.htm
New Version 3 April 23, 2003 - MULTISELECT must be enabled for this version
to function properly.

Special Thanks to Peter Walker!

FieldList.zip is a database containing the FieldList control Access uses in
its Table Analyzer and Performance Analyzer Wizards. This control is created
directly from the ACCWIZ.DLL so no ActiveX registration problems are
incurred. ACCWIZ.DLL is automatically installed with all full installs of
Access.

This a VB like ListBox with:

1) CheckBoxes for each row

2) True Drag and Drop

3) Conditional Formatting for each Row

4) AddItem method
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"(PeteCresswell)" <[e-mail]> wrote in message
news:jf********************************@4ax.com...

Per Tom van Stiphout:

I don't know of a control that can do this, but you could simulate one
using a listbox or subform, with an Up and Down button next to it to
"move" the selected item.

Time's running out, and I think that is what I will do. Native MS Access
controls seem really weak on Drag/Drop events.
--
PeteCresswell