TISS28.accdb Change Log

TISS.mdb is a Microsoft Access database for storing TISS form data after scanning by Teleform. Since January 1, 2013, data collection has switched to the new TISS-28 form. The corresponding database therefore contains only TISS-28 data.

This change log reflects the ongoing evolution of the database in response to emerging requirements from the Main Office as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communciated via email.

NOTE: The TISS-28 database consists of two Access files, TISS.mdb and TISS_Data.mdb, representing the user interface and data components, respectively. The generic term database as used in this article refers to both components.

Version 2013-02-28

Changes since the last version:

• Removed sorting by batch number (edit window - forms section)
• TISS Forms can now be deleted from the database via the edit window
• After importing new data, a list of forms just added to the database is displayed to allow confirmation/validation by the data processor
• Added tblTISSReport as a linked table in TISS28_Data.mdb

Version 2013-02-22

Changes since the last version:

• Grouped and added controls to the main form to access new functions
• Added new form to provide access to "canned" reports/queries
• Added Count of TISS Items query (accessible via the new form above)
• Added Patient and Date query (accessible via the new form above)
• Patched STB_CCU unit designation (removed leading space from CCU in existing data)

Version 2013-01-25

Changes since the last version:

• Cosmetic UI changes
  • added vertical scroll bar to edit form
  • edit form maximizes on open
  • added record navigation controls to image lookup form
• Additions and deletions are now allowed on ITEMS subform (on edit form)
• Added Edit and Save buttons to the edit form; form now opens in "view" mode to prevent accidential editing of data
• Added feature on image lookup to open image PDF file
• Fixed data display issue on edit form

Version 2013-01-18

Changes since the last version:

• Added code to prevent the importing of duplicate forms
• Added form to facilitate controlled editing of TISS data elements already contained in the database

Version 2013-01-16

This is the original release of the TISS-28 database. It contains limited functionality as follows:

• Importing TISS data as generated by Teleform
• Looking up a TISS form image file name (from the corresponding SERIAL number)

See also

• TISS28 data specifications