We are Access Experts. Call Us Today! 773-809-5456

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.