LIFE Multimedia Catalog makes it easy for public speakers or ministries to catalog and label unlimited media types. CD's, DVD s, MP3's. Any media type that the librarian adds to the Type Look-up table can easily be cataloged for label creation, patron orders, and reporting. Single messages cataloged have the option of an associated parent album, and likewise albums may be grouped by Collections. A parent set may include a combination of any media type. People listing enables librarian to keep track of Patrons, Ministries, Speakers and suppliers. New message entries and new patron orders are automatically flagged for labeling. Production and Patron Order reports display media usage by Date, Media type, and usage ("Master audio", "Worker copy", "purchases", Shut-ins" etc)
LIFE Multimedia incorporates file-to-record attachments, user-defined hyperlinks, data import/export, and Open Database Connectivity (ODBC). These enable LIFE Multimedia to work with applications external to itself. Photos may be attached to contacts. Messages may be hyper-linked to MP3's. Albums may have the case-cover design file attached to the database record. Pending labels may be linked via ODBC to labeling software (Avery and Memorex have applications that will link via ODBC - I've included a few layouts for Avery's DesignPro). LIFE Multimedia does include a few labels and reports, but the ability to link and export data reduces the database's limitations, especially as additional media types are added to the library
Default field-value lookup enables the easy creation of the next record for messages in series. The database assumes that the next message entry is a series continuation, populating the parent, series part#, Title, and Title Part# based on the last single message recorded for the selected speaker.
Written in Microsoft Access 2010, a copy of MS Access 2010 is not necessary. Microsoft provides a run-time application available for free download to execute MS Access 2010 databases.
---MS Access 2010 Runtime---
----Memorex Express it--
---ODBC Open Database Connectivity overview ---
----Using ODBC with MSAccess
See instructions in Avery DesignPro "Open databases created in other programs using ODBC"
1-Link to LIFE Media 07, "ToLabel" query from Designpro via ODBC
2-Create Label in Design Pro
3-Enter A Hyper-link to the new label design from LIFE Media 07 "Setup"--> "Labels", and select the appropriate media type.
4- When printing labels, select the hyper-link directly from pending labels to print.
- Compact and Repair option on login, in case errors needing repair are preventing proper startup.
- Added "Remove Filter" button to Add-message form, enables easily associating multiple speakers with an album series
- repaired labeling error which was resetting the labels to the first position when printing the label preview.
Jan 2014 - Added functionality
10/18/2013 - Improved labeling and reporting capabilities. Now Reports and Labels may be created within the program. MS Access Label wizard, and the report wizard, have been incorporated into this version. (However, unless the vba code is imported manually into the newly created labels, the new labels will not be able to print based upon the qty field, nor will the user be able to request a starting position. If the existing labels are not sufficient, I recommend importing the code, if you have a full version of MS Access or use Avery Design pro with ODBC to better control label selection and usage.
10/14/2013 - Repaired printing options. Label Copies now print based on the Qty field in the Order's form. The 'To label' form auto-loaded for label printing so hyper-link finds the current records to print.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.