Skip to main content Skip to primary sidebar

Ryan McCormick

Search

Ms Access 2010

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

· 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. […]

How to Count Records in VBA | Microsoft Access 2010

· Ryan McCormick · 3 comments

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 […]