Database duplicate record help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul M (P_at_doinghisbest)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 10:04:34 -0000

Hi
I have a registration form created in FP which submits to an Access
database.
How can I check to see if an entry has already been entered ie check the
email address field for duplicates before allowing the form to enter a
record into the database and returning "The email address is already in use"
type message if a duplicate is found.

Best wishes
Paul M

Relevant Pages

  • blank fields issue
    ... My tblCompanies table has a field called CompanyName. ... was suggested that CompanyName should be a field in my tblCompanies database. ... Require an entry ... No Duplicates ...
    (microsoft.public.access.tablesdbdesign)
  • Re: blank fields issue
    ... CompanyName     DataType = Text ... Indexed = Yes (Duplicates OK) ... was suggested that CompanyName should be a field in my tblCompanies database. ...  Require an entry ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database duplicate record help
    ... You'll have to modify the page, using script, to query the database before you apply the new record. ... You could make the email addy ... > I have a registration form created in FP which submits to an Access> database. ... > How can I check to see if an entry has already been entered ie check the> email address field for duplicates before allowing the form to enter a> record into the database and returning "The email address is already in use"> type message if a duplicate is found. ...
    (microsoft.public.frontpage.client)
  • Re: Getting duplicates but I dont know why
    ... >understand why I am getting duplicates. ... ate Sub TriageAndApply(InRecordset As ADODB.Recordset, ... >Our program reads records from the first database and then attempts to ... If a record is not found in the second database, ...
    (microsoft.public.vb.database.ado)
  • Re: Help writing SQL statement in PHP script
    ... IMPOSSIBLE to determine if the database is normalized or not from the ... normalized - AND STILL HAVE DUPLICATES IN THESE COLUMNS. ... It would be nice if you knew something about database normalization ... There is nothing flawed about a design which has three ...
    (comp.lang.php)