This program reads and manipulates the .odb that holds that lab stocks. Tkinter GUI interface implemented for easier interactions.

1. Python (Confirmed working with Python 3.xx)
2. pypiwin32 (Printing labels through COM)
3. pandas (Manipulation of data)
4. jaydebeapi (Connection to HSQLDB)

A simple Tkinter GUI program made to search through the Lab Stock Database and print them directly.

Searches can be made by:

1. Stock ID
2. Genotype
3. Description
4. Note
5. Responsible Person
6. Flybase
7. Project

The user can select the entries they want on the label with checkboxes. A print preview is displayed to show what will be printed.

If the search has multiple results (i.e. searching by someone's name with the "Responsible Person" entry), the user will be prompted to select a specific stock.

• Shows empty stock numbers.
• Adds Bloomington stocks (requires bloomington .csv)