ACCESS DEVELOPMENT
Save Time and Simplify Your Microsoft Access Applications with Inline Functions
Get more from Access with these two functions.
Subscribers: Sign-in to activate download link -- Get an example database containing form and code examples from this article.
About this Article:
You can reduce the time you spend writing code by using Access’ inline functions. By using Nz() and DLookUp() you can reduce long routines and complex queries to a single line. Putting them together gives you even more power.
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