troubleshooting Question

Record re-order by changing date/time created

Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
23 Comments1 Solution103 ViewsLast Modified:
I have a single form layout subform that moves to any record by the record navigators. They are listed by the data and time they were created (Oldest First). One of my clients wants to be able to re-order entries. (typically when some record was missed out or something needs adding in between existing records). Because the current order is date and time I could simply add a pop up form and demand an old date and time that fitted between entries in the existing list. I just wandered if there was a more user friendly approach. Something like a pop up form with a list of the records with a drag and drop feature.

Strictly speaking there is no specific reason to have a date time created field in any record. it was originally the best way I knew to ensure that records were presented in the order that they were created

Am I asking too much for drag and drop?
Join our community to see this answer!
Unlock 1 Answer and 23 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros