Centralized data front end.accdb Change Request
see the Development Documentation Category for other development logs
This article contains requested changes for Centralized data front end.mdb. See Centralized data front end.mdb Change Log for it's change log.
Please fix SPEED
- BOTH EDITS AND NDC QUERIES
- Edits: change VBA from executing queries to making tables. Brad
- will import Brad's code for this when it's ready, hoping for before Thursday Ttenbergen 22:58, 2014 February 24 (CST)
- Edits: change VBA from executing queries to making tables. Brad
Temp Studies
- Listing multiple rows of information when looking in Tmp studies via the binoculars. email sent to tina and Brad. Feb 25.14.
- Cannot use the down lists for Project or Items get error message “ undefined function in hosp expression”
- What is the correct way to edit dates in TMP studies?
Cat problem
- Cat is not working this time. Run time error 94 Invalid use of Null. Even if sorted the last name in alphabetical order not working.
- Comorbid is not working you cannot edit. Complication yes you can add but there is a pop up message as soon you get out of that screen. It says changes you requested on the table were not successful because they would create duplicate.
PTorres 14:47, 2014 February 25 (CST)
ensure s_alldiagnoses part of re-linking
- S_allDiagnosis is not hooked up to centralized front end. Have to use link manager to link it in to front end.-Trish Ostryzniuk 13:42, 2014 February 21 (CST)
other spot that might contain requirements...
TMSX MedTMS to Centralized go-live
SAS Views
- implement Created Variables in TMSX or Med TMS
After go-live
Email Generator
- provide automation for generating email with particulars for collector to correct data for Pagasa to use
- Trish sent Tina several example emails
- revisit Category:Cleaner.mdb Data Integrity Checks