MS Access

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

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

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

How To Have Access Export A Table To An Excel XLSX In VBA

This was regarding a question I received from this blog: Hello, I am hoping to find some help. I have an Access DB that I use to collect data. I have a number of different reporting features. I would like to add the option for my user to export to excel. When I do this […]

Continue Reading

How To Send Email With Access And Outlook VBA

There are 3 things you probably want to send from your Access application. You probably want to send an Access report or send an attachment(s). 1. Email An Access Report (SendObject) 2. Email An Access Report With Attachments (Outlook Automation) 3. Email With Attachment(s) (Outlook Automation) First, if you are in the database, and want […]

Continue Reading

How To Use VBA To Extract Outlook Emails To Access Table

I use this code to extract outlook emails from a certain Outlook folder of a user (like the user’s Inbox) whenever they leave the department. This code will loop the Outlook Inbox (or other folder) of the logged in user’s Microsoft Exchange Account, and insert the body of the message into an Access table. Note: […]

Continue Reading

Error In Loading DLL And DAO DLL Download

The other day I was doing a database modification for a long time customer, and I was compiling their database, when the compilation failed at a line of VBA code calling for a DAO object. FYI: I originally designed this bit of code for a prior Access version and now they had upgraded to an […]

Continue Reading

What Is The Access VBA NZ Function

The Access VBA NZ function allows you to test for values with zero length. It is unique with Access, as far as I know, no other language has this type of function, and you’ll have to make your own. If you want to check if a variable is blank, you should check the length (contents) […]

Continue Reading




 

Call Erik Now