Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)

In this video, I'm going to teach you how to start programming in Microsoft Access VBA. If you've never done any programming before, don't worry. I'll show you how to get started and walk you through it step by step. We will learn how to work with the VBA Editor, create a MsgBox, learn how to open a form with DoCmd.OpenForm, and set a value in a form field.

Patricia from Ann Arbor, Michigan (a Platinum Member) asks: I've seen in several of your TechHelp videos where you mention "you can do this with a couple lines of code." I've been using Access for a few years, but I've never done any VBA programming before. Can you tell me where do I put this code, and how do I get started?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a button to open a form to a specific record. We'll put a customer list box on the main menu. Pick a customer, click the button, and that customer's record will open. Then we'll learn about Event programming. We'll use the On Double Click event to do the same thing by just double-clicking on that customer list box. Then we'll learn about the If / Then / Else statement. If the user doesn't pick a customer from the list and then click the open button, then they will get an error message. Lots more too!

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, VBA, Choose Builder, Code Builder, Project Pane, Properties Pane, Immediate Pane, MsgBox, parameters, optional parameters, DoCmd.OpenForm, Set Value, Turn Off Choose Builder Box, Options, Object Designers, Always Use Event Procedures, Open Form to Specific Record, On Double Click Event, On Dbl Click, DblClick, If Then Else, Microsoft Access VBA, Access VBA Tutorial, Access VBA for Dummies

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[letsgetdowntobusiness-]

Richard, if you are still out there? I just want you to know that "YOUR THE MAN!"

[m.ebrahimheydari]

Dear Richard,

I trust that this message finds you well. I am writing to express my gratitude for the exceptional training courses you have made available on YouTube. Your teachings have proven to be immensely valuable, and I eagerly look forward to learning more from you.

In light of this, I kindly request that you provide me with the direct links to your other courses. I am certain that these resources will further enhance my understanding and contribute to my personal growth.

Thank you for your unwavering dedication to sharing your knowledge and expertise. Your cooperation and attention to this matter are greatly appreciated.

Warm regards,

Ebo❤

[glennfelpel]

You certainly are a very gifted trainer. Much appreciated thank you.

[Saad-Sadiq]

Richard you're the best. King of Ms Access.

[DAcutech]

You make learning so much fun. Thank you for sharing your invaluable knowledge.

[luzkrg]

What are the odds that just yesterday I was looking for exactly this… THANK YOU!!! 🤩

[jessicasojka]

I love your videos!!! Thank you so much sharing all of your knowledge.

[christiankranabetter]

Hello Mr. Richard, I joined today this Youtube channel, it's really interesting and helpful. I'm quite new in this VBA in ACCESS and I looking for help for the following: I creating a database of staff members for our organization and since we're people from all over the world we have many different First Names, either one or two up to 3 or 4. And either with or without dash -. Also the length is variating a lot, but I need to specify this because I don't want people to make mistakes when they enter the data. Every single name should start with a capital letter. Where can I find help for this. Thank you Christian

[GaylerdGuitar]

Great job Richard, and excellent teaching.

[moodkn]

Thanks Sir!
Very useful and helpful exercise
I had also needed it a lot, because I had worked on the Visual FoxPro Programing before it where VBA is not use, so sometimes it is very difficult to me to work on the VBA.

[easyspeak]

Thank you Richard, easy to understand, thanks.

[shahdtae]

MR. Richard, Hello, Thank you for your Tech help.

[Anilsingh-vqcv]

very helpful thank you very much respected sir

[marshallgrads]

Lol, just watched this tutorial and fell out of my chair when you mentioned programming on a Radio Shack TRS-80. We use to call trash-80s. Ah, storing data on cassette tapes, the good days all came rushing back❤

[cpxtyvk]

interested in your course for VBA is their any reduced rate for the complete course list available

[karibayoumi]

Hello Dear

Thanks for your valuable videos

I am trying to code an If statement between a subform and another separate form.

I need after updating a Combobox in the subform to set an if statement: ( If the record in a field in the form equals the value updated in the combo box then a field in the same raw in the form becomes true )

Could you please advise about the VBA Code.

Thanks.

[umairpioneer]

Hey Richard, i have a question. I may sound silly in this but i will highly appreciate if you'd help me in this. imagine a scenario in which a customer has ordered two products of different values (say 200 dollars and 450 dollars). Here, I want to create a query table that shows the orders of 200 or above for a customer if he as at least one order of value 400 or greater? There are thousands of customers and orders are also in thousands.

[lambertmuloya-vksx]

Sorry how can I command save by using code, and after save I want my registration form to direct me to new field

[tutsecret]

how can I calculate age via VBA on the Age field inside the table. Thank you.

[muvaffaksarikahya]

Dear sir, Where can I found the discription for VBA commands such (docmd., me.) . regards