Show Bid Request VB6.0/ACCESS Runtime Error: -2147467259(80004005)...NEED ASAP Bid Request Id: 5909 Bookmark in my 'To Do' list Posted by: Flipbee309 (6 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 10.00% Buyer Security Verifications: Unverified Approved on: Dec 3, 2001 4:45:05 AM EDT Bidding Closes: Dec 4, 2001 12:20:39 PM EDT Viewed (by coders): 965 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, Visual Basic Enter chat room for this bid request (0 active users at Aug 21, 2003 4:41:22 AM EDT) Description: This simple beginner program runs on Visual Basic 6.0 and ACCESS 2000, it is an Inventory program. The problem occuring in the program is the runtime error: -2147467259(80004005), a duplication entry error. More details on the error is on the "DIRECTIONS" file located on the attached zipped file. What I want to be completed is just a simple validation where a certain field (Prop ID) will have a msgbox saying "a duplicate Prop Id has been found, please enter a different Prop id" or something to that sort, instead of the runtime error msg that I usually get. The program must run on the A: Drive and the Access database must be taken out of the folder and put on the a: drive only (not in folder), (a:/dInventory.vbp). 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. Special Conditions / Other: Comments must be made within the code that is made so I will know what exactly was made to get the program to validate what I want. I will give the coder 3-4 HOURS from the time I ACCEPT the coder to complete the program since I need this ASAP. 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! Michael Sharp (134 ratings) in Ptolemaida, Kozani Greece Bid id: 63,553 This coder is certified! Click here for transcript $6 (USD) Dec 3, 2001 7:16:31 AM EDT  9.98 (Excellent)     Hi Flipbee, I looked over your code and fixed it. Now, when a user tries to add a duplicate record they get the message you specified and are returned to the data entry screen once they've acknowledged the message. I've also added a 'catch all' for other problems. If it is not a duplicate and there are no other problems then the record is accepted normally. I'm sorry I can't give this to you for free but you know the rules! Regards, Mike           See 5 private reply(ies) to/from Michael Sharp.