MS Access VBA How To Videos – Free Tutorial Reference


Welcome to vbahowto.com! We hope you find the information you need, and if not please let Erik know at this link.
Latest Resource

Click image to take a look at our latest resource…
Click Here And Visit Our Store!
If you just need the database, search for the title of the video on the top right corner of this page (then click the magnifying glass). Then click the post title. Thank you.

(MS Excel VBA training? Click Here)

Still need help? Click and call LoeblCom Services

Click here for the database used in most of the modules:
Nwind_2k_modified.mdb

Find The Best VBA Tutorial Video To Watch Based On Your Needs, or start at the top of the list and move down sequentially through the modules (Modules 1-8) to view the ENTIRE 30+ DAY COURSE at your own pace!

Have A Specific Question? Click Here.

Module 1

    Free Access programming tutorial Video 1

  1. Writing VBA Procedures
  2. Overview Of VBA Modules And Procedures
  3. Working With VBA Modules
  4. The VBA Code Window
  5. Creating A VBA Sub Procedure
  6. Working With VBA Variables
  7. Declaring Variables In VBA

    Free Access programming tutorial Video 2

  1. Declaring VBA Variables
  2. VBA datatypes
  3. Running VBA code
  4. Different ways to use the VBA message box

    Free Access programming tutorial Video 3

  1. Working With VBA Variables
  2. Obtaining Values From The User
  3. How to use the VBA Inputbox
  4. Efficient Variables In Your Application With The Dim statement.

    Free Access programming tutorial Video 4

  1. Working with variables.
  2. String expressions
  3. String Concatenation
  4. Inputbox examples
  5. Currency Formatting
  6. Step through code
  7. Debug code
  8. Immediate window samples
  9. if statement example
  10. one line if statement example
  11. if else statement example
  12. if elseif statement example
  13. select case statement example

    Free Access programming tutorial Video 5

  1. Module 1 Review.

    Free Access programming tutorial Video 6

  1. How to call other procedures.
  2. How to better organize your code.
  3. Common Errors

    Free Access programming tutorial Video 7

  1. Overview Responding to user actions at runtime
  2. building a table in Access

    Free Access programming tutorial Video 8

  1. Database Design in Access
  2. building tables in Access
  3. field properties
  4. field datatypes
  5. relating tables in Access

    Free Access programming tutorial Video 9

  1. Form Design in Access
  2. building forms in Access
  3. programming forms in Access

    Free Access programming tutorial Video 10

  1. option frames
  2. option buttons
  3. command buttons, in regards to printing reports.
  4. learn how to program “pick lists”
  5. further uses of message boxes.
  6. “On Open” event of forms to analyze password entries
  7. string concatenation.

Module 2

    VBA Event Driven Programming

  1. Creating An Event Procedure
  2. Reacting To User Actions Programatically
  3. Using the DoCmd Object
  4. Program Flow
  5. Frame and Option Button Events
  6. Command Button Events
  7. Drop Down Box Events

    VBA Form Object Event Procedures

  1. MS Access Form Open Event
  2. How To Cancel Open Event

    MS Access Form Events – PT1

  1. MS Access Message Box
  2. MS Access Form Caption
  3. MS Access Form Calculation
  4. MS Access Form Current Event
  5. MS Access Form Open Event
  6. MS Access Form Load Event

    MS Access Form Events – PT2

  1. MS Access Form_Delete
  2. MS Access Form_Unload
  3. MS Access Form_Close

Module 2b

    MS Access VBA Control Events – PT1

  1. Click
  2. DblClick
  3. GotFocus
  4. LostFocus
  5. DblClick
  6. Change

    MS Access VBA Control Events – PT2

  1. AfterUpdate
  2. BeforeUpdate
  3. NotInList

    MS Access VBA Control Events – PT3

  1. NotInList Continued

Module 3

    MS ACCESS FORM OBJECTS – PT1

  1. Forms collection
  2. Forms object referencing

    MS ACCESS FORM OBJECTS – PT2

  1. Form Object Referencing
  2. Calculate Function

    MS ACCESS FORM OBJECTS – PT3

  1. With / End With Statement
  2. DoCmd.OpenReport
  3. OpenForm Method Described

Module 4

    MS ACCESS FORM VALIDATION – PT1

  1. ms access text validation
  2. validation rule access
  3. input mask in access
  4. validation in access
  5. microsoft access tables

    MS Access Validation – PT2

  1. Table & form validation

    MS Access Validation – PT2 (explained)

  1. MS Access Validation – PT2 (explained)

    MS Access Validation – PT4

  1. Validating Text Strings
  2. Check the string for null values
  3. IsNull function
  4. Len Function
  5. InStr function
  6. Other VBA String function
  7. Validating Numbers
  8. IsNumeric function
  9. IsDate function

Module 5

    How To Make A VBA Function

  1. How To Make A VBA Function

    VBA Variable Scope

  1. VBA Variable Scope

Module 6

    VBA Debug Part 1

  1. breakpoints
  2. Test variables
  3. Monitor variable
  4. Validation

    VBA Debug Part 2

  1. The Immediate Window
  2. debug.print
  3. The Local Window
  4. The Watch Window

Module 7

    VBA Error Handling PT1

  1. Division by zero errors
  2. Invalid use of the null characters
  3. Overflow errors,
  4. VBA Error Handling
  5. Run-Time Errors

    VBA Error Handling PT2

  1. Handling the VBA Err Object
  2. VBA Error Handling

