Drag and Drop possible ?

[Aceware]

I have a reasonably nice scheduling screen for a client.

On the left is a subform showing a filtered list of tasks to be allocated.

On the right I have a subform with names going horizontally and dates going
vertically.
Both subforms use conditional formatting to convey a lot of additional
information
(eg on RHS - different shading on weekends, when allocated task has been
done, etc)
To allocate a task to a person on a specific date the user must:
1) click in the cell in the list of tasks to be allocated
2) click in a cell representing a person and a date
3) click on a button to make the allocation happen

A similar sort of scenario applies if we wish to pick an allocated task up
and move it to a different person or date.

The client quite likes the form already - but are asking if we can enhance
it further and use drag and drop.

Question:
I am contemplating buying a 3rd party grid control to allow drag and drop.
However, my philosophy all these years has been to try to implement the
application purely within Access (and bits of MS Office)
Can anyone point me to any examples that would allow me to implement drag
and drop purely between Access subform ?

Many thanks in advance
Tony Epton

 

[pddxxx]

Tony,

Access has nothing built-in to allow dragging and dropping between
subforms. There are some third-party tools that may help:

A trial version of a product I created called Drag-N-Dropper for
Microsoft Access is available at this web site: http://www.peterssoftware.com/dd.htm

Stephen Lebans has an example of a FieldList control that supports
drag and drop: http://www.lebans.com/vb_listbox.htm

The Forms Sample database provided by Microsoft has an example called
"Simulating Drag-And-Drop Capabilities". You can download the sample
database here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;175066

Hope this helps,