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 post, we will be showing you how to call a function from a Swtichboard. Being able to call code from a Switchboard is very useful as it gives us the flexibility to determine how we open our forms…
In the previous post, we showed you how to create multiple Switchboard Pages. In this post we will be showing you how to use Macros with your Switchboard Form.
In the previous post, you learned how to create a simple switchboard that allows you to open up different forms. In this post, we will be showing you how to create multiple switchboard pages, giving the effect of having multiple…
In this post, we will be showing you how to create a simple Switchboard form that you can use to open up forms.
In this video we will be showing you how to use barcodes in MS Access.
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…
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…
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…
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…
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…
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…
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…
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…
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:…
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…
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 this post we will be introducing VBA and the Access Integrated Development Environment. To really take Access to the next level, you will need to learn VBA and how it underpins a lot of what takes place in MS…
In this post we will be looking at more advanced concepts in queries. We will be examining different join types and introducing action queries. List of topics covered: Table Joins Returning Null Values Cartesian Product Action Queries Append (Insert) Delete…
In this post we will be examining Macros and how you can use them to automate your application. Macros are an important part of MS Access as they enable you to quickly and easily add functionality to your database. Read…
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…
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…
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…
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…
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…
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…
In this post we will be looking at the Data Modelling and Normalisation. We will be looking at the way data is handled by Access and the how you should be breaking your data down into tables and relating them.…
In this post we will be giving some thought to designing an Access application with SQL Server in mind.
