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

Check for Name Duplicates when entering new records

P: n/a
No point in reinventing the wheel!

-I'm looking to create a popup dialog that prompts for FirstName MI
Lastname.
-Checks and reports duplicates.
-And offers the user an option to continue or cancel.

I know this must be a very common aspect of systems managing names, and
know that many creative interfaces must have been built. I was
wondering if any samples or examples exists at sites that I can
experiment with. Or, suggestions that will make for a good performing
smooth/intuitive interface.

Thankyou
Greg

Jan 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use the BeforeUpate event procedure of the *form* (not controls) to check
for a duplicate.

Use DLookup(). If you need help, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

If the DLookup() finds a match, use MsgBox() to ask the user what to do. To
cancel the entry:
Cancel = True
Me.Undo

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Ap******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
No point in reinventing the wheel!

-I'm looking to create a popup dialog that prompts for FirstName MI
Lastname.
-Checks and reports duplicates.
-And offers the user an option to continue or cancel.

I know this must be a very common aspect of systems managing names, and
know that many creative interfaces must have been built. I was
wondering if any samples or examples exists at sites that I can
experiment with. Or, suggestions that will make for a good performing
smooth/intuitive interface.

Thankyou
Greg
Jan 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.