admin
How to get the images out of tblBinary
The custom ribbon uses the tblBinary to store images, but how do you get them out, if you want to use the nice images again for something else like a webpage toolbar? How to get the images out of tblBinary Well this code will loop the tblBinary table and save each image to the specified […]
How To Use The Value Of A Hidden Combo Box Column
So I had a question come my way regarding some form operations. It will probably help someone else, so I am going to let you know how I did it. Basically it had to do with setting 2 other form controls based on the first. Here is a picture: The table data is a simple […]
How To Highlight The Current Row In A Continuous Form In 3 Steps
Somebody asked this question, and so I wanted to show how to do it here. It is really simple. As you may know, when you change the color for 1 row in a continuous form, every row will be affected! Not like Excel. So how do you fix this? Glad you asked…with VBA and conditional […]
Peoplesoft To SAP Migration Via Access
I received an interesting question yesterday from a potential customer. They are migrating all their Oracle PeopleSoft data to SAP. (They are exporting from PeopleSoft into Excel, importing it into Access to tweak it, and exporting to csv from Access to upload to SAP) Basically, how to take 1 (PeopleSoft) row and make it into […]
How To Declare A Variable With VBA Dim
To declare a variable, means to allocate a portion of the computer’s memory to hold the contents of that variable. “Dim” means “Dimension”, or “allocate a portion of the computer’s memory.” “Dim intNumber As Integer” – means that we need the computer to allocate 2 bytes of the computer’s total RAM memory to hold a […]
How To Restart A VBA Loop Counter
This is related to an interesting question I received from an individual, and this processing example may help someone. Basically we are conducting a 10 day clinical study on a group of patients. We want to store the results of the finding in a database and reset the study counter when a result comes back […]
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 […]
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: […]