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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]