This is the comprehensive and official reference documentation on OLE, revised to incorporate OLE enhancements and bring them in line with 32-bit Windows 95 and Windows NT. Volume 2 concentrates on OLE Automation, the revolutionary capability of OLE that makes it possible to manipulate an application's objects from outside the application.

Volume II introduces OLE Automation, the hot new capability that makes it possible to manipulate an application's objects from outside the application. This book is key to learning how to create applications that expose programmable objects, and how to create tools that access and manipulate objects. Includes a reference of Automation interfaces and tools.

Gives programmers two-in-one coverage, with both a "how-to" on SQL functions and a complete SQL functions reference SQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functions Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL

Newly revised and expanded to include such topics as ActiveX controls, exposing and accessing ActiveX objects, Remote Automation, and Windows NT 4.0, "Automation Programmer's Reference" is the comprehensive and official reference documentation on Automation.

Build business applications that exploit all of your organization's information resources--in whatever form and from wherever they reside in the enterprise--with Microsoft's powerful OLE DB 2.0 technology. This kit packages complete information and tools to create universal data access for all Windows - based and Windows NT - based systems. You'll discover how to expose data stores and extend full-blown DBMS functionality to personal or group databases, individual file systems, spreadsheets--even e-mail. Book jacket.

Updated and expanded for the most up-to-date version of VBA, this volume covers the basics of using Excel and VBA. The authors explore a range of new topics related to using the software more effectively and solving the many issues faced by developers.

What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.