Printing the Inventory
GetKitIndex(kitscombo.Value, kitsitemcombo.ListIndex)Unlike most of the other forms, the Print Form comes ready to work.  Its ready to print the entire database as shown by the "Items to Print" box (Red Rectangle) in the screen on the left.  If you want to print the entire database just click on the "Print" button and you're done.
More likely you want to print only a portion of the database and in one of the formats specified
The Report Format section of the form allows you to specify how you want the printout to be formatted.  These selections also determine how the data will be sorted prior to printing.
The Master report format prints all of the information in the database limited by the Print Criteria.  The records are sorted prior to printing in the order specified
The Locker report format prints all records meeting the Print Criteria on a locker by locker basis.  Before printing the records are sorted by Locker ID. and the other two sort keys.  When printed, the Locker Report format inserts a page break between each Locker.
The Critical Kit Report format is not currently implemented.  Selecting this option currently is the same as selecting the Master Report Format.
Within the Print Form is a group of Sort Keys that can be set to any of the fields in the Inventory Records.  When the "Print" button is clicked these sort keys are used to order the inventory data for the printout.  This is an actual sort of the database and the "Inventory" worksheet data will be sorted in this manner after the "Print" button is pressed.
In the bottom right hand corner to the Print Criteria section are two boxes that can be used to modify the generated print.
The check box titled "Print Each on a Line", if selected, will cause all inventories records with units of "Each" to print on as many lines as the quantity in the record.  That is, if an item has a quantity of "5 Each" in the record it will be printed 5 times with a quantity of "1" on each line.  If the printout is to be used to record usage of inventory items it is easier to just strike out a line when one of an item is used rather than edit the quantity.
The test box with the title, "Blank Entries at End" can be used to create any number of blank lines at the end of a printout to record new items before they are entered into the workbook inventory.  For the Locker Report format these blank lines are generated at the end of the listing for each locker.
Click in screen capture to view at full resolutionOn the left is an example of what the Master Report format looks like when viewed through the Excel Print Preview.  The Print Form currently does not actually send any data to your printer.  It just generates the print data in the worksheet "Print".  You can then use the Excel print facility to further format the print (Headers, Footers, etc.) and then send it to the printer.
Click in screen capture to view at full resolutionLocker Report format may be the most useful of the print format.  It can be used to print the contents of all lockers on the boat, those in a single cabin, or just one locker.  These printouts can be placed in the locker and annotated to track items removed from or added to the locker so they can eventually be recorded in this inventory.
Click in screen capture to view at full resolutionWhen the Locker Report format is selected the first sort key is changed to "Locker ID" and cannot be changed until you select another report format.  The other two sort keys can still be used to order the data in the printout.  In this case I have specified a 2nd sort key of "Item" which will sort the entries in each locker by the Item Description field.
On the bottom left corner of the Print Form is the Print Info section.  While you are modifying the Print Criteria section the "Items to Print" will reflect how much print data will be generated.  This number includes the additional print lines generated by the "Print Each on a Line" selection and the number of "Blank Entries at End" specified.
The "Pages to Print" is generated when the print generation is complete.  This number is currently not generated correctly.  Its only function at the moment is to tell you the print generation process is complete.
Click in screen capture to view at full resolutionSince the Print Form does not actually send anything to the print, if you want hard copy of the report you must close the Print Form and select the "Print" worksheet from the Excel tab at the bottom of the Excel workspace (Red Arrow).
There you will see the data generated by the Print Form. 
Click in screen capture to view at full resolutionYou can use the Excel Print Preview feature to review and modify the printout before sending it to the printer.
This is an example of the Locker Report format. 
 
Click in screen capture to view at full resolutionThe printout for each locker is started on a separate page..