MS Access

Simple Access Audit Trail In VBA

. Do you need to track who is making changes to your company records? Sometimes you want to go back to the person who changed a record, and find out why they did it? They had some reasoning behind why they made such a change, but you don’t know. Well, in this post I am […]

Continue Reading

QBE – Query By Example Grid – Calculated Field

This post is actually the response to a question I received on one of my videos: Thanks for the help. question: how can I add a calculated field to speech using your code? I’m new Video: https://www.youtube.com/watch?v=rtlswEIQYS0&lc=UgxUoxYnDL-DF1t4R2V4AaABAg I would suggest that you not add a calculated field in your table. Yes, I know Access allows […]

Continue Reading

How To Find Which Table Is Causing Your Access Database To Be So Big

Some of you, like me, sometimes have the question of “what is causing my Access database to be so big!” As you may or may not know, the database’s tables are the only objects which store the data. It’s very frustrating not to know, and just to try and look smart by saying the generic […]

Continue Reading

Controlling Program Flow

Controlling program flow in VBA or in any other language is directing program activity based on the user’s input, result of some logic, or actions that are performed. You can selectively perform tasks, and respond to different situations. To this end, I will be demonstrating the following 2 control structures: 1. If Structures -If…Then -If…Then…Else […]

Continue Reading

What Is Microsoft Access Used For?

To those of you who are asking the question of “What is microsoft access used for?” , here is my opinion. I’ve been using this program for well over 15 years, and it’s become fairly easy to deal with. Many people feel that it is hard to work with, but that’s not my experience anymore […]

Continue Reading

How To Make An Access Select Query

Hi everyone, This is not really a VBA item, but it’s important and you will need to understand this concept when you are creating your SQL statements in VBA. In our example we have a table called “Customers”: Now we just want the customers from “London”. So we set up a select query to select […]

Continue Reading

VBA Access Database Update For Developers – 64 bit

For a client I am currently doing work for, we have a mixture of Access versions. Both versions are Access 2016, but one version is 32 bit, and the other is 64 bit (Office 365 version). Whenever a new version of the database is released, the users can click a button to upgrade the database […]

Continue Reading

Docmd.OpenForm With Multiple Parameters

Hi everyone, I received a question as a result of one of my other posts: How To Open A Form To A Specific Record In Access 2016 VBA please help me. i’ve been trying to solve this problem but didn’t success. how to open a specific record in access 2016 with two conditions? for example […]

Continue Reading

How To Do An Access Export To Excel In VBA

In this post, we are going to do an Access export to Excel, and you’ll see the VBA we’ll work with. This Excel automation will create a worksheet for each of our data points, and then enter the row items for that data point. We are going to let Access do most of the querying […]

Continue Reading

Field Inspection App In MS Access

Today, we will consider how to track field inspections, by building a framework for a field inspection app in MS Access. This sample application is just a framework, and just shares some potential ideas. You can customize it and put your own “spice” on it. Here’s what it will look like when we’re done: First […]

Continue Reading