This guide covers the upgraded features of Access 97, including Internet connections, Visual Basic for Applications (VBA) imnprovements, object linking and embedding (OLE) secrets, and error and debugging tools. The CD contains all examples from the book, including databases; reusable code; and subroutines and user-interface objects. Also included are freeware and shareware utilities, as well as demonstration versions of third-party utilities.
DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET TRUE ENTERPRISE NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Enterprise Developer's Handbook offers complete coverage of every aspect of building client-server Access applications for large-scale enterprises. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage Includes: * Developing Access projects that store data using SQL Server * Managing concurrency using stored procedures * Creating data access pages that allow the editing and viewing of Access and SQL Server data in a browser * Using data access pages to validate data, link pages, and create dynamic HTML effects * Retrieving and editing server data directly with ADO * Managing multiple developers with source code control * Creating Web pages that connect to Access and SQL Server data * Controlling all aspects of replication * Securing your Access databases and projects * Distributing your Access applications * Importing and exporting XML files * Creating and managing SQL Server objects
WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers working withany of the more than 300 products that employ the Visual Basic forApplications programming language. Written by recognized VBAexperts, it provides detailed coverage of a wide range of specificVBA programming challenges. Its careful, step-by-step instructionsand thousands of lines of code offer answers, while teaching you todevise new and creative solutions. The instruction applies equallyto all VBA environments, whether you are building standaloneapplications or customizing commercial products using theirbuilt-in VBA programmability. Coverage Includes Manipulating text, numbers, and dates Using automation to control other applications Creating objects using VBA class modules Using standard search and sort algorithms from within VBA Creating standard dynamic data structures, including linkedlists, binary trees, stacks, and queues Working with Windows system information, including memorystatus, screen info, mouse, keyboard, and power status Working with Windows Registry data Retrieving and setting Windows networking information Working with the Windows file system, iterating throughfolders, creating and deleting files Adding sound and movies to VBA apps using Windows multimediaextensions Tapping the system capabilities provided by the WindowsScripting Runtime library Writing add-ins for the Visual Basic environment Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
This how-to book of custom applications shows how organizations can use Access 97 to develop effective information systems in less time, for less money. This is the one-volume reference that shows users how to automate tasks, do application programming, and integrate an Intranet or the Internet. The CD includes source files and developer tools.
A "must have" book, this title shows Office 97 users how to get the most out of the HTML and ActiveX ready capabilities of the newest versions of Microsoft's most popular applications. Readers will be led step-by-step through implementing Office 97 documents on the Web.
Exploit powerfully enhanced programmability in Office XP with authoritative information -- straight from the Microsoft Office development team. This hardcore programming reference comes packed with practical, roll-up-your-sleeves resources to help you maximize your productivity with development tools for Microsoft Office, including the Microsoft Visual Basic "RM" 6.0 and Microsoft Visual C++ "RM" development systems. This guide includes coverage of Workflow Solutions for Microsoft SQL Server "TM" and Microsoft Exchange, offering both design and coding examples, plus API-level coding examples. It also covers enhanced support in Microsoft Office XP for Web-enabled information sharing and XML. Use this incisive coverage to build on what you know and to accomplish everything from automating individual tasks to creating complex vertical-market applications. Each chapter presents dozens of code examples that illustrate the discussion. And the companion CD-ROM contains hundreds of procedures you can use right now -- helping you to focus your creativity on designing solutions, rather than on building rudimentary code. It's everything you need to create better business solutions, faster!
This follow-up to the successful "VBA Developer's Handbook" is a significant revision because it targets a much broader audience and focuses on all the new, improved programming techniques that aren't available from any other source. The book and CD include hundreds of reusable functions and classes that readers can use in their own programming projects with little or no modification.
All the Access features are highlighted, allowing power users to create a custom application without writing a line of code--like making switchboards, command buttons, hyperlinks, and macros--to create a mini-information highway on or off the Web. Lots of graphics make this book an easy read for people who might be intimidated by thicker, more theoretical books on Access.
Designed to introduce beginners to databases, this book shows how to use and customise a contact-management database, and how to link complex sets of data, such as invoicing and order prcoessing databases
PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.
