Monthly Archives: April 2014

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 question “what are navigation forms”, first. Having lots of great looking forms and reports is […]

01 – Many-To-Many Relationships Review

Understanding many-to-many relationships is critical to creating a database that doesn’t suffer from issues such as data redundancy, inefficiency and bloat. In this series of blog posts, rather than focus too much on what many-to-many relationships are, we will be taking a practical look at how they can be implemented in an Access database. Knowing […]

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 data source available via ODBC.  In simple terms it lets you play with data held […]

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 makes loops useful is that they can work with arrays and collections, they can perform […]

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 data structures inside our programs, computers, hard-drives and memory will be stored as repeating rows […]

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 and act accordingly. Coding wouldn’t be possible without them. List of topics covered: If…Then, Evaluating […]

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 Errors Breakpoints Debug Control Bar Immediate Window ? and Debug.Print : to concatenate commands ; […]

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 looking for? Well, you will have to write one yourself. List of topics covered: What […]

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 editor Forms, Controls and their events Mouse Events Form Events Recordset Control Events OnTimer Events […]

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: Variables Declaring variables Dim Restrictions on naming variables Naming Conventions Constants Variable Scope Arithmetic Operators […]

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 the physical world objects are things like tables, cars and people and in the VBA […]

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. In fact all Microsoft Office applications (Word, Powerpoint, Excel, Outlook) use the same VBA Editor, […]