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: […]
How To Find Certain Files In VBA
Someone wanted to loop through the files in over 100 directories and find a list of their powerpoint files. This code will loop a specific directory and check if a file with a “pptx” extension exists in that directory. If it does, a message box will be displayed. Instead of the message box, the file’s […]
How To Search For A Folder In VBA
The purpose of this code is to tell you if you need to add a folder or not. ***You don’t need to create a new folder for some files if one exists already. This code is helpful if you have hundreds of folders to go through, otherwise if you just have a few, you can […]
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 […]
How To Extract Data From Outlook To Access With VBA
In this post you are going to find out how you can extract data From Outlook to Access with VBA”. Someone at the place I’m working at was let go, and they wanted the information, primarily from the user’s Outlook inbox, to be extracted to an outside application so the particular information about various projects […]
How To Have Access VBA Link Tables Programmatically
This table relinking procedure is a really good example of how to use VBA to link your tables programmatically, and how to have MS Access refresh linked tables automatically. It allows re-linking all tables to a selected drive source (the folder the backend database is in). In this example, all of the tables that need […]
How To Calculate Date Intervals With VBA DateAdd
One of my clients ask me to design a little utility to operate like the Outlook appointment recurrence feature. This the first basic step, so I wanted to share how I did it. I have a basic form where I’ll probably be adding more variables, but the functionality basically works like this: I have an […]
Client Side Storage Access And WebSQL Database Part3
In this post I am showing how you can make your webform more user friendly. Sub GenerateContainmentInspectionsHTML() Dim intRandomDB As Integer Dim intSeed As Integer Dim strDB As String ‘this is seed value for the RND function’s random number generator. Randomize ‘Int ((upperbound – lowerbound + 1) * Rnd + lowerbound) intRandomDB = Int((2500 – […]
Client Side Storage Access And WebSQL Database Part2
In this revised procedure I will create the SQLlite (WebSQL) database to hold the Access query contents and then display them on a web form in a table format. (don’t be concerned with the colors in the following code:) Sub GenerateContainmentInspectionsHTML() ‘HERE YOU ARE MAKING THE DATABASE FOR THE INSPECTIONS Dim intRandomDB As Integer Dim […]
How To Create A Local Web Page With Access DB Data PT1
This is going to be a multiple part blog post, but here I am clicking a command button on a form and then taking the data from a query called “qrySecondaryContainmenttodrain”, and creating a html page called “containment_inspections.htm”. (You will have to modify the query and the html page so it will fit your need) […]