save error (1 Viewer)

[Dhanu]

guys, pls refer the print screen and let me know what should I do when this error appears.

thanks.

 

[theDBguy]

Hi. Double check your data and make sure it doesn’t violate any of your table constraints like a unique index.

 

[Dhanu]

Hi. Double check your data and make sure it doesn’t violate any of your table constraints like a unique index.

ok i will chek again.

thanks

 

[theDBguy]

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.

 

[Uncle Gizmo]

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.

 

[Dhanu]

If you don't find anything obvious, you might consider posting a sample copy of your db for examination.

thanks for the help. i have recreated the database. now it's fine.

 

[Dhanu]

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.

thank you very much. I watched your video on youtube. it was informative.

 

[theDBguy]

thanks for the help. i have recreated the database. now it's fine.

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

 

[Uncle Gizmo]

thank you very much. I watched your video on youtube. it was informative.

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

 

[Uncle Gizmo]

Here is another example of this error from DATABASE SOLUTIONS

Preventing Duplicates from being entered

 

[Dhanu]

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

thank you very much sir.

 

[Dhanu]

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

yeah. I subscribed your channel.

 

[Dhanu]

Here is another example of this error from DATABASE SOLUTIONS

Preventing Duplicates from being entered

thank you very much. very useful. there are so many articles about access on this site.