

Welcome to the CD-ROM for the Access 2000 VBA Handbook. The products on this CD are compatible with Windows 95, Windows 98, and Windows NT Workstation 4 and later. You must also have Microsoft Access 2000 installed on your computer.



********************************************************************

* Please maximize this window. If you're viewing this in Notepad,  *

* turn on Word Wrap under the Edit Menu to best view this file. If *

* you're viewing this in WordPad, go to the View menu, choose      *

* Options, and then, from the Text tab, choose Wrap to Window.     *

********************************************************************



Please review the following license agreement. A description of the CD's contents, copyright information, and installation instructions follow.

________________________________________________



SOFTWARE LICENSE AGREEMENT: TERMS AND CONDITIONS

________________________________________________



The media and/or any online materials accompanying this book that are available now or in the future contain programs and/or text files (the "Software") to be used in connection with the book. SYBEX hereby grants to you a license to use the Software, subject to the terms that follow. Your purchase, acceptance, or use of the Software will constitute your acceptance of such terms.



The Software compilation is the property of SYBEX unless otherwise indicated and is protected by copyright to SYBEX or other copyright owner(s) as indicated in the media files (the "Owner(s)"). You are hereby granted a single-user license to use the Software for your personal, noncommercial use only. You may not reproduce, sell, distribute, publish, circulate, or commercially exploit the Software, or any portion thereof, without the written consent of SYBEX and the specific copyright owner(s) of any component software included on this media.



In the event that the Software or components include specific license requirements or end-user agreements, statements of condition, disclaimers, limitations or warranties ("End-User License"), those End-User Licenses supersede the terms and conditions herein as to that particular Software component. Your purchase, acceptance, or use of the Software will constitute your acceptance of such End-User Licenses.



By purchase, use or acceptance of the Software you further agree to comply with all export laws and regulations of the United States as such laws and regulations may exist from time to time.



SOFTWARE SUPPORT



Components of the supplemental Software and any offers associated with them may be supported by the specific Owner(s) of that material but they are not supported by SYBEX. Information regarding any available support may be obtained from the Owner(s) using the information provided in the appropriate README files or listed elsewhere on the media.



Should the manufacturer(s) or other Owner(s) cease to offer support or decline to honor any offer, SYBEX bears no responsibility. This notice concerning support for the Software is provided for your information only. SYBEX is not the agent or principal of the Owner(s), and SYBEX is in no way responsible for providing any support for the Software, nor is it liable or responsible for any support provided, or not provided, by the Owner(s).



WARRANTY



SYBEX warrants the enclosed media to be free of physical defects for a period of ninety (90) days after purchase. The Software is not available from SYBEX in any other form or media than that enclosed herein or posted to www.sybex.com. If you discover a defect in the media during this warranty period, you may obtain a replacement of identical format at no charge by sending the defective media, postage prepaid, with proof of purchase to:



SYBEX Inc.

Technical Support Department

1151 Marina Village Parkway

Alameda, CA 94501

(510) 523-8233

Fax: (510) 523-2373

e-mail: info@sybex.com

Web: http://www.sybex.com



After the 90-day period, you can obtain replacement media of identical format by sending us the defective disk, proof of purchase, and a check or money order for $10, payable to SYBEX.



DISCLAIMER



SYBEX makes no warranty or representation, either expressed or implied, with respect to the Software or its contents, quality, performance, merchantability, or fitness for a particular purpose. In no event will SYBEX, its distributors, or dealers be liable to you or any other party for direct, indirect, special, incidental, consequential, or other damages arising out of the use of or inability to use the Software or its contents even if advised of the possibility of such damage. In the event that the Software includes an online update feature, SYBEX further disclaims any obligation to provide this feature for any specific duration other than the initial posting.



The exclusion of implied warranties is not permitted by some states. Therefore, the above exclusion may not apply to you. This warranty provides you with specific legal rights; there may be other rights that you may have that vary from state to state. The pricing of the book with the Software by SYBEX reflects the allocation of risk and limitations on liability contained in this agreement of Terms and Conditions.



YEAR 2000 COMPLIANCE



Where possible and relevant, SYBEX has licensed and compiled third-party software that meets the U.S. Federal standards for Year 2000 compliance, but SYBEX does not guarantee that any third-party software distributed on this CD is compatible with the U.S. Federal requirements for Year 2000 compliance. Call the product's manufacturer if you have questions about a product's Year 2000 compliance.



SHAREWARE DISTRIBUTION



This Software may contain various programs that are distributed as shareware. Copyright laws apply to both shareware and ordinary commercial software, and the copyright Owner(s) retains all rights. If you try a shareware program and continue using it, you are expected to register it. Individual programs differ on details of trial periods, registration, and payment. Please observe the requirements stated in appropriate files.



COPY PROTECTION



The Software in whole or in part may or may not be copy-protected or encrypted. However, in all cases, reselling or redistributing these files without authorization is expressly forbidden except as specifically provided for by the Owner(s) therein.







