Author Archives: Robert Austin

08 – Standalone Data Macros

In this post, we will be taking a look at standalone Data Macros. We know that you can tie data macros to table events but did you know you can create a data macro that isn’t tied to anything? The idea is to create a reusable table level resource that can be called from events […]

07 – Introduction To Data Macros

In this post, we will be introducing you to Data Macros in Access 2013. Data Macros enable you to create events that fire when an action is performed on a table (insert, update, delete). These Macros allow you to keep your business logic in one place and means that you won’t have a disparate series […]

04 – Adding Data

In this post, we will be adding seed data to the application and finding out how it all fits together . . . In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

05 – Excel Automation (Advanced Code)

In the previous post, we gave you some code to import from Excel into an existing table. That code is absolutely fine for most circumstances but we thought you might like to improve on it a little… In this post, we add the ability to select your Excel file using a File Picker and a […]

04 – Excel Automation (Standard Code)

In this post, we will be showing you how to use VBA to import from an Excel file. Although Access comes with built-in importing functionality, sometimes you will want extra control over how the data is being imported. You might not want to import data into one single table or you may wish to convert […]

01 – Excel Importing – Introduction

The ability to import data from Excel is a very useful feature of the Office suite. Access has its own in-built importing capabilities but sometimes these are not enough and we require VBA to give us more control over the process. In this series of posts we will be taking you through the basics of […]

Database Functions

In this post, we will be taking a look at Database Functions (D-Functions) and providing some examples of their usage. Database Functions are an extremely useful feature in MS Access. They allow you to make quick queries of the database without having to write complicated SQL or open up recordsets and can help you to […]

Logical Operators

Logical Operators Logical operations work with Boolean expressions to yield an answer for expressions. Individually they are quite straightforward but can be combined to create complex expressions. And Operator The And operator requires 2 Boolean values, gives a True answer when both sides of the argument are also True, otherwise False. A logic table demonstrates […]

Multidimensional Arrays

Multidimensional Arrays In Access it is possible to create an array with more than one dimension. Dim myIntegerArray() as Integer ReDim myIntegerArray(7,52) In the above code, we tell Access to create an array of 364 elements (7×52). In the code below, we create a 3×5 array, fill certain elements with values and print it to […]

Emailing 9 – Using Lotus Notes

In this post, we will be providing you with a script that you can use, if you have Lotus notes as your preferred emailing option. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

Emailing 4 – Using The CC and BCC Fields

In this post, we will be showing you how to use the CC and BCC fields. Why BCC? The BCC field means Blind Carbon Copy and is very useful if you want to send multiple emails at once but you don’t want the recipients to know who else received the email. In order to view […]

Emailing 3 – Reading Email Addresses From A Table

In the previous post, we introduced the fundamental code associated with opening Outlook from Access. In this post, we will be showing you how to manipulate the “To” field of the email so you can send emails to multiple email addresses. In order to view the rest of this content you will need to register […]

Emailing 1 – Introduction

An important but often unknown feature of MS Access is the ability to utilise Outlook to send emails. Outlook is the email client of choice for many people and for those with the full Office suite, it makes sense to make full use of its capabilities. MS Access, as a data repository, is the perfect […]