Microsoft Access Intro to VBA Programming - Visual Basic for Applications for Beginners - Access VBA

There is a NEW version of this video available here: • Introduction to Progra...
In this introduction to Microsoft Access Visual Basic for Applications programming, you will learn how to write your first code in Access VBA. To learn more, see my full course at the links below:
Full Access Developer 1 Course:
599cd.com/XYTD1
Intro to Microsoft Access:
• Create a Database in M...
Full THREE-HOUR Microsoft Access Beginner Tutorial:
• Microsoft Access 2013 ...

[@599CD]

There is a NEW version of this video available here: kzbin.info/www/bejne/q6fQpZagf8p1m5Y

[@scottaxton2513]

Richard good to see you are releasing videos again. Just have to comment on sound quality. What happened??!! It sounds like you are talking into a tin can from across the room. NOT your usual quality.

[@599CD]

Yeah, my sound quality was awful in this video. It's high on my list to re-record. Hello from 4 years in the future. :)

[@markparsons4434]

Your courses are simply excellent, it has helped me loads in the very short time I’ve been working with programming and databases.

[@599CD]

Great to hear!

[@aftabnawaz8429]

Sir very well teaching and very comprehensive

[@599CD]

Thanks and welcome

[@tahwnikcufos]

Did you record this on your phone? I don't remember the audio being this poor, on your earlier videos.

[@599CD]

Yeah, I went through a bunch of different microphones at that time. This one was pretty crappy. I'll be re-recording this soon.

[@tahwnikcufos]

@@599CD Damn... talk about a late response... lol. I've done some pretty cray things since then, especially with the drawing tools.

[@akashtak4531]

Sir, Thanks a lot for free tutorials. I was looking for your "Expert Level" Access learning series.

[@599CD]

You're welcome. You can find that here: 599cd.com/acx1

[@user-zc1gm6lo4s]

A very useful lesson. We do not have that many good lessons in Russian. Access and vba not very popular in Ukraine.

[@599CD]

That's unfortunate. Sorry I don't speak Russian (or any other languages for that matter). I know dozens of languages... all computer. :)

[@alializadeh8195]

Thank you ///

[@tikummacmillianngu6477]

Hello sir, Nice meeting you. I do appreciate your tutorials, there very educative and d enjoy them. i have a challenge.

[@599CD]

Glad you enjoy

[@euwofbw]

wow , very informative ! thanks!

[@599CD]

My pleasure.

[@majidakbary1363]

Hello There my question about VBA this is my database Table “PMACustomer” contains all records for all Branches, (separate by Branch No. are like 01, 02, 08….) By Making Query “PMACustomerQry “able to ask by Branch No. to show just that Branch records. Form “PMACustomerQryFrm” is an end-user data Form entry. If you open “PMACustomerQryFrm” form 1- 1st ask you Branch No. user type 01,02 or 03) 2- It has a Red Button on this form (Upper Right) 3- I want when I press on this Button “Uncheck “all Checkbox name “Invoiced” 4- But I want just those checkbox showing in this form with that Branch No. 5- If Branch No. change to others still have checkbox clicked (not change other branch checkboxes) If you open VBA on this Button I did some code but I cannot find the argument/code right for it too. My Table contains: PMA_ID AutoNumber PMAName Short Text PMABranch ShortText Invoiced Yex/No My Query SELECT PMACustomer.PMA_ID,PMACustomer.PMAName, PMACustomer.PMABranch, PMACustomer.Invoiced FROM PMACustomer WHERE (((PMACustomer.PMABranch) Like [Please Type Your Branch No like 01, 08])); And My Form: it has Just all field and Default View Continuous Forms but I add a Botton in this form for unchecking all " Invoiced " Checkbox for each record. my problem start when I used this button all record includes records belong to other Branch get uncheck as well, what I want each branch able to uncheck just own checkbox Private Sub Command17_Click() CurrentDb.Execute " update PMACustomer Set Invoiced =false" Me.Requery where????????? End Sub I know my code has missing where or when an argument Could sone one Help me on this code thank you all

[@599CD]

TL;DR

[@KashifKhan-mm5td]

hi, sir i have a error MS Access (V.2010) file uploading to Visual Studio (V.2019), the table can show but query didn't show, total 5 tables and 7 query but show only 5 tables and 2 query, Please help,

[@599CD]

Can't help you with VS. Sorry.

[@lavanyamadhuri3752]

how to auto add text boxes when a button is clicked in an access form using vba.please help me out urgent

[@599CD]

What do you mean by "auto add text boxes?" Do you want to create new RECORDS, or a whole new control?

[@bakaneko6639]

Thanks man! that helped me out so much.

[@599CD]

My pleasure.

[@a.k.m.bellalhossain6727]

very good tutorial

[@599CD]

Many many thanks

[@nouramer18]

when i open visual basic in access its crashes and not open although it is installed with office , can u help me plz.

[@599CD]

Try uninstalling and then reinstalling Access. That's usually the first and easiest solution I recommend.

[@totairoy]

Sir, I'm from india. I need your help, please help me out. Is there any way to send message(with api key) from ms access using vba code.

[@599CD]

I get asked this a lot. Yes, you can. No, I haven't done a video on it yet. I will in the future though.

[@totairoy]

@@599CD thank you sir, i glad to see your replay,🙏🙏🙏🙏🙏🙏🙏🙏

[@santars2030]

SIR PL GUIDE ME HOW TO CHANGE CONDITIONAL INPUTES BY CODING LIKE DATE

[@599CD]

I have no idea what you just said. :)

[@avb6programminguser776]

Good for VB6 programming too.

[@599CD]

A lot of it is, yes.

[@hansofficialedits681]

Sir Good day! Can you make a video for loan amortization in query

[@599CD]

Already have one: kzbin.info/www/bejne/j3qnfWyhlJ6Baqs

[@jpd773]

Your courses are great, however you need to work on that mic you've been using. Sound is terrible.

[@599CD]

Yeah, that was a crappy mic. I'll be re-recording this soon.

[@tomcollier4089]

Wish I could pay you to help me. Just installed Office on a 2 year old computer and I can't even see ACCESS as an (open with) option. Guess I will just buy a new comp, even though mine WAS a great one. Should bought the damn single program for $750, instead of the whole thing for $100. THANKS OBAMA!

[@599CD]

Are you sure the version of Office you had included Access? It doesn't come with the Standard Edition. You're better off with a Microsoft 365 subscription. And... LOL... what did Obama have to do with it? He wasn't even president when you wrote this. Ha ha.

[@tomcollier4089]

@@599CD The Obama thing was a joke...the access problem is real. I am stuck...I bought a new computer and I am trying to download a zipped file and unzip it in access . The file has hundreds of millions of accounts that I need to filter...I can't do it...giving up on life pretty much...and yes, I have office 365....I can go on it fine now, but the is, I am so confused I haven't been able to work for over a year. I return(ed) unclaimed property to people (or corporations) that cannot get it back from the state...estates, trusts, etc. I sue the state of florida (16 years now) for a living....they hate me. I'll be dead soon. Don't bother with me.

[@paulagift5210]

log in form please

[@599CD]

Extended Cut covers this: 599cd.com/DatabasePassword

[@dennisssebuggwawo8355]

Good stuff but but speaking too fast for us non Americans to follow or comprehend. Otherwise good stuff

[@599CD]

Sorry. I can't drive 55 either. :)

[@donniematz]

The audio is SO BAD…

[@599CD]

Yeah it's an older video