Examples from Access Day presentations
Filename Access Day Description
ContactMgmt.zip The example contact management application built during the "Introduction to Access" morning session of Access Day.
TipOfTheDay.zip 9/19/01 Tip of the day start-up application from Dean Serrentino's presentation. Demonstrates how to set and retrieve the value of a Windows registry key.
IntroToASP.zip 9/18/02 Examples from John Giuliano's Introduction to Active Server Pages (ASP) demonstration.
Tools2000.zip 4/16/03 From David Bird's presentation, an Access 2000/2002 data-driven add-in used to insert code snippets into a code pane at the touch of a button. Also includes a custom form to create menu items in client applications.
ClassModules.zip 5/21/03 Examples and PowerPoint file from John Giuliano's discussion on class modules.
DAO_to_ADO.zip 6/16/04 Code samples and PowerPoint file from Dean Serrentino's presentation on DAO and ADO.
WebServices.zip 4/20/05 Slides and example database from Phil Denoncourt's presentation on utilizing web services from within Access.
AccessSecurity.zip 5/18/05 Powerpoint presentation and example files from Russ Ganz's presentation on Access Security. Contains explanations and demos of various techniques for locking-down Access databases.
AccessTools.zip 11/16/05 Slides from Russ Ganz's presentation on "Tools for Access Developers"
DynamicVB.zip 6/20/07 Code samples from Marty Svedlow's 6/20/07 presentation on ways to dynamically create Visual Basic forms and their elements, and how to link those elements to SQL Server using VB code.
DynamicSQL.zip 8/15/07 From Dean Serrentino's presentation. Demonstrates the use of Dynamic SQL, and the calendar control which ships with Access.
Ganz16Jan08.zip 1/16/08 Powerpoint slide deck from Russ Ganz's presentation on Access developer tools.
Other useful downloads
Filename Description
rjhExtensions A simple utility that adds a number of useful functions to the context menu of Windows Explorer. The Path to clipboard function copies the path of the selected folder or file to the clipboard. Runs on Windows 95/98/NT/2000. Submitted by David LeBel.
SCA_ToolBox.zip John Giuliano's ToolBox. Packed with lots of ready-to-use code routines. Includes both Access '97 and 2000/2002 formats.
ifnull.txt Ifnull() function written by Rick Lunetta of Luna Systems. A variation of the Access IsNull function that tests for Access Null values, character zero, and zero length strings.
Links
Link Description
The Access Zone An "all-in-one" resource for Microsoft Access Developers.
Access 97 Expert Solutions An excellent site for Access developers. See Chapter 6 and Appendix C for information on the Leszynski Naming Convention.

Email suggestions and comments to Dean Serrentino

Home