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

preview_player
Показать описание
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

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba

Рекомендации по теме
Комментарии
Автор

Sean your channel is incredibly valuable. Thank you!!

AdvaitaX
Автор

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

interestingamerican
Автор

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.

mehdibakhtiari
Автор

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

interestingamerican
Автор

Is there a function to sum the elements of array?

muhammadtareq
Автор

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?

artistryartistry
Автор

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

eyribalt
welcome to shbcf.ru