duplicate entries help

P

Paul M

Hi
Is there a way that a record will not be created if one of the field
entries already exists.
I am using a frontpage form to populate a database and I wish to avoid
multiple submisions of the same data. If one of the fields say the email or
or one of the other fields has the same data as bieng entered, I would like
it so the entry is not added
Thanks
Paul M
 
S

Sharkbyte

Paul:

Simply set whichever field, you wish to control this, to Indexed(No
Duplicates). You may also want to add Docmd.SetWarnings False/True to the
insert code, to suppress the error that Access will give on a failed insert.

HTH

Sharkbyte
 
P

Paul M

Thanks
That did it
I don't recieve any warnings as there is no way to see them in the web pages
It works ok so it must be fine Where do I set the Docmd.SetWarnings
False/True
Paul M
 
S

Sharkbyte

Paul:

You would want to put "DoCmd.SetWarnings False" before any action query/SQL
that you are running, but want to suppress errors on. Then you use
"DoCmd.SetWarnings True" after the query/code runs, to turn errors back on.

Sharkbyte
 
Top