Link to home
Start Free TrialLog in
Avatar of Mudasir Noorani
Mudasir NooraniFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Click Feature To Allow Click and Drag

Hello Experts,

One of my potential clients wants a feature in Access that will allow him to Click and Drag records represented by a Grid - like a Flex Grid or Data Grid - into an order of his choice. Then, that order should be saved the way it is and the records can then be printed.

The feature should be something like the Tab Order dialog box that one gets when a Form is in Design View and from the View Menu the Tab Order option is selected. You know how a user can Click and Drag the Custom Order area to re-arrange the order in which the control's selection wll flow? A similar kind of feature is required but with a Grid (Flex Grid or Data Grid) bound to a table so that the underlying records can be arranged using Click and Drag and then that order can be saved.

Any suggestion will be highly appreciated.

Many Thanks,

ref-IT
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mudasir Noorani

ASKER

Hey DatabaseMX,

Thanks a lot for the Link.

I've downloaded the zip file and installed the software. Its late here. I'll check it out further tomorrow and get back to you asap.

ref-IT
Hello DatabaseMX,

Will the In-House License ($35.95) give me access to the source code? I suppose some compromises can be made, however, I'll need access to the source code so that I can understand what the code does and then tailor that to the current scenario.

Regards,

ref-IT
"Will the In-House License ($35.95) give me access to the source code?"
Yes ... for sure.  But, it's pretty complex ... so be careful.  I suggest not changing it, because Peter come out with new versions frequently .... but that's your call.

It's seriously cool.  Be sure to check out the Listbox Reordering demo.  I put that to good use!

mx
Hey DatabaseMX,

Thanks alot for the lead - It has helped me broaden my VBA scenario and provide a valid option for my client.

Thanks alot again.

With Regards,

ref-IT