473,395 Members | 1,631 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

check Duplicate

102 64KB
Hello friends, I am stuck with Duplicate problem. So looking for help.

I have a data entry form (name is "Review Entry From") and I want to check 2 field from 2 different tables.

1. Check Drawing and Rev from Process table and if both conditions are Not Ok then message "Drawing with this Rev dose not Exis".

2. Check Drawing and Rev from Reveiw table and if both condition are found OK... the message should be "Drawing with this Rev already exist".

Both checks should be on form.... form name is "Review Entry Form"
Thanks in advance from all friends.
Irshad Ahmed
Jun 25 '12 #1
1 1503
Rabbit
12,516 Expert Mod 8TB
Create a unique index on the fields in the tables and you won't have to do any checks. Access will enforce it itself and not allow duplicates to get put into the table.
Jun 25 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: vbportal | last post by:
Hi, I would like to add BitArrays to an ArrayList and then remove any duplicates - can someone please help me forward. I seem to have (at leaset ;-) )2 problems/lack of understanding (see test...
7
by: ucfcpegirl06 | last post by:
Hello, I have a dilemma. I am trying to flag duplicate messages received off of a com port. I have a software tool that is supposed to detect dup messages and flag and write the text "DUP" on...
8
by: Iona | last post by:
Hi Allan, I'm using a nifty piece of code you put on here some time back to do a duplicate entry check as below. I'm using to check for duplicate names. However I am getting an error message on...
0
by: B.N.Prabhu | last post by:
Hi, I have a DataTable with several rows. Its having 20 Columns. when i click the Insert button then i have to check the Database Rows. Whether these new rows are already available in the...
3
by: wongray | last post by:
Hello, I need help. I have a form and I would like to do a check when I enter a data into the field and once I press enter into the field it will check whether is duplicate or not. currently...
3
by: milecimm | last post by:
Hi, I want to check in the below code if the email exists in the database before inserting. How can I do that? Dim EmailAlertDataSource As New SqlDataSource() ...
2
by: Ranma13 | last post by:
Hello, I have a duplicate record check written in VB for a check in/check out database. Here's the pseudocode, written for the BeforeUpdate property on the form: If DCount(search for records with...
2
by: sejal17 | last post by:
hello I want to check duplicate word in textarea.In textarea,all words are separated by comma.No words are allowed with enter or white space.And the limit is only 7 words i want to insert.I...
2
by: irsmalik | last post by:
Hi Friends, I am developing Engineering Document System which keep the record for all kind of Engineering Drawings and other related documents in MS Access + VBA. Table Details are Drawing No, ...
1
by: Gouri | last post by:
I am creating roombooking website in asp.net. and i am facing problem while inserting the record. eg: if the room is already booked from 1st march 2010 to 10th march 2010.and if anybody is...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.