MS Access VBA How To – Free Tutorial Reference

Click if you need help now.
  Click here to learn how to put your MS Access database on the web.


Free MS Access VBA Programming Course

Make sure you sign up for this now:


Free Help!
Here is a list of categories you’ll find helpful…
VBA Message Box How To’s MS Access Query How To’s MS Excel VBA How To’s MS Access Forms How To’s VBA Procedures How To’s VBA Input Box How To’s VBA Instr Function How To’s
Access VBA Recordset How To’s VBA For Loop How To’s VBA Do Loop How To’s Security How To’s
Welcome to vbahowto.com! We hope you find the information you need!

If you need help on something you can’t find, Click here to ask it on our contact form.

Free VBA Helps:


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)

Title
How To Escape Apostrophe In SQL Update Query2024-04-23 23:56:08
How To Make An Access Form Time Picker2024-04-19 19:28:14
How To Parse A Flat File In Excel VBA2024-04-10 22:11:30
How to pick a file to load In VBA2024-04-09 19:52:24
What is the purpose of the Me keyword in Access VBA?2024-04-08 17:55:53
How do I handle errors in Access VBA code?2024-04-01 18:57:57
How can I interact with other Office applications (Excel) using VBA in Access?2024-03-29 17:34:46
How To Create A Parameter Query In Access2024-03-16 18:14:59
How do I run VBA code when form opens2024-03-06 00:12:50
Simple Custom Progress Bar in Microsoft Access Forms Example2023-01-23 20:50:41
What Is Microsoft Access Used For?2020-11-04 20:15:58
Joke: Debugging Definition2020-11-04 20:07:56
How To Exit A VBA Loop2020-11-04 07:57:48
How To Make An Access Select Query2020-11-03 19:41:07
How To Generate A XML File With Access VBA2020-11-03 07:29:07
Mouse Click Counter On Access Form2020-11-02 19:23:17
Find Error Line Number in VBA With Erl2020-11-02 07:09:50
How To Open A Form To A Specific Record In Access 2016 VBA2020-11-01 19:03:53
How To restrict user logon to specific computers2020-11-01 06:49:21
Shared Access Database Management2020-10-31 18:28:42
Access To PHP MySQL Tutorial2020-10-31 06:16:46
Access Database Users And Permissions Example2020-10-30 18:04:53
VBA MS Access Form Filter Example2020-10-30 05:44:05
MS Access Object Security2020-10-29 17:33:35
Here Is A Customized Msgbox VBA Example2020-10-29 05:26:55
How To Use A Variable In A VBA Message Box.2020-10-28 17:20:33
How To Make A VBA Msgbox Yes No2020-10-28 05:00:45
VBA Msgbox New Line Example2020-10-27 10:42:38
Here Is An Example Of The VBA Trim Function2020-10-26 22:39:46
How To Use The VBA Input Box Cancel Button To Exit Sub2020-10-26 10:33:56
How To Search A String With The VBA Instr Function2020-10-25 22:21:25
How To Make An InputBox In VBA2020-10-25 10:13:30
Bringing A 300+ Column Excel File Into Access2020-10-24 22:12:14
How To Return A Dollar Value As A Text String2020-10-24 10:03:12
Access Pagination2020-10-23 21:46:59
MS Access Hiding Text Boxes Based On User Selection VBA2020-10-23 09:41:45
How To Write A Recordset To File With VBA2020-10-22 21:31:19
VBA Building Dynamic SQL2020-10-22 09:14:04
Excel VBA Read Text File2020-10-21 21:12:03
VBA Read Excel File2020-10-21 09:06:18
MS Access Form Calculation On Checked Items2020-10-20 20:51:18
How To Have MS Access Increment A Number Without An Autonumber VBA2020-10-20 08:24:25
How To Use 2 Access Checkboxes Update 1 Field2020-10-19 20:16:02
VBA Debug Part 22020-10-19 08:12:19
MS Access Validation – PT2 (explained)2020-10-18 19:56:45
MS Access Validation – PT22020-10-18 07:50:28
Access Forms – Access Default Value2020-10-17 19:44:47
MS ACCESS FORM OBJECTS – PT32020-10-17 07:31:58
MS ACCESS FORM OBJECTS – PT22020-10-16 19:09:03
MS ACCESS FORM OBJECTS – PT12020-10-15 18:39:51
MS Access VBA Control Events – PT32020-10-15 06:22:19
MS Access VBA Control Events – PT22020-10-14 17:59:04
How To Connect Access To SQL Server On Amazon Virtual Machine2020-10-14 05:54:24
MS Access VBA Control Events – PT12020-10-14 05:54:24
MS Access Form Events – PT12020-10-13 17:42:47
MS Access Form Events – PT22020-10-13 05:42:05
How To Do A VBA CSV Import For One To Multiple Files2020-08-28 05:13:49
VBA Access Database Update For Developers – 64 bit2020-08-24 19:25:34
MS Access VBA Form Filter Example2020-07-22 05:54:13
How To Add Images To tblBinary2020-07-09 18:12:43
How to get the images out of tblBinary2020-07-09 05:54:19
How To Use The Value Of A Hidden Combo Box Column2020-07-08 17:07:40
How To Highlight The Current Row In A Continuous Form In 3 Steps2020-07-08 05:00:43
Peoplesoft To SAP Migration Via Access2020-07-07 10:42:57
How To Declare A Variable With VBA Dim2020-07-06 22:32:10
How To Restart A VBA Loop Counter2020-07-06 10:21:56
Docmd.OpenForm With Multiple Parameters2020-05-30 17:34:47
How To Do An Access Export To Excel In VBA2020-05-18 19:19:23
Field Inspection App In MS Access2020-05-08 21:11:33
How To Have Access Export A Table To An Excel XLSX In VBA2020-05-05 19:31:11
How To Send Email With Access And Outlook VBA2020-04-28 19:27:58
How To Use VBA To Extract Outlook Emails To Access Table2020-04-22 18:44:47
Error In Loading DLL And DAO DLL Download2020-04-22 17:14:03
What Is The Access VBA NZ Function2020-02-29 18:18:47
How To Use Access VBA To Copy A Table With DoCmd.CopyObject2020-02-28 22:02:55
An Easy VBA Counter2019-10-23 22:59:30
Why Does My Query Change Like To Alike?2019-10-09 19:54:19
Access VBA Create Table (Simplified)2019-09-12 22:26:19
MS Access FilterOn Error (Solution)2019-09-12 20:20:46
How To Find Certain Files In VBA2019-08-15 23:11:16
How To Identify The Last Row Worked On (VBA Variable Scope)2019-08-05 22:47:14
How To Attach Files In An Access Database2019-07-31 20:40:40
MS Access VBA Programming – Responding To User Actions2019-07-09 17:53:46
How To Convert Your Pivot Table To An Access Crosstab Query2019-06-18 18:42:01
Watch How To Run VBA Code In Access2019-06-15 20:04:00
Converting A Excel Spreadsheet To Access Database2019-06-11 22:09:16
How To Search For A Folder In VBA2019-05-29 21:27:59
How To Create A MS Access Dynamic Report Based On A Dynamic Table2019-04-29 22:43:34
MS Access Stock Control Database Pt12019-04-20 04:11:31
How To Run Access VBA On A Timer Schedule2019-03-27 23:07:51
How To Make A MS Access Filter Form With Combobox Using VBA2019-03-21 22:23:16
How To Connect Access To MySQL2019-03-16 19:04:27
How To Create A Table In Access Using SQL And VBA2019-03-12 18:39:25
How To Extract Data From Outlook To Access With VBA2019-03-02 20:39:21
How To Have Access VBA Link Tables Programmatically2019-02-25 23:37:40
MS Access Subform Navigation Buttons2019-02-16 03:34:52
MS Access Running Count With String Column And Duplicates2019-02-14 18:42:57
MS Access Running Count With Duplicates2019-02-13 17:57:42
How to programmatically create an Access DSN2019-02-12 00:09:04
How To Create Dynamic Combo Boxes In Access2019-02-04 21:37:31
How To Do A VLookup In Access2019-01-28 20:06:47
How to setup cascading comboboxes in datasheet subform2019-01-27 22:50:19
How do I create a query between two dates in Access?2019-01-23 19:45:10
How To Make An Access Report Based On Form Inputs2019-01-22 18:55:24
How To Embed A YouTube Video In Access Form2018-12-10 18:42:45
How To Add A MS Access Custom Ribbon2018-10-25 22:36:39
How To Determine If A User Clicked The Cancel Button On VBA Input Box2018-10-22 17:25:00
Video: Access report parameter with date range2018-10-20 20:28:11
Use This Tool To Find Your Website Rank In A Google Search2018-10-11 15:50:50
MS Access VBA Basics – Video 12018-09-18 16:31:54
How To Calculate Date Intervals With VBA DateAdd2018-09-15 18:10:08
How To Make A VBA Message Box OK Cancel2018-06-15 23:59:56
How To Make A VBA Message Box Yes No2018-06-14 17:15:59
How To Make A VBA Message Box2018-06-14 16:49:31
Client Side Storage Access And WebSQL Database Part32018-06-06 16:58:09
Client Side Storage Access And WebSQL Database Part22018-06-04 20:02:52
How To Create A Local Web Page With Access DB Data PT12018-06-02 16:11:26
How To Integrate Access With An HTML Page2018-05-23 17:34:19
MS Access Incrementer/Counter2016-12-13 21:08:56
File Open Shell VBA2016-11-24 20:30:47
Create A Report Based On Items Selected In Access Combo Box2016-11-22 21:34:40
Access Parameters Using TempVars2016-10-07 17:58:37
Access 2010 Ignoring Open Of ADP File2016-04-22 18:57:21
How To Set Up Relational Database2015-12-30 23:17:26
MS Access Beginner To Advance Propulsion2015-04-27 14:24:11
Resolution – VBA Error 49 – Bad DLL Calling Convention2015-04-10 14:03:10
MS Access VBA – How To Add A ‘Select All’ Option To A Combo Box2014-09-06 20:10:22
How to create SQL Statement from Combobox Selections2013-09-10 22:53:50
How To Convert Macros To VBA2013-09-09 03:55:49
Converting a macro into VBA code2013-09-06 14:27:27
MS Access Running Counter In Query2013-09-02 02:06:08
MS Access Option Group QA2013-08-27 03:27:29
Access Report Parameters2013-08-24 21:27:18
VBA Move File2013-08-24 02:10:07
Access VBA Create Table2013-08-23 03:55:42
MS Access Login Form Revised2013-08-22 04:06:02
Being More Specific In Access Import2013-08-21 03:45:40
Shell VBA function2013-08-19 18:36:48
Access Import Of Spreadsheet Or Table2013-08-19 18:12:05
How Do I Import An Excel Spreadsheet2013-08-17 02:14:09
Microsoft Access IIF Function2013-01-01 01:27:08
VBA Calculate – Multiply2012-12-31 20:37:13
MS Access Option Group2012-12-29 18:01:41
MS Access SQL2012-12-27 17:53:23
How To Make A MS Access Login Form2012-12-14 23:14:43
How To Make An Access Timer2012-12-14 21:23:34
Passing Form Field Default Values2012-10-15 02:18:00
Recordset In VBA – PT42012-10-11 17:27:18
Recordset In VBA – PT32012-10-11 17:24:37
Recordset In VBA – PT22012-10-11 17:22:35
Recordset In VBA – PT12012-10-11 17:20:12
VBA For Loop2012-10-05 04:02:36
VBA Do Loop2012-10-05 03:59:37
VBA Error Handling PT22012-10-03 03:30:45
VBA Error Handling PT12012-10-02 18:44:38
VBA Debug Part 12012-09-29 19:43:14
A Variable Scope2012-09-26 04:15:59
How To Make A VBA Function2012-09-24 00:17:08
MS ACCESS FORM VALIDATION – PT42012-09-22 21:57:39
MS ACCESS FORM VALIDATION – PT12012-09-18 04:14:49
VBA Form Object Event Procedures2012-09-02 00:37:59
VBA Event Driven Programming2012-09-01 23:42:40
Database Access From Anywhere2012-08-23 18:44:46
MS Access, PHP or MySQL Assistance?2012-06-25 15:41:44
Free Access programming tutorial Video 102012-04-22 21:30:14
Microsoft Access Form Design – Video 92011-11-08 03:51:39
Database Design – Video 82011-11-08 03:50:09
Free Access Programming tutorial Video 72011-11-08 03:46:23
Free Access programming tutorial Video 62011-11-08 03:44:15
Free Access programming tutorial Video 52011-11-08 03:40:19
Free Access programming tutorial Video 42011-11-08 03:37:42
Free Access programming tutorial Video 32011-11-08 03:27:57
Free Access programming tutorial Video 22011-11-08 03:23:09
Free Access programming tutorial Video 12011-11-07 00:28:22
Donors And Donations Lesson Guide MS Access Training Video Set Customers And Orders Lesson Guide
Click image to take a look at our latest resources to help you learn VBA!…
Click Here And Visit Our Store!
If you just need the database, search for the title of the video by using the CTRL + F (Find) functionality of your browser. 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!

How can I help you?

ejl_pic [si-contact-form form=’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…”

whatispifullnumber.com

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




By the way, if you got or are getting value from the VBA information, please give me a tip, thanks!