________________________________________________



THE Access 2000 VBA Handbook CD-ROM

________________________________________________



This CD-ROM contains answer database files, the Event Logger database application, a collection of tables associated with Chapters 2, 5, and 8, and a Windows API file.



As you work through the exercises in the book, you will receive instructions on how to install and use the files on this CD-ROM. General instructions also appear below.



The files listed below are included on this CD.



EVENT LOGGER FOLDER

===================

The Event Logger database application (EventLogger.mdb) is used in Chapter 2 for hands-on experience with events. This application was created by the authors of Access 2000 Developer's Handbook (Sybex, 1999) who have kindly given permission to include this excellent tutorial database in this book and on the book's CD-ROM. You can run the Event Logger from the CD-ROM or copy it to your hard disk, but you must have Microsoft Access 2000 installed on your computer before doing so. 



SOLUTIONS FOLDER

================

The Solutions folder includes the answer databases for the book's chapters, as well as other files required by the Northwind database. To use this folder, you must have Microsoft Access 2000 installed on your computer. 



Work through the hands-on exercises in the book and use these files as a check for your work. You can leave the database files on the CD-ROM and run them directly from the CD. Alternatively, you can copy the database files to the VBAHandbook folder you created to store your work. Please note, however, that the database files in the Solutions folder are read-only files. In order to modify or save data in these files, you'll need to remove the read-only attribute. For each database file, do the following: Right-click the file in Windows Explorer and select Properties. A dialog box will appear. Click the General tab. In the Attributes section, click the Read-Only check box in order to remove the check mark. Click Apply and then click OK.



The following files are included in the Solutions Folder:



ADOProject.adp

--------------

The project you create and use in Chapter 6 to work with the new ActiveX Data Object model and Access project concepts. Before working with this file, make sure you have installed MSDE. If not, insert the Microsoft Access CD and run the SETUPSQL.EXE file from the \sql\x86\setup directory.



Expenses.mdb

------------

This is the semi-automated database that the Database Wizard creates and that we modify using the other built-in Access tools in Chapter 1. Chapters 2, 3, and 4 also refer to this database.



Ch7_Examples.mdb

----------------

This is the solutions file you create from scratch in Chapter 7.



Ch10_Examples.mdb

-----------------

This is the solutions file you create from scratch in Chapter 10.



Northwind_Ch4.mdb

-----------------

This is the copy of the Northwind database used in Chapter 4.



Northwind_Ch5,6.mdb

-------------------

This is the copy of the Northwind database used in Chapters 5 and 6.



Northwind_Ch8.mdb

-----------------

This is the copy of the Northwind database used in Chapter 8.



Northwind_Ch9.mdb

-----------------

This is the copy of the Northwind database used in Chapter 9.



Northwind_Ch11.mdb

------------------

This is the copy of the Northwind database used in Chapter 11.



Northwind_Ch12.mdb

------------------

This is the copy of the Northwind database used in Chapter 12.



Northwind_Ch13.mdb

------------------

This is the copy of the Northwind database used in Chapter 13.



Northwind_Ch14.mdb

------------------

This is the copy of the Northwind database used in Chapter 14.



Northwind_Ch15.mdb

------------------

This is the copy of the Northwind database used in Chapter 15.





TABLES FOLDER

=============

The Tables folder contains the tables referred to in Chapters 2, 5, and 8. You can read the tables using Adobe(TM) Acrobat(TM) Reader, also provided on this CD. Simple installation instructions are provided below.



INSTALLING ADOBE(TM) ACROBAT(TM) READER

===============================

The table files have a .pdf extension. You can view .pdf files using the Adobe Acrobat Reader.



*If Adobe Acrobat Reader is installed on your computer, you can open a .pdf file by double-clicking the file.



*If Adobe Acrobat Reader is not installed on your computer, you can install it by double-clicking the Acroread.exe file in this CD-ROM's root directory. When the installation is complete, open any .pdf file by double-clicking the file.



Acrobat and Acrobat Reader COPYRIGHT 1987--1997 Adobe Systems Incorporated. All rights reserved. Adobe, Acrobat, and the Acrobat logo are trademarks of Adobe Systems Incorporated which may be registered in certain jurisdictions.



WIN32API.TXT (IN THE ROOT DIRECTORY)

====================================

The file Win32api.txt is a Microsoft text file that describes the declaration statements required to use procedures in the dynamic link libraries of the Windows Application Programming Interface (API). Chapter 15 refers to this file.



WIN32API.TXT -- Win32 API Declarations for Visual Basic Copyright (C) 1994-98 Microsoft Corporation. You have a royalty-free right to use, modify, reproduce and distribute this file (and/or any modified version) in any way you find useful, provided that you agree that Microsoft has no warranty, obligation or liability for its contents. Refer to the Microsoft Windows Programmer's Reference for further  information.



