Database duplicate record help

P

Paul M

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
 
M

MD Websunlimited

Hi Paul,

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
a key which does not allow dups, then it would produce an error.


--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
 

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

Preventing Duplicate Users 3
Stop Fooling Database Entry Users 2
password confirmation 1
Access Automatically Send a notification email once a record is added 0
Update database page help 1
Sending an e-mail when a database is updated via a web form 11
Duplicate Not Allowed, clear field 12
Contact Us - Email Form 4

Top