Module 8

    VBA Do Loop

  1. A Do Loop in VBA

    VBA For Loop

  1. A For Loop in VBA

Module 9

    Recordset In VBA – PT1

  1. An DAO recordset in VBA.

    Recordset In VBA – PT2

  1. An ADO recordset in VBA.

    Recordset In VBA – PT3

  1. Using the methods of the recordset object.
  2. MoveFirst, MoveLast, MoveNext, MovePrevious, EOF, BOF

    Recordset In VBA – PT4

  1. Using SQL to select and modify records.

All Posts (Most Recent To Past)

  • MS Access VBA – How To Add A Select All To A Combo Box
  • MS Access Hiding Text Boxes Based On User Selection VBA
  • How To Write A Recordset To File With VBA
  • How to create SQL Statement from Combobox Selections
  • How To Convert Macros To VBA
  • Converting a macro into VBA code
  • MS Access Running Counter In Query
  • VBA Building Dynamic SQL
  • MS Access Option Group QA
  • Access Report Parameters
  • Excel VBA Read Text File
  • VBA Read Excel File
  • VBA Move File
  • Access VBA Create Table
  • MS Access Login Form Revised
  • Being More Specific In Access Import
  • Shell VBA function
  • Access Import Of Spreadsheet Or Table
  • How Do I Import An Excel Spreadsheet
  • MS Access Form Calculation On Checked Items
  • Microsoft Access IIF Function
  • VBA Calculate – Multiply
  • MS Access Option Group
  • MS Access SQL
  • How To Make A MS Access Login Form
  • How To Make An Access Timer
  • Passing Form Field Default Values
  • Recordset In VBA – PT4
  • Recordset In VBA – PT3
  • Recordset In VBA – PT2
  • Recordset In VBA – PT1
  • VBA For Loop
  • VBA Do Loop
  • VBA Error Handling PT2
  • VBA Error Handling PT1
  • VBA Debug Part 2
  • VBA Debug Part 1
  • A Variable Scope
  • How To Make A VBA Function
  • MS ACCESS FORM VALIDATION – PT4
  • MS Access Validation – PT2 (explained)
  • MS Access Validation – PT2
  • MS ACCESS FORM VALIDATION – PT1
  • MS ACCESS FORM OBJECTS – PT3
  • MS ACCESS FORM OBJECTS – PT2
  • MS ACCESS FORM OBJECTS – PT1
  • MS Access VBA Control Events – PT3
  • MS Access VBA Control Events – PT2
  • MS Access VBA Control Events – PT1
  • MS Access Form Events – PT1
  • MS Access Form Events – PT2
  • VBA Form Object Event Procedures
  • VBA Event Driven Programming
  • Database Access From Anywhere
  • MS Access, PHP or MySQL Assistance?
  • Free Access programming tutorial Video 10
  • Microsoft Access Form Design – Video 9
  • Database Design – Video 8
  • Free Access Programming tutorial Video 7
  • Free Access programming tutorial Video 6
  • Free Access programming tutorial Video 5
  • Free Access programming tutorial Video 4
  • Free Access programming tutorial Video 3
  • Free Access programming tutorial Video 2
  • Free Access programming tutorial Video 1
  • Need Help? Click And Call LoeblCom Services

    If you’ve been helped, consider giving us a tip. Thanks!






    ($5 suggested amount)

    (…10% of your gift amount will go to charity)


    Testimonials from some of those helped by this site:

    I have been through the VBA training videos, I like very much.

    Thank you very much for you thoughts for training free of charge…

    Thanks Erik

    Regards

    Kalyana



    Hi Mr. Erik,

    Every thing is ok. I would say that you have done a wonderful job. I pray to God that may HE bless you and guide you to the RIGHT PATH and expand your
    knowledge more for this service you have done for humanity.

    Thanks much for educating me.

    Usman



    Dear Erik,

    … I found
    the 1-10 lessons extremely helpful because you are going through creating
    something from start to finish by experience…I really appreciate your tutorials.

    Thanks,

    Jeremy



    Hi Erik

    Everything is great how it is. The lessons are easy to understand and interesting.
    You’re doing a brilliant job and I’m learning a lot.
    Probably the best video learning resource on the net in my opinion. I’d just like to
    see more videos on any topic regarding Microsoft Access.
    And always look forward to watching when I get an email for a new video link. You
    have so much knowledge about Access. I don’t know how you remember it all.
    … I’m good with GUI design but struggle a bit with VBA and Coding but you’re
    making it easier for me to comprehend things. I really liked your record set and vba
    videos. They were really interesting and I have more of an understanding now from
    them.

    I for one appreciate your work and efforts
    Thanks very much Mate

    Mars – Australia


    Hi Sir,

    Thank you so much for sharing your knowledge freely with the world.Thanks for all I
    enjoy learning Access and VBA through your videos. I found the answers to my worries
    learner in your videos

    God bless you

    Joean – France


    “I watched some of your videos, I think they are great…” – Thanks Emad


    “This site is absolute the best to me. I never knew I could be a programmer on my
    own. I am absolute greatful to Erik Loebl and management.” – Kelvin


    IT IS TOO GOOD, THANX – Aditya


    “Thanks so much, am so grateful…”

    Click Here And Visit Our Store!
    Need Help? Click And Call LoeblCom Services