Prompt to advise of duplicate entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access Data Project with SQL backend and have a table of parts
with serial numbers. In the parts entry form, if someone enters a part with
a serial number that already exists in the table, can the user be prompted
'Serial Number already exists'?

Thanks.
 
You must log in or register to reply here.

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

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Checking for duplicates 3
Access Auto Matching Duplicates? 0
Access Macro Repeat Expression using value of a field in table 0
Transpose - Help with crosstab query 7
update query using like criteria 3
MS word Find and Replace using Regex - Help required 0
Counting Duplicates 10

Back
Top