Category Archives: Code Snippets
File System Object Code (last modified, etc.)
Get File Last Modified Date Get File Created Date Get File Size Get File Type
Export A Table Or Query To Excel – Specific Worksheet on Specific Workbook
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t already have one.
Export A Table Or Query To Excel – To Specific Worksheet
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t already have one.
Export Table/Query To Excel to New Named Sheet
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t already have one.
Export A Table Or Query To Excel
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t already have one.
Export a Form’s Recordset to Excel – To an Existing Worksheet
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t already have one. You can then call it … Continue reading
Export A Form’s Recordset To Excel
Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don’t have one set already. You can then call … Continue reading
Clear All Controls On Form
And then you call it by using to clear the current form.
Compact Database
ACCESS 2000 – 2003 ACCESS 2007 ANOTHER WAY (multiple versions)
Code To Loop Through A Recordset
With this code you can modify it as you like. This is a simple starter for opening a DAO Recordset and looping through it.