VB6.0/ACCESS Runtime Error: -2147467259(80004005)...NEED ASAP

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:/[login to view URL]). ## 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. ## Deadline information 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.