• Skip to main content
  • Skip to primary sidebar

Ryan McCormick

Dedicated Dad, Software Engineer and Lover of Coffee

access 2013

File Dialog Save-As in VBA Export Table by Name | Microsoft Access

April 23, 2014 by Ryan McCormick 16 Comments

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

Import Excel File to Access 2010, 2013 With File Dialog in VBA

March 5, 2014 by Ryan McCormick 32 Comments

Import Excel File into Access 2010, 2013 with VBA File Dialog

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

March 3, 2014 by Ryan McCormick 6 Comments

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

February 4, 2014 by Ryan McCormick 3 Comments

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

Primary Sidebar

Recent Posts

  • Force Quit Kill all Chrome Windows MacOS
  • Review: MSP Valet Parking at Terminal 1
  • SOLVED: Angular 6 CLI Karma Stuck in Single Run | Karma Stops Running
  • How to Manually Install Java 8 on Ubuntu 18.04 LTS
  • Remove VirtualBox from Ubuntu 16.04 Xenial

Recent Comments

  • KKV on Webstorm adding spaces between imports and braces | JavaScript and TypeScript
  • jusopi on Clear all Node Modules Folders Recursively Mac/Linux
  • Qaisar Irfan on Clear all Node Modules Folders Recursively Mac/Linux
  • mustafa on Remove VirtualBox from Ubuntu 16.04 Xenial
  • Pourya on How to Manually Install Java 8 on Ubuntu 18.04 LTS

Archives

  • May 2019
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • March 2017
  • December 2015
  • November 2015
  • July 2015
  • April 2015
  • February 2015
  • September 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • October 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • December 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • May 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009

Categories

  • Angular
  • Angular 2
  • AngularJS (1x branch)
  • Computer Q&A
  • ES2015
  • Internet Marketing
  • Javascript
  • Job Interviews
  • Job Search
  • Karma
  • Laravel
  • Linux
  • Linux/Unix Tips
  • MacOS
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Word
  • News
  • Node
  • Open Source
  • PHP
  • Protractor
  • Resume Writing
  • Spring Boot
  • SQL
  • Tech Conference
  • Ubuntu
  • VBA
  • VBScript
  • VirtualBox
  • Web Development
  • Windows Tips
  • Wordpress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2021 · Magazine Pro on Genesis Framework · WordPress · Log in