I also wasn't sure how to word the title, but it seems to make sense. This is a very short post as this is pretty simple. When reporting out on data, there is the possibility that at some point, a report request will call for a count of items by group. I wanted to make this example as simple as possible. To keep it simple, I designed a table with first names(FirstName) and … [Read more...] about How to Count by Item With SQL | Group By Query MS Access
Microsoft Access
Import Excel File to Access 2010, 2013 With File Dialog in VBA
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, I save a ton of time, my results are accurate, … [Read more...] about Import Excel File to Access 2010, 2013 With File Dialog in 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 one result, for instance a count query. Here is an … [Read more...] about Access 2010, 2013 VBA Run SQL Return Results
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 and 2013 on personal development PC. This works on both. For this … [Read more...] about How to Display SQL Query Data with Listbox in Access 2010 with VBA
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. UPDATE 05/22/2015: The function below contains an error handler and works well if your … [Read more...] about Select or Open a file in VBA with file dialog | Access VBA