Microsoft Access Intro to VBA Programming - Visual Basic for Applications for Beginners - Access VBA
ฝัง
- เผยแพร่เมื่อ 6 มิ.ย. 2017
- 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 ...
There is a NEW version of this video available here: th-cam.com/video/uvmtcjJeBe4/w-d-xo.html
Your courses are simply excellent, it has helped me loads in the very short time I’ve been working with programming and databases.
Great to hear!
Sir, Thanks a lot for free tutorials. I was looking for your "Expert Level" Access learning series.
You're welcome. You can find that here: 599cd.com/acx1
Hello sir, Nice meeting you. I do appreciate your tutorials, there very educative and d enjoy them. i have a challenge.
Glad you enjoy
Thanks man! that helped me out so much.
My pleasure.
wow , very informative ! thanks!
My pleasure.
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.
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. :)
Sir very well teaching and very comprehensive
Thanks and welcome
very good tutorial
Many many thanks
Did you record this on your phone? I don't remember the audio being this poor, on your earlier videos.
Yeah, I went through a bunch of different microphones at that time. This one was pretty crappy. I'll be re-recording this soon.
@@599CD Damn... talk about a late response... lol. I've done some pretty cray things since then, especially with the drawing tools.
when i open visual basic in access its crashes and not open although it is installed with office , can u help me plz.
Try uninstalling and then reinstalling Access. That's usually the first and easiest solution I recommend.
Thank you ///
how to auto add text boxes when a button is clicked in an access form using vba.please help me out urgent
What do you mean by "auto add text boxes?" Do you want to create new RECORDS, or a whole new control?
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,
Can't help you with VS. Sorry.
SIR PL GUIDE ME HOW TO CHANGE CONDITIONAL INPUTES BY CODING LIKE
DATE
I have no idea what you just said. :)
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.
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.
@@599CD thank you sir, i glad to see your replay,🙏🙏🙏🙏🙏🙏🙏🙏
A very useful lesson. We do not have that many good lessons in Russian. Access and vba not very popular in Ukraine.
That's unfortunate. Sorry I don't speak Russian (or any other languages for that matter). I know dozens of languages... all computer. :)
Good for VB6 programming too.
A lot of it is, yes.
Sir Good day! Can you make a video for loan amortization in query
Already have one: th-cam.com/video/YIDL9k_9N4I/w-d-xo.html
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
TL;DR
log in form please
Extended Cut covers this: 599cd.com/DatabasePassword
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!
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.
@@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.
Your courses are great, however you need to work on that mic you've been using. Sound is terrible.
Yeah, that was a crappy mic. I'll be re-recording this soon.
Good stuff but but speaking too fast for us non Americans to follow or comprehend. Otherwise good stuff
Sorry. I can't drive 55 either. :)
The audio is SO BAD…
Yeah it's an older video