Show Bid Request Trade Codes Display Bid Request Id: 2362 Bookmark in my 'To Do' list Posted by: steved (2 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 20.00% Buyer Security Verifications: Good Approved on: Sep 6, 2001 9:26:54 AM EDT Bidding Closes: Sep 20, 2001 9:27:39 AM EDT Viewed (by coders): 1097 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Windows, Database, Visual Basic Enter chat room for this bid request (0 active users at Aug 3, 2003 11:24:49 AM EDT) Description: We have a MS Access DB (Office 2000). Within it there are three of many tables which have the following relationship. 1. Project table - list various projects in our inventory. 2. Trade Code Table - Provides a list (such as a drop down list) of trade codes so our data entry people can classify each project. 3. Trade Table - Grabs the project # from the project table and accociates it thier various trade codes from the trade code table. The DB contains a "project form" which shows all the fields for each project in the project table. We would like to include a "Trade Code subform" within the "project form" that will allow you to classify each project by trade code. The "Trade Subform" should display all possible trade codes (currently less than 15) and not just the selected ones. Next to each trade code, we must have a count of projects that have each trade code, along with percent of total. example of "trade code subform" display (2 line sample): [check box] Water and Sewer 35 projects - 26% [check box] Storm Drain 22 projects - 15% etc This is the first part of a larger project. Deliverables: A fully functional MS Access 2000 DB with these feature. We will provide the original three tables and "project form" to the successful bidder. Special Conditions / Other: Need to complete in a few days and move on to the larger phase. If you know Access and VB, this is just a few hours of work. We will provide the original three tables and "project form" to the successful bidder. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! VB Doc (7 ratings) in Pune, Maharastra India Bid id: 19,627   $50 (USD) Sep 6, 2001 11:23:45 AM EDT  6.14 (Above Average)     Hello, Accept my bid and be rest assure and get work done in 2 working days. I have tremendous experience in MS Access as well as in VB. I am Microsoft Certified Solution Developer having 3+ years of experience. Hope to here from you soon. Thanks in advance!