ACCESS DEVELOPMENT
Speed Up Microsoft Access Application Development and Maintenance with Program-Specific Options
Instead of making design changes to every application you create, you can customize your applications using an options table. One table and a little VBA code can make your life easier.
Subscribers: Sign-in to activate download link -- Get an example database containing form and code examples from this article.
About this Article:
In this article, Joe shows you how he built this reusable feature that he includes with all my custom applications and that you can add to your application. He'll show you the single table and the VBA code (all self-contained in a module in the sample database) he uses to customize his applications for each customer. With these tools, even if you don't know VBA, you (or your users) can add user default values to forms and reports.
Joe Stockman is an independent consultant and author in Pittsburgh, Pennsylvania. He is the author of the Access 2007 Workbook For Dummies and the co-author of the Access 2007 Bible and Access 2007 VBA Programming For Dummies. His focus has always been to make software easier to use for those new to the computer world. jcstockman@yahoo.com