DAO Label Printer - Updated 7-13-02

Update: Added a new print option. This is an address label printer. It was originally created for church use and mass mailings. You can have multiple files to help organize your address; the program will remember the last 4 you have opened. You can search for a specific address in a variety of ways. It allows you to move address from one file to another (one at a time or a selected group) by opening a selected paste file. You can Import/Export address from/to text files; you pick the field delimiter (Tab, Semicolon, Comma, or Carriage Return). You can print a single address label, selected address labels, all address labels of selected zip codes, or all address labels in a file at a selected starting row and column. You can print a single page of labels beginning with the first address you select. You can use it to print nametags by selecting the print option "Print Names Only". You can create and save different printing schemes which contain label size/layouts as well as what font will be used to print. You can view/edit one address at a time or view all the address in a spreadsheet format. In the spreadsheet, you can filter the information displayed to show only the address you want. The data in the spreadsheet can be sorted by column heading in either ascending or descending order. Included with this project are several cls files, which contain a lot code that you will find very useful to use in your project such as: * Play wave files stored in a resource file. * Many screen utilities like Center Form, Vertically Fit Form to Screen, and Make on top. * File Open and File Save dialog boxes without using an OCX. * Auto match Combo Boxes. * Masked Text. * Format text as it is typed. There are two versions of the project included, PrintLabels_MsGrid.vbp and PrintLabels_SheridanGrid.vbp. PrintLabels_SheridanGrid.vbp uses the Sheridan Data Widgets and PrintLabels_MsGrid.vbp uses Microsoft's data grid control. To select a group of connected rows using the mouse and the shift key, you need to click somewhere inside the grid; to select several non-connected rows using the mouse and control key you need to click on the Record Selectors bar located on the left side of the grid. The dbgrid32.ocx can be found it on your Visual Basic CD under ?:\Common\Tools\VB\Controls. You can find the ADO version of this project at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=36736&lngWId=1