Centralized data front end.mdb Change Log 2016: Difference between revisions

Line 68: Line 68:
* added Sub ''old_field_cleanup_20161121()'' to clean out old fields in L_Log.
* added Sub ''old_field_cleanup_20161121()'' to clean out old fields in L_Log.
* confirmed that Pagasa's forms are in my master
* confirmed that Pagasa's forms are in my master
* updated query ''link_suspect_mismatch_to_ours__incomplete'' to fix L_Problem use Ttenbergen 10:16, 2016 November 24 (CST)
* updated [[link_suspect_mismatch_to_ours__incomplete query]] to fix [[L Problems table]] use Ttenbergen 10:16, 2016 November 24 (CST)
* updated/confirmed queries to have D_ID as first columns so they will work with form dropdown, and to include L_Problem reference:  
* updated/confirmed queries to have D_ID as first columns so they will work with form dropdown, and to include [[L Problems table]] reference:  
** [[link_suspect_dead_then_alive query]]
** [[link_suspect_dead_then_alive query]]
** [[link_suspect_mismatch_from_ours__incomplete query]]
** [[link_suspect_mismatch_from_ours__incomplete query]]