This is going to be a very short and sweet (and saweeeet!!! that you don't have to delete) post. Have you ever wanted to reset the counter on a autonumber field in Access, but don't want to delete the table and start over again? SQL Magic to the rescue! Before running the SQL statement below, you should understand that by re-numbering an index, you will lose access to data in … [Read more...] about Reset Autonumber Field in Access Without Recreating Table
SQL
VBA Export to CSV From SQL With Save-As in Access
Although not as common as exporting to Excel, some projects may have a need to export in .csv format. Here is my solution. VBA Export With User Defined SQL Query This example uses the QueryDef function. Basically, the user passes a SQL query in, the file dialog prompts for where to save-as and the export is completed. 'To use file-dialog, you must add a reference 'to … [Read more...] about VBA Export to CSV From SQL With Save-As in Access
How to Count by Item With SQL | Group By Query MS Access
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
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