By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,691 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Unique index works but...

P: n/a

Hi I have a unique index on a combination of fields to ensure that
duplicate contacts are not entered. I checked it by entering the same
contact info twice and it works but... there is no message that pops up
saying that the record was not added because of the index. Is there a
way to do this?

thx

Colin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you used DoCmd.SetWarnings False somehwere and not turned it back on?

Mike Storr
www.veraccess.com
"ColinWard" <je*********@hotmail.com> wrote in message
news:40*********************@news.frii.net...

Hi I have a unique index on a combination of fields to ensure that
duplicate contacts are not entered. I checked it by entering the same
contact info twice and it works but... there is no message that pops up
saying that the record was not added because of the index. Is there a
way to do this?

thx

Colin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.