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.