Hi. Double check your data and make sure it doesn’t violate any of your table constraints like a unique index.
If you don't find anything obvious, you might consider posting a sample copy of your db for examination.ok i will chek again.
thanks
If you don't find anything obvious, you might consider posting a sample copy of your db for examination.
I answered a question a few years back where I remember seeing that error message! The question was actually about preventing duplicate values appearing in a subform, see YouTube:- Prevent Duplicates - Nifty Access --- That error pops up when you try and create a duplicate record. This position in the video demonstrates the error message:- (Time Index 2:50)
Update:- I've added the above video to my website:- "Prevent Duplicates" along with some more information, and and a time indexed list to take you to particular places in the video.
thanks for the help. i have recreated the database. now it's fine.
thank you very much. I watched your video on youtube. it was informative.
Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Thank you I'm glad you found it useful. If you haven't already done so, might I trouble you to sign up to my YouTube channel? I'm hoping to get to 1000 subscribers which should unlock a treasure chest of extra features for me! To subscribe just follow this link:- https://www.youtube.com/user/UncleGizmo?sub_confirmation=1
Here is another example of this error from DATABASE SOLUTIONS
Preventing Duplicates from being entered