|
A Generic Lookup Table Editing Form - 3/2/2011 From Jim Pilcher's March 2011 presentation, "A Generic Lookup Table Editing Form" VBA Table Wrapper Classes - 6/17/2010 Lindsay Wert's Table wrapper classes Crystal's Analyzer... the ultimate Data Dictionary Tool - 5/6/2010 Crystal's free Analyzer application to document databases. How to Make an Add-in - 5/5/2010 Aaron Kogan's presentation on how to make an Add-in which includes an Add-in Template. Access 2010 Web Database Template Relationship Diagrams - 4/9/2010 Access 2010 Web Database Template Relationship Diagrams, documented by Crystal, March 2010 Search Buddy - 3/4/2010 Aaron Kogan's Search Buddy (aka 'Search Pane') from his March 2010 presentation. Outlook Attachment Options - 3/4/2010 Outlook Attachment Options utility (from Slovak Technical Services www.SlovakTech.com/AttachmentOptions.htm). Briefly presented by Aaron Kogan during the March 2010 meeting. Importing Excel Data - 3/4/2010 Samples from Patrick Headley's March 2010 presentation, "Importing Excel Data". 'Tips and Tricks Inspired by Student Questions' Samples - 2/8/2010 Samples from Sco's January 2010 presentation, "Tips and Tricks Inspired by Student Questions" Disable Mouse Wheel - 1/31/2010 From Sco's January 2010 presentation, the sample from Wayne Philips' EverythingAccess.com 'A new method for disabling the Mouse Scroll Wheel in Access forms'. Table Interface Class Builder for DAAUG - 10/12/2009 Access, PPT, and related files from Lindsay's Presentation MSDN Access Team Contributors' Toolkit - 5/21/2009 Background info on contributing to Power Tips Access Add-ins and Code Snippets - 4/7/2009 More of Aaron Kogan's "Little Buddies" from his Code Library Office Automation in Microsoft Access - 1/17/2008 Phil Ferrero demonstrated several techniques for automating Microsoft Word and Excel using Microsoft Access. He also demonstrated the differen between early and late binding in VBA code. Download and run this self extracting zip file to access the files that Phil used in his demonstration. Word Automation from Access - 11/16/2006 This zip file was provided by member Alan Ruff as part of his demonstration on automating Microsoft Word by using Microsoft Access. When you unzip the files a new folder named C:\AccessAutomation will be created and the files placed in that folder. Everything will work from within that folder. Hitting the Cycle with Outlook and Access - 4/20/2006 Mike Nindorf explained the application and processes that he built for his company to use in order to input data into Access from Outlook and then export that data into Word templates. Though he was unable to share the application with the group he has provided his presentation notes which includes code for gathering the data form Outlook and outputting it to Word. The Access Sub-way - 2/16/2006 Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. This download contains the forms and subforms that Jim used in his presentation. DAO Transactions - 11/17/2005 (447 KB) Demo files preapared by M.L. "Sco" Scofield for his presentation on SQL Transactions. SQL Transactions allow you to process a set of SQL commands and commit the updates or roll back the updates as a batch, instead of one command at a time. In this way, you can roll back the set of SQL commands if one or more of the individual commands fail. Practical Ways to Use XML with Access 2003 - 10/20/2005 (1.33 MB) presented by Tim Getsch, Microsoft Access Program Manager, Redmond, WA A One-form Application - 9/15/2005 (29 KB) "Export Access Table Structure" Add-in presented by M.L. (Sco) Scofield Unbound Forms - 8/18/2005 (780 KB) Presented by Jim Pilcher Upsizing SQL Server - 7/15/2004 (16 KB) Presented by Kevin Bell Recordsets in Microsoft Access - 6/20/2002 (264 KB) Presented by Barton P. Haase.
|
