Channel: Computer Learning Zone

Category: Education

Tags: #tutorial#msaccessms accesshow to sort in a form in accessorderbyorderbyonclick to sort#microsoftaccess#howto#lessonclick field header to sort access#trainingmicrosoft accessorder byclick on column header#help#database#learnorder by onon click eventms access tutorialsort by column

Description: In this video, I'm going to teach you how to create a one-click method to sort by a specific field (column) in your Microsoft Access continuous forms. Bernie form St. John's, Newfoundland (a Platinum Member) asks: I know you can sort the records in a form by right-clicking on the field and selecting a sort option, but that's a pain. Is there an easier, faster way to just, say, click on the column header and sort by that column? My accounting software works this way and I would love it if Access did, too. Silver Members and up get access to an Extended Cut of this video. Members will take this up a notch. We will make one click to sort ascending (A to Z) and a second click will sort descending. We will also change the color of the column header label to blue if it's sorted ascending, and red if descending. MEMBERS VIDEO: youtu.be/hJ4mN-ofL-g BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/ClickToSort SUGGESTED COURSE: Search Seminar: 599cd.com/SearchSeminar LINKS: Intro to VBA: 599cd.com/VBA OnClick Event: 599cd.com/OnClick Access Developer 1: 599cd.com/ACD1 OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: 599cd.com/THFree Blank Template: 599cd.com/Blank Contact Management: 599cd.com/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: 599cd.com/TipJar Get on my Mailing List: 599cd.com/YTML Contact Me: 599cd.com/Contact TechHelp: 599cd.com/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, click to sort, How to sort in a form in Access, orderby, orderbyon, Click field header to sort Access, order by, order by on, sort by column, click on column header, on click event QUESTIONS: Please feel free to post your questions or comments below. Thanks.