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

[@letsgetdowntobusiness-]

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

[@599CD]

Still here. Thanks. :)

[@payvandsarandi6130]

I cannot believe I just did my first VBA coding which was complicated enough. Like Patricia, I've been using Access for many years but not VBA. the "Coding" was so scary for me, but I DID it. Thank YOU, THANK YOU, THANK YOU!

[@glennfelpel9785]

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

[@599CD]

You are very welcome, and thank you for the compliment.

[@m.ebrahimheydari6109]

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 KZbin. 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❤

[@christiankranabetter2344]

Hello Mr. Richard, I joined today this KZbin 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

[@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.

[@599CD]

My pleasure!

[@luzkrg]

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

[@599CD]

100% LOL - you're very welcome.

[@GaylerdGuitar]

Great job Richard, and excellent teaching.

[@599CD]

Thanks

[@VincentAranda-z1h]

Just brilliant !!! second to none....

[@599CD]

Thanks I appreciate that

[@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❤

[@599CD]

I still remember the sound of my TRS-80, 300 baud modem connecting to the local BBS...

[@easyspeak101]

Thank you Richard, easy to understand, thanks.

[@599CD]

Very welcome

[@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.

[@599CD]

You are welcome!

[@shahdtae439]

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

[@599CD]

Welcome

[@jessicasojka7507]

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

[@599CD]

You are so welcome!

[@demenner8509]

Your lessons are very helpfull. I am only stuck at 1 point: with the +1 button you state that "whatever the value is, it will add 1. But what if the value is empty (I do not want to start at zero) I need this to count my stock but if I fill in zero on al the articles it will go wrong when I import the file and have not counted all my stock....

[@599CD]

599cd.com/Ask

[@lambertmuloya-vk2sx]

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

[@AlwynMiller]

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

[@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.

[@leomaredcampos4941]

I can't use docmd.close while opening other form

[@599CD]

Okay

[@alializadeh8195]

Thank you ......

[@Anilsingh-vq2cv]

very helpful thank you very much respected sir

[@599CD]

Most welcome

[@TheRosboroughs]

Hi Richard - I am working on building out an Access database for a small business company in my town and I have a few questions. I wondered if you take paid consultation hours? Could I schedule some time to speak with you on the phone or over Zoom to communicate their specific wants/needs and get your assistance on how to apply them? Thank you so much.

[@pjn2001]

Hi there, did you ever come right?

[@599CD]

Sorry I don't do one-on-one consultations but you can see this page for people who might be able to help you 599cd.com/DevNet

[@teejayare2980]

Love your work!

[@599CD]

Thx

[@muvaffaksarikahya8100]

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

[@599CD]

599cd.com/Developer

[@karibayoumi8633]

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.

[@599CD]

599cd.com/AfterUpdate

[@tutsecret499]

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

[@599CD]

599cd.com/Age

[@richardmeborg4717]

Hi Richard. How do I become a member?

[@599CD]

Click the blue Join button on KZbin or go to 599cd.com/THM

[@LHPottery]

I remember the halcyon days when Access put code behind the buttons instead of marcos. Yeah, I'm old.

[@599CD]

Yeah, that's going back to like 2000/2003, I think

[@LHPottery]

@@599CD I go back to version 2. About the same amount of time as you!

[@imjustsaying...3720]

that within a second of you mentioning "but first a word from our sponsors, and that's me!" You had me laughing so hard, that I just had to stop the video and comment. I didn't realize that you had both the color of your skin and your sex changed to an attractive Black woman promoting some college courses! Thank you KZbin for a good laugh LOL . But of course I clicked on the Skip Ad after a few seconds and returned to your video.

[@599CD]

Ha ha. Black woman selling college courses, eh? KZbin must have just randomly placed a "real" ad at that spot in my video, because all I did was mention one of my other courses at that moment. But, I'm glad you got a good chuckle out of it. I do aim to entertain as well as educate. LOL

[@599CD]

And hey... don't skip those ads! I need that 0.00003 cents from you watching that black woman! :)

[@joeg9561]

Do you still read all comments? ACCESS!!!

[@599CD]

Yup