Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules

This episode is for those of you who have spent some time making forms and reports, and have started looking over the fence at VBA and how it could help you in your project. This introduction to VBA shows the two main ways that VBA is used in Access, through "code-behind" on forms/reports, and in module code. I'll show you how to find events on your form, how to code in an Event Procedure, and how to make your own custom subs and functions. I'll also introduce you to function visibility, and where and when you can use your functions, in modules and in code-behind. Buckle up and let's go check out VBA.

Related Videos:
Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules
You are watching this video now!
VBA MsgBox - How to use message boxes in MS Access
How to Use a Do Until Loop in MS Access VBA
How to Use Iif in Microsoft Access
How to Use the Replace Function in Microsoft Access
How to Use Nz in Microsoft Access to Handle Null and Empty Values
Iif, If Then Else, and Select Case in MS Access
How to Use DLookup in Microsoft Access
How to Create and Configure a Custom Pop-Up Form in MS Access

For developers looking for a new role, check out and sign up:

Needing to hire technical resources for your project? Get the best:

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 #dataengineering

[khabathawrami]

Your videos about Ms Access and VBA are great .. Thank you

[jamesmartinez]

Magnifica enseñanza, diez mil gracias señor Sean

[wtlzvtb]

Thanks for the great effort. I need to paste a value into a selection rows in the table through VBA Code

[davegoodo]

Hi Sean, I'm taking a walk through this playlist. I have VBA experience in Access but I want to do an intro to see if there are gaps in my knowledge. I hope to do the Intermediate and Advanced as well so that I'm really prepared for a project I'm involved in. I've checked out some of your videos and I feel confident that you will have the info I'm looking for. Thanks as always, on with the show!

I watched this intro video Sean, you do set a fairly steep learning curve. The focus was mainly on visibility and getting the difference between Public & Private and how that relates to forms and modules. You didn't mention your prefix "p" for public variables, if I was brand new I'd wonder what that was. Anyway, I'm sure an intro to anything is going to be challenging because there's so many bases to cover. I don't want to sound too critical, your relaxed style always makes the content easy to follow even if at times it can be distracting. I'm going to continue with the next in the series. Thanks Sean.

[finvictho]

Can I set Access talk off (no any prompts from access )while using Querry update function.

[matthewb]

Hi Sean. I appreciate your videos, so thanks first of for making them available. That's getting started, but where would you suggest going to to find a course in VBA? Any thoughts? Udemy? CodeAcademy? A college online course? Are you aware of any you like? There are so many. And I should perhaps add, a course that you provide but I think you might not be focused of the basics so to speak, but coding techniques for more experienced Access users.

[charleskent]

This is a excellenf intro to VBA. One question: at 18.49, what did you do to "run the function" and open the OUR_MODULE window?

[krishnakuraku]

Can you please do a video on how to write and execute stored procedure or function in python..?