Fixing a D ID in TISS28.accdb

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:

Query TISS Errors D ID not in CFE ‎ (← links) Deleting an item from TISS28.accdb ‎ (← links)