Archive for September, 2012


VBA Debug Part 2

In this video I talk about VBA Debug aspects like the Immediate Window, Local Window and Watch Window. …also we use the “debug.print” statement to print a value to the Immediate window. The Local Window is useful to view the current state of all the variables present in the current sub procedure. The Watch Window […]

Read More...
Click Here And Visit Our Store!

Helpful? Consider giving us a tip. Thanks!

($5 suggested amount)
(...10% of your gift amount will go to charity)










Need help? Click and Call LoeblCom Services

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: 1 << VBA Variable Scope | VBA […]

Read More...
Click Here And Visit Our Store!

Helpful? Consider giving us a tip. Thanks!

($5 suggested amount)
(...10% of your gift amount will go to charity)










Need help? Click and Call LoeblCom Services

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 Validation – PT2 (explained)

In my video called “MS Access Validation – PT2”, I used a lot of controls and went through them really quickly, I couldn’t show completely what was going on in the design or where I found some of the settings I used. This video explain better. Watch it now! You can get the VBA code […]

Read More...

MS Access Validation – PT2

Table & form validation rules can be set at the table level or form level. Use the power of the database to manage your form validation. Why spending time coding something that the database can already handle for you? Remember that a validation rule created at the table level is available to all the forms […]

Read More...

MS ACCESS FORM VALIDATION – PT1

Get all the videos in this Access VBA collection 100% FREE by signing up at http://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...

MS ACCESS FORM OBJECTS – PT3

Get all the videos in this Access VBA collection 100% FREE by signing up at http://vbahowto.com/ms-access-tutorial In this video I talk about the “With” Statement, and 2 DoCmd methods, DoCmd.OpenForm and DoCmd.OpenReport There are many arguments for the OpenForm and OpenReport methods I will elaborate on at the blog, http://vbahowto.com This is part 3 of […]

Read More...

MS ACCESS FORM OBJECTS – PT2

Get all the videos in this Access VBA collection 100% FREE by signing up at http://vbahowto.com/ms-access-tutorial In this video I continue to talk about ms access form object items as I demonstrate how to set control values. I also will show how to reference ms access form object items. This is part 2 of a […]

Read More...