Chapter 35: Creating a Stand-alone Database Application
The application included with chapter 35 was developed for the 16-bit version of Visual Basic 4.0 under Windows 95. Some adjustments may have to be made to run it under the 32-bit version or under windows 3.1. In particular, the custom controls have to be changed to their appropriate version for the compiler. If they are not done automatically when you load the program, you can reset them by modifying their entries in the Customer Controls and References option under the Tools menu.
The database contains 4 sample customers. Customer numbers 1, 2, 3 and 6. Customers 1 and 6 have duplicate company names to show the lookup form's multiple match feature.
While the data-bound grid is handy, it does not handle cursor movement well without quite a bit of code. The sample grids illustrate the data-bound feature, so navigation is left to mouse clicking and arrow keys. These grids could be replaced by Apex's True Grid by removing the existing ones and putting True Grids on the form and giving them the same name as the data-bound grid (the code for the various events will attach itself to the new grid). Doing this would give full navigation as well as many other nice features.
The application depends on everything being installed on the \SOURCE\CHAP35 directory. To change this, edit the Cover_Scr Load subroutine where the value of App_location is set and make it whatever you want. If you put the database somewhere other than where the report files are installed, you must also go into the report designer and set the database location for both the ordtick.rpt and statemnt.rpt files.
