Sometimes it is necessary to export a table to create a backup, share data with a team member, or whatever... Here is how you export a table using the File Dialog object in Access with VBA. This example will work in Access 2007 - 2013. UPDATE 02/16/2015: Added reusable code for file save-as dialog box. Create a new module or add the following code to an existing … [Read more...] about File Dialog Save-As in VBA Export Table by Name | Microsoft Access
access 2013
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