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
LVL 2
Mudasir NooraniSenior Analyst ProgrammerAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I use this in several apps:

http://www.peterssoftware.com/dd.htm

It's absolutely amazing and nothing else like it.

Download the demo and check it out.

mx
0
 
Mudasir NooraniSenior Analyst ProgrammerAuthor Commented:
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
0
 
Mudasir NooraniSenior Analyst ProgrammerAuthor Commented:
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
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
0
 
Mudasir NooraniSenior Analyst ProgrammerAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.