Is there a way to move a record in a datasheet view form with up and down arrows (command buttons)?

Is there a way to move a record in a datasheet view form with up and down arrows (command buttons)?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
Only if you have a field that can be sorted by, which you could change.

So, if for example you used a temporary table to display the data in the datasheet, and that temporary table contains a "Rank" or "SortOrder" column (or some such thing), then you could use a button to update the value of that field for the record which is currently selected and the one above of below it.  I actually do this all the time with lists.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'd also caution that you should not go against conventional UIX paradigms. Users expect the Up/Down arrows to move them up or down in the UI, not actually move a record. If you need some way to reorder records, then create an interface where users can specify that order.

If you want to do Drag-n-Drop, as you asked in your other question, then you could always use a Continuous View form, and use the stuff from Peter's Software. Continuous View forms can be made to look very much like a Datasheet form, but you get the full event model of an Access form.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
You can include a Rank or Priority field and run code as described here to move records not only up/down but anywhere on the list:

You may have to follow the links as well.

SteveL13Author Commented:
All good advice.  Thanks again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.