Show Bid Request VB code using treeview to see data, sorted by date Bid Request Id: 25340 Bookmark in my 'To Do' list Posted by: infomed (37 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 14.81% Buyer Security Verifications: Good Approved on: Aug 24, 2002 11:07:15 AM EDT Bidding Closes: Sep 7, 2002 11:10:09 AM EDT Viewed (by coders): 763 times Phase: 100% of work was accepted by buyer. Coder account has been credited. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, Language Specific, Visual Basic Enter chat room for this bid request (0 active users at Sep 8, 2003 8:15:31 PM EDT) Description: I'm looking to build a recordset in VB6 that will pull all data for PatientID = 260 from 3 different tables, then sort the data by Date. I want to then be able to show the data sorted by date, as well as print the entire list of data (probably using VB6's datareport). I've included an example database with the three tables, SOAP, Notes, and Patient Messages. Each of these tables have the PatientID field. The Date field, however, is named differently in these tables. It is "EncounterDate" in the SOAP table, and "DATE" in the other tables. I tend to pick bids that show me a working demo (doesnt have to be pretty, though). Perhaps you could use a TREEVIEW to show the relation of these items based on date, and when clicking on the tree view it would pull the applicable data and show it. But I also want to be able to print it all out in order by date. Finally, the code MUST be short and sweet and well documented, and not call any ocx's or other external components. Optimally, you could do this in a couple procedures and with less than a dozen or two lines of code using ado. I look forward to your solutions! 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. Platform: 32 bit windows 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! IT Dnepr (5 ratings) in Dnepropetrovsk, Dnepropetrovsk Ukraine Bid id: 289,279   $15 (USD) Aug 27, 2002 9:34:40 AM EDT  5.8 (Above Average)     Hello. Your project is interesting to me. I have 6 years experience in work with VB, MS SQL Server an MS Access. In the project I used ADO 2.7, TreeView and TextBox. For testing multitablebid.exe and database (AC.mdb) should is in one folder. Thank you. Attached File