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
• How to Sort Arrays in ...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #vba
• How to Use 1D and 2D A...

[@miles6875]

Sean your channel is incredibly valuable. Thank you!!

[@seanmackenziedataengineering]

Thanks for watching! cheers

[@interestingamerican3100]

Okay, half way through......MY F***ING GAWD THIS IS WHAT I NEEDED!!! F***ING EPIC DUDE!!!

[@seanmackenziedataengineering]

Awesome!! Stay tuned for more!

[@mehdibakhtiari300]

Mr. MacKenzie, did you , sir, make a follow-up video /episode for the array? I need to update 5 reports for 125 subsidiaries (from a table list) everyday.

[@seanmackenziedataengineering]

This is a good idea - I have an idea for a good solution that I've been thinking about for some time. It is on my list!

[@interestingamerican3100]

WOW, quality material! Commenting for algorithm. Subscribed and ringed the bell.

[@seanmackenziedataengineering]

Welcome aboard!

[@dbdata9836]

10/10

[@seanmackenziedataengineering]

More to come!

[@khabathawrami]

Thank you man !

[@seanmackenziedataengineering]

Welcome!

[@artistryartistry7239]

Truly awesome material!!!! Subscribed. Whenever I try to use a dynamic array without declaring how many items it holds -- arrVal (1 to 10) I always get a subscript out of range error. Any idea?

[@seanmackenziedataengineering]

VBA is 0-based, so you will count 0 to 9 for 10 items when you Dim arrVal(10) it seems counter intuitive, but it works!

[@artistryartistry7239]

@@seanmackenziedataengineering Thanks for the reply! If I don't know how big the array is going to be, I would just declare arrVal() creating a variant, correct? But this never works. I always get an error subscript out of range.

[@seanmackenziedataengineering]

It is better to give a size to start: Sub arrTest() Dim arrVal(1) arrVal(0) = "ABC" arrVal(1) = "DEF" Debug.Print arrVal(0) Debug.Print arrVal(1) End Sub You can also resize the array if you want it to grow (and keep the original contents): ReDim Preserve arrVal(3) arrVal(2) = "GHI" arrVal(3) = "JKL" etc.

[@artistryartistry7239]

@@seanmackenziedataengineering You're awesome Sean. Thanks for being generous with your time :)

[@muhammadtareq3124]

Is there a function to sum the elements of array?

[@seanmackenziedataengineering]

No, just loop it and add 'em up! 🛠

[@muhammadtareq3124]

@@seanmackenziedataengineering Thank you so much

[@dbdata9836]

thanks

[@seanmackenziedataengineering]

You're welcome!

[@eyribalt99]

Always appreciate your vids but I find the music within the intro very distracting.

[@seanmackenziedataengineering]

Noted! Thanks for the feedback.

[@dbdata9836]

1

[@seanmackenziedataengineering]

Nice!

[@dbdata9836]

well

[@seanmackenziedataengineering]

👍

[@dbdata9836]

1

[@seanmackenziedataengineering]

Cheers,