Appendix E

What's on the CD-ROM


This appendix lists and describes the files included on the CD-ROM.


A document version of this appendix is in the root folder of the CD as CD_INDEX.DOC. The document may contain information that is more current than this appendix.

Installing the Sample Files

Before using a sample file, you will want to copy it to your local drive or a network disk from the CD-ROM. Files on the CD are read-only, which will inhibit your ability to explore and modify the samples as you learn.

There may be dependencies between multiple sample files for the same chapter. Thus, keep an entire chapter folder's contents together when copying.

Using the Sample Files

Here are some general considerations for using the database files included with this book:


The file AES_VBA.MDB contains a routine lci_AppBoAECheck demonstrating how to check for this setting in the startup of an application.

Files for Chapter 2

The file for this chapter provides information on the Leszynski Development Framework.

File LDF-SUMM.DOC

Files for Chapter 3

The file for this chapter provides information useful in project planning.

File PRE-PLAN.DOC

Files for Chapter 4

The files for this chapter provide tools to help you create design specification documents.

File SPECSHEL.XLS

File SPECSHEL.DOC

Files for Chapter 5

The file for this chapter provides examples of consistent object naming conventions.

File AES_NAMG.MDB

Files for Chapter 8

The file for this chapter provides examples of the various user interface components you need to build a friendly application.

File AES_UI.MDB


This database provides an example of the use of the Common Dialog ActiveX control. The control is shipped with the Office Developer Edition and must be present on your system and properly registered in order to use the form frmComDlg. You may need to reinstall the control on the form in order to use it; follow these steps:

  1. Install the Office Developer Edition tools on your system.
  2. Open the form in design view.
  3. Delete the Common Dialog control from the lower right of the form.
  4. Insert the Common Dialog control onto the form, using the Insert, ActiveX Control... menu option. Name the control cdlg.
  5. Update the reference to the control by locating the control file COMDLG32.OCX with the Browse button in the References dialog box.
  6. Recompile the database.

Files for Chapter 9

The files for this chapter are useful when completing and distributing an Access-based solution.

File AES_ISSUE.MDB

File PRE-SHIP.DOC

Files for Chapter 10

The files for this chapter provide examples of defining and building database table structures.

File AES_TBL.MDB

File SCHEMA.MDB


The database contains references to the Office 8.0 Object Library (MSO97.DLL), the Common Dialog ActiveX control (COMDLG32.OCX), and the Excel 8 object library; you must check and update these references when first using the database. See "Files for Chapter 8" for assistance.

Files for Chapter 11

The files for this chapter provide examples of using Visual Basic for Applications.

Files AES_VBA.MDB and AES_VBA.ICO


The database contains a reference to the Office 8.0 Object Library (MSO97.DLL); you must check and update this reference when first using the database. See "Files for Chapter 8" for assistance.

Files for Chapter 12

The file for this chapter provides examples of some foundation techniques required before you can master Access form development.

File AES_FRM0.MDB

Files for Chapter 13

The files for this chapter provide examples of advanced techniques for using combo and list boxes on forms.

Files AES_FRM1.MDB and ORDER.TXT

Files for Chapter 14

The file for this chapter provides examples of advanced techniques for application navigation.

File AES_FRM2.MDB


This file contains a reference to the Office 8.0 Object Library (MSO97.DLL). If code in the database does not run or compile correctly, check that this library is correctly referenced in the Tools, References... dialog box.

Files for Chapter 15

The file for this chapter provides examples of advanced data entry and validation techniques.

File AES_FRM3.MDB

Files for Chapter 16

The file for this chapter provides examples of techniques for the presentation of data on forms.

File AES_FRM4.MDB

Files for Chapter 17

The files for this chapter provide examples of techniques for "bulletproofing" an application to make it retail quality.

Files AES_BPRF.MDB, AES_BPRF.BMP, AES_BPRF.ICO


This database contains a reference to the Office 8.0 Object Library (MSO97.DLL). If code in the database does not run or compile correctly, check that this library is correctly referenced in the Tools, References... dialog box.

This database also contains startup property settings that restrict access to the Database window, menu design, and other aspects of the development environment. To browse the database, you must open it while holding down the Shift key to bypass the startup settings.

File BULLETPF.DOC

Files ESPLASH1.BMP Through ESPLASH6.BMP

Files for Chapter 18

The files for this chapter provide examples of techniques to create applications that use advanced Access reporting capabilities.

File AES_RPTS.MDB

Files AES_HTML.HTM, AES_VBA.HTM, and AES_WEB.HTM

Files for Chapter 19

The files for this chapter provide examples of using Access as a front-end for data stored in SQL Server.

File AES_SRVR.MDB


You must create a saved data source on your workstation that tells Access how to locate the Pubs database. See the chapter text for instructions on creating a data source.

This database contains startup property settings that force you to login to Pubs each time the database is opened. The login event creates a cached connection to the server that is reused by Access to improve performance, and also creates a variable with a server connect string that is useful as you explore the examples. To bypass the login dialog, open the database while holding down the Shift key.

Files for Chapter 20

The files for this chapter provide examples of creating tools to make your development work with Access more productive and enjoyable.

Files AES_SCUT.MDB, AES_LIB.MDA

File AES_WIZ.MDA

Miscellaneous Files

In addition to the preceding materials directly related to the chapter text, the CD contains the following helpful files.

File CONVRT97.DOC

File KCCPAK1.EXE

File LNC97DEV.HLP, LNC97DEV.CNT

Files UTILITY.MDA, WZLIB80.MDE, WZMAIN80.MDE, WZTOOL80.MDE, and WIZARD97.TXT

To stop using the unlocked wizard code, close Access and copy the backup files you made in step 2 previously back into your Access directory.


1996, QUE Corporation, an imprint of Macmillan Publishing USA, a Simon and Schuster Company.