A newer version of this series has started for Microsoft Access 2016 here:

———-
VBA – Writing Our First Code in “Programming in Microsoft Access 2013”. Hosted by Steve Bishop.
In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).

Click here for the full playlist of”Programming in Access 2013″

Click here for the Work Files of this series:

———-
Become a member today for only $5 a month!

When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
———-
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

Coffee With Steve:

Nguồn:https://madisonrep.org/

Xem Thêm Bài Viết Khác:https://madisonrep.org/cong-nghe

31 Comments

Programming

February 7, 2020

Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.

Coffee With Steve: https://www.youtube.com/channel/UCeXAUvo5xxDY_b-lSknPC1A

Reply

Samuel Paradis

February 7, 2020

Man I swear to god there is nobody explaining VBA basics for beginners as well as you on youtube.

Reply

nour amer

February 7, 2020

When i open visual basic for app . access stoped and closed . what the problem ?

Reply

ShaingSun

February 7, 2020

I told my dog like you asked, he appeared interested

Reply

Steve Freeman

February 7, 2020

I've been asked to "write some VBA code using the IN() function" which I have zero experience with. Given a table named NAMES with 5 names in it; Bill, Sam, Steve, Stephanie, and William; I have a form that has an Access List Box that looks to the NAMES table to retrieve the entire list. I want to enable the form user to be able to select 4 names; so I set the property of the List Box (Property-Other-MultiSelect="extended"). The ListBox puts the data away in a record field named "V2". So far so good.
Next, I have a button on this form that will generate a report based on the criteria displayed on this form.
This button when activated Print-Previews a report, and the report is based from a query.
The query, when examined in DesignView, utilizes the FORM method; using this
Like ([forms]![padc]![V2])
Of course, my form name is "padc" and the values I want to retrieve are shown on this form in the field "V2"
Prior to trying the ListBox approach to putting values into V2; I would specify one name, such as W* for all the William results.
My problem arises when I want to show Sam and Steve and William; but exclude Bill and Stephanie. This is the problem I'm hoping my ListBox approach might fix.
So…….
Being ignorant of the finer points of SQL and knowing zero VBA; I am at a loss on how to use the "IN() function" which I've been told will let me select the names from the Form, which will drive the query, which will drive the report showing the NAMES selected on the form.
The person who suggested the IN() function solution is probably offering good advice; even though they show me (no way I comprehend) how to actually DO the coding to make this work.
Suggestions are highly appreciated.
[email protected]

Reply

KissNa Tharu

February 7, 2020

What is your name ? Sir

Reply

Diego Rojas

February 7, 2020

Tell your dog! XD 10:18

Reply

Lomax

February 7, 2020

Cool, cool! Thought we were going off the deep end for a bit, but this is manageable.

Reply

Yuxiao Liu

February 7, 2020

FYI i did tell my dog…….

Reply

patrick khasina

February 7, 2020

Great stuff, well arranged, easy to follow and understand.

Reply

Phan Quang Vĩnh

February 7, 2020

Hi, would you please help me about code disable shift key and click copy record and delete the record in the table? Would you like send email address for me? I will send my software to you. Hope you help me because I want to a copy-wright software.

Reply

John Davy

February 7, 2020

Thanks, very well done!

Reply

luke lightning

February 7, 2020

Hi Steve i really love your videos, its very helpful
i just have one question, How do you know which code to use, is there like a list of vba codes that you need to memorize before you can start coding. Please help me with the codes, i would really appreciate it, thanks

Reply

Bruce Scott Yogaro

February 7, 2020

I don't need a college degree!😂 Thanks to you bro

Reply

Civil Registry Office Manila

February 7, 2020

ty for the tutorial… may I ask in this string " Hello World! ". is there a way to change the (Hello) to BOLD font and the (World) change to higher font size and the output is in the same textbox. TY again and also i watch all 79 videos very great …

Reply

محمد جبران اليافعي

February 7, 2020

thank you i want to know to make the statement in access by VBA

Reply

Eric McCarley

February 7, 2020

why don't you have to put me. in front of the txtOutput?

Reply

Milagros Guthrie

February 7, 2020

Great tutorial. Thank you.

Reply

Reuben Matene

February 7, 2020

Great tutorial!!!

Reply

Cody Yager

February 7, 2020

This could be a 3 min video instead of a 10 min…..

Reply

marcinofsky

February 7, 2020

Cool

Reply

