Show Bid Request MS Access Text Search Bid Request Id: 14580 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: Apr 25, 2002 2:03:14 PM EDT Bidding Closes: Apr 26, 2002 11:00:00 PM EDT Viewed (by coders): 444 times Deadline: 5/3/2002 TIME EXPIRED 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:09:37 AM EDT) Description: Overview: Microsoft Access Database text search needs to be made functional by modifying existing code. The text search component appears to accurately capture the record information from the filtered records and place it into arrays. This is so that the program can loop through using dynamic information. During a previous test run with static information and different tables, the text search code worked - minor editing is expected, though not a major overhaul nor entirely new search code. Feel free to edit the table structure or directory/filenaming setup given how you see fit. Detailed Information: Open the "PLAN-Search" form in 4_24_Coder.mdb Notice the main search (central area) is an initial SQL filter. It filters the records from table "montevista" given a date or type selection and displays the corresponding record information from the table. It works. Each record in the table has a corresponding .tif file and .htm file (see mastertext folder for .htm files and images folder for .tif files). Notice the text search component in the top right corner. This is to capture the filtered results from the initial search (especially tif and path) and search the .htm files corresponding to the records for text specified by the user (in txtTextSearch). The search will cover all filtered records. Any "matches" between txtTextSearch and the .htm files will be displayed in txtSearchResults. When the user double-clicks on a particular "match" in txtSearchResults, it is to launch bidvue.exe (in the images folder) and open the .tif IMAGE that corresponds with that particular record and .htm file and open to the appropriate image PAGE. When a user clicks on a particular record information box in Detail, it takes the user to another page displaying the information in an easy to read fashion. This appears to be fine. From there the user clicks Text Search. This is nearly identical to the text search on the main search page; however, it is only for the INDIVIDUAL record the user has selected. Remedy its directory problems and make it work as expected. The included TxtLink.idx file may be relevant to any of these problems, though may not, it is not at all formatted to the present database and information - it is a result of a previous and similar text search. Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Final Product will consist of “Fine Tuning” the Existing Database: -Editing of pre-existing multiple-item text search of .htm files to make it functional. -Editing of code to make it "mesh" with directory structures, filenames, and table setup. -Editing of other pre-existing code to remedy other directory/access-related issues --When a user types a word into the text search box, it should search the .htm files that correspond to the records displayed in the Details subform and display the results in the TextSearchResults textbox. From there, the user should be able to double-click and result in TextSearchResults and have it open the .tif file that corresponds to the .htm file and open to the appropriate page using Bidvue.exe. Platform: Windows 98,2000 & XP Must be 100% finished and received by buyer on: May 3, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Special Conditions / Other: Currently the text search works just fine on one record. We need it to loop thru numerous records to seek out text located in externally referenced HTM files. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. 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! jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 159,458   $40 (USD) Apr 25, 2002 2:57:39 PM EDT  9.47 (Superb)     Hello, My name if John Morgan and I have been an Application Developer for almost 10 years, with the last 6+ working for a Fortune 500 financial corporation(Capital One). As you can see by viewing my RAC resume, I have worked on many, many projects that involve MS Access. I always provide fully commented code, free product support and guarantee customer satisfaction. I saw in your posting instructions to open a particular database and the mention of other text files, but I did not see any attachment to the request. Regardless, I am ready to begin immediately and look forward to hearing from you soon. Thanks, John           See 3 private reply(ies) to/from jsmorgan24.