| |
Access Cookbook contains a comprehensive collection of problems, solutions,and practical examples for the Access power user or programmer who is running up against some of the apparent limits of the Access user interface or of Access application development. The diverse problems and solutions presented here are of interest to Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated. Each of the books 14 chapters focuses on a particular topic area related to the Access environment or Access programming. Within each chapter, individual items follow a standardized format. The authors first pose the problem, and then present its solution. Finally, a discussion follows, which consists of extended analysis of the solution, an insightful examination of how Access works, or interesting programming techniques that are used in the solution but that you can also apply elsewhere.The kinds of problems posed and solved in the book include the following:Specifying query criteria at runtime, rather than at design time Restricting the user to a single row of a form Preventing a report from printing if it has no records Making slow forms run faster Insuring that user interface objects present a uniform, consistent appearance Controlling a printers paper source programmatically Referencing data from multiple SQL Server databases in a single Access Data Project page Using contact information from an Access database when sending email using OutlookThe accompanying CDROM includes Access databases that contain the solutions for all problems presented in the text.ABOUT THE AUTHORKen Getz is a senior consultant with MCW Technologies and splits his time between programming, writing, and training. He specializes in tools and applications written in Visual Studio .NET and Visual Basic. Ken is coauthor of bestselling several books, including Access 2002 Developers Handbooks with Paul Litwin and Mike Gunderloy, Visual Basic Language Developers Handbook with Mike Gilbert, and VBA Developers Handbook with Mike Gilbert (Sybex). He cowrote several training courses for Application Developers Training Company (www.appdev.com), including VB.NET, ASP.NET, Access 2000 and 97, Visual Basic 6, and Visual Basic 5 seminars.He has also recorded video training for AppDev covering VB.NET, ASP.NET, VB6, Access 2000, and Access 97. Ken is a frequent speaker at technical conferences and spoken often at Microsofts TechEd conference. Kens also a technical editor for AccessVBSQL Advisor magazine and a columnist for Informant Publications asp.netPRO magazine.
|
| |
|