hamzaable

February 7, 2020

Thnaks

Reply

Brainy Books

February 7, 2020

Frustrated! I wrote the following VBA code precisely as Lesson 28 prescribes: Private Sub btnGo_Click()
    Dim strText As String
    strText = "Hello World"
    txtOutput.Value = strText
End SubAlso, I assigned btnGo as the Name of the button box and assigned txtOutput as the Name of the text box. Plus, I made sure to Save the subroutine. Yet it is not working, i.e. no output when I click on the button. What in the world could I be doing wrong???

Reply

Junte Junae

February 7, 2020

Its incredible how you have had no formal training and yet you still deliver knock out Tutorial like this..I'm Totally Enjoying them..Thanks Steve

Reply

Charles Amusan

February 7, 2020

awesome videos Thanks

Reply

Morshedul Islam

February 7, 2020

u could name the form with differernt something rather than frm_form.
i think that could be quiet more understandable for practitioners

Reply

cipta anugrah

February 7, 2020

Great Tutorial…Realy realy understandable,,..thank you very much

Reply

Candy Duff

February 7, 2020

thanks, great job of clearly explaining what you're demonstrating! Very easy to follow

Reply

Bill Hines

February 7, 2020

I am working my way through your Access classes. I started learning Access to help out a group of supervisors I work with. They have been using paper records to cover time slots created by employees taking vacation. I,ve posted below, what I'm trying to accomplish, if anyone wants to weigh in on ideas of developing this database.
Employee Draft System

Employee Draft System is a system to fill empty time slots created by an employee going on vacation (or any other time off situations). A list of open slots will be posted for volunteers to sign for if they want OT (or extra time, if this won’t bring them to over forty hours).
• For each vacation days, two time slots are created (half shift slots; four hour slots on weekdays, or six hour slots on weekend slots).
• The replacement employee must be in same job class (work in same department, and qualified to perform same job).
All employees’ in above group are returned and then further evaluated:
• The above being meet; they must have the lowest total Over Time, year-to-date in the class
o OT is referred to as CAP Hours in our system?
o Ranked lowest to highest, in CAP (OT)Hours Employees W,X,Y,Z (The employee’s with lowest CAP Hours will be drafted).
• Figuring that these four will qualify for all the open slots, after allowing for the following exemptions
• Has “W” been in job position for a minimum of six months?
o If No, exclude from draft
o If Yes, them
• Does “W” have their own vacation scheduled for any of the time slots?
o If Yes, then exclude from any conflicting time slots
o If No, then
• Is “W” scheduled to fill any other slots (of this or other employees, which will either conflict or change their draft ranking)?
o If Yes, then exclude from conflicting slots
o If No, then
• If a weekend employee is available to fill a weekday slot, then they bump weekday employees (weekend employees get paid for 36 hours, even though they only work 24 hours. They must get 40 actual hours before OT kicks in and therefore are preferred over weekday employees, for weekday slots).
• Tending their supervisors’ approval draft for slot(s) as needed
o Send their supervisor an email of intent to draft their employee for which slot(s)
o Upon their supervisors approval (there could be issues with employee, not accounted for in the draft system; death in family, etc…):
• Print draft notice and have employee sign it
• They are now responsible for this/these slot(s), as if it was their normal schedule.
• Repeat this procedure with employees X, Y, Z, etc… as needed.
As to volunteers:
• Weekend employee employee’s can bump weekday employees (for weekday slots).
• In first quarter of year only: a person with year’s of service seniority can bump a junior person for a slot.
• Weekend employees can not fill weekend slots ( as they work twelve hour shifts), nor weekday shifts that touch their normal shift. An employee can not work more than thirteen hours in a twenty-four hour period.

Reply

Antonio lau jr

February 7, 2020

Hello,
I try to do this sample in my Access 2010 and get the error message: I have to declare the variable …txtOutput.Value…
and the video # 29 the error message is that I can't assign a value to CheckYesNo…

Somebody can help me , Please…??? Thanks

Reply

Online .Questions

February 7, 2020

I'm looking to calculate commission pay at one rate during the weekdays and at another rate during weekends and this based on the total labor sold during a given period.

I've managed to figure out how to take my imputed date and turn it into a "spelled out"  day of the week in a query but the next step is to use a formula that takes into consideration the day of the week to determine when to apply the weekday rate or the weekend rate in order to calculate total commission earned for the pay period.

Reply

Leave a Reply