OneNote collection of code tips

from the Artful SQL Server & Access Tips List


This is a collection of hundreds of code snippets, modules and classes, all contained in a single OneNote notebook in these sections:

API Calls
Command Line Switches and Parameters
Connections
Database Functions
Classes
Date Calculations
ADO
DAO
Email
File Handling
Form Functions
Import/Export
Modules
Table Functions
Attachments
Report Functions
Run External Programs
Helen Fedemma's Access Archives (list of URLs)
Ribbon Functions

Each section has a number of pages devoted to a sub-topic or example.

Download it here. To use the file you need a copy of Microsoft OneNote, which is available as a part of Microsoft Office, and also available as a free download from http://www.onenote.com.

When you're programming in Access, it's best to open the OneNote file and keep it open. When you're facing a problem, you can refer to the appropriate section and often find code that is relevant to your particular issue.

Return to the Artful SQL Server & Access Tips page