Access Part Tracking Modifications

This project has five modification requests, some of which are related The attached file contains a sample database and a word document, which more thoroughly explains the desired modifications. The modifications are 1) modify the scrolling on subform JOBPARTDET on form frmJobDet so that after the first part number is entered and the user is starting to enter the second part number, the details of the first part are still displayed. 2) fix the "Cancel" button on frmSearch so that it will return you to frmJobDet without all of the Microsoft Access messages. (This request may be superceded by 3) below if I can get 3). 3) when the item description it not in the table PARTMASTER, directly lauch frmTempPartMaster and upon the addition of a new temporary part, place this new temporary part in frmJobDet for the active job. 4) allow for the modification of current cost in subform JOBPARTDET in form frmJobDet when the fields "QTY On Hand" and "QTY On Order" are both zero. 5) modify frmSearch so that it displays not only the Part Description and Part Number, but also the CUrrent Cost. Again, please see the attached file for the sample database and the Word document. If no file is attached, please check back in a few hours. The workstation on which I am preparing this has an internet connection which often times out before the file can be transferred. If that happens, I will then modify the bid by attaching the file from another location later today. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) List of all tables, queries, forms, reports, macros and modules to which modifications were made, to assist me in determining which items I need to copy into my live database. ## Platform Microsoft Access 97 running on workstation with Windows 95, Windows 98, Windows 2000 and Windows Xp. ## Deadline information all new objects added must conform to the following naming convention: Object Prefix Table tbl Query qry Form frm Report rep Macro mac Module mod Users usr Groups grp Containers con Documents doc Indexes idx Fields fld Property pty Pages pag