admin
VBA Error Handling PT1
In this VBA Error Handling set (1 & 2) we’ll talk about: Trapping run-time errors Creating error handlers Using the error object There are 3 main types of VBA Errors: 1. Syntax Errors 2. Logic Errors 3. Run-Time Errors Syntax errors result when the logic is misspelled, or a wrong keyword is used. The VBA […]
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 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 […]
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 […]
Database Access From Anywhere
How can you develop a database you can access anywhere? How can I develop a worldwide platform for my database? You can get register your domain with Godaddy and then host your domain with someone like HostGator. Here is a link to use to HostGator (get started with a penny!): HostGator Build your webforms in […]
MS Access, PHP or MySQL Assistance?
Need some advice with getting your project started? Maybe some direction? Whether it is a desktop application using Access, or a PHP, MySQL web application, let me know your conundrum below and I possibly can be of service to you. The advice won’t cost you anything. It will help you out and probably help someone […]