Pharmacy Program

Delivering Integrated Care Management

The IHTC pharmacy and healthcare professionals interact on a daily basis at our center to maximize coordination and quality of care. Our pharmacists and physicians are on call and available 24 hours a day, seven days a week.

The IHTC pharmacy and healthcare professionals effectively coordinate ongoing care by proactively communicating with our patients to manage clotting factor needs, therapy compliance, and bleeding episodes.

Interventions and Operative Procedures – Manual

System Requirements

  1. Operating System
    • Windows XP SP3
    • Windows 7 SP1 or later
  2. Microsoft Access 2003 or later


  1. You will receive a zipped (.zip) file in the email you provided. Download this .zip file to any location you deem appropriate.
  2. Unzip the .zip file
  3. Once the file is unzipped, navigate to a folder containing 9 files (the first is named AcroRd32.dll). This folder (and the 9 files within) is all you need to run the Surgery Letter Database. It is up to individual practices to determine if you want to perform a local installation or a network installation.
    • Local Installation: Create a directory anywhere on your local machine. Copy all 9 files and paste them in this new directory.
    • Network Installation: Create a directory anywhere on your network that is accessible to the end users who will use the database. Copy all 9 files and paste them in this new directory.
  4. Because all of the files were created on a different machine than the one you are using, you may need to unblock the files. To do this, right-click each file, select properties, and click the button that says Unblock (located near the bottom of the screen).
  5. You are now ready to begin using the Surgery Letter Database. Open the file SLDB.mde to launch the program. If you receive a message that says “Security Warning: Some active content has been disabled. Click for more details.”, you will need to click the Enable Content button before the database will work properly.

Using the Database

  1. After the initial Splash Screen disappears, you get a Search for Patients form. Search for a new patient using any field on the form. If the patient you are searching for is not in the database, you will get a message that says No records were found. Click Cancel to enter a new patient.
  2. Regardless of whether your search was successful or you are adding a new patient, a form named Patient Overview appears. HTC Physician is a mandatory field – when the database is shipped to you, there are no physicians in the database. When adding a new Physician: if the physician is a physician at the HTC, it is vital that you: (1) check the box that says HTC Physician and (2) enter a pager number. Failure to enter a pager number will cause the database to not be able to generate a letter.
  3. Once you have added the patient’s information, you are ready to add a procedure. Click the Add New Procedure button. This will launch a window named Surgery Information. This form can be divided into 3 categories:
    • Surgery Header Information: All fields starting with the Surgery Name and ending with the Secondary Product.
    • Surgery Detail Information: The section below Primary Product that contains up to 16 “events”. Events include Lab Draws, Infusions, Drug Administration, and free text (free text allows the user to add a paragraph in the middle of the letter).
    • Labs: Fill out this section as you fill out the events. If you choose an event named Lab Draw – Daily, make sure to fill out Daily Labs.
  4. Once all of the information on screen is filled out, click the View Letter button. This will launch a Word document that takes all of your information on screen and converts it into paragraphs. It is very important to take a look at this document for issues – this is a computer program attempting to make sentences out of data points, so there may be issues with word tense, sentence structure, etc.
  5. Once you’re done working with your Word document, save the file. You can link this file to the surgery by using the Upload File button near the top of the Surgery Information form.

Known Issues

  1. Form: Patient Overview. Failure to add a Pager # when adding an HTC Physician causes the View Letter button to return an error message.
  2. Form: Surgery Information. Adding a Location does not update the drop-down list labeled Location of Labs and Infusion. You will need to close out of the Surgery Information form and re-launch it from the Patient Overview form in order to see this Location in the drop-down.
  3. Form: Patient Overview. Adding a Surgery does not automatically update the Procedures section at the bottom of this form. You will need to close out of this form and re-open the Patient Overview form using the form Search for Patients.

Contact Us

If you encounter any problems when using the Surgery Letter Database, please send email to with a description of the problem and (if possible) screenshots of error messages.

Did you like this? Share it: