How to better handle duplicate entry error
- Thread starter krowe
- Start date
No he aint, dont know anyone called Anthony, just the stupid auto correcter of the stupid IPad I was using that corrected that and I didnt catch it sorry.Is Anthony one of your pals Mailman?
Ha, I knew it was something related to that. I was just messing with youNo he aint, dont know anyone called Anthony, just the stupid auto correcter of the stupid IPad I was using that corrected that and I didnt catch it sorry.
Lal-Bangalore
New member
- Local time
- Today, 10:30
- Joined
- Oct 23, 2014
- Messages
- 4
how to handle duplicate entry.....
Hello friends I am a beginner in ms access 2010. I need some help. I have a main table called Mailing_Entry_Table in this table I have the following fields: SlNo.(Primery_Key), Dep_Id, M-Date, Cmbo_M-title, Sign, M-Desi, M-Dept, M-Name, Institute, Address1, Address2, City, Pin, Phone. where Cmbo_m_title is a combo box, and the field name is acquired form a different table called Title_Table. Institute is also a combo, where the records are drawn from another table called fulllist (This contains the details of various Institutions, address, Pin and Phone)
I have a form called Maling_Lable_Entry_Form, in this form the date, name, designation department are entered Other fields like initiation name address1, address2, city, pin and the title is drawn from different tables as stated above.
Now, the help I am looking for is: when I enter a data. And press save! Access should check for duplicate entry, if the same name with the title and institution same has already been entered????? If yes give me an option to either save and continue and go the next entry without saving this entry.
How to check this duplicate entry……..
Regards,
Lal
Hello friends I am a beginner in ms access 2010. I need some help. I have a main table called Mailing_Entry_Table in this table I have the following fields: SlNo.(Primery_Key), Dep_Id, M-Date, Cmbo_M-title, Sign, M-Desi, M-Dept, M-Name, Institute, Address1, Address2, City, Pin, Phone. where Cmbo_m_title is a combo box, and the field name is acquired form a different table called Title_Table. Institute is also a combo, where the records are drawn from another table called fulllist (This contains the details of various Institutions, address, Pin and Phone)
I have a form called Maling_Lable_Entry_Form, in this form the date, name, designation department are entered Other fields like initiation name address1, address2, city, pin and the title is drawn from different tables as stated above.
Now, the help I am looking for is: when I enter a data. And press save! Access should check for duplicate entry, if the same name with the title and institution same has already been entered????? If yes give me an option to either save and continue and go the next entry without saving this entry.
How to check this duplicate entry……..
Regards,
Lal
