In the previous post, we looked at how we can generate multiple many-to-many relationships for a single table. In this post we are going to be giving you an alternative to many-to-many relationships that will produce the same result.
In the previous post, we looked at how we can actually implement a many-to-many relationship in a database in a way that makes it simple and, crucially, logical to enter data. As stated, there is little point in understanding how…
In the previous post, we demonstrated a simple way in which developers can get into trouble whilst data modelling. We had to create a many-to-many relationship between Films and Actors which involved creating a linking table and utilising two one-to-many…
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…
One of the best things about working with MS Access is the ability to use global variables, functions and procedures. This means that we are able to call globally declared code from anywhere within the application and is very useful…
In this post we will be demonstrating how you can instantiate your newly create clsFilms class module from the Form.
In this post we will be giving you the code you need to Create, Update and Delete records through a Class Module.
In this post we will be adding properties and get/let methods to the class module.
In this post we will be showing you how to create an unbound form.
In this post we will be demonstrating how using class modules can make your arrays more functional and easier to read! In the first post we explained how class modules change the way you think about programming. You are now…
What is a class module? A class module is a group of code that allows you to create objects and utililise them in your application. What? OK, a class module is a fancy way of writing code. Better. But why…
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 this post, we will be demonstrating how to use a report as the basis for the text in the body of an email.
In this post, we will be looking at how to send an Access report as an attachment.
In this post, we will be demonstrating how to send an email from Outlook without showing Outlook.
In this post, we will be looking at how you can add attachments to your emails.
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…
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…
In this post, we will be giving you the basic code required to open up Outlook from Access and set the subject and body fields.
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…
Structured Query Language (SQL) In a previous post, we looked at some of the core concepts behind relational databases and how data should be organised to avoid some of the pitfalls of database design such as repetition and redundancy. In…
In this post, we will be taking an in-depth look at data-modelling and how best to solve some common data-modelling problems. What is Data-Modelling..? The simplest definition of data-modelling is that it is the act of deciding what table structure…
In the previous few posts, we have covered different ways to retrieve information from Excel and get it into Access. In this post, we will be discussing some of the pros and cons of using Excel to cart your data…
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,…
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…
In this post, we will be showing you how to use the built-in features of Access to import an Excel file into an existing table in an MS Access database.
In this post, we will be showing you how to use the built-in features of Access to import an Excel file into an Access database as a new table.
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…
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…
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…
