01 – Switchboard Forms
In this series of posts, we will be taking a look at how you can use switchboard forms to help navigate around your database and to improve efficiency. What is a Switchboard Form? It might be better to ask the…
Month April 2014
10 – Recordsets
In this post, we will be taking a look at Recordsets. Strictly speaking a Recordset is an object available to VBA and Access that encapsulates the functionality and code necessary to interact with the Jet Database Engine and any other…
09 – Loops
In this post, we will be taking a look at Loops. A loop is a block of code that executes again and again until either an expression equates to false or is broken by way of an Exit statement. What…
08 – Arrays And Collections
In this post, we will be taking a look at Arrays and Collections. Computing is all about sets of similar looking data; appointments, files, pictures, addresses, UDP packets, tracks, database records, patient records, library records, lots of records. These different…
07 – Conditionals And Branching
In this post, we will be taking a look at Conditionals and Branching. The ability to use conditionals and branching constructs in MS Access is vitally important. They will enable you to make decisions based on the values of variables…
06 – Debugging
In this post, we will be looking at Debugging in VBA. Debugging refers to the act of removing errors from your code and is absolutely vital if you want to write effective code. List of topics covered: Break on Unhandled…
05 – Functions, Sub-procedures And Arguments
In this post, we will be looking at Functions, Sub-Procedures and Arguments. In order to master VBA, you will need to know how to use and find VBA’s built in functions. And if you can’t find the function you are…
04 – Events
In this post, we will be looking at events and how mastering them can help you to write better, more functional code. List of topics covered: Form and Report Events Related Objects How to create an event in the VBA…
03 – Data Types, Variables, Constants and Operators
In this post, we will be examining Data Types, Variables, Constants and Operators. Working with differing types of data is an essential skill in VBA and one that is necessary in order to write efficient code. List of topics covered:…
02 – Objects, Properties and Methods
In this post, we will be looking at objects, properties and methods in VBA. VBA is an object based language and can interact seamlessly with Access objects (along with objects from other Office programs such as Excel and Word). In…
01 – The VBA Editor
In this post, we will be examining the VBA Editor and taking a look at its various facilities to aid with coding. The VBA Editor is what we use to enter VBA code for Forms, Reports, custom functions and more.…
