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 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…
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…
In this video we will be showing you how to use barcodes in MS Access.
In this video blog I will be showing you how to password protect the back end of a split database.
In this video blog I will be showing you how to dynamically update a combo box based on the selected value in another combo box.
In this video post I will be explaining how to create a hyperlink on a form that opens up another form.
In this blog post we will be showing you how to update, add and delete records in a recordset. Please download Updating, Adding And Deleting Records Updating A Recordset DAO Sub DAOUpdating() On Error GoTo ErrorHandler ‘This sub-produre will add…
In this blog post we will be demonstrating how to loop through a recordset. Recordsets act like a cursor or a ruler underneath a row of data. They only operate on one row at a time so to access the…
In this blog post we will be introducing recordsets and providing some examples of their use. So, what is a recordset? You can think of a recordset as a table or query that we can utilise (read, update, delete, insert)…
