A “search?? form in Microsoft Access with query results populating a ListView in Report mode that allows sorting by clicking on the column headers. The search function should create an SQL query based on the parameters captured from text boxes and query every table in the database. Only a few fields are necessary to query on, but the query should include all tables in the database and any new ones created. The starting database will be provided. Note: This project was up for bid last week, but the coder could not get the ListView control to work in Access. As a result, the project is open to bid again. Coders that bid before, please bid again!
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 1. Finished Access form should be automatically expandable to any future tables added to the database and easily expandable to include additional query fields. 2. There will be multiple columns in the ListView, but the unique value in all cases will be the FID (Form ID), which is in every row of every table. 3. A selected row in ListView should have options to view the form or preview or print the associated report (reports included in original database). 4. Error control included in coding. Complete copyrights to all work purchased.
## Platform
Windows Office XP (Access)