|
Add-ins and Your Mama - 3/20/2008 If “necessity is the mother of invention,” then Microsoft Access add-ins should be getting a Mother’s Day card this year. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. Aaron Kogan shares some of his add-ins and some of his favorits from other developers. 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.
|
