How to Use 1D and 2D Arrays in MS Access VBA - Introduction

Programming for speed is usually a consideration, especially when you're developing complex applications, or application that will reside on less than ideal infrastructure. Slow networks, hard disk issues, slow user computers, and other factors often impact the user experience, resulting in horribly slow reports, drop-down loading and selection issues, and generally unhappy users. Arrays can be used in many of these cases to speed things up immensely, when applied correctly. Watch an introduction to arrays in this episode before we do more in-depth techniques in upcoming episodes. Related Videos: How to Use 1D and 2D Arrays in MS Access VBA - Introduction You are watching this video now! How to Sort Arrays in MS Access VBA Using Insertion Sort https://youtu.be/nkLZBdw5pwI For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vba https://youtu.be/KdGrvd0DMUM