ms-excel-vba
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 […]
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 […]
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: […]
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) […]
How To Convert Your Pivot Table To An Access Crosstab Query
This post is regarding how to convert your Excel pivot table to an Access format. You can also refer to this post for more information: https://vbahowto.com/converting-a-excel-spreadsheet-to-access-database/ Basically an Excel pivot table is an Access crosstab query, so this post goes into more detail of how to make your Access crosstab query look like what your […]
Converting A Excel Spreadsheet To Access Database
While I was scouring the Upwork gigs, one caught my eye, they left an Excel spreadsheet example and so I decide it was good enough to try and recreate it in Access database format. I just couldn’t pass up the challenge on this one. So I figured I wanted to share the journey with you […]
How To Create A MS Access Dynamic Report Based On A Dynamic Table
So in my other post, I demonstrated how to create a table dynamically with VBA. Here’s the post How To Create A Table In Access Using SQL And VBA Now what if we need a report based on a table that is always changing, but is consistent in its format? Well we can send the […]
MS Access Stock Control Database Pt1
I am in the process of converting an Excel spreadsheet into an MS Access database. One of the first questions I asked was, “Are you doing this manually” and “How”. The reason is simple, I don’t want to try and figure out a new way of processing for them. If they are already used to […]
MS Access Running Count With String Column And Duplicates
In my previous post, https://vbahowto.com/ms-access-running-count-with-duplicates/, the DCount counter, works fine when you have a numeric value, and it works fine when you do the VBA counter when you do it on numeric column values, but what about counters on string columns with duplicates? MS Access Running Count With String Column And Duplicates Since an Access […]
How To Do A VLookup In Access
This post is in response to this question: This really doesn’t need any VBA code. It just needs to be setup correctly, and it functions like the VLookup function in Excel. In the image, we want to change the “Unit Price” (“PUnitPrice”) value after changing the the “Product Name” (“OProductID”) in the form. The real […]