James Satori-Brunet

James Satori-Brunet

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…

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…

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…

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…

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…

07 – Reports

In this post we will be looking at how to create and manipulate reports in MS Access. Outputs are the main reason that we use databases. They enable us to view summarized data quickly and efficiently and to make critical…

06 – Form Controls

In this post we will be taking a look at form controls. The way in which form controls interact with their parent forms can determine how well your data is validated and presented. Understanding form controls will help you to…

05 – Forms

In this post we will be taking a look at forms and how you can use them in your Access applications. Forms represent the central way in which data can be added to your Access applications and in order to…

01 – The Access Object

In this post we will be looking at the Access Object in detail. We will be examining everything from File Types and Terminology through to the Access Integrated Development Environment and Downloading Templates in order to help you get to…

04 – Basic Queries

In this post we will be examining basic queries and introducing Structured Query Language. We will also be showing you how to make your queries smarter with criteria and how to work with multi-table queries. List of topics covered: Introduction…

03 – Tables

In this post we will be examining tables, data types and primary keys. Being able to manipulate tables is a fundamental requirement of working with Microsoft Access. We will be showing you how to work with different data types, how…

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube