CREATE A MACRO TO SEARCH FOR DUPLICATE ENTRIES &RETURN MESSAGE

G

Guest

hi,
forget macro. go to queries. click new. there is a wizard
that will do that. find duplicates query wizard.
 
K

KR

Thanks. I dont know if this will work as I want the table to be searched for
duplicate entries when the the control loses focus. Eg I have a field called
Req Number which is not a primary key , when I enter a new number in this
field I want the undelying table checked to see if this number already exist
and return a message dtating entry already exist or duplicate number.

Thanks for any help given.
 
D

Dan S.

I want the exact same thing, I have found other threads that show sample
code but to no avail, I can't get any of it to work. Plz help Us both
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Duplicate entry in a column/row 14
Help creating a search form in Access XP 0
Macros to delete duplicate entry 1
No Macros or VBA in Mac for Office 2011 Excel 0
Excel VBA and macros not available in Excel 2011? 0
Office for MAC Excel version 11 VBA/Macro issue 0
Macro to search for a value on multiple tabs 0

Top