Archive for September, 2012


VBA Debug Part 1

In this video I talk about VBA Debug aspects like setting breakpoints, viewing the current state of variables, and stepping through code. …as well as: Set breakpoints to stop program execution. Test variables in the immediate window. Monitor variable values in the Locals window. Here is the video: Private Sub btnValidate_Click() If IsEmailAddress(Me.txtEmail) Then MsgBox […]

Read More...

A Variable Scope

Key points: A private procedure can be called from any procedure in the same module. The default scope for a sub procedure is “Public” unless you specifically designate it as Private. Store all your procedures and functions you plan to use in your application in “Modules”, which you can call from your other database objects. […]

Read More...

How To Make A VBA Function

This video will cover the following: –How to call built-in and custom vba functions in an application. –How to create a custom vba function. Here’s the video: There are 2 types of functions, “Built-in” and “Custom” functions. Buit-in functions are functions Access provides. Custom functions are vba functions you create because Access doesn’t provide a […]

Read More...

MS ACCESS FORM VALIDATION – PT4

In this video we will cover VBA validation functions like: Validating Text Strings Check the string for null values. IsNull function Check the length of a string. Len Function Check the presence of characters present in a string. InStr function Inpect a portion of a string. Left, Right, Mid functions Removing the leading or trailing […]

Read More...

MS ACCESS FORM VALIDATION – PT1

Get all the videos in this Access VBA collection 100% FREE by signing up at https://vbahowto.com/ms-access-tutorial In this video I talk about: ms access text validation validation rule access input mask in access an input mask validation in access microsoft access table Here is the video: Data validation is a useful method to guide users […]

Read More...

VBA Form Object Event Procedures

In this video I talk about how to program vba object items like the access form . Specifically we look at the Access Form Open Event, and add a password prompt in the open event of the form. Also we will look at controlling the Cancel Open Event of the form. Private Sub Form_Open(Cancel As […]

Read More...

VBA Event Driven Programming

In this video I demonstrate the Procedural/Application programming difference. We’ll cover Access form events: Creating An Event Procedure Reacting To User Actions Programatically Using the DoCmd Object Program Flow Frame and Option Button Events Command Button Events Drop Down Box Events (Click here for the Navigating Records part.) << Free Access programming tutorial Video 10 […]

Read More...