Fixing a D ID in TISS28.accdb

From CCMDB Wiki
Jump to navigation Jump to search

Instructions

  • In the navigation panel on the left, filter for queries by entering fixer
    • should give you queries D_ID_fixer_form and D_ID_fixer_Item
  • right-click the first query, and open in design view"
  • edit the "criteria" to the wrong value
  • edit the "Update to" to the correct value
  • run the query by clicking on the Design menu and then clicking the "!" Run button
  • close the query
  • repeat for the second query

old methods

Quick way

  • open L_Tiss-form
  • do a Ctrl H
  • enter the wrong DI_D into "Find what" line
  • copy and past wrong DI_D into the "replace with" field and CORRECT it
  • hit the "replace all button
  • do the same in the L_Tiss-Item

Long way

  • If the error is a wrong location, serial or date mismatch on the TISS form, delete the TISS from the TISS28 Data.mdb.
    • go to: L_Tiss-form . Double click to open.
      • Go to the D_ID column, RIGHT click, text filter, enter the D_ID you are looking for (e.g. HSC_SICa_1607) . Press OK.
      • make sure you know the scanned batch number,
      • delete the row (or rows if more than one form in the batch has the same wrong site, loc, serial). To delete, highlight the row (rows), right click, delete. A window pop up that says you are about to delete one record, press YES.
      • IMPORTANT: After you press YES, you will get another window that asks: Do you want to save changes to the design of the table L_Tiss-form? Press NO.
    • Now go to: L_Tiss-Item, Double click to open.
      • Go to the D_ID column, RIGHT click, text filter, enter the D_ID you are looking for (e.g. HSC_SICa_1607) . Press OK.
      • delete the rows. To delete, highlight the row (rows), right click, delete. A window pop up that says you are about to delete e.g. 10 records, press YES.
      • IMPORTANT: After you press YES, you will get another window that asks: Do you want to save changes to the design of the table L_Tiss-form? Press NO.
      • you are now ready to RESCAN the form, with a NEW Batch number.

Related articles

Related articles: