MS Excel VBA

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

Excel VBA Read Text File

So how can you import the contents of a csv or text file into your Excel worksheet: Find out:

Click here for the file: VBA Read Excel File.zip

Continue Reading

VBA Read Excel File

Here is a question I received “Thanks for the video, I have a question.How to read from a group of closed excel files searching for a certain value in say column F then if that value is found then copy that row to a workbook and continue search for then next value ” So I […]

Continue Reading

Create A Report Based On Items Selected In Access Combo Box

You can download the database here: Click here for the database and the code: Create-A-Report-Based-On-Items-Selected-In-Access-Combo-Box.accdb If you have a suggestion for a future video, contact me on my contact form, and I will seriously consider it.

Continue Reading

Resolution – VBA Error 49 – Bad DLL Calling Convention

So everything in this particular database was working for a client of mine, until just last night I get notified that he can’t open the database because of some error. I was able to view his screen using T.V. and after clicking on a command button, I would get the following error: “Error 49 – […]

Continue Reading




 

Call Erik Now