I have been working with a lot of excel spreadsheets lately. In most cases, I have found that the most simple approach has been to load spreadsheets into Access tables and slice/dice data with SQL queries. I have one spreadsheet in particular that is standardized and updated daily. By quickly loading and running saved queries, […]
Vba
Access 2010, 2013 VBA Run SQL Return Results
Sometimes when developing automation with VBA in Access, it is important to return results from a SQL query string. For simplicity, all examples have been written as Functions. Please feel free to modify as needed. Recordset Selection in VBA | Select One Record There are many reasons why a developer would want to return only […]
How to Display SQL Query Data with Listbox in Access 2010 with VBA
Sometimes I like to use the listbox control in Access to display information. Partially because I like the look of it and partially because it offers up a better user experience. You will note that the title references Access 2010 where my screenshots see were taken in 2013. I use 2010 on my work computer […]
Select or Open a file in VBA with file dialog | Access VBA
In a recent project, I was tasked with designing a program in Access where an end user could import a spreadsheet, run a sub routine in VBA and export the results. As part of the user experience, I wanted the end user to be able to select the input spreadsheet with the file dialog tool. […]
How to Count Records in VBA | Microsoft Access 2010
In a recent program that I wrote, I needed to store a count of records from a query in a variable. Since VBA and Access isn’t as intuitive as say connecting to a MySQL database with PHP, I thought I would share. Function recordCount() Dim rs As DAO.Recordset Dim db As Database Dim strSQL As String […]