[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Click Feature To Allow Click and Drag

Posted on 2011-05-02
6
Medium Priority
?
261 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:ref-IT
  • 3
  • 3
6 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 35506915
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
 
LVL 2

Author Comment

by:ref-IT
ID: 35508389
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
 
LVL 2

Author Comment

by:ref-IT
ID: 35514179
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75
ID: 35515406
"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
 
LVL 2

Author Closing Comment

by:ref-IT
ID: 35688881
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
 
LVL 75
ID: 35691273
You are welcome ...

mx